The treasure in your hands that you never open
Every Shopify store already owns 60+ reports that answer the questions owners pay agencies to guess at. Here is how they are split, which five matter, and how a business owner and a media buyer should each read them.
Short answer: Shopify reports are split into eleven families (Sales, Orders, Customers, Acquisition, Behavior, Marketing, Finance, Profit, Inventory, Fraud, Retail). Only four questions matter for growth: where do people come from, what do they do on the store, what do they buy, and do they come back. Five reports answer those four questions — Conversion rate breakdown, Total sales by product variant, Customer cohort analysis, New vs returning customers, and Sessions by referrer (with UTMs). Everything else is detail.
In most stores we audit across Egypt, Saudi Arabia and the UAE, the owner has opened the Analytics home page hundreds of times and the Reports page fewer than five. That gap is the cheapest growth lever in the business, because the reports are free, already populated, and they describe your customers, not a benchmark.
questions that cover 90% of growth decisions. Match each to one report and stop scrolling the rest.
A store can lose conversion rate and still grow revenue per session by 57%. The funnel report alone would have called that a failure.
Shopify's attribution resets after 30 days of inactivity and defaults to last non-direct click. Your Meta ROAS and Shopify's "sales by referrer" will never match — by design.
Eleven families, four questions
Shopify organises reports by data type. Owners think in questions. This is the translation. Starred reports are the ones we open every Monday.
Where do they come from?
- Sessions by referrerDirect, search, social, email, unknown — with UTM campaign as a dimension.
- Sessions by locationCountry → region → city. In KSA, Riyadh vs Jeddah alone changes your ad split.
- Sessions by deviceExpect 85–95% mobile in MENA. If desktop converts 2× better, the mobile site is the problem.
- Sessions by landing pageWhich page your ads actually land on, and how it converts.
What do they do?
- Conversion rate breakdownSessions → added to cart → reached checkout → completed. The only funnel with your real numbers.
- Conversion rate over timeWeekly, never daily. Daily CVR on 300 sessions is noise.
- Searches with no resultsWhat people type and cannot find. A free product-development list.
- Web performanceCore Web Vitals. A slow product page silently taxes every campaign.
What do they buy?
- Total sales by product variantThe winner list. Variant level, not product level — the size or colour that sells is what the ad should show.
- Average order value over timeYour AOV is the ceiling on your CAC. Track it monthly.
- Sales by discount codeHow much of revenue is bought with margin.
- Total sales by referrerLast-interaction revenue by source — read with the attribution caveat below.
Do they come back?
- Customer cohort analysisGroups customers by first-purchase month and shows who buys again. This is LTV, in one grid.
- New vs returning customersReturning rate is the number that decides whether you can afford a higher CAC.
- RFM customer analysisEleven segments (Champions, Loyal, At risk…) ready to sync as Meta custom audiences.
- Predicted spend tierShopify's own model of who will spend most.
The funnel report, and the trap inside it
Conversion rate breakdown is the most-quoted Shopify report and the most misread. Here is a real shape from one of our Egyptian eCommerce accounts, indexed to 1,000 sessions.
Same store, two lines, opposite stories
Session conversion rate (amber) and revenue per session (mint), indexed to 100 at month 1, over 22 months. The line owners look at went down. The line that pays the bills went up.
The cohort grid is your LTV, drawn
Customer cohort analysis groups everyone who bought for the first time in a given month, then shows what share of them bought again in the months after. It is the single report most owners have never opened, and the one that tells you how much you can pay to acquire a customer.
Illustrative grid in the shape we see when a store adds a post-purchase flow and a returning-customer offer: each newer cohort comes back at a higher rate. Cells read "share of the cohort that placed another order in that month". Example values, not a specific client.
How to read it in 60 seconds
Read down a column, not across a row. Column "+1" tells you whether your second-purchase rate is improving cohort by cohort. If it is flat, retention emails and offers are not working, whatever the open rates say.
Sum a row to get repeat revenue per customer. Switch the metric from "customers" to "net sales" and a 6-month row gives you the LTV of that cohort so far. Divide by first-order count and you have the number your CAC must sit under.
Filter by first product. Cohorts by first product purchased tell you which item creates repeat buyers. That product deserves the acquisition budget even if its first-order ROAS is lower.
What to open every Monday
The same five reports, two different jobs. The owner protects margin and repeat purchase. The media buyer protects the winner list and the landing page.
The owner
- Total sales over time — weekly, against the same week last year.Seasonality in MENA is violent (Ramadan, Eid, White Friday, back to school). Month-over-month lies; year-over-year tells the truth.
- Average order value over time.If AOV drops while orders rise, discounts are buying growth with your margin. Check Sales by discount code next.
- New vs returning customers.Returning rate below 15% in a replenishable category means every month starts from zero and CAC will only rise.
- Customer cohort analysis — net sales.Is the +1 column climbing? This is the only place retention is visible.
- Conversion rate breakdown — with AOV next to it.Ask "revenue per session", never "conversion rate" alone.
The media buyer
- Total sales by product variant — last 7 and last 28 days.Your catalog "bestseller" product set should be built from this list, not from the merchandiser's opinion. We automate this tagging with Shopify Flow.
- Sessions by landing page — filtered to UTM source.The page your ad lands on, with its own conversion rate. A 0.4% landing page kills a 3× ROAS creative.
- Sessions by device and location.If iOS converts at half of Android in Egypt, check the checkout, not the audience.
- Searches with no results.Demand you are already paying for and cannot fulfil. Feed it to the product team, and to your keyword list.
- Sales attributed to marketing — by UTM campaign.Not to replace Ads Manager ROAS, but to reconcile it. The gap between the two is your real attribution error.
Gross, net, total: three "sales" that are never the same
Every argument between an owner and an agency about "revenue" is one of these three numbers being compared to a different one.
| Number | Shopify formula | Use it for |
|---|---|---|
| Gross sales | product price × quantity, before discounts, returns, tax, shipping | Demand. What people wanted to buy. |
| Net sales | gross − discounts − sales reversals | Growth, MER, and any comparison to ad spend. |
| Total sales | net + taxes + duties + shipping + fees | Cash in. Never use it for ROAS — shipping is not margin. |
| Attribution model | Who gets the sale | When to switch to it |
|---|---|---|
| Last non-direct click (default) | The last channel before purchase, ignoring direct visits | Default reading. Closest to how the owner experiences "where the sale came from". |
| Last click | The very last touch, including direct | Rarely. It inflates "Direct" and hides paid channels. |
| First click | The channel that introduced the customer | Judging prospecting campaigns and TikTok/Snap, which rarely close the sale. |
| Linear | Equal credit to every touch | Board-level channel-mix arguments, not daily optimisation. |
| Any click | Full credit to every channel touched | Never for totals — it double counts. Useful only to see which channels assist. |
Two more rules Shopify applies quietly: a session ends after 30 minutes of inactivity or at midnight UTC, and first-interaction attribution resets after 30 days without a visit or after a purchase. Meta's default is 7-day click / 1-day view on its own pixel events. Different windows, different models, different currencies of truth — which is why platform ROAS and Shopify revenue by referrer must be reconciled, not compared.
Five additions that change the Monday routine
Shopify's Spring '26 edition moved analytics from "reports you open" to "reports that come to you". Three of these are worth setting up this week.
Custom explorations (build any report from metrics + dimensions, write ShopifyQL, or ask Sidekick to write it) are available on all plans; plan tiers change how far back and how deep you can go.
Three honest reasons owners never open Reports
The Analytics home is designed to be enough. It shows total sales, sessions, conversion rate and top products. Those four tiles answer "how did we do", which feels like the question. They never answer "why", which is the only question that changes next month.
The reports are named by data, not by decision. "Sessions by referrer" does not sound like "which channel should get more budget". The translation table above is the missing manual.
The agency owns the dashboard. When the only numbers an owner sees are the ones the ad platform reports, the store's own data becomes the agency's private source. A good partner does the opposite: it teaches the owner to read the five reports, because that is what makes the monthly conversation about the business instead of about ROAS.
That last point is not generosity. An owner who reads cohort and AOV reports approves higher-CAC campaigns that a ROAS-only owner would cut. The treasure pays the agency too.
FAQ
Which Shopify report shows my best-selling products?
Total sales by product variant. Use variant level, not product level, and read it over 28 days for stability and 7 days for what is moving now. This list should feed your Meta catalog "bestsellers" product set.
Why doesn't my Meta ROAS match Shopify's sales by referrer?
Different attribution windows and models. Meta defaults to 7-day click / 1-day view on pixel events; Shopify defaults to last non-direct click with a 30-day inactivity reset and a session that ends at midnight UTC. Neither is wrong. Reconcile them monthly by comparing paid-attributed net sales in Shopify to Meta-reported revenue and tracking the ratio, not the absolute gap.
What is a good Shopify conversion rate in Egypt or Saudi Arabia?
Session conversion for mobile-heavy, COD-heavy stores in MENA typically sits between 0.8% and 2.5% depending on category and price point. But conversion rate without AOV and revenue per session is not a performance number. A store at 1.25% with a 2× AOV outperforms a store at 2% with a small basket.
Do I need Shopify Plus to see cohort or RFM reports?
Customer cohort analysis, RFM customer analysis and custom explorations are available on the standard plans; deeper history and some advanced reports depend on plan tier. Check the report's availability note inside your admin before assuming you need to upgrade.
What is the difference between net sales and total sales?
Net sales is gross sales minus discounts and sales reversals. Total sales adds shipping, taxes, duties and fees on top. Judge growth and marketing efficiency on net sales; total sales is a cash figure.
How often should I look at these reports?
Weekly for the five core reports, monthly for cohorts and AOV trends, and never daily for conversion rate on a store under a few thousand sessions a day — the noise will make you change things that were working.
Want the five reports read on your store, this week?
A free audit covers exactly these reports plus your ad accounts, and comes back as a short written diagnosis, not a sales deck.