Example 2 of 5 · ShopifyQL sample dashboard
Prioritize inventory, ads, and homepage slots from real sales, not vanity clicks.
From sales, show total sales by product title, top 8.
FROM sales
SHOW total_sales, orders, product_title, product_type
GROUP BY product_title, product_type
ORDER BY total_sales DESC
LIMIT 8
VISUALIZE total_sales TYPE barSKUs selling
8
of 42
Top SKU share
19.9%
Trail Pack
Outerwear sales
$74.4k
+11%
Accessories units
1,143
+8%
Ranked total sales
Sample data as if returned from Shopify Analytics
| Product | Type | Orders | Total sales |
|---|---|---|---|
| Trail Pack 28L | Bags | 412 | $49,440 |
| Alpine Shell Jacket | Outerwear | 198 | $43,560 |
| Ridge Softshell | Outerwear | 154 | $30,800 |
| Merino Crew — Graphite | Apparel | 386 | $27,020 |
| Thermal Base Layer | Apparel | 221 | $17,680 |
| Daylight Cap | Accessories | 540 | $16,200 |
| Cordura Belt Bag | Bags | 267 | $16,020 |
| Camp Mug 12oz | Accessories | 603 | $15,075 |