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

Blending Analytics Data for Historic Reporting

Nothing Bundt Cakes

Google

Further built an application to import historic UA data into a BigQuery table, and enabled the integration to transfer data from GA4 into BigQuery daily, saving money and time for our client.