Shopify Analytics is built to show you what happened inside your store. It is not built to show you whether your business is profitable. That distinction sounds minor. It is not. Most DTC founders run their week off the overview dashboard: sessions, orders, revenue, conversion rate. Those numbers are real. They are just incomplete in ways that cost you money quietly and continuously.
The leakage is not dramatic. You will not see a sudden drop that triggers an alert. You will see steady revenue growth alongside a bank balance that never quite reflects it. Margins compressing gradually. CAC rising without explanation. The fix is not a new analytics tool. It is six reports already inside your Shopify admin, read properly, in the right sequence.
Why Shopify Analytics Fails DTC Operators at Scale
Shopify Analytics is accurate for what it measures: transactions. Revenue comes in, orders go out, the dashboard reflects that. The problem emerges in three areas where it systematically underreports or misreports reality.
First, attribution is unreliable. Shopify uses last-click attribution by default. A customer who discovers your brand via a TikTok ad, reads three emails over two weeks, then buys after clicking a Google search result gets credited entirely to Google. The email and TikTok investment are invisible. Brands making channel allocation decisions based on this data are systematically underfunding their best-performing touchpoints.
Second, Shopify treats each store as a separate data silo. If you run a UK store and a US store, your customer who buys from both is counted as two separate customers. Retention metrics, LTV calculations, and cohort analysis are all inflated as a result. The problem compounds as you scale internationally.
Third, Shopify shows revenue. It does not show profit. COGS, shipping, fulfilment, returns, and ad spend are not subtracted anywhere in the standard analytics view. A brand generating 200k GBP per month in revenue could be running on 8% contribution margin and Shopify's dashboard would look exactly the same as a brand running on 38%.
The 6 Shopify Reports That Actually Show Revenue Leakage
Returning Customer Rate
Analytics > Customers > Returning customer rate
This is the most under-read report in the average DTC admin and the one with the most direct connection to unit economics. Your returning customer rate tells you what percentage of your orders in any given period came from customers who had bought before. The inverse is your new customer rate, and that ratio determines whether your CAC is sustainable.
A returning customer rate above 25% is healthy for most verticals. Consumables (supplements, skincare, food) should be pushing 35 to 50%. Below 20% means you are constantly paying to replace customers who do not come back, which means your unit economics require a first-order margin that almost no DTC brand achieves.
The lever this report exposes is timing. Shopify lets you filter this by date range. Run it month by month for the last 12 months. If your returning customer rate is declining over time, your retention programme is weakening even if your total revenue is growing. You are running faster just to stay still, and the cost of that treadmill compounds every quarter.
Sessions Converted by Traffic Source
Analytics > Acquisition > Sessions converted
Most founders look at traffic by source. Fewer look at conversions by source. The gap between those two is where attribution lies hide.
A channel can drive 30% of your sessions and 8% of your conversions. At that ratio, you are paying for attention that does not buy. The sessions converted report shows you which channels actually close, not just which ones drive clicks. This is the operational counter to what your ad platform dashboards show you. Meta will tell you a campaign drove 47 purchases. Shopify will tell you how many of those sessions actually converted in your store. The difference is often significant.
Read this report filtered by week, not month. Conversion rates by source fluctuate with creative fatigue, seasonality, and algorithm changes. A month-level view smooths out signals you need to act on in real time. If paid social conversion is dropping week on week while organic or email holds, that is a creative fatigue signal, not a structural decline.
Customers Over Time (Cohort Analysis)
Analytics > Customers > Customer cohort analysis
This is the most powerful and most neglected report in Shopify Analytics. The cohort analysis shows you, for customers acquired in a given month, how much revenue they generated in each subsequent month. It is the only native Shopify report that gives you a true LTV signal rather than a blended average.
Blended LTV averages hide critical information. A brand with a high blended LTV might be carrying that average on the back of customers acquired two years ago, while their recent cohorts are significantly weaker. The cohort analysis surfaces this immediately. If you are spending more to acquire customers now than you were 12 months ago but getting weaker cohort performance, your growth is genuinely running in reverse regardless of what the revenue chart shows.
Run this quarterly. Identify your strongest cohorts by acquisition month and trace back what was different: which product drove the first purchase, which channel brought them in, which offer was running. That reverse-engineering tells you exactly what to replicate.
Average Order Value by Product
Analytics > Products > Product sales (sort by revenue vs orders)
This report requires a small manual step but is worth it. Export your product sales report and calculate average order value for orders containing each SKU. Most brands discover that their best-selling product by volume is not their best-performing product by margin or by AOV contribution.
The finding that changes strategy most often is the discovery of AOV anchors: products that, when present in an order, consistently pull in other items. These are not always your most promoted SKUs. Sometimes they are mid-range products that serve as natural bundle starters. Once you identify them, you build your homepage, your email flows, and your ad creative around leading with those products.
The inverse finding is equally valuable: products that sit at the bottom of your range in price, that customers buy alone, that have high return rates. These are AOV destroyers. They are often your most-advertised products because they have the lowest barrier to purchase. Understanding this trade-off lets you make conscious decisions about promotional strategy rather than defaulting to whatever is easiest to sell.
Refunds and Returns Over Time
Analytics > Finances > Returns
Gross revenue is what customers pay you before they change their minds. Net revenue is what you actually keep. Most DTC founders track gross revenue as their primary metric and treat returns as a customer service problem rather than a financial signal.
Return rate is one of the most reliable early indicators of product-market fit degradation. When your return rate starts climbing, it usually means one of three things: your product quality has shifted, your marketing is attracting customers who are not the right fit for the product, or your creative is setting expectations that the product cannot meet.
Track this report monthly. Calculate your return rate as a percentage of gross revenue, not just as a count of orders. A 10% return rate on a 50 GBP product erodes margin very differently than a 10% return rate on a 15 GBP product. If your return rate exceeds 8% in most DTC categories, it warrants a dedicated review of which products are driving it and which customer segments are returning most frequently. That combination almost always points to a positioning problem that can be fixed at the creative or product description level before it reaches logistics.
Customer Acquisition Over Time
Analytics > Customers > Customers over time
This report shows you how many new customers you acquired in each period. Read in isolation it is just a volume metric. Read alongside your ad spend for the same period, it becomes your true CAC calculation that is not corrupted by platform attribution.
Divide your total marketing spend in a given month by the number of new customers acquired in that month. That is your blended CAC. Compare it to what your ad platforms report. The gap, and there will be a gap, tells you how much you are over-attributing to paid channels. Most brands find the gap is 30 to 50% in paid channels favour, meaning their actual CAC is significantly higher than what Meta or Google claims.
Track this metric monthly and plot it over 12 months. A rising blended CAC is not always a crisis if your cohort LTV is rising alongside it. If blended CAC rises while cohort performance stays flat or declines, that is the clearest signal that your growth engine needs restructuring, not just more spend.
The Shopify vs Klaviyo Revenue Problem
68% of merchants using both Shopify and Klaviyo report confusion about which revenue number to trust when they disagree. This is one of the most common reporting failures in DTC, and it leads to either over-crediting email or abandoning email analytics entirely, both of which result in bad decisions.
The discrepancy is not a bug. Shopify records revenue at the moment of checkout using last-click attribution. Klaviyo records revenue using a configurable attribution window, typically a five-day email open or a one-day click, which means a customer who opens an email on Monday and buys after clicking a Google ad on Friday gets counted in both systems. The same order appears in Klaviyo's email revenue and Shopify's organic or Google revenue simultaneously.
Use Shopify as your revenue of record for financial reporting. Use Klaviyo's attributed revenue only for email channel optimisation decisions. Never add the two together.
The practical fix: narrow your Klaviyo attribution window to one-day click and five-day open at most. This reduces double-counting without eliminating meaningful email attribution. Review the Klaviyo number as a directional indicator of email contribution, not a financial fact. Use Shopify's data for your P&L and your post-purchase survey data to cross-reference what actually drove the purchase decision.
Building a Clean Weekly Reporting Stack
The six reports above are more useful together than in isolation. Here is the weekly sequence that works at brands between 500k and 5 million GBP in annual revenue.
Review returning customer rate and acquisition numbers
Set your date range to the prior week. Check whether the returning customer rate held steady against the prior four-week average. Check whether new customer acquisition volume is consistent with your spend. If acquisition is down but spend is flat, your creative or targeting needs attention. If acquisition is up but returning rate is down, you are growing the top of the funnel faster than the retention engine can absorb.
Pull sessions converted by source
Look at which channels converted at or above their four-week average. Any channel with conversion rate dropping week on week for three consecutive weeks gets a creative or offer review. Do not cut spend based on one week of data, but flag it immediately so you are not two months into a decline before you act.
Cohort analysis and return rate review
Run the cohort analysis for the most recent full month of completed orders. Compare to three and six months prior. Calculate your blended CAC using total marketing spend divided by new customers. Review refunds and returns for any product or collection showing above-average rates. These two reviews together give you the financial health picture that no daily dashboard provides.
This routine takes under an hour per week and surfaces the vast majority of revenue leakage signals before they become structural problems. Brands above 2 million GBP in annual revenue will benefit from layering in a third-party analytics tool (Triple Whale, Polar Analytics, or Northbeam), but only after this native reporting discipline is established. Bringing in a more sophisticated tool on top of a broken reporting habit just produces more expensive confusion.
What This Looks Like When You Fix It
A wellness brand I worked with was spending 40k GBP per month on paid acquisition and showing strong revenue growth. Their Shopify overview looked healthy. Their cohort analysis told a different story: customers acquired in the previous six months were buying once and not returning at anywhere near the rate of earlier cohorts. Their blended CAC had risen from 38 GBP to 71 GBP without anyone noticing because gross revenue was still climbing.
The sessions converted report showed that their email channel was converting at 4.2%, while paid social was converting at 0.9%. They were spending 85% of their budget on the channel with the worst conversion rate. Their return rate on their hero product had climbed from 6% to 14% over eight months, signalling a product-promise mismatch in their ad creative.
Six weeks after restructuring their budget based on what the reports actually showed, shifting spend toward their lower-CAC channels and rebuilding their post-purchase flow around the 60-day retention window, their blended CAC dropped to 48 GBP and their 90-day returning customer rate increased from 18% to 29%. Revenue barely moved. Margin improved by 11 points. That is what happens when you stop running on the dashboard and start running on the data.
Inside the system
How we build this for brands
Reading these reports by hand is the slow way. For brands we run a profit dashboard, built by AI from their Shopify and ad data, that turns the six reports above into one live contribution-margin view. A reporting agent reads it every week and surfaces the SKUs, channels, and journeys quietly leaking margin, in plain English.
From there the fixes are built and deployed, the flows, the segments, the offer changes, by the same system rather than left on a to-do list. Part of this runs live for portfolio brands today; the full build is what we deploy when we take a brand on.
Growth Audit
Find Out Where Your Revenue Is Going
I will review your Shopify analytics, identify your biggest leakage points, and give you a clear action plan to recover margin and fix your reporting. No pitch deck. Just the numbers and what to do about them.
Book Your AuditFrequently asked questions
Which Shopify reports matter most for DTC brands?
The six most important Shopify reports for DTC operators are: returning customer rate, sessions converted by traffic source, customers over time (cohort analysis), average order value by product, refunds and returns over time, and customer acquisition over time. These six reports, read together weekly, give you a clearer picture of unit economics than any single dashboard metric.
Why does Shopify show different revenue numbers from Klaviyo?
Shopify records revenue at checkout using last-click attribution. Klaviyo records revenue using a configurable attribution window, which means the same order can be credited in both systems. The mismatch is not a data error. It is a methodological difference. Use Shopify as your revenue of record for financial reporting, and Klaviyo's attributed revenue only for email channel optimisation decisions.
What is a good returning customer rate for Shopify DTC brands?
A returning customer rate above 25% is healthy for most DTC brands. Brands with rates above 40% typically have strong retention programmes and high LTV. Below 20% is a warning sign that acquisition costs are not being recovered and unit economics are structurally weak. The target varies by category: consumables like supplements and skincare should aim for 35 to 50%.
How accurate is Shopify's built-in conversion tracking?
Shopify's server-side order tracking is highly accurate for revenue and orders. Where it falls short is in session attribution and marketing channel tracking. Ad blockers, browser privacy updates, and cross-device journeys mean approximately 1 in 5 sessions may be misattributed or missed entirely. For marketing decisions, supplement Shopify Analytics with post-purchase surveys to improve signal quality.
How do I find where revenue is leaking in my Shopify store?
Start with refunds and return rate over time. If this is rising, your margin is eroding in a way that gross revenue figures will never show. Then check your average order value by product to identify which SKUs are dragging down AOV. Review your sessions converted by source to see if certain channels are driving traffic that does not convert. Finally, check your cohort analysis to identify whether customer LTV has been declining by acquisition month. These four reports together will surface the majority of revenue leakage in most DTC businesses.
Should DTC founders use Shopify Analytics or a third-party tool?
Shopify Analytics is the right starting point for brands under 1 million GBP in annual revenue. Above that threshold, the gaps become expensive. The most common gaps are: no cross-device identity resolution, no blended profitability view, and inability to merge data across multiple Shopify stores. Tools like Triple Whale, Polar Analytics, and Northbeam are worth the investment above 2 million GBP, but only after you have mastered the native reports first.
About the author
Caner Veli built Liquiproof from zero to 3,000+ global retailers in under 6 years. He now helps DTC and CPG brands fix broken growth engines and scale 2x-15x in 90 days.