--- title: "CMO Dashboard: An AI Dashboard on Your Data Model | OWOX" canonical: "https://www.owox.com/marketing-dashboards/cmo-dashboard" updated: "2026-10-29" --- AI dashboard · e-commerce # CMO dashboard, built by AI on your Data Model Net sales, profit, ad spend, new customers and CAC for an online store, on one board view. Claude built it through OWOX MCP, and every number comes from a governed Data Mart, not from the AI's guess. 7 Data Marts · Built by Claude via OWOX MCP · Refreshed every Report run · [E-commerce data model](/data-models/e-commerce) ## The dashboard ## What each view answers ## Four questions, one [Data Model](/data-models/e-commerce) Every view answers one question a marketing or sales lead asks. Between them they read seven of the twelve Data Marts in the e-commerce Data Model below, 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 ### Is marketing paying for itself? Opens with what the numbers mean: whether marketing makes money, how last month compared, which platforms lose money and where the opportunity is. Then net sales and profit against ad spend from all seven platforms, month by month, with net sales per $1 of ads and ad spend per new customer. [Purchases](/data-models/e-commerce#mart-purchases) [Orders](/data-models/e-commerce#mart-orders) [Unified Ad Spend](/data-models/e-commerce#mart-unified-ad-spend) [Customers](/data-models/e-commerce#mart-customers) [Customer acquisition cost](/metrics/customer-acquisition-cost) Channels ### Which platforms make money, and which lose it? Net sales by channel group, then every ad platform's spend against the net sales and profit the store recorded from its visits, what is left after ad spend, and what each platform claims per $1 beside it. Then ad spend and its return against the budget plan, and a Scale, Hold or Cut call on each platform from a rule printed on the page. [Purchases](/data-models/e-commerce#mart-purchases) [Sessions](/data-models/e-commerce#mart-sessions) [Traffic Sources](/data-models/e-commerce#mart-traffic-sources) [Unified Ad Spend](/data-models/e-commerce#mart-unified-ad-spend) [ROAS](/metrics/return-on-ad-spend) Customers ### Are we winning new customers? New customer accounts each month and revenue by segment. The view says plainly why CAC by channel is left out: in this demo, most accounts carry no acquisition source. [Customers](/data-models/e-commerce#mart-customers) [Traffic Sources](/data-models/e-commerce#mart-traffic-sources) [Purchases](/data-models/e-commerce#mart-purchases) [Orders](/data-models/e-commerce#mart-orders) Markets ### Where does the year come from? The eight largest markets by net sales, and how each moved on last year. Country is defined once, so every view splits revenue the same way. [Purchases](/data-models/e-commerce#mart-purchases) [Sessions](/data-models/e-commerce#mart-sessions) [Countries](/data-models/e-commerce#mart-countries) ## 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. Net sales · Net profit · [Ad spend](/metrics/advertising-costs)[Customer acquisition cost](/metrics/customer-acquisition-cost)[Return on ad spend](/metrics/return-on-ad-spend) · New customers ## 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 what revenue means, every time Each export is its own version of the truth, so two dashboards give two numbers. The file goes to whoever has it, and it is out of date the moment it is saved. ![Two exported files showing 29 and 32 orders for the same days](https://cdn.owox.com/www/content-marketing-dashboard/net-sales-review/body-vector/1-7by02w.svg/public) Which one goes to the board? On your Data Model ### Spend and revenue meet on one channel name Ad spend, sessions and orders share the source, medium and campaign defined once in Traffic Sources, so cost sits next to the revenue it bought instead of in a separate report. ![Purchases in the e-commerce Data Model, joined through Orders to Sessions and Customers](https://cdn.owox.com/www/portfolio-management-data-model/e-commerce/diagram/10.svg/w=1600,fit=scale-down,format=auto#mart-purchases) 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 net sales, an order 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) ## 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 ## Schedule in person meeting at Data Outpost San Francisco 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. - [E-commerce data model](https://www.owox.com/data-models/e-commerce) — /data-models/e-commerce.md - [Customer acquisition cost](https://www.owox.com/metrics/customer-acquisition-cost) — /metrics/customer-acquisition-cost.md - [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 - [Get Started Free](https://www.owox.com/app-signup)