Marketing BI dashboard for ecommerce: fewer dashboards, one decision
Where it sits among the other tools is on the ecommerce marketing technology stack page.
What does a marketing BI dashboard do?
It turns data into a view someone can act on. The data comes from your shop, ad platforms, analytics and sometimes email.
A good one answers a question such as: can I spend more next month, and where? A poor one answers nothing and shows forty charts.
One business owner on Hacker News, paying an SEO agency in 2024, could not tell whether traffic growth came from the agency or from their own PR, and asked for tools to see ROI beyond the vanity metrics in Google Analytics1. In our view, that complaint is about the question a report answers, not its colours.
Why do e-commerce brands use it?
Example (illustrative): Meta shows a ROAS of 3, GA4 shows 2 and the shop revenue looks flat. A single page that puts spend, revenue and margin side by side ends that argument faster than three logins.
Platform, analytics and shop numbers disagree. A guide from a vendor that sells a reconciliation tool explains why: the shop counts orders, ad platforms count touches inside their own window, and GA4 counts the sessions it could follow2. A dashboard cannot remove those reasons. It can put the numbers next to the one that matters, your own revenue.
What should be on it?
Start with a few numbers, each tied to a decision:
- Contribution margin. Revenue minus the variable costs that grow with every order: cost of goods, shipping, payment fees, returns and discounts. Our convention is to count it before marketing spend.
- MER (marketing efficiency ratio). Our convention: total revenue divided by all marketing cost (media, agency, creative and tools), not only media spend. This split is our convention, not an industry standard.
- Blended ROAS. Our convention: total revenue divided by media spend only. See also ROAS, which counts only revenue attributed to ads.
- Cohort analysis. Customers grouped by first purchase month, to see whether they come back.
Our view: take revenue from the shop or finance system, not by adding up the platforms.
How do we implement it?
Start with a decision
Name the budget decision the dashboard should change. Build one dashboard around that question, including margin.
Agree the definitions
Write down what revenue, margin and a new customer mean before drawing anything.
Connect and own it
Take revenue from the shop or finance system. The dashboard and the data should be yours.
Name an owner
Someone keeps the connections working and asks what decision each chart changes.
When should you not use it?
A new dashboard is the wrong fix when:
If the tracking is the doubt, you can start with a free tracking audit. Our article on how to read an agency report shows what to ask for in place of vanity metrics.
What does it cost in effort?
We give no figures.
- Definitions. Agree what revenue, margin and a new customer mean, before drawing anything.
- Data. Each source needs a connection, and connections break.
- An owner. Someone keeps it correct and asks what each chart is for.
- Access. Our view: the dashboard and the data should be yours, not rented from whoever built them.
Pitfalls
Vanity metrics
Clicks, impressions and platform ROAS fill a screen. On their own, they rarely settle a budget decision.
Automation addiction
Even a B2B data vendor has published a piece titled "The dangers of automated dashboard addiction"3. Our view: automate the data collection, not the thinking.
No margin
Revenue-only views reward growth that loses money.
Different definitions on each tab
You have rebuilt the disagreement.
A dashboard nobody asked for
If no decision depends on it, it is decoration.
Our take: Core
Our view: Core. This is our rating, not a market fact or an industry scale. It comes from the role a dashboard plays in our own work, not from a study of dashboards.
In our view, a budget decision needs one shared view of spend, revenue and margin. It rarely needs ten. The test is simple: does it change a decision?
Our view: one dashboard, built around a question and including margin.
FAQ
What is a marketing BI dashboard?
A screen that combines marketing and sales data to support a decision. BI stands for business intelligence.
Is a marketing dashboard the same as an ecommerce reporting dashboard?
Largely a naming difference. What matters is whether it answers a budget decision and includes margin.
How many dashboards do I need?
Our view: one per decision, and often one is enough.
What should a marketing dashboard show?
Margin first, then MER or blended ROAS, then cohorts. Add platform metrics only where they change a decision.
Where should revenue come from?
Our view: from your shop or finance system. One vendor's guide shows four tools each claiming the same order2, so platform totals can add up to more than you sold.
Do I need a warehouse before a dashboard?
Not necessarily. A warehouse helps with order-level and cohort questions. Our view: start with the question, and add a warehouse when the simpler set-up cannot answer it.
Let’s find what’s actually working.
Next step. Want a view on what your dashboard should answer? Talk to us about your budget decision. Or read about our Analytics & tracking service.