---
title: "Automate Marketing Reporting for Restaurants | OWOX"
canonical: "https://www.owox.com/blog/success-stories/how-to-automate-marketing-reporting-in-the-restaurant-business"
updated: "2026-10-22"
---

# How to automate marketing reporting in the restaurant business

Updated October 25, 2021 · [Alyona Samovar](/team/alyona-samovar) · 6 min read · Ecommerce · [E-Commerce data model](/data-models/e-commerce)

**43%** media-driven share of channel traffic

![How to automate marketing reporting in the restaurant business](https://cdn.owox.com/www/customer-success-case-study/how-to-automate-marketing-reporting-in-the-restaurant-business/thumbnail/1-ps2qb2.png/public)

With the help of the marketing agency and OWOX products, marketers at the restaurant chain have entirely updated their analytics system.

There are 57 restaurants and delivery service locations, serving both Japanese and Italian cuisine. In connection with the business’s scaling and diversification, the marketing department faced new tasks:

*   **Understand what advertising activities bring new users to the website and mobile application and how much it costs to attract a client.** They had to combine data from the website, mobile application, and CRM system to figure this out.
*   **Receive fast performance reports and compare actual performance with the forecast.** For this, they needed to automate marketing reporting.
*   **Evaluate the incremental impact of media impressions on performance channels and targeted website and mobile application activities.** To do this, they merged raw data at the client ID level with impressions from the Campaign Manager.

Let’s see how they accomplished each of these tasks and give some advice to those just starting down the marketing automation path.

_Note: All reports presented in the article are based on a test dataset._

## Merge website, mobile application, and CRM data

The team built advanced analytics based on OWOX, Google BigQuery, and Power BI. Schematically, the system looks like this:

![Diagram: advertising, website, CRM and AppsFlyer data pass through OWOX into BigQuery, R and Power BI.](https://cdn.owox.com/www/webflow/679520106338e9e5136f11d0_40984.png/public)

_Data is imported into storage, processed there, and visualized on the [dashboard](/product/dashboards)._

OWOX imports cost data from all advertising systems as well as raw website data from Google Analytics and application data from AppsFlyer. Then it transmits all this data to Google BigQuery.

Google BigQuery also receives forecast metrics that agency experts calculate in the interface using the R language.

Inside Google BigQuery, data is processed and merged using views and scheduled queries.

Finally, the data is visualized in Power BI.

## Create automated reports

The team focused on three reports by which they can track the necessary metrics:

*   Basic management report for the balanced scorecard system
*   Report on attracting users to the website
*   Report on attracting users to the application

### Basic management report for the balanced scorecard system

They developed an Impact Matrix — a hierarchy of metrics — to determine which metrics to focus on and in which cases. They also used the balanced scorecard methodology to monitor prediction data. As a result, they received a report that allows to:

*   understand which metrics are ahead and which are behind the plan
*   track major KPIs that have different weights for the business (CPO, CR, Revenue, CTR)
*   predict KPIs

In the report architecture, can be distinguish three levels: the business level, KPI level, and detailed level.

**Business level**

At this level, you can see the plan vs fact for crucial business metrics.

![A balanced scorecard table of parameters, with weight, plan, forecast, difference, progress and a total result.](https://cdn.owox.com/www/webflow/6795200f1f4f4242be78a104_38792.png/public)

![A formula: the result R is the sum of forecast over plan, times the parameter weight ratio.](https://cdn.owox.com/www/webflow/6795200f6ed0de8bfedfdebb_38794.png/public)

From the data above, the team can conclude that the CR KPI was exceeded by 43%. At the same time, the traffic volume and conversions didn’t reach the planned values. A high CR can indicate a good website and application UX — there are few dips, and users convert well. However, it’s necessary to increase the volume of traffic to ensure the required sales volume.

**KPI level**

Based on the KPI-level report, the marketers analyze efficient and inefficient placements from the point of view of CR and cost indicators — this allows to quickly split the budget between channels to fulfill the general plan.

![Scorecard tables by traffic type, for all, organic, CPC and direct traffic, with progress in green and red.](https://cdn.owox.com/www/webflow/67952010368d555355a31e91_38796.png/public)

The report illustrates the upper-level correspondence of planned and actual KPIs (CR, Visits, Revenue, Transactions) to the forecast values. For example, you can see that the plan for overall website traffic volume wasn’t met, but this is offset by higher CR in organic and direct traffic. Accordingly, it’s necessary to increase the CR of paid traffic (CPC type) with more dynamic optimization or an increased purchase price. The team may also need to increase the purchase of paid traffic in principle to fulfill the general traffic plan.

**Detailed level**

At this level, marketers look at the dynamics of metrics by region and device type — this also helps redirect the budget to what works better.

![A Power BI Website Transactions report, with a plan against fact bar chart and a device breakdown.](https://cdn.owox.com/www/webflow/6795200f8a90799b24871693_40986.png/public)

From the data above, can be concluded that the team missed the plan in terms of the total number of transactions and CR for the given period of analysis by 5.5%. At the same time, both desktop and mobile traffic show approximately the same tendency to fall behind the volume of conversions (desktop fell by 5.7%, mobile by 5.6%). Accordingly, both device types bring about an equal number of conversions. But to optimize, traffic in the CR section must be analyzed.

![A bar chart of December conversion by device type, for desktop, mobile and tablet.](https://cdn.owox.com/www/webflow/6795200f8bc93152de47a4f6_38800.png/public)

Here, can be seen that mobile traffic (1.8%) and tablet traffic (2.8%) showed the lowest CRs in December. Since mobile traffic brings about the same number of conversions as desktop traffic and is probably cheaper, marketers can try to optimize mobile traffic by purchasing better quality traffic to increase its CR.

![A bar chart of December values by region, including London, New York City, Paris and Kyiv.](https://cdn.owox.com/www/webflow/6795200fb82a806669cf91a1_40988.png/public)

This graph illustrates the performance plan for traffic across cities. With information on bought volumes, it’s possible to conclude where underperformance is critical and impacts the effectiveness of all campaigns.

### Automated reports on attracting new users to the website and mobile application

Thanks to these reports, the team could divide all purchases into new and returning customers. This made it possible to exclude returning customers from advertising campaigns for new customers, thereby, reducing CPO across all channels. By seeing statistics in the channels section for returning and new users simultaneously, the marketers were able to understand which sources drive more new orders and tilt the budget in their favor. In sources where repeated purchases prevail, they reduced the budget, thereby reducing the total planned CPO.

By the way, the main KPIs in these reports are calculated based on CRM data.

![A table of new users by media source, with purchases, revenue and repeat purchase columns.](https://cdn.owox.com/www/webflow/67952010bc5224041b922a70_40990.png/public)

The report above demonstrates that the largest number of new purchases for all traffic from the website is led by inst\_kz (81.82%), Facebook Ads (43.45%), mobrain\_int (31.25%), and gomobile\_int (30.38%). Since, in general, the company has an active and loyal audience and a high percentage of market coverage, it’s clear why some websites lead customers who have already made an order at least once in the application. For greater efficiency and execution of the Customer Acquisition KPI, the team can try to exclude the active CRM audience in the ad campaign settings and launch promotions for new customers.

![A table of new users by channel grouping, with purchases, revenue and repeat purchase columns.](https://cdn.owox.com/www/webflow/67952010ca44d28542c7c108_40992.png/public)

Here, you can see that more than half of desktop traffic across all channel groups is returning customers. This indicates the importance of working with a loyal base and increasing retention.

## The Turning Point

OWOX Data Marts

See your first report built in real time. _15 minutes._

1.  Connect your data warehouse
2.  Pick your metrics
3.  Get a live Google Sheets report

In the time it takes to write a ticket. Then imagine never writing that ticket again.

[Book a Demo](/book-a-call)

We'll use your actual use case

## Set up post-view analytics

With post-view analytics, you can evaluate the influence of media activity on the number of orders.

Impression statistics are uploaded to BigQuery from Google Campaign Manager and are detailed down to the individual user (client ID). The report compares segments of those who saw and those who didn’t see media ads. As a result, we can evaluate the incremental effect of media impressions on performance channels and targeted actions on the website and in the mobile application.

![A Power BI page of post-view analytics, with line charts, donut charts and a source table.](https://cdn.owox.com/www/webflow/679520103d3f4ddc78a4c9e7_40994.png/public)

For example, the team learned that conversions to orders from those who saw videos and banners were 42% higher than for those who didn’t see them. Due to post-view analytics, they also determined that the audience of those who saw media advertising brought in double the income.

In the future, the team plans to develop cross-platform reporting. The first step is to evaluate the impact of web traffic on application conversions by linking mobile application and website data. Such reporting will create a complete understanding of the value of advertising channels and assess their impact on each other. It will also help to make management decisions about the development of customer interaction channels and adjust the marketing communication strategy.

## Your New Normal

Turn your data into decisions.

Governed data marts give you the clean foundation ML needs to actually work.

*   No AI hallucinations
*   Analyst-governed definitions
*   Every number traces to SQL

[Get started free](https://www.owox.com/app-signup)

## Who wrote this

![Alyona Samovar](https://cdn.owox.com/www/webflow/6799099d337aa8a997b03b56_Alyona-Samovar.png/public)

[Alyona Samovar](/team/alyona-samovar) · Senior Digital Analyst

Alyona Samovar is a Senior Digital Analyst who spent years at OWOX helping enterprise clients design analytics systems, build BigQuery reporting pipelines, and optimize marketing measurement. She specializes in SQL-based analytics, data modeling, and turning raw marketing data into actionable insights. Alyona writes about practical analytics workflows, BigQuery best practices, and data-driven decision-making.

[Case Studies](/blog/topics/case-study)

[Marketing Analytics](/blog/topics/marketing-analytics)

[OWOX](/blog/topics/owox-bi)

## More stories

[boodmo · Evaluating Acquisition Channels and LTV via Cohort Analysis · Ecommerce · Jun 27, 2017](/blog/success-stories/boodmo)

[Citrus · Competitors’ Prices Impact Sales: Citrus Success · Ecommerce · Mar 1, 2018](/blog/success-stories/citrus)

[COMFY · Set up Marketing Analytics · Ecommerce · Dec 12, 2018](/blog/success-stories/comfy)

## What users are saying

## What our clients say

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A9 · re: one source of truth

![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public) Mark Simmons · CMO, Pürblack®

> _“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”_

C7 · re: getting time back

![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack®

> _“We regained time. And time is the one resource that never comes back.”_

E3 · re: golden data

![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack®

> _“Golden data is clean data — the measure of reality, true and not false, that you can trust based on its source. If you have that, you're good.”_

## Book a call

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Schedule a meeting

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Alyona Samovar](https://www.owox.com/team/alyona-samovar) — /team/alyona-samovar.md
- [E-Commerce data model](https://www.owox.com/data-models/e-commerce) — /data-models/e-commerce.md
- [dashboard](https://www.owox.com/product/dashboards) — /product/dashboards.md
- [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md
- [Get started free](https://www.owox.com/app-signup)
- [Case Studies](https://www.owox.com/blog/topics/case-study) — /blog/topics/case-study.md
- [Marketing Analytics](https://www.owox.com/blog/topics/marketing-analytics) — /blog/topics/marketing-analytics.md
- [OWOX](https://www.owox.com/blog/topics/owox-bi) — /blog/topics/owox-bi.md
- [boodmo · Evaluating Acquisition Channels and LTV via Cohort Analysis · Ecommerce · Jun 27, 2017](https://www.owox.com/blog/success-stories/boodmo) — /blog/success-stories/boodmo.md
- [Citrus · Competitors’ Prices Impact Sales: Citrus Success · Ecommerce · Mar 1, 2018](https://www.owox.com/blog/success-stories/citrus) — /blog/success-stories/citrus.md
- [COMFY · Set up Marketing Analytics · Ecommerce · Dec 12, 2018](https://www.owox.com/blog/success-stories/comfy) — /blog/success-stories/comfy.md