Data Analytics15 June 202613 min read

E-Commerce Growth Analytics: Build the Stack That Scales

Most scaling e-commerce brands track ROAS religiously but can't explain why profit shrinks as revenue grows. Here's how to build the analytics stack that fixes that.

E-Commerce AnalyticsGrowth AnalyticsData EngineeringConversion FunnelCAC AnalyticsBigQuerydbt

E-commerce growth analytics is the practice of measuring and optimising every stage of your customer acquisition and retention funnel — from first click to repeat purchase — using a connected, trustworthy data stack. Done properly, it tells you not just how much you are spending to acquire customers, but exactly which channels, cohorts, and funnel stages are generating profitable growth versus expensive noise.

For scaling e-commerce brands, the gap between ROAS-obsessed reporting and genuine growth intelligence is where margin quietly disappears. This post is about closing that gap.

Why Most E-Commerce Analytics Stacks Break at Scale

Here is the pattern we see repeatedly when working with growth-stage e-commerce businesses: the founding team built reporting that worked at £500K in revenue. Shopify's native dashboard, a few Google Sheets tracking blended ROAS by channel, and a GA4 account that nobody has fully validated. Then the business reaches £3M, £5M, £10M — and suddenly nobody can agree on the numbers.

Finance says CAC is £42. The growth team's spreadsheet says £38. The agency deck says it is £29. All three are technically calculating something, but they are calculating different things — different attribution windows, different cost inclusions, different definitions of "new customer." The business is making budget decisions on fragmented, inconsistent data, and the cost of that is real.

This is not a tooling problem. It is a data architecture problem. The tools — Shopify, GA4, Meta Ads Manager, a CRM — are all generating the data. The failure is in how that data is unified, defined, and exposed to decision-makers.

The structural issue is that <strong>e-commerce analytics naturally fragments across four or five source systems</strong>, each with its own identity model and attribution logic. Shopify tracks orders. Meta tracks ad clicks. GA4 tracks sessions. Klaviyo tracks email touches. None of them agree on when a customer was acquired, and none of them see the full picture. Until you pull all of that into a single warehouse with a single, documented definition of your core metrics, you are measuring the shadow on the wall rather than the thing itself.

E-commerce growth analyst reviewing multi-stage conversion funnel drop-off analytics dashboard on monitor


📺 Watch: Most Important Ecommerce Metrics & KPIs (with Calculator) | You MUST Know These

Most Important Ecommerce Metrics & KPIs (with Calculator) | You MUST Know These


What a Proper E-Commerce Growth Analytics Stack Actually Looks Like

The architecture is simpler than most people expect, but the details matter significantly.

At the foundation, you need a cloud data warehouse — BigQuery or Redshift are the two most common choices for e-commerce businesses at Series A scale. All of your source systems land there via a modern ELT pipeline (Fivetran, Stitch, or Airbyte are common connectors). The raw data from Shopify, your ad platforms, your CRM, and your email tool all flows into the warehouse without transformation.

On top of the raw layer, you build transformation models using dbt. This is where your business logic lives — how you define a "new customer", how you calculate blended CAC, how you assign orders to acquisition cohorts, how you handle refunds and chargebacks in your revenue figures. These definitions are version-controlled, tested, and documented. When a definition changes, you change it in one place and it flows through every downstream report.

On top of the dbt models, you need a semantic layer or a BI tool that enforces metric consistency. We use Holistics BI extensively for this — as an official Holistics partner, we have seen firsthand how a properly configured semantic layer eliminates the single most common complaint in e-commerce analytics: the same metric showing different values in different dashboards.

Above that sits your reporting layer — growth dashboards, finance views, channel performance reports — all pulling from the same defined metrics, same logic, same source of truth.

The practical outcome: when the CFO and the growth lead are in the same meeting, they are looking at the same number. That sounds like a low bar. In practice, it is one most scaling brands have not crossed.

The Metrics That Actually Matter for E-Commerce Growth

Not all metrics are created equal. A lot of e-commerce dashboards are full of vanity metrics — sessions, page views, blended ROAS — that feel like signal but do not connect directly to the unit economics of the business.

The metrics that deserve to be first-class objects in your data model are:

CAC by channel, by cohort. Not blended CAC — channel-level CAC that accounts for actual spend attribution and actual new customer counts. Customer acquisition costs in 2026 are rising fast — up 40–60% since 2023, which means a business still running on blended CAC from two years ago is almost certainly underestimating the true cost of acquiring customers from paid channels today.

CAC payback period. This is the metric that connects acquisition efficiency to cash flow. CAC payback period, once a back-office finance metric, has quietly become the most-cited number on Series B term sheets and M&A info memos. The formula is straightforward — total acquisition cost divided by gross profit per customer per month — but it requires clean, joined data to calculate reliably by channel. Best-in-class companies recover acquisition costs in under 12 months, while payback periods longer than 18 months often alarm investors.

Funnel conversion rates by stage, by traffic source. A healthy e-commerce funnel in 2026 shows session-to-product-view rates of 45–50%, product-view-to-add-to-cart of 8–10%, add-to-cart to checkout initiation of 30–35%, and checkout to completed purchase of 45–50%. When you have these broken out by source (paid social, organic, email, branded search), you can immediately see which acquisition channels are bringing in traffic that converts, and which are optimising for clicks at the expense of purchase intent.

New vs. returning customer revenue split. Growth teams at early-stage brands tend to optimise acquisition relentlessly while underinvesting in retention. But the unit economics only work if customers come back. You need to see, at a dashboard level, what percentage of your revenue each month comes from new versus returning customers — and how that is trending. If the new customer share is rising while overall revenue is flat, you are on a treadmill.

Repeat purchase rate and purchase frequency by cohort. This is where cohort analysis becomes essential. A cohort that was acquired in January 2025 looks very different from one acquired in August 2025 if you ran a discount campaign in one period. Aggregated repeat purchase rates hide this — cohort-level data reveals it.

If you are building or rebuilding your growth analytics stack and want to understand how these metrics should be modelled and exposed, explore how Fintel Analytics approaches this — we design and deliver exactly this kind of data infrastructure for growth-stage e-commerce and fintech businesses globally.

The Conversion Funnel Problem Nobody Talks About

Every e-commerce brand has some version of funnel analytics. Most of them are broken in a way that produces optimism rather than insight.

The failure mode is almost always the same: funnel analytics are built on session-level data from GA4 or a similar web analytics tool, and the funnel stages are mapped to page views or events that fire inconsistently across devices and browsers. The result is a funnel that looks clean in reports but has significant data quality issues underneath — missed events, double-counted steps, cross-device journeys that are severed and counted as multiple funnels.

Apple's Intelligent Tracking Prevention, iOS App Tracking Transparency, GDPR consent workflows, and the deprecation of third-party cookies have fragmented the identity graphs that session-level analytics depends on. By 2026, practitioner estimates put usable identity coverage at roughly 30–60%, down from the 90%+ of the cookie era. That means a session-based funnel is structurally missing a significant portion of the customer journey before you even look at the data.

The fix is to build funnel analytics warehouse-side rather than browser-side. Instead of relying on GA4 to reconstruct the journey, you join order data from Shopify, session data from your server-side events, and CRM touchpoints in your warehouse — building the funnel from deterministic, first-party data rather than inferred browser events. The result is a funnel that is less complete in terms of top-of-funnel visibility (you will never fully recover anonymous browsing behaviour) but far more accurate for the stages that matter most: product engagement, cart behaviour, and checkout completion.

In our work with a direct-to-consumer brand scaling through Series A, we rebuilt their funnel analytics warehouse-side using dbt models on BigQuery. What they discovered immediately was that their checkout completion rate was 12 percentage points lower for mobile users on certain payment methods — a finding that was invisible in their GA4 reports because cross-device attribution was fragmenting those sessions. That single insight drove a checkout optimisation that materially improved mobile conversion.

Growth team reviewing CAC payback period by channel dashboard in Series A startup meeting room

Attribution: What to Use at Each Stage of Growth

Attribution is the most contested topic in e-commerce analytics, and most of the debate is unproductive because people are arguing about which model is "correct" when the more useful question is which model is appropriate for the decision being made.

At early stage (pre-£2M revenue), the priority is clean first-party data and last-click attribution for operational decisions — which campaigns are generating orders today. Last-click is imperfect but actionable, and at this scale, the complexity of multi-touch models does not justify the implementation cost.

At growth stage (£2M–£15M), you need to move beyond last-click. If more than 50% of conversions show only last-click, multi-touch attribution will systematically over-credit lower-funnel tactics and under-value awareness and consideration channels. This is when you start seeing brands over-investing in branded search and retargeting because these channels "own" the last click, while the prospecting campaigns that actually drove the customer into the funnel are defunded. The fix is not necessarily a full MMM — it is correctly attributing across the channels you can track deterministically, and being honest about the channels you cannot.

Marketing mix modelling is a statistical method that correlates aggregate spend by channel against aggregate outcomes like revenue, using regression to estimate each channel's incremental contribution. It needs no personal data, which makes it privacy-durable. For brands spending more than £500K per month on marketing, MMM starts to justify the implementation investment. According to a 2025 EMARKETER survey, close to half of marketers plan to invest in marketing mix modelling in the coming year.

The practical architecture we recommend for Series A e-commerce brands is a pragmatic hybrid: first-party multi-touch attribution for digital channels (using your warehouse, not a black-box tool), incremental testing for high-spend channels where you can run geo or holdout experiments, and MMM for strategic budget allocation decisions quarterly rather than daily. This gives you the tactical signal you need without requiring a data science team to maintain a complex model.

Building the Stack: A Phased Approach

The most common mistake we see when e-commerce brands try to "build their analytics stack" is doing too much at once and shipping nothing. Here is the phased approach that actually gets to production:

Phase 1 — Foundational data warehouse (weeks 1–4). Land Shopify, your ad platforms, and your CRM into BigQuery. No transformation yet. Just get the raw data flowing and validate that your order counts in the warehouse match Shopify. This step alone eliminates a surprising amount of confusion.

Phase 2 — Core metric models in dbt (weeks 4–8). Build dbt models for your three most critical metrics: daily revenue by channel (with refunds handled correctly), new vs. returning customer classification, and blended CAC by channel. Document the logic. Test it. Get sign-off from finance and the growth team that this is the definition they will use going forward. This is the moment you create a single source of truth.

Phase 3 — Operational dashboards (weeks 8–12). Build the dashboards your teams actually need to make decisions — a daily growth dashboard for the growth lead, a channel P&L view for the CMO, and a unit economics view for the CFO. These should pull entirely from your dbt models, not from ad platform native reporting. Keep them simple and focused on decisions, not metrics.

Phase 4 — Funnel analytics and cohort tracking (weeks 12–20). Add warehouse-side funnel analytics using server-side events. Build cohort retention models. Add CAC payback period by cohort and by channel. This is where the stack starts generating insights that are genuinely unavailable in native platform tools.

A reconciliation process that once took 30–50 minutes of manual cross-referencing between Shopify and ad platforms can — and should — be rebuilt as an automated SQL pipeline. We have seen this process complete in under 3 seconds once it is properly modelled in dbt. The analyst time saved compounds immediately into higher-quality work.

For context on when the right time is to build this infrastructure, see our guide to when a startup needs a data warehouse — the answer is almost always earlier than founders expect.

Frequently Asked Questions

Q: What is e-commerce growth analytics and why does it matter?

A: E-commerce growth analytics is the practice of measuring and optimising the full customer lifecycle — from acquisition through conversion to retention — using connected, warehouse-based data. It matters because native platform tools (Shopify, GA4, Meta Ads Manager) each show a partial view, and decisions made from fragmented data consistently misdirect marketing spend and underestimate customer acquisition costs.

Q: How do I calculate CAC payback period for an e-commerce brand?

A: CAC payback period for e-commerce is calculated as: total acquisition cost per customer divided by gross profit per customer per period. The critical distinction from SaaS is that gross profit per customer is variable — it depends on repeat purchase behaviour. This means you need cohort-level order data joined to acquisition cost data, which requires a warehouse-based data model rather than a spreadsheet calculation.

Q: What are the most important funnel metrics to track for a scaling e-commerce brand?

A: The highest-signal funnel metrics are: session-to-product-view rate, product-view-to-add-to-cart rate, cart abandonment rate, checkout completion rate, and post-purchase repeat purchase rate at 30/60/90 days. Each of these should be broken out by acquisition channel and device type — aggregated funnel rates consistently mask the channel and device segments where the real optimisation opportunities sit.

Q: Should a Series A e-commerce brand invest in marketing mix modelling?

A: Not necessarily at Series A. MMM is most valuable when you are spending across channels that cannot be tracked deterministically — offline media, influencer, OOH. For a primarily digital brand spending under £500K/month on marketing, first-party multi-touch attribution and incremental holdout testing will give you better signal at lower implementation cost. MMM becomes worth the investment when your media mix diversifies meaningfully into channels that do not produce clickable, trackable interactions.

Q: What is the right data stack for e-commerce growth analytics in 2026?

A: For most Series A e-commerce brands, the right stack is: BigQuery as the warehouse, Fivetran or Airbyte for connectors, dbt for transformation and metric logic, and a semantic BI layer (Holistics, Looker, or Metabase) for dashboards. Avoid building bespoke analytics infrastructure before this foundation is solid — the common failure mode is investing in expensive visualisation tools before the underlying data is clean and consistently defined.

Scaling e-commerce brands are making daily decisions about where to invest acquisition budgets, which channels to scale, and how to optimise checkout flows — all of which depend on having accurate, consistent, granular growth data. If your analytics stack is still a patchwork of platform native reports and spreadsheets, the cost is not just analytical friction: it is misdirected spend, missed optimisations, and a metrics story that will not survive investor scrutiny. At Fintel Analytics, we have built growth analytics infrastructure for e-commerce and fintech businesses from Series A through to scale — turning fragmented platform data into a single, trustworthy source of truth that actually drives decisions. If your numbers are inconsistent, your CAC story is unclear, or your team is spending more time reconciling data than acting on it, that is a solvable problem.

New from Fintel Analytics

Fintel Insight — AI audit of your data stack

Connect your GitHub or warehouse and get a scored report across cost, quality, security, and code health in under 10 minutes, with actionable recommendations to fix what matters most. $99 flat, data never stored, GDPR compliant.

Get your data audit →

Work with Fintel Analytics

Ready to unlock the value in your data?

We work with businesses globally to design and deliver data solutions that drive real, measurable results — from strategy through to production.

Book a free data strategy consultation →