How to Build an Ecommerce KPI Dashboard for Shopify

Most Shopify owners check revenue and call it a dashboard. Revenue is the score at the end of the game, not the play-by-play that tells you what to do next. A real ecommerce KPI dashboard puts the leading indicators in one view so you can read your store in under a minute. This is the build guide that sits under the ecommerce metrics and KPIs that predict growth.

What belongs on the dashboard

Group the metrics by the question they answer, not by where they came from. Four groups cover a Shopify store.

Acquisition

• Sessions and traffic source so you know where demand is coming from.
• Conversion rate, the share of visitors who buy. The single fastest lever on revenue.
• Customer acquisition cost (CAC) per channel, because traffic that does not pay back is a leak.

Order economics

• Average order value (AOV). Track it next to your effort to increase average items per order.
• Revenue, split into new vs returning so growth is not hiding churn.

Retention and value

• Repeat purchase rate, the heartbeat of a healthy store. Work it with strategies to increase repeat purchase rate.
• Customer lifetime value (LTV), ideally predicted. See the LTV guide.
• Cohort retention, so you can see whether each month of new customers sticks. Covered in cohort analysis for Shopify.

Marketing efficiency

• Blended MER rather than platform ROAS, for the reason laid out in ROAS vs MER.
• LTV:CAC ratio, the one number that says whether growth is profitable. See the LTV:CAC guide.

How to assemble it

1. Pick one source of truth. A dashboard fed by three tools that disagree is worse than no dashboard. Pull spend, orders, and customer data into one place.
2. Show trend, not just today's number. A KPI without a week-over-week or month-over-month comparison is trivia. Every tile should show direction.
3. Segment the headline metrics. New vs returning, by channel, by cohort. A blended number hides the story.
4. Make it the first thing you open. A dashboard you check weekly beats a perfect one you build once and forget.

Why a spreadsheet is not enough

You can build version one in a spreadsheet, and many stores do. It breaks the moment the data needs to refresh itself or segment on demand. The durable version updates automatically and lets you slice any metric by cohort or channel without rebuilding formulas. That is what By the Numbers does: it assembles these KPIs from your live Shopify data and ad platforms, and its AI briefing surfaces the three that changed most each week so you do not have to scan the whole board.

A dashboard is not about having every metric. It is about having the handful that change a decision, in one place, trending. Build that and the weekly "how is the store doing" question takes a glance instead of an afternoon.

Keep reading

If you want the full picture on ecommerce metrics and KPIs, start with the KPIs that actually move Shopify revenue.

Related reading: Best Shopify Analytics Plan For Store Growth, 7 Common Shopify Analytics Mistakes to Avoid and Why You Need Custom Reports to Scale.

By the Numbers builds this into the dashboard. See Shopify ecommerce reporting.