Analytics for D2C founders
who hate spreadsheets.
Drop your Shopify export. See cohorts, returns, channel ROAS, and inventory forecasts — with the exact SQL behind every chart.
Where spreadsheets fail you
Three blind spots quietly eating your margin.
No cohort analysis — no idea which acquisition channels actually retain customers
Cohort retention curves built straight from your order data in one query
Return rates visible only at month-end, in a manual spreadsheet
Anomaly alerts the moment return rates spike above baseline
ROAS from the ad platforms never matches the revenue in your books
Channel ROAS computed from your own transaction data — no platform bias
What Workliq does for D2C
Four capabilities built for ecommerce data
Cohort retention analysis
Ask “show retention by acquisition month” — Workliq builds the cohort table from your order history, groups by join month, and plots the drop-off curves. The SQL is shown alongside.
Geography & margin
Which cities drive your highest-margin orders? Which pincodes are high return-risk? Drill by city, region, or pincode in plain English — bar chart and SQL together.
Anomaly alerts on order spikes
If orders drop sharply on a Tuesday or returns spike on a product, Workliq flags it and can queue an email alert — before it shows up in the month-end report.
Inventory forecast
ARIMA forecasting on SKU-level demand from your own order history — next-month predictions with confidence intervals and seasonal-pattern detection.
A worked example
Net ROAS, after returns — the number the ad platform won't show you.
Illustrative, on Workliq's built-in sample D2C dataset — not a customer result. Your own numbers replace these the moment you connect data.
SELECT channel,SUM(revenue) / NULLIF(SUM(ad_spend), 0) AS gross_roas,SUM(revenue - returns - cancellations) / NULLIF(SUM(ad_spend), 0) AS net_roasFROM orders GROUP BY channel ORDER BY net_roas;
Drop your Shopify export and start.
CSV, Excel, JSON, or a PDF with tables. Full cohort and ROAS analysis with the SQL shown. No account needed for the demo.
Try with sample data →Pre-loaded with sample D2C retail data. No signup required.
The same workspace, doing your job
Which acquisition cohort is actually profitable after returns?