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

$29,356,250

Total revenue

27,659

Orders

$1,061.36

Avg order value

18,484

Active customers

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

$272

median lifetime value (mean $1,588, skewed high)

77.0%

of revenue comes from repeat customers (2+ orders)

Quote the median, not the mean: lifetime value is right-skewed, so a few big spenders pull the average up.

Who's slipping away

Active26.1% of total · 24.6% of revenue

At-risk27.5% of total · 29.2% of revenue

Churned46.5% of total · 46.3% of revenue

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

Active78.5% of total · 70.7% of revenue

Dead21.5% of total · 29.3% of revenue

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).

Receipt: how a number is computed

Every figure in this report carries one of these. Here is the receipt behind the Top products by revenue table above: the exact query Tilltrend ran, the build it ran against, its content hashes, and a one-line command that reproduces the result with no model in the loop. The CSV download carries this same receipt.

product_performance via run_metric

receipt
rcp_f6d584ddcbc348d8b955f0cb7b4ea338

warehouse build
4730b8fb-b3a5-4115-8437-b6cae1220cf6

receipt hash
sha256:87789d1e71944e4e24fa9003e50395d8cd78bcfb6a2b32485355be983514584b

result hash
sha256:40e544574605ae969e46fea1da0dde8b7c548ef4660c9f9a3fef72e2449edfdb

dataset window
2010-12-29 – 2014-01-28

rows · elapsed
5 rows · 618 ms

SQL Tilltrend ran

SELECT product_key, product_number, product_name, category, subcategory, product_line, revenue, units_sold, orders, customers FROM gold.v_product_performance f ORDER BY revenue DESC, product_key ASC LIMIT %s

params

[5]

Replay (model-free)

python app\scripts\replay.py rcp_f6d584ddcbc348d8b955f0cb7b4ea338

Tilltrend: the honest AI analyst for Shopify. Every number traces to a governed definition and a replayable receipt. tilltrend.app