Example 4 of 5 · ShopifyQL sample dashboard
Balance acquisition spend against retention before CAC eats margin.
From sales, show orders and total sales by new or returning customer.
FROM sales
SHOW orders, total_sales, average_order_value, new_or_returning_customer
GROUP BY new_or_returning_customer
DURING last_month
ORDER BY orders DESC
WITH TOTALSNew order share
62.4%
+4.3 pts
Returning AOV
$145
+$15 vs new
Repeat rate
37.6%
−4.3 pts
Returning sales
$100k
40% of $
Order share by segment
Sample data as if returned from Shopify Analytics
| Segment | Orders | Share | Total sales | AOV |
|---|---|---|---|---|
| New | 1,149 | 62.4% | $148,620 | $129.35 |
| Returning | 693 | 37.6% | $100,300 | $144.73 |