Situation

Real time analytics platform enabled our client to derive actionable insights for decision making. Tracking KPIs, beverage performance, consumer profiling, and media spend were key to revenue growth for our client and their customer.

Actionable insights delivered from real time analytics platform.

Our client is a Fortune 100 beverage company. It’s executive team routinely met with the leadership of a major fast-food chain in Canada to discuss business performance and how to drive revenue growth. To arrive prepared for the discussion, our client’s team would gather detailed insights on store traffic, trends, KPIs, and more. This was a manual and time-consuming task.

Data was also needed to help the chain conduct targeted marketing across different regions, versus nationally.

Tracking KPIs, understanding beverage performance, consumer profiling, and media spend strategies were key to revenue growth for our client and their customer.

Action

Our Data & AI team delivered a real-time analytics platform that enabled our client to derive actionable insights for decision-making. Key components of the solution:


  • Regional Performance Tracking: Developed a dashboard to monitor KPIs like traffic and spending patterns across Canadian regions. The dashboard allowed the client to identify areas with higher-than-average traffic and compare metrics over time.

  • Sales Opportunity Analysis: Conducted a comparative analysis of beverage sales growth against macro indicators, such as population growth. This analysis identified underperforming areas where beverage volume lagged population trends.

  • Consumer Segmentation: Created consumer profiles based on demographics and lifestyle, such as identifying "Trendsetters" in Quebec who typically visit after-hours and have distinct characteristics compared to the general population.

  • Media Targeting Optimization: Used media consumption data to recommend optimal advertising channels for specific regions. For example, Quebec trade areas responded well to radio, internet, and subway ads.


Results

  • Focused on underperforming regions with a data-driven approach, adjusting promotions to local demographics and aligning campaigns with customer profiles.
  • Optimized marketing spend through a refined media strategy, aligning campaigns with regional preferences for cost-effective targeting and improved engagement.
  • Enhanced targeting using improved consumer segmentation to reach key customer segments more effectively.
1/3

Developed dashboard to monitor regional performance KPIs.

2/3

Refined media buying strategy, ensured cost-effective targeting and better engagement.

3/3

Our client increaseed revenue by 6% through optimized pricing across all categories.

  • 33%

    Reduction in time to gather insights

  • 50+

    KPIs identified

  • 1000+

    Fast food chain locations