What Should Be in an Ecommerce Analytics Dashboard?
by Om Rathod
|
8 min read
Sep 02, 2026
Most ecommerce founders can tell you their revenue for the week. Fewer can tell you if they made money doing it. That gap is exactly what an ecommerce analytics dashboard should close, and it's why so many people search for what should be in an ecommerce analytics dashboard instead of just building one off vibes. This guide walks through the metrics, data sources, and refresh rates that actually matter, skipping the fluff most dashboard vendors pad their feature lists with.
What Is an Ecommerce Analytics Dashboard, and Why Does It Matter?
A real ecommerce analytics dashboard is one view that pulls your Shopify or Amazon sales, your ad platform spend, and your GA4 funnel data into a single place. Not five browser tabs. Not a Slack thread where someone pastes screenshots.
The problem it solves is boring but expensive: founders and growth leads burning two to three hours a week stitching CSVs together just to answer "are we profitable this week." That's not analysis. That's data entry with extra steps.
Here's the part most people skip when they set one up: a dashboard only earns its keep if it answers a specific business question. "Are we profitable this week" is a good one. "What does our CAC look like by channel today" is another. A wall of charts that doesn't answer anything specific is just decoration. If you're asking what should be in an ecommerce analytics dashboard, start by listing the three or four questions you actually need answered daily, then build backward from those.
What Are the Core Metrics Every Ecommerce Dashboard Should Track?
There's a short list of non-negotiables. If your dashboard is missing any of these, it's not done yet.
Revenue (gross and net of refunds)
AOV (average order value)
Contribution margin (revenue minus COGS, shipping, and ad spend)
CAC (customer acquisition cost, ideally by channel)
Blended ROAS
Repeat purchase rate
Contribution margin is the one brands skip most, and it's the one that actually tells you if the business is healthy. Revenue can go up while margin quietly goes negative, especially during aggressive discount pushes or when freight costs creep. A dashboard that shows revenue and CAC but not contribution margin is showing you half the picture and calling it whole.
Here's a concrete case. A brand spending $50k a day across Meta and Google needs CAC by channel, broken out daily, not rolled up monthly. At that spend level, a bad week on one channel can burn tens of thousands before a monthly report would even flag it. Daily granularity isn't a nice-to-have here, it's the difference between catching a problem on Tuesday versus finding out on the 1st of next month.
Which Data Sources Should a Dashboard Pull From?
The standard stack looks like this: Shopify or WooCommerce for storefront sales, Amazon Seller Central or Vendor Central for marketplace orders, Meta and Google Ads for spend, and GA4 for on-site funnel behavior.
The trouble is these platforms don't agree with each other. Shopify admin will show one revenue number, Meta Ads Manager will show a different (usually inflated) return on ad spend, and GA4 will show yet another version of the funnel depending on how attribution is configured. None of them are lying exactly, they're just measuring different things with different windows and different rules. That's why a warehouse layer, something like Redshift, matters: it pulls raw data from each source and reconciles it into one consistent number instead of forcing you to guess which platform is closest to the truth.
The gap brands forget most often is retention data from Klaviyo or Mailchimp. Everyone remembers to hook up ad platforms because that's where the money burns. Fewer remember that email and SMS drive a real chunk of repeat revenue, and without that data, your repeat purchase rate and LTV numbers are incomplete. If you're building out custom dashboards that pull from a warehouse, make sure email and SMS platforms are in the source list from day one, not bolted on later.
How Should Ad Spend and Attribution Data Be Displayed?
Platform-reported ROAS is almost always inflated. Meta and Google both use last-click, in-platform attribution models that take credit for conversions other channels helped drive. Blended ROAS (total revenue divided by total ad spend across all channels) and MER (marketing efficiency ratio) strip that bias out and give you a number closer to reality.
The right way to display this isn't one blended number sitting alone. Show spend and revenue by channel side by side with the blended figure. That way you can actually see where CAC is creeping up on a specific channel instead of it getting buried in an average that looks fine overall.
One thing that trips up a lot of teams: attribution windows aren't consistent across platforms. Meta might default to a 7-day click window, Google to something different, TikTok to something else again. A dashboard that just pastes in raw platform exports without normalizing these windows is comparing numbers that were never meant to be compared. This is a big part of what a proper insights layer should be doing behind the scenes, not something you should have to manually correct in a spreadsheet every week.
What Inventory and Fulfillment Data Belongs on the Dashboard?
Marketing metrics tell you half the story. Inventory and fulfillment fill in the rest.
At minimum, you need stock-on-hand, sell-through rate, and days-of-inventory-remaining. Without these three, you're flying blind on stockouts (which kill momentum on a product that's finally working) and overstock (which ties up cash you need for the next ad push).
Fulfillment cost per order deserves a spot right next to your marketing numbers too. A product can look profitable on paper with a healthy contribution margin, then quietly lose money once you factor in a shipping cost spike or a warehouse fee increase. True profitability only shows up when marketing and ops data sit in the same view.
This is genuinely where a lot of marketing-first tools fall short. Triple Whale and Northbeam were built to answer ad performance questions, not ops questions. They're good at what they do, but stock levels and fulfillment costs were never part of their core design, so brands end up bolting on a second tool (or a spreadsheet) just to see the operational side. If profitability is the question you're trying to answer, marketing data alone won't get you there.
How Often Should the Data Refresh?
Not every metric needs to update at the same speed, and treating them all the same is a common mistake.
Ad spend needs to be close to real-time. If you're pacing a $50k daily budget, you need to know by early afternoon if a campaign is overspending, not find out the next morning when the damage is already done. Same-day ad spend should be visible within hours.
Inventory levels and LTV cohorts don't need that urgency. A daily batch sync is fine for those, since stock levels don't swing hour to hour the way ad spend does.
The mistake a lot of dashboards make is applying one blanket refresh setting to everything, which either wastes compute refreshing inventory every ten minutes or leaves ad spend stale for a full day. A Redshift-based pipeline lets you set refresh cadence per data source, so fast-moving numbers stay current and slow-moving ones don't need to.
What Makes a Dashboard Actionable Instead of Just a Report?
Charts are passive. You still have to look at them, notice something's off, and figure out what changed. An actionable dashboard flags the anomaly for you: "CAC on Meta up 22% week over week" shows up on its own instead of waiting for someone to spot the trend line bending the wrong way.
Forecasting is the other piece that separates a report from a decision tool. Projecting the next 30 days of revenue, or flagging when you'll run out of stock on a bestseller based on current sell-through, gives you something to act on today instead of a history lesson about last month.
This is really the line between a dashboard and a decision-support tool. One tells you what happened. The other tells you what's about to happen and what to do about it. If you're evaluating tools and trying to figure out what should be in an ecommerce analytics dashboard versus what should be in an actual insights system, this is the dividing line to use. Tools like Trivas Insights and forecasting and simulation exist specifically to close that gap.
How Trivas Approaches Ecommerce Dashboards
Trivas combines Redshift-based BI reporting with the Wingman AI insights layer and forecasting in one system, so you're not stitching together a warehouse, a BI tool, and a separate forecasting spreadsheet on your own.
The pain point this solves is a specific one: it cuts weekly reporting time from around three hours down to about 20 minutes, mostly by removing the manual CSV stitching that eats up a founder's Monday morning. Wingman flags the anomalies automatically, the forecasting layer projects what's coming next, and the reporting sits on top of a warehouse that reconciles Shopify, Amazon, ad platforms, and GA4 into numbers that actually agree with each other.
If you're tired of rebuilding the same spreadsheet every week, it's worth seeing what a dashboard built around your own data actually looks like. Subscribe to updates or poke around the rest of our resources if you want to keep digging into how this stuff should work before you commit to anything.
Revenue growth leader and co-founder driving Trivas's commercial strategy. Om has led the product vision and execution from scratch. With a strong background in SaaS sales and GTM strategy, Om bridges product innovation with real-world customer needs.
Continue Reading
explore more insights
Best Shopify Analytics Tool for US Brands (2025 Comparison)
3 min read
Is Northbeam Worth It? The Complete Guide for DTC Founders
3 min read
What Is TikTok Shop Analytics for DTC Brands? A Beginner's Guide
.d53b12e5.png&w=3840&q=75 "Trivas.ai")
by Om Rathod
