Providing Business Insights from Live Customer Data with BigQuery

Checkers needed a way to simplify its online ordering marketing and attribution strategy.

Business Challenge

Checkers needed a way to simplify its online ordering marketing and attribution strategy. The goal was to better differentiate multiple ways of placing orders: mobile and desktop orders, third-party fulfillment and delivery, plus native app loyalty orders, all in real-time and relayed franchisors and management across hundreds of U.S. locations.

Solution

The team’s goal was to provide deeper data insights. Further achieved this by creating a consolidated order data schema into Google Cloud Platform using BigQuery from a webhook within the Olo Order Export API.

‍
Next, Further created a Looker Studio dashboard to visualize key trends in order fulfillment.
‍

That allowed optimization of marketing performance and better understanding of the hard costs of third-party delivery platforms such as DoorDash and Uber Eats.

See Our Google Solutions

Business Impact

Now measuring loyalty app sign-ups and purchases and differentiating sales.
Can optimize costs of third-party delivery vs. the company’s own website and loyalty app.
Better visibility into key metrics such as return on advertising spend.

“The work the team has done this year for Checkers and Rally's has been very impactful and has allowed us to mature at a very quick rate.”

Ryan Reichmann

Sr Director for E-commerce & Digital Technology

More Success Stories

Digital Measurement Strategy Creates Operational Efficiencies at Athenahealth

Athenahealth

Healthcare

Aligned measurement strategy leads to self-service & time savings, unlocks insights.

Campaign Activation Using Global Gaming Insights

Gaming Client

Marketing

Our gaming client needed a solution to connect a vast amount of gaming usage data across all of their labels.

Machine Learning Technology Saves Costs & Identifies Operational Efficiencies for Pharmaceutical Leader

Pharmaceutical Leader