This is a Store Data Health-Check generated on Tilltrend's public demo dataset (2010–2014 bike sales) — exactly the report a merchant gets on their own Shopify store, with every number traced to a governed metric definition and a replayable receipt. Request yours →
↓ Download this data (CSV)
The top-products table from this report as a governed CSV — the file
carries its own receipt in the footer (metric id, the exact SQL, the result and
receipt hashes, and the model-free replay.py command). Open it in Excel.
Store Data Health-Check
Sample Store · data as of 2014-01-28 (latest order date) · 38 months of history
Gross revenue (no refund/cancellation data). AOV is the ratio of sums (revenue ÷ orders), never an average of monthly AOVs. Active customers are distinct identified buyers — not additive.
Revenue over time
Edge months of the data window can be partial — read them as partial periods, not trend points.
What your customers are worth
Quote the median, not the mean — lifetime value is right-skewed, so a few big spenders pull the average up.
Who's slipping away
As of the latest order date in the data, not today. Active = ordered within 3 months; At-risk = 3–6; Churned = 6+ . Thresholds are yours to set.
Dead stock
As of the latest order date, not today. Active = sold within 3 months; Slow = 3–6; Dead = no sale in 6+ . Thresholds are yours to set.
Frequently bought together
| Product A | Product B | Orders together | Share of orders |
|---|---|---|---|
| Mountain Bottle Cage | Water Bottle - 30 oz. | 1,692 | 6.1% |
| Road Bottle Cage | Water Bottle - 30 oz. | 1,521 | 5.5% |
| HL Mountain Tire | Mountain Tire Tube | 957 | 3.5% |
| Touring Tire | Touring Tire Tube | 808 | 2.9% |
| Patch Kit/8 Patches | Mountain Tire Tube | 785 | 2.8% |
Co-occurrence, not causation — these products share orders, which need not mean one drives the other.
Top products by revenue
| Product | Category | Revenue | Units |
|---|---|---|---|
| Mountain-200 Black- 46 | Bikes | $1,373,454 | 620 |
| Mountain-200 Black- 42 | Bikes | $1,363,128 | 614 |
| Mountain-200 Silver- 38 | Bikes | $1,339,394 | 596 |
| Mountain-200 Silver- 46 | Bikes | $1,301,029 | 580 |
| Mountain-200 Black- 38 | Bikes | $1,294,854 | 582 |
Gross revenue per product; a product's order count is not additive (one order can span products).