Analytics for e-commerce founders. Shopify CSV in. Insights out.
Analytics for e-commerce founders shouldn't require a BI team or a $79/month tool. DataHub Pro reads any Shopify, WooCommerce, BigCommerce or Stripe export and gives you GMV trends, RFM customer tiers, cohort retention, top products by margin, and a 12-month forecast — in two minutes, with editable Word/PowerPoint reports for investor updates. from $14.99/mo, free tier first.
Updated 7 May 2026
Why Shopify Analytics + spreadsheets is a fragile workflow
Most e-commerce founders use a stack that breaks at scale: Shopify Analytics for live store metrics, Excel for the deeper analyses (cohorts, margin by product, RFM), and screenshots in Notion for investor updates. The handoffs between those tools eat half a day a month at best, and the analyses get progressively wronger as the team scales.
What breaks first
- Cohort retention. Shopify shows you traffic and conversion, not "of customers acquired in March, what % bought again by month 3?". The answer lives in a manual SQL query or a multi-pivot Excel file.
- RFM segmentation. Vital for retention campaigns; impossible to keep current in Excel without macros.
- Margin-by-product. Shopify reports revenue, not contribution margin. You need to join cost data manually.
- Forecasting. Spreadsheet LINEST is wrong for seasonal e-commerce data. You need Holt-Winters or similar.
- Investor reports. Pasting Shopify screenshots into a Notion page is fine until investors ask follow-up questions.
Why dedicated e-commerce analytics tools (Databox / Glew / Polar) don't fit
Three problems: they cost $79-$300/month, they pull from Shopify's live API (locking you in), and they're not editable — you can't add custom calculations or non-Shopify data sources. They're also overkill if your store does under £500k/year GMV.
How DataHub Pro turns a Shopify export into the analytics you need
Same primitives as the rest of the platform, applied to e-commerce data shapes. No e-commerce-specific configuration required — the platform infers what your file is.
Shopify / WooCommerce export ingest
Drop in the standard Orders or Customers CSV from your store. Auto-handles Shopify's date formats, multi-currency totals, line-item subtotals, and tax/shipping splits. Same for WooCommerce, BigCommerce, and Stripe exports.
Auto RFM segmentation
Customers are scored on Recency, Frequency and Monetary; segments (Champions, Loyal, At-Risk, Lost) are built; per-segment retention recommendations and CSV export are generated. Drop the At-Risk CSV into Klaviyo for re-engagement.
Cohort retention
Customers are grouped by acquisition month; the retention curve shows what fraction repurchased by month 1, 3, 6, 12. Compare cohorts to see if recent customers are stickier or less loyal than earlier ones.
Holt-Winters GMV forecast
Fits a seasonal forecast on monthly GMV with 80%/95% confidence bands. Lets you flex assumed growth rate or seasonality strength for sensitivity analysis.
Top products by margin, not just revenue
Upload a separate cost-of-goods CSV and the platform joins it to your orders, computing contribution margin per SKU. Pareto chart shows which 20% of products drive 80% of margin.
Investor-ready DOCX/PPTX
Auto Report builds a branded Word doc and PowerPoint deck with title page, exec summary, GMV trend, top products, RFM breakdown, retention chart, and 12-month forecast. Editable, ready to send to investors.
What e-commerce founders actually do with this
- Weekly Monday dashboard — drop in last week's Shopify export; the team's KPI dashboard refreshes with GMV, AOV, return rate, top products. Share via URL.
- Monthly investor update — generate a branded PPTX in 2 minutes with retention cohorts and forecast — the analytics half of the update done before coffee.
- Reactivation campaign sizing — RFM Lost segment goes to CSV → Klaviyo segment → win-back email; measure the recovered LTV next month.
- Margin-driven product cuts — Pareto chart on margin reveals SKUs that consume warehouse space without earning their keep.
- Black Friday / Q4 forecasting — Holt-Winters with strong seasonality predicts inventory needs and cash flow with confidence bands.
Each of these would have taken half a day and a SQL query. Each takes minutes here.
Who in an e-commerce team uses DataHub Pro
Founder + small team (sub-£1m GMV)
The classic fit. Founder, ops lead, marketing lead — no analyst. Pro tier flat rate; the whole team analyses without a per-seat licensing tax.
Mid-market e-commerce (£1-10m GMV)
You probably have a part-time data person but they're stretched. The platform handles the recurring 80% of analytics so they focus on bespoke modelling.
Multi-store operators / brand groups
Each brand gets its own workspace; group-level dashboards aggregate across stores. Useful for portfolio operators (multiple Shopify stores under one parent).
When DataHub Pro isn't the right shape for e-commerce
If you need real-time analytics (sub-second decisions, live ad-spend optimisation), you need a different tool — DataHub Pro works on the export you uploaded, not a live API. For most e-commerce decisions (which run on weekly or monthly cadence), the snapshot pattern is exactly right. For attribution-heavy ad-spend optimisation, pair us with Triple Whale or Northbeam.
What a real e-commerce analytics dashboard should show
Shopify's native analytics shows sales totals. What most e-commerce operators actually need is the layer underneath: which customers are driving repeat revenue, which products are being returned, which acquisition cohorts are churning, and where GMV will be in 90 days. DataHub Pro builds that view from a standard Shopify, WooCommerce, or Stripe export.
GMV, AOV and repeat-purchase rate
Gross Merchandise Value by month, Average Order Value trend, and the split between new-customer and returning-customer revenue — the three numbers that separate a growing store from a stagnant one.
RFM customer segmentation
Every customer scored by Recency, Frequency, and Monetary value. Champions vs At-Risk vs Hibernating — automatically. Exportable for email/SMS campaigns in one click. Typically surfaces 15–25% of revenue sitting in "at risk" segments that haven't been re-engaged.
Cohort retention by acquisition month
Which months produced customers who stuck around? Cohort curves show 3-month, 6-month, and 12-month retention per acquisition cohort — the single most useful chart for diagnosing whether product-market fit is improving over time.
90-day GMV forecast with confidence bands
Holt-Winters triple exponential smoothing on your monthly GMV series. 80% and 95% confidence bands. What-if sliders for seasonality and trend strength. The forward view most Shopify owners are missing.
Top products and return rate
Revenue by product, units sold, refund rate, and margin contribution (when cost data is included). Useful for inventory planning and identifying which SKUs are generating returns that erode margin.
Investor-ready PPTX in one click
Auto Report bundles GMV trend, cohort retention, RFM breakdown, and forecast into a branded PowerPoint or Word document. Format investors and board members actually read.
FAQs
Can it pull from Shopify directly without an export?
Native Shopify connector is on the roadmap. Today, the workflow is: Shopify Admin → Orders → Export → drop the CSV into DataHub Pro. Takes 30 seconds. Most founders we work with prefer this for audit reasons (snapshot files are auditable; live links aren't).
What's the difference between this and Databox or Glew?
Databox and Glew are e-commerce-specific live dashboards with curated metrics and pre-built integrations — convenient if you want exactly what they offer at $79-$200/mo. DataHub Pro is more flexible (any data source, custom calculations, white-label), cheaper ($14.99), and better at deep analyses (RFM, cohort, forecasting, anomaly detection). Trade-off: we don't auto-pull from Shopify; you upload exports.
Does it work with WooCommerce, BigCommerce, Etsy?
Yes — any of those tools' standard CSV exports work. The platform auto-detects the column shape (customer ID, order date, total) and runs the analyses. Not all platforms export every field; the platform tells you what's missing if needed.
Can it compute contribution margin if I upload a cost-of-goods file?
Yes. Upload your COGS CSV (SKU + cost) and join it via Pipelines to your orders file; the platform computes contribution margin per order and per SKU. Pareto, anomaly detection, and the KPI dashboard then run on margin rather than just revenue.
How does forecasting handle Black Friday / Q4 seasonality?
Holt-Winters with seasonal smoothing handles strong cyclical patterns natively — Q4 spikes are baked into the model. The 80%/95% confidence bands widen during high-variance periods so you see the uncertainty rather than a false-precise number. For more on the method, see Holt-Winters forecasting.
Can I share dashboards with my agency or freelancer?
Yes — public-share URLs with optional password and expiry. Recipients view in any browser; no DataHub Pro account required. White-label with your store branding on Pro.
Is it GDPR-compliant for UK/EU customer data?
Yes — UK/EU data residency by default, signed DPA on request, no model training on customer data. See GDPR & DPA.
How big a Shopify export can I upload?
Free tier: 50 MB / 100,000 rows. Pro: 200 MB / 2,000,000 rows. A typical Shopify export for a £1m GMV store fits well under 50 MB.
Can I integrate with my email tool for automated retention campaigns?
Today: export segment as CSV → import to Klaviyo / Mailchimp / Omnisend. Direct integrations are roadmap. CSV is intentional for now — gives you control over which segments actually get campaigns sent to them.
Does it have a free tier I can test?
Yes. Free tier handles real Shopify exports up to 50 MB / 100,000 rows. No credit card. Most founders we work with run their first analysis on the free tier and upgrade to Pro once they're using DataHub Pro on a recurring (weekly/monthly) basis.
What is the best analytics dashboard for Shopify?
The best Shopify analytics dashboard goes beyond native Shopify reports to show: cohort retention by acquisition month, RFM customer segments, GMV trend with a 90-day forecast, and top-product analysis with return rates. DataHub Pro builds all of these from a standard Shopify orders export — no custom development, no warehouse, from $14.99/month.
Does it work with WooCommerce and Stripe as well as Shopify?
Yes. Any platform that exports an orders CSV with customer ID, date, product, and amount columns works. That includes Shopify, WooCommerce, Stripe, Gumroad, Paddle, BigCommerce, and most headless commerce setups. The platform auto-detects column schemas across different export formats.
How do I get cohort retention data from Shopify?
Export your Shopify orders as a CSV (Shopify Admin → Orders → Export). Upload to DataHub Pro. The platform groups customers by first-order month and computes what fraction placed a second, third, or Nth order at 1, 3, 6, and 12 months. No SQL or spreadsheet formulas needed.
Can it handle multi-currency Shopify stores?
Yes — multi-currency orders are converted to a single reporting currency using configurable exchange rates. If your Shopify export includes a presentment currency column, the platform uses it. You can also set manual rates per currency pair.
Drop in your Shopify export.
Get GMV, RFM, cohort retention, top products and forecast in two minutes. Free tier — no credit card.
See also: · For SaaS founders · For marketing agencies · For sales teams · For product teams · · Home