Case study · Aviation

Ad spend and revenue, finally in one picture

How an online retailer pulled Google Ads, Facebook Ads, Shopping Ads, and finance into one Power BI app that marketing and finance now read from the same screen.
Multi-channel data integration Marketing & finance KPI design Power BI app build
Online retailer, multi-channel paid acquisition
INDUSTRY
E-commerce / retail
ENGAGEMENT
Power BI reporting suite
STACK
Supermetrics, Power BI
SCOPE
7 weeks

/01THE IMPACT

6 → 1

ad and finance sources unified into one model

Daily

scheduled refresh, no more manual pulls

1 app

for every report, from exec view to campaign detail

Same #

marketing and finance now read from one number

/02THE CHALLENGE

Every KPI review started with someone exporting from four tools and rebuilding the same spreadsheet.
Marketing performance sat in Google Ads, Facebook Ads, and Shopping Ads, while revenue and cost lived in finance systems. Each of those tools reported well on its own, but none of them talked to the others, so comparing spend against actual revenue meant pulling exports by hand and reconciling them. The work was slow, the numbers drifted between versions, and no one could see how a campaign moved the business overall, only how it looked inside its own platform.

Data in four silos

Ad platforms and finance never met, so every review meant exporting and stitching the same sources together by hand.

Slow and inconsistent

Manual consolidation took hours and the figures shifted between versions, so people argued about the numbers instead of acting on them.

No view of the whole

Each tool showed its own slice, so the team could see clicks and cost per channel but never the full link to revenue.

/03THE APPROACH

We piped every source into one model, defined the KPIs with the teams who use them, then shipped it all as a single app.

01

Pull every source through Supermetrics into a star schema

We used Supermetrics to extract Google Ads, Facebook Ads, and Shopping Ads, then structured and consolidated the queries into a clean star schema in Power BI built to scale as channels are added.

Logic audit
Gap analysis

02

Define KPIs with marketing and finance, not for them

Through a detailed requirements process we set the metrics that matter to each team, so blended ROAS, contribution, and channel performance all resolve to one agreed definition.

Calculation framework
Multi-level logic

03

Ship it as one Power BI app

We delivered a portfolio of reports, from a high-level executive overview to campaign and financial detail, all centralized in a single Power BI app so the whole company opens the same place.

Power BI
UX / UI
Accessibility

/04THE RESULTS

Marketing and finance stopped reconciling and started comparing.

Spend meets revenue on one screen

Campaign cost and actual revenue sit side by side, so the team reads channel performance against the business instead of inside each tool.

The morning export is gone

Scheduled refreshes keep every report current, so reviews start from a live number rather than a freshly rebuilt spreadsheet.

One app, one set of figures

Executives, marketers, and finance all open the same Power BI app, so the conversation moved off whose number is right.

Want your ad spend and revenue in one place?

We unify your marketing and finance data into a single Power BI app, then train your team to run it.