Ecommerce Reporting: Metrics, Dashboards and a Template

What ecommerce reporting covers

An online store has data in at least three places: the store (orders, products, customers), the ad platforms (spend, clicks, platform-reported conversions) and, for many brands, an email tool. Each one has its own report, and each one is accurate only about its own corner.

• Store reports show what was actually sold. Shopify's analytics, for example, give you a customizable dashboard of metric cards, and each card opens a deeper report with a chart and a detailed table.
• Ad reports show what the ads delivered and what they cost. Meta Ads Reporting builds custom reports from breakdowns, metrics and filters.
• Email reports show what flows and campaigns earned from existing customers.

Ecommerce reporting is the job of reading all three together. Read alone, each report flatters its own channel. Read together, they show profit. If you want a wider view of the Meta side, see our guide to Facebook ads reporting.

Metrics that matter, by question

Two of these need a note.

ROAS against break-even ROAS. ROAS is revenue divided by ad spend. It tells you nothing about profit until you set it against your margin. Use the break-even ROAS calculator to find the line your campaigns have to clear.

Blended ROAS. Total store revenue divided by total ad spend across every platform. It ignores which platform gets the credit, which makes it harder to game than any one platform's number. Use it as the headline, and use the platform numbers to decide where to move budget.

Weekly, monthly and quarterly cadence

Each rhythm answers a different kind of question, so each gets a different report.

• Weekly: what do we change now? Revenue, spend, blended ROAS, CPA by campaign and creative performance. Meta's Time breakdown shows results by day, week, 2-week periods and months, so the weekly view is one setting away.
• Monthly: how did the month go? Revenue against target, ROAS by channel, top and bottom products, repeat purchases and email revenue. Compare with the previous month and the same month last year.
• Quarterly: is the strategy working? Channel mix, customer acquisition cost against customer value, and which products or offers earn their ad spend.

Keep the weekly report short enough to read in ten minutes. Anything longer gets skipped, and a skipped report changes nothing.

A one-page report template

Copy this layout into a spreadsheet, a Shopify analytics dashboard or a reporting tool. Fill the same cells every week, so the page is quick to compare.

Block 6 turns the report from a record into a tool. Over a few months it shows which of your decisions paid off.

Blending ad, store and email data

The hardest part of ecommerce reporting is joining the numbers. The ad platform reports the sales it thinks it caused, the store reports the orders it saw, and the two never match exactly. Do not try to force them to. Use them for different jobs:

• The store is the source of truth for revenue and orders.
• The ad platform is the source for spend, delivery and creative results.
• Blended ROAS joins them: store revenue divided by total ad spend.

Meta also says that statistical modeling may be used in breakdowns to fill in conversion data when it is missing or partial, and that conversions it cannot attribute to a breakdown row show up as "Uncategorized", as described in its Ads Reporting guide. That is one more reason to check the platform's total against your store before you read the split.

Joining platforms by hand means copying exports into a sheet every week. A reporting tool that connects the sources does it for you. See our overview of the best dashboards for ecommerce ad analytics and the answer page on how to compare reporting dashboards for Meta ads.

Share reports with a team or client

• Inside Shopify, staff members need the Analytics permissions to see reports and dashboards, so check access before you promise a colleague a view.
• Outside the store, send a link or a PDF. A link stays current. A PDF is a snapshot you can attach to an email or a monthly review.
• Pair every number with a sentence. A manager or client reads the headline and the sentence under it, not the table.

If you send reports to clients, our guide to a Facebook ads client report has a template and the key metrics to include.

Common reporting mistakes

• Reporting every metric. Twenty numbers hide the three that matter. Pick the headline block and add detail only on request.
• Trusting one platform's revenue. Compare it with the store's orders before you act.
• Mixing click definitions. Meta's reporting separates all clicks from link clicks. Use one consistently, or a benchmark will mislead you.
• Comparing different date ranges. Check the ad account and the date range at the top of the report before you read it. Meta's help page tells you to do exactly that.
• Ignoring margin. A good ROAS can still lose money.
• Reporting without a next step. If no decision comes out of the page, shorten it.

For more on running ads in a store, see our guide to ecommerce advertising strategies.

Build the weekly ecommerce report with Madgicx

Meta Ads Reporting and Shopify's analytics are the baseline: each one reports its own side well. Madgicx joins them.

• One-Click Report and the dashboards combine Meta, Google Ads, TikTok, Shopify and Klaviyo data in one place, so ad spend sits next to store and email results. You share the report by link or PDF.
• The Business Dashboard shows blended business metrics, which is the headline block of the template above.
• Copilot answers questions about your account in plain language, using your own data, with charts. Ask it which campaigns dropped last week.
• Alerts suggest metric thresholds from your own numbers, so a problem reaches you before the weekly read.
• AI Marketer reviews the account and prepares recommendations that you complete or dismiss, which gives block 6 of the template its first draft.

For the full workflow of automating the Meta side, read our answer on how to automate Meta ads reporting.

Try Madgicx free for 7 days

FAQ