Example 5 of 5 · ShopifyQL sample dashboard
Put budget where efficiency and volume actually meet.
From sales, show total sales and AOV by referring channel.
FROM sales
SHOW total_sales, orders, average_order_value, referring_channel
GROUP BY referring_channel
WHERE referring_channel IS NOT NULL
ORDER BY total_sales DESC
LIMIT 10
VISUALIZE total_sales TYPE barPaid share
55.8%
Shop + Meta + TT
Top channel
Google Shopping
$68.4k
Best AOV
Google Shopping
$139
Email sales
$41.3k
high efficiency
Ranked total sales
Sample data as if returned from Shopify Analytics
| Channel | Orders | AOV | Total sales |
|---|---|---|---|
| Google Shopping | 492 | $139.07 | $68,420 |
| Meta Ads | 381 | $136.77 | $52,110 |
| Email / Klaviyo | 298 | $138.52 | $41,280 |
| Organic search | 214 | $133.83 | $28,640 |
| Direct | 188 | $128.62 | $24,180 |
| TikTok Ads | 142 | $128.80 | $18,290 |
| Affiliates | 127 | $125.98 | $16,000 |