Skip to main content
BI for Luigi's Google Ads
Case Study

+94% Google Ads revenue.

How Luigi's Google Ads optimisation moved to its own data warehouse with Power BI, almost doubling revenue vs 2019.

Google AdsAnalytics
+94%
Ad revenue
+53%
Google ROAS
+72%
Orders
100%
One template

More growth and better returns in an already mature account

Luigi already had a very good year behind it, with a mature account where the usual optimisations had been done. The goal for 2020 was more ambitious: much more revenue and, at the same time, a better return for every euro.

At this point the easy wins do not show inside Google Ads. The platform shows totals per campaign, while the big patterns hide in how structure, searches, bids, audiences and time of day combine.

There was also a question of order. The account had grown bit by bit over three years, collecting inconsistent names, ad groups with mixed intent and negative keywords that differed from part to part.

A manual rebuild would have fixed this for a while, but within a year the same problems would have returned. The rebuild had to be automated to last.

Automated rebuild, then optimisation outside the platform

Our own software rebuilt the whole Google Ads account from the Merchant Center feed and a set of rules. Every campaign follows the same template, so the disorder does not come back.

Account performance flows every day through ELT into a data warehouse, together with revenue from GA4, the catalogue and the e-shop's orders. That becomes the one truth for everyone.

Outside the platform, patterns appear that Google Ads does not show: searches wasting budget, hours with weak returns, campaigns cannibalising each other, and audiences with very different performance.

Power BI dashboards turn them into weekly actions: which negative keywords to add, which hours to limit, which audiences to split. Every action is measured, and the account improves week after week.

Data pipelines and BI for Luigi's Google Ads

Decisions outside the platform

Phase 01

Automated rebuild

The software builds the whole account from the feed with the same rule everywhere, and every future change is one command.

Phase 02

Data in one place

With ELT, Google Ads, GA4, catalogue and order data join every day in one data warehouse.

Phase 03

Weekly loop with Power BI

Dashboards show what to change, every change is measured, and the account moves towards its best possible performance.

The Results

+94%

Google Ads revenue

Revenue from Google Ads almost doubled in 2020 vs 2019.

+53%

ROAS

Every euro in Google Ads brought 53% more revenue.

+72%

Orders

More purchases, once the searches that did not sell were stopped.

100%

One template

Every campaign follows the same template, built automatically from the feed.

Want to see what the platform does not show?

We move your ad data into a proper BI setup and find the levers the platform does not show.

Start a conversation