Business Need:

• Need for Digital Marketing Performance Dashboard with consolidated view of all media spends, campaign performance and returns (ROAS)
• Gaining fast, reliable and intuitive actionable insights for advertising media channels

Challenges:

• High variety and volume of data (10M+ monthly rows) across 15+ Digital Media Platforms and 30+ tables.
• Excel used as reporting tool – scalability, performance, collaboration and security

Our Solution:

• Integrated data from media sources to establish a unified data model
• Implemented self-service BI portal

Business Benefits:

• Increased client engagement through interactive, self-service BI dashboards
• 10% savings in specialist's time enabling them to focus on campaign optimization

Technology