---
title: "Ad Performance Dashboard: Seven Platforms, One Model | OWOX"
canonical: "https://www.owox.com/dashboards/advertising-campaigns"
updated: "2026-11-15"
---

AI dashboard · advertising

# Ad performance dashboard, built by AI on your Data Model

Spend, store net sales, return and profit for seven ad platforms, set against what each platform claims and against the plan. Claude built it through OWOX MCP, and every number comes from a governed Data Mart, not from the AI's guess.

8 Data Marts · Built by Claude via OWOX MCP · Refreshed every Report run · [E-commerce data model](/data-models/e-commerce)

[Get Started Free](https://www.owox.com/app-signup) · or [book a call](https://calendly.com/owox/book-a-call)

## The dashboard

## What each view answers

## Six questions, one [Data Model](/data-models/e-commerce)

Every view answers one question a marketing lead asks before moving budget, starting with the plainest one: are we making money on ads? Between them they read eight Data Marts of the e-commerce Data Model, and each view names the ones it uses, so you can open the definition behind any number.

![The E-commerce data model: 12 Data Marts and how they join](https://cdn.owox.com/www/portfolio-management-data-model/e-commerce/diagram/10.svg/w=1600,fit=scale-down,format=auto)

[E-commerce data model · 12 Data Marts · 15 relationships · open it →](/data-models/e-commerce)

Summary

### Do our ads pay back?

Opens with what the numbers mean: which platforms make money, which lose it, how far the platforms' own claims run ahead, and where spend stands against the plan. Then spend, store net sales, net sales per $1, clicks and click-through rate against the same dates last year, with spend and net sales month by month.

Ad Performance · [Unified Ad Spend](/data-models/e-commerce#mart-unified-ad-spend)[ROAS](/metrics/return-on-ad-spend)[Ad spend](/metrics/advertising-costs)

Platforms

### Which platforms make money, and which lose it?

Google, Facebook, TikTok, LinkedIn, Microsoft, Reddit and X side by side: spend, the net sales the store recorded from the visits each one bought, net sales per $1, and the profit left after cost of goods and ad spend. Each platform gets a Scale, Hold or Cut call from a rule printed on the page.

Ad Performance · [Purchases](/data-models/e-commerce#mart-purchases)[Sessions](/data-models/e-commerce#mart-sessions)[Traffic Sources](/data-models/e-commerce#mart-traffic-sources)[ROAS](/metrics/return-on-ad-spend)

Claims

### Can we trust what the platforms report?

Each platform's own return per $1 next to the store's, and the conversions it claims next to the orders the store recorded. Platforms count views as well as clicks and two of them can claim the same purchase, so the page shows both numbers and never one instead of the other.

[Unified Ad Spend](/data-models/e-commerce#mart-unified-ad-spend) · Ad Performance · [Purchases](/data-models/e-commerce#mart-purchases)[Orders](/data-models/e-commerce#mart-orders)

CTR

### Is our click-through rate right?

The click-through rate calculated from summed clicks and impressions, next to the one a spreadsheet gets by averaging each day's stored rate. The averaged number is wrong at every cut, and not even in one direction.

Ad Performance · [CTR](/metrics/click-through-rate)

Plan

### Are we spending to plan, and is it returning what we planned?

Spend, clicks, cost per click and net sales per $1 against the advertising and marketing plan, month by month, over the same days on both sides.

Ad Performance · \[Plan\] Advertising · \[Plan\] Marketing · [CPC](/metrics/cost-per-click)

Campaigns

### Which campaigns carry the spend?

Every campaign that spent money this year, with its store net sales, return, click-through rate, cost per click and the customers it brought. Reddit, LinkedIn and X report no campaign name, and the page says so instead of guessing one.

Ad Performance · [Sessions](/data-models/e-commerce#mart-sessions)[Purchases](/data-models/e-commerce#mart-purchases)

## Metrics

## The metrics on this dashboard

Each one is defined once in the Data Model and read the same way in every view. Follow a chip for what the metric means and how to calculate it.

[Ad spend](/metrics/advertising-costs)[Return on ad spend](/metrics/return-on-ad-spend) · Platform ROAS · [Click-through rate](/metrics/click-through-rate)[Cost per click](/metrics/cost-per-click)[Cost per mille](/metrics/cost-per-mille)[Ad impressions](/metrics/ad-impressions) · Profit after ad spend

## Connected, not a snapshot

## An AI dashboard is only as true as what it reads

Most AI dashboards start from an exported file. That works until the second export.

On a CSV

### The AI guesses how to add up a rate, every time

One export averages each day's click-through rate, the next divides clicks by impressions, and the same ads show 2.67% in one deck and 1.66% in another. The file goes to whoever has it, and it is out of date the moment it is saved.

![Two exports of the same ad rows giving a CTR of 2.67% and 1.66%](https://cdn.owox.com/www/content-marketing-dashboard/advertising-campaigns/body-vector/1-othjx5.svg/public)

Which one goes in the deck?

On your Data Model

### Spend and revenue meet on one channel name

Ad spend from seven platforms shares the source, medium and campaign defined once in Traffic Sources with sessions and orders, so cost sits next to the revenue it bought, and every rate is calculated the same way at every cut.

![The e-commerce Data Model: Unified Ad Spend joined through Traffic Sources to Sessions, Orders and Purchases](https://cdn.owox.com/www/portfolio-management-data-model/e-commerce/diagram/10.svg/w=1600,fit=scale-down,format=auto)

One definition, every view.

**Connecting the AI straight to the warehouse is not enough either.** A warehouse rarely holds the business context, so the AI still guesses what the numbers mean. The Data Model is where that context lives.

## How it is built

## From your warehouse to a dashboard in five steps

Your analyst does step two once. After that, anyone with access asks their AI for the dashboard they need.

1.  01 · Your warehouse · BigQuery · Snowflake · Databricks · Redshift · Athena · Your data stays where it is. OWOX runs on it and keeps no copy.
2.  02 · Data Model · Data Marts · joins · metrics · Your analyst defines once what spend, a click-through rate and a channel mean.
3.  03 · OWOX MCP and API · governed · permissions · The only door the AI gets: the Data Marts it may read, nothing raw.
4.  04 · Claude or ChatGPT · your own AI · Ask for the dashboard in plain words. It builds it on the Data Model.
5.  05 · AI dashboard · Report · every run · Kept as a Report, refreshed every time it runs, like Sheets or Excel.

## Build yours

## Build this on your own data

Connect your warehouse, describe your business once, and let your AI build the dashboards your team asks for.

[Get Started Free](https://www.owox.com/app-signup) · or [book a call](https://calendly.com/owox/book-a-call)

## 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.

- [E-commerce data model](https://www.owox.com/data-models/e-commerce) — /data-models/e-commerce.md
- [Get Started Free](https://www.owox.com/app-signup)
- [ROAS](https://www.owox.com/metrics/return-on-ad-spend) — /metrics/return-on-ad-spend.md
- [Ad spend](https://www.owox.com/metrics/advertising-costs) — /metrics/advertising-costs.md
- [CTR](https://www.owox.com/metrics/click-through-rate) — /metrics/click-through-rate.md
- [CPC](https://www.owox.com/metrics/cost-per-click) — /metrics/cost-per-click.md
- [Cost per mille](https://www.owox.com/metrics/cost-per-mille) — /metrics/cost-per-mille.md
- [Ad impressions](https://www.owox.com/metrics/ad-impressions) — /metrics/ad-impressions.md
