Ecommerce Reporting: Reports, KPIs and a Weekly Workflow

Ecommerce reporting is the routine of pulling sales, customer, product, marketing and operations data into a small set of reports that tell you what happened in your store and what to do next. Shopify’s guide frames it as turning raw data into decisions about merchandising, acquisition cost, inventory risk and retention. The practical version: pick six report types, give each a cadence and an owner, tie every number to an action, and automate the pulling so your time goes into reading, not copying.

This guide covers which reports to run, which KPIs go in each, why your ad platform and your store never agree, and how to build a weekly review you will actually keep doing.

TL;DR

• Run six report families: sales and revenue, conversion and checkout, customers, marketing and acquisition, product and inventory, and returns.
• Every report needs an action attached. A number nobody will act on does not belong in the weekly rotation.
• Ad platforms and your store count orders differently, so use a blended metric such as MER as the headline and platform ROAS as a directional input.
• Automate the data pull and keep the human part: the short note on what changed and what you will do about it.
• Caybl connects Google Ads, Google Analytics and Search Console so you can ask questions in plain English instead of building each report by hand.

Table of Contents

• What ecommerce reporting covers
• The six reports worth running
• KPIs that belong in each report
• Why your ad numbers never match your store
• Turn every number into an action
• Build a weekly report that stays short
• Automating the data pull
• Where Caybl fits in your reporting
• Our perspective
• FAQ
• Sources

What ecommerce reporting covers

A useful definition is narrow. Ecommerce reporting collects, analyzes and presents data about an online store’s performance, centered on commerce-specific metrics such as orders, revenue, conversion rates and customer behavior across the buying journey. It sits next to two neighbors that people often blur with it:

• Reporting tells you what happened. Revenue was down 12% last week.
• Analytics tells you why. Mobile checkout completion fell after a shipping-cost change.
• Attribution tells you where it came from. The extra orders traced back to a specific channel or campaign.

Shopify’s Elise Dopson makes exactly this three-way split, and it is a good filter for your own reports. If a report cannot be followed by an analytic question, it is decoration.

The payoff is consolidation. Ramp’s guide describes good reporting as unifying data from the website, marketing channels, payment systems, inventory tools and accounting software into one source of truth. For a marketer, that means the Google Ads number, the GA4 number and the store number finally sit in the same conversation.

The six reports worth running

Shopify’s 2026 guide groups the field into six core report categories with suggested cadences. That structure holds up well for stores of any size, because it separates the daily checks (is anything broken?) from the weekly and monthly reviews (what should we change?).

If you are small, start with three: sales, conversion and marketing. Add the rest when a question you cannot answer starts costing you money.

Sales and revenue

This is the front page. Total revenue, order count, average order value (AOV), refunds and sales by channel. Split new from returning customers early, because a flat revenue line can hide a store that is buying growth and losing loyalty.

Conversion and checkout

Track overall conversion rate, add-to-cart rate, checkout completion and cart abandonment. GA4 can build much of this, and one walkthrough of GA4 ecommerce reports starts with purchases by item category and funnel exploration for exactly this job. Watch mobile separately from desktop; checkout problems usually show up on one device first.

Customers

Repeat purchase rate and customer lifetime value (CLV) by cohort are the two numbers that most often get skipped. Flowium’s CMO guide warns that acquisition metrics can look strong quarter after quarter while profitability quietly erodes, because nobody is tracking what happens after the first purchase.

Marketing and acquisition

Spend, clicks, CPC, CTR, conversions, ROAS and customer acquisition cost (CAC) by channel and campaign. This is the report where a connected Google Ads and Analytics view saves the most time, and where the reconciliation problem below bites hardest.

Product and inventory

Best sellers, sell-through rate, stockout flags and margin by product. For advertisers there is one extra check: are you spending on products that are about to run out, or that carry thin margin?

Returns and post-purchase

Return rate by SKU, with reasons. A spike on a single SKU usually points to a listing, sizing or quality issue, not a marketing one, but it still drags down the true return on the ads that sold it.

KPIs that belong in each report

Sources differ on the exact list, but they converge. Flowium organizes KPIs into three layers: acquisition, conversion and retention. GoDaddy says most stores benefit from tracking AOV, cart abandonment rate, conversion rate, cost per acquisition and customer lifetime value. NetSuite splits dashboards into financial health metrics and traffic and engagement metrics.

Here is a working set, organized the way a marketer reads it:

• Acquisition: sessions by channel, spend, CPC, CAC, ROAS by channel, revenue from new customers.
• Conversion: conversion rate, add-to-cart rate, checkout completion, cart abandonment, AOV.
• Retention: repeat purchase rate, CLV by cohort, share of revenue from email and SMS.
• Executive: net sales, refunds, total ad spend, blended MER, contribution margin, payback period.
• Technical health: page load time, bounce rate, mobile versus desktop share.

That last group is easy to forget. Mailchimp’s dashboard guide includes technical health alongside sales, customer, marketing and inventory metrics, and slow pages quietly tax every ad dollar you spend.

A note on benchmarks

You will see ranges quoted everywhere. One roundup puts typical conversion rates at 1.5% to 3.5% and ROAS at 3x to 5x, as summarized in Flowium’s guide. Treat these as rough orientation, not targets. Your margins, category and average order value decide what a healthy ROAS looks like. A store with 70% gross margin and one with 25% need very different numbers.

Why your ad numbers never match your store

This is the most common reporting argument in any marketing team. Google Ads says one number, GA4 says another, and the store platform says a third.

The reason is not a bug. Each tool counts differently. According to Engineers in Marketing, Google Ads uses data-driven attribution over a 30-day click window, GA4 uses its own configurable window, and Shopify uses last-click with a lookback that often defaults to 28 days. Each ad platform also claims the orders it influenced, so platform totals rarely add up to the store total, a point Brand Media Works makes about brands that report each platform’s own numbers.

The fix is to stop forcing the numbers to match:

1. Treat the store as the source of truth for orders and revenue. EzCommerce calls this the commerce truth layer: orders, revenue and refunds come from the store.
2. Use analytics for events and sessions. GA4 and Tag Manager tell you what shoppers did on the site.
3. Use ad platforms for spend and signals. Spend, clicks, impressions and platform-reported conversions are directional.
4. Report a blended headline. Marketing efficiency ratio (MER), total revenue divided by total ad spend, is the headline KPI that the Engineers in Marketing article recommends, with platform ROAS as a directional input.
5. Audit your conversion actions. Double-counted conversions inflate platform ROAS faster than anything else.

One more nuance from EzCommerce: a campaign with a lower ROAS but better new-customer quality or a higher repeat rate can be worth more than a high-ROAS retargeting campaign. You only see that if contribution margin and payback period are in the report.

Turn every number into an action

A report earns its place by changing what you do on Monday. Ringly.io suggests defining action triggers in advance, such as reviewing checkout if cart abandonment exceeds 75% or auditing campaigns if CAC rises 20% month over month. The thresholds are examples; set yours from your own history.

Shopify’s guide pairs patterns with first moves:

These come from Shopify’s reporting guide, which also advises assigning each key metric to a team or function responsible for reviewing, interpreting and acting on it. Without an owner, a dashboard turns into wallpaper.

A practical rule: write the action next to the metric before the report goes into rotation. If you cannot name one, drop the metric.

Build a weekly report that stays short

Brand Media Works describes a weekly marketing report in six sections: revenue and orders, new and returning customers, spend and results by channel, email and SMS revenue, top products and stock alerts, and a closing note on what changed and what the team will do. The first five can refresh automatically. The last is the one that needs thinking.

Here is a version you can run in 20 minutes:

1. Headline row. Revenue, orders, AOV, MER, week over week and against the same week last year.
2. Channel table. Spend, conversions, ROAS and CAC for each paid channel, plus organic search clicks from Search Console.
3. Funnel check. Conversion rate and checkout completion by device.
4. Product watch. Top sellers, stockout risks, and any ad-promoted product that is low on stock.
5. Wasted spend. Search terms, campaigns or keywords that spent without converting.
6. What changed, what we will do. Three bullets, each with an owner.

Different readers want different cuts. An owner wants rows 1 and 6. A channel manager wants 2 and 5. An agency client wants a clear, short story with the numbers behind it. Build the full report once, then send each reader the slice they use.

Automating the data pull

The usual automated setup is, per Brand Media Works, a connector pulling from the store, ad platforms and email platform, a storage layer, and a dashboard or emailed report on top. That is a sound architecture for larger brands. For a marketer who mainly needs answers from Google Ads and Google Analytics, there is a lighter path: connect the accounts to an assistant and ask.

That is where Caybl fits. It connects Google Ads, Google Analytics and Search Console, plus Microsoft Advertising, Bing Webmaster Tools, Tag Manager, YouTube and PageSpeed Insights, so you can ask a question like which campaigns spent the most last week without converting, and get an answer without exporting a file or building a custom report. You can use it inside Caybl or through an AI assistant such as Claude or ChatGPT.

Where Caybl fits in your reporting

If your weekly report depends on Google Ads, Google Analytics and Search Console, Caybl takes over the slow part: pulling and cross-checking the numbers. You connect your accounts, start asking questions in plain English, and run audits for wasted spend or broken tracking. For selected actions you can apply recommended fixes directly or through your AI assistant.

Plans are published on the Caybl pricing page: Free at $0, Pro at $29 per month, and Team from $20 per month per seat. If you run out of credits, 500 more cost $6 one-off. You can start on the free tier and see how it handles your own weekly questions.

To connect your ads and analytics to Claude, see the Google Analytics and Google Ads MCP server page.

Our perspective

Most ecommerce reporting fails at the same point: the data exists, but getting to an answer takes too long. Someone exports a CSV from one platform, another from a second, and the meeting starts before anyone has found out why spend went up.

We built Caybl on a simple belief: the person responsible for the numbers should be able to ask a question and get an answer. Which campaigns are wasting budget? Did tracking break after the last site release? Why did Search Console clicks rise while conversions fell? Those are sentences, not projects.

That is why we focus on connecting Google Ads, Google Analytics and Search Console with minimal setup, and on letting you work from Caybl itself or from the AI assistant you already use. Reporting should end in a decision and, where it makes sense, a fix. Our platform supports both reading your data and selected write actions, so the insight and the change can happen in one place.

The best report is the one you actually read every Monday. Make it short, give every number an owner, and let software do the pulling.

Gearoid

FAQ

What is the difference between ecommerce reporting and ecommerce analytics?

Reporting presents what happened: revenue, orders, conversion rate and spend. Analytics digs into why it happened, such as which device, product or channel drove a change. Good teams use reports to spot movement and analytics to explain it.

Which ecommerce metrics should I track first?

Start with revenue, orders, AOV, conversion rate, cart abandonment, CAC and ROAS or MER. These cover the core KPIs most stores benefit from. Add CLV and repeat purchase rate once you have enough order history to see cohorts.

How often should I run ecommerce reports?

Match cadence to how fast the metric moves. Sales topline, checkout anomalies and campaign pacing suit a daily glance, while funnel reviews and channel performance suit a weekly review. Customer lifetime value and cohorts are better monthly, as in Shopify’s suggested cadences.

Why does Google Ads show more conversions than my store?

The tools use different attribution models and lookback windows, and each ad platform counts the orders it influenced. Report store revenue as the truth, track MER as the headline, and use platform ROAS as a directional signal, as Engineers in Marketing advises.

Can I use Claude or ChatGPT for ecommerce reporting?

Yes, once your ad and analytics accounts are connected to the assistant. Caybl provides that connection for Google Ads, Google Analytics and Search Console, so you can ask questions about performance in plain English. Start with the free plan on the pricing page.

Sources

• Ecommerce Reporting: Top Reports & Metrics to Track
• E-commerce Reporting Guide: Metrics, Reports & Tools
• Ecommerce reporting explained: what you need to know
• eCommerce Reporting: CMO’s Complete Performance Guide
• Which ecommerce KPIs should you focus on?
• 38 Ecommerce Metrics to Track in 2025
• Ecommerce Dashboard: Must-Have Features & Metrics
• How to Build a Cross-Channel Attribution Dashboard for D2C
• Automated marketing reporting for ecommerce brands
• Why your Google Ads conversions don’t match Shopify revenue

Made with BabyLoveGrowth’s AI