Shopify is the source of truth. Paid channels are judged on 7-day click.
Demo with sample data. Figures are illustrative, for a sample ecommerce brand, to show what a live DataSauce dashboard reports. The live version pulls Shopify, Meta, Google Ads and Klaviyo every day, and is tailored to each client's KPIs.
Revenue vs ad spend
Daily Shopify revenue split by new and returning customers, with Meta and Google spend.
New customer revenueReturning revenueAd spend
Blended efficiency
0xTarget 5x10x
New customer MER
Breakeven CPA
$60
Breakeven on first purchase and LTV targets are set with each client at onboarding. $60 is an example.
Channels
Lifetime value by first-order month
Average revenue per new customer. Windows fill in as each month's customers age.
Repeat and returns
Repeat within 90 days
54.8%
Median days to reorder
52
Most reorders land 6 to 10 weeks after the first order, so Klaviyo replenishment flows start from day 42.
Return rate
Refunded revenue
Sets and products
Shopify orders in the range. Repeat rate is the share of buyers who reorder anything within 90 days.
Campaigns
Two campaigns: New Customer takes 70 to 80% of budget with existing customers excluded; Creative Testing finds the next winners.
Top ads
Sorted by spend. Winners move from Creative Testing into New Customer by post ID, keeping their social proof.
Campaigns
Three always-on campaigns. Brand is reported on its own so it never props up new customer results.
Performance Max asset groups
One asset group per product category, each with its own products and landing page.
How the numbers work
Revenue is Shopify net sales (after discounts, excluding GST and shipping). Shopify is the single source of truth for every total on this page.
MER (marketing efficiency ratio) is Shopify revenue ÷ total ad spend. The 5x target (every $1 of spend returns $5 of revenue) is an example; each client's target is set at onboarding.
Cost per new customer is total ad spend ÷ first-time Shopify customers. It's compared with breakeven on first purchase, set with the client at onboarding.
Channel revenue credits each Shopify order to the last non-direct click, using UTM tags on every paid ad. The "Platform reported" view shows what Meta and Google claim. Those overlap and include view-through, so they add up to more than Shopify recorded and aren't used for budget calls.
Lifetime value follows each month's new customers for 30, 90 and 180 days after their first order.
Data refreshes daily through DataSauce's Supermetrics connection. Date ranges, tabs and metrics can be changed to suit the team.
Privacy: the dashboard holds totals by day, channel, campaign and product only. No customer names, emails or addresses.