it isn't luck

Generated data demo

A sample operating view prospects can actually try.

Cedar & Spoon Market is a synthetic four-store retailer. The example shows how messy sales, customer, inventory, and marketing exports can become a weekly decision view for owners and managers. This is not the product; it is one example of the operating layer we can build around a workflow, tool stack, and decision cadence.

Explore the operating view
Cedar & Spoon Market Manager view
Revenue $33.9k Goal $33.2k
Gross profit $18.5k 54.4% margin
Net profit $2.6k YoY +106%
6-week revenue $34k
Category units 646
Owner takeaways
NP +106% YoY 2 stores under revenue goal 16 low-stock items

Live demo surface

Cedar & Spoon operating view

Company health

Jun 29 - Jul 5

Net revenue $33,938 Goal $33,215 Over by $723.05
Gross profit $18,466 GP goal $16,940 Over by $1,526
Net profit $2,610 NP goal $2,491 · 7.7% margin Over by $118.53
Transactions 1,848 Goal 1,563 Over by 285
Average ticket $18.36 Goal $21.25 Under by $2.89
Gross margin 54.4% Goal 51.0% Over by 3.4%
Net margin 7.7% Goal 7.5% On goal
Goal status 2/4 Goal 4/4 stores 2 stores below goal
Order clicks 901 Goal 1,200 Under by 299
Email click rate 4.8% Goal 5.0% On goal
Low stock 45 Max 40 Over by 5
13-week trend readout Selected week compared with the rolling average, last week, and the same week last year.
Net revenue $33,938
13W avg $36,251 -6.4%
vs last wk -3.8%
YoY +13.7%
Gross profit $18,466
13W avg $19,587 -5.7%
vs last wk -3.4%
YoY +14.9%
Net profit $2,610
13W avg $3,139 -16.9%
vs last wk -10.6%
YoY +106.1%
Transactions 1,848
13W avg 1,963 -5.9%
vs last wk -5.2%
YoY +15.1%
Gross margin 54.4%
13W avg 54.0% +0.4 pts
vs last wk +0.2 pts
YoY +0.6 pts

Weekly revenue trend

Trailing 13 weeks
Selected week $33,938
13W average $36,251
Revenue goal $33,215 Over by $723.05
Apr 6May 18Jun 29 Jun 29 - Jul 5

Revenue by store

Jun 29 - Jul 5
Downtown $10,927 of $11,107 goal · 98% to goal · Under by $179.91
Westside $8,039 of $8,330 goal · 97% to goal · Under by $291.10
Riverside $8,775 of $7,156 goal · 123% to goal · Over by $1,619
North Market $6,196 of $6,622 goal · 94% to goal · Under by $425.24

Store scorecards

Goal status, revenue, GP, NP, average ticket, margin, and review signal by location.

Downtown

good
RevenueGoal $11,107 $10,927 Under by $179.91
Gross profitGoal $5,665 $5,996 Over by $331.04
Net profitGoal $833.04 $1,091 Over by $258.01
TransactionsGoal 518 607 Over by 89
Avg ticketGoal $21.44 $18.00 Under by $3.44
Gross marginGoal 51.0% 54.9% Over by 3.9%
Net marginGoal 7.5% 10.0% Over by 2.5%
New reviewsGoal 12 18 Over by 6

Westside

watch
RevenueGoal $8,330 $8,039 Under by $291.10
Gross profitGoal $4,249 $4,313 Over by $64.81
Net profitGoal $624.78 $452.36 Under by $172.42
TransactionsGoal 388 426 Over by 38
Avg ticketGoal $21.47 $18.87 Under by $2.60
Gross marginGoal 51.0% 53.6% Over by 2.6%
Net marginGoal 7.5% 5.6% Under by 1.9%
New reviewsGoal 12 3 Under by 9

Riverside

good
RevenueGoal $7,156 $8,775 Over by $1,619
Gross profitGoal $3,649 $4,807 Over by $1,157
Net profitGoal $536.67 $905.23 Over by $368.56
TransactionsGoal 355 481 Over by 126
Avg ticketGoal $20.16 $18.24 Under by $1.92
Gross marginGoal 51.0% 54.8% Over by 3.8%
Net marginGoal 7.5% 10.3% Over by 2.8%
New reviewsGoal 12 13 Over by 1

North Market

watch
RevenueGoal $6,622 $6,196 Under by $425.24
Gross profitGoal $3,377 $3,350 Under by $26.85
Net profitGoal $496.62 $161.00 Under by $335.62
TransactionsGoal 302 334 Over by 32
Avg ticketGoal $21.93 $18.55 Under by $3.38
Gross marginGoal 51.0% 54.1% Over by 3.1%
Net marginGoal 7.5% 2.6% Under by 4.9%
New reviewsGoal 12 18 Over by 6

Customer geography heatmap

Where generated customer value clusters around each store, with hotter areas showing higher neighborhood LCV.

Customer value near stores

Customer value by neighborhood
100%
$603.91 generated LCV · 1 customers · $603.91 avg/customer $403.79 generated LCV · 1 customers · $403.79 avg/customer $986.93 generated LCV · 1 customers · $986.93 avg/customer $930.62 generated LCV · 1 customers · $930.62 avg/customer $358.81 generated LCV · 1 customers · $358.81 avg/customer $2,795 generated LCV · 2 customers · $1,397 avg/customer $666.81 generated LCV · 1 customers · $666.81 avg/customer $1,847 generated LCV · 2 customers · $923.33 avg/customer $2,103 generated LCV · 1 customers · $2,103 avg/customer $5,833 generated LCV · 5 customers · $1,167 avg/customer $14,885 generated LCV · 7 customers · $2,126 avg/customer $6,225 generated LCV · 4 customers · $1,556 avg/customer $3,528 generated LCV · 3 customers · $1,176 avg/customer $304.33 generated LCV · 1 customers · $304.33 avg/customer $24,176 generated LCV · 10 customers · $2,418 avg/customer $63,399 generated LCV · 18 customers · $3,522 avg/customer $24,344 generated LCV · 9 customers · $2,705 avg/customer $8,430 generated LCV · 5 customers · $1,686 avg/customer $1,965 generated LCV · 2 customers · $982.26 avg/customer $285.84 generated LCV · 1 customers · $285.84 avg/customer $8,608 generated LCV · 6 customers · $1,435 avg/customer $36,093 generated LCV · 12 customers · $3,008 avg/customer $135,893 generated LCV · 22 customers · $6,177 avg/customer $39,341 generated LCV · 13 customers · $3,026 avg/customer $5,289 generated LCV · 4 customers · $1,322 avg/customer $331.22 generated LCV · 1 customers · $331.22 avg/customer $3,418 generated LCV · 3 customers · $1,139 avg/customer $6,693 generated LCV · 6 customers · $1,115 avg/customer $16,008 generated LCV · 8 customers · $2,001 avg/customer $26,744 generated LCV · 8 customers · $3,343 avg/customer $19,105 generated LCV · 9 customers · $2,123 avg/customer $12,644 generated LCV · 9 customers · $1,405 avg/customer $2,630 generated LCV · 1 customers · $2,630 avg/customer $14,474 generated LCV · 7 customers · $2,068 avg/customer $18,904 generated LCV · 9 customers · $2,101 avg/customer $30,127 generated LCV · 15 customers · $2,008 avg/customer $8,238 generated LCV · 5 customers · $1,648 avg/customer $2,029 generated LCV · 1 customers · $2,029 avg/customer $209.23 generated LCV · 1 customers · $209.23 avg/customer $1,010 generated LCV · 1 customers · $1,010 avg/customer $265.20 generated LCV · 1 customers · $265.20 avg/customer $520.78 generated LCV · 1 customers · $520.78 avg/customer $1,565 generated LCV · 1 customers · $1,565 avg/customer $3,256 generated LCV · 2 customers · $1,628 avg/customer $10,187 generated LCV · 8 customers · $1,273 avg/customer $15,847 generated LCV · 8 customers · $1,981 avg/customer $58,369 generated LCV · 17 customers · $3,433 avg/customer $40,005 generated LCV · 17 customers · $2,353 avg/customer $12,735 generated LCV · 9 customers · $1,415 avg/customer $1,257 generated LCV · 1 customers · $1,257 avg/customer $6,402 generated LCV · 4 customers · $1,600 avg/customer $900.35 generated LCV · 1 customers · $900.35 avg/customer $1,595 generated LCV · 1 customers · $1,595 avg/customer $8,599 generated LCV · 7 customers · $1,228 avg/customer $63,241 generated LCV · 21 customers · $3,011 avg/customer $240,934 generated LCV · 39 customers · $6,178 avg/customer $62,849 generated LCV · 17 customers · $3,697 avg/customer $20,606 generated LCV · 12 customers · $1,717 avg/customer $15,004 generated LCV · 5 customers · $3,001 avg/customer $27,254 generated LCV · 13 customers · $2,096 avg/customer $5,121 generated LCV · 3 customers · $1,707 avg/customer $5,155 generated LCV · 3 customers · $1,718 avg/customer $2,585 generated LCV · 3 customers · $861.81 avg/customer $1,611 generated LCV · 1 customers · $1,611 avg/customer $17,900 generated LCV · 9 customers · $1,989 avg/customer $13,662 generated LCV · 7 customers · $1,952 avg/customer $22,201 generated LCV · 9 customers · $2,467 avg/customer $39,963 generated LCV · 13 customers · $3,074 avg/customer $32,121 generated LCV · 13 customers · $2,471 avg/customer $19,602 generated LCV · 9 customers · $2,178 avg/customer $29,337 generated LCV · 9 customers · $3,260 avg/customer $76,703 generated LCV · 13 customers · $5,900 avg/customer $10,152 generated LCV · 5 customers · $2,030 avg/customer $1,916 generated LCV · 1 customers · $1,916 avg/customer $1,146 generated LCV · 1 customers · $1,146 avg/customer $19,631 generated LCV · 10 customers · $1,963 avg/customer $41,735 generated LCV · 11 customers · $3,794 avg/customer $49,331 generated LCV · 9 customers · $5,481 avg/customer $40,515 generated LCV · 15 customers · $2,701 avg/customer $15,084 generated LCV · 8 customers · $1,886 avg/customer $19,660 generated LCV · 11 customers · $1,787 avg/customer $12,386 generated LCV · 6 customers · $2,064 avg/customer $25,427 generated LCV · 9 customers · $2,825 avg/customer $58,346 generated LCV · 10 customers · $5,835 avg/customer $18,285 generated LCV · 6 customers · $3,048 avg/customer $2,398 generated LCV · 3 customers · $799.49 avg/customer $484.13 generated LCV · 1 customers · $484.13 avg/customer $11,968 generated LCV · 6 customers · $1,995 avg/customer $41,431 generated LCV · 10 customers · $4,143 avg/customer $55,597 generated LCV · 12 customers · $4,633 avg/customer $20,130 generated LCV · 7 customers · $2,876 avg/customer $10,139 generated LCV · 5 customers · $2,028 avg/customer $2,538 generated LCV · 1 customers · $2,538 avg/customer $2,525 generated LCV · 1 customers · $2,525 avg/customer $6,269 generated LCV · 3 customers · $2,090 avg/customer $3,125 generated LCV · 2 customers · $1,562 avg/customer $14,408 generated LCV · 7 customers · $2,058 avg/customer $6,864 generated LCV · 5 customers · $1,373 avg/customer $5,696 generated LCV · 4 customers · $1,424 avg/customer $19,032 generated LCV · 8 customers · $2,379 avg/customer $25,060 generated LCV · 8 customers · $3,133 avg/customer $23,395 generated LCV · 11 customers · $2,127 avg/customer $2,693 generated LCV · 1 customers · $2,693 avg/customer $3,232 generated LCV · 2 customers · $1,616 avg/customer $4,164 generated LCV · 3 customers · $1,388 avg/customer $2,966 generated LCV · 2 customers · $1,483 avg/customer $469.57 generated LCV · 1 customers · $469.57 avg/customer $9,467 generated LCV · 6 customers · $1,578 avg/customer $5,017 generated LCV · 3 customers · $1,672 avg/customer $1,603 generated LCV · 1 customers · $1,603 avg/customer $1,023 generated LCV · 1 customers · $1,023 avg/customer $1,497 generated LCV · 2 customers · $748.70 avg/customer $546.05 generated LCV · 1 customers · $546.05 avg/customer $888.75 generated LCV · 1 customers · $888.75 avg/customer $1,052 generated LCV · 1 customers · $1,052 avg/customer $1,100 generated LCV · 1 customers · $1,100 avg/customer $1,235 generated LCV · 1 customers · $1,235 avg/customer $1,517 generated LCV · 1 customers · $1,517 avg/customer $1,101 generated LCV · 1 customers · $1,101 avg/customer $596.03 generated LCV · 1 customers · $596.03 avg/customer Downtown Westside Riverside North Market © OpenStreetMap contributors
Hotter areas show higher generated LCV Store LCV is generated customer spend tied to home neighborhood © OpenStreetMap contributors

Distance bands

Nearest store
Westside 193 generated customers assigned to nearest-store distance bands
0-1 mi, 1-3 mi, 3-5 mi, 5-10 mi, 10+ mi
Riverside 153 generated customers assigned to nearest-store distance bands
0-1 mi, 1-3 mi, 3-5 mi, 5-10 mi, 10+ mi
Downtown 240 generated customers assigned to nearest-store distance bands
0-1 mi, 1-3 mi, 3-5 mi, 5-10 mi, 10+ mi
North Market 134 generated customers assigned to nearest-store distance bands
0-1 mi, 1-3 mi, 3-5 mi, 5-10 mi, 10+ mi

Item sales heatmap

Selected-week category demand by store, so managers can compare locations before drilling into SKU-level winners.

Category/store sales intensity

Selected-week units
Selected-week units by store Each row is a store and each cell is units sold for that category in Jun 29 - Jul 5. Darker cells show where demand is concentrated, which helps managers rebalance prep, inventory, and merchandising by location.
Store BakeryCoffeeFermentsGrab And GoHome GoodsPantryPrepared MealsWellness Drinks
Downtown
166 $837.51
208 $1k
204 $2k
196 $995.24
87 $1k
144 $1k
229 $2k
190 $1k
Westside
133 $682.14
135 $665.95
125 $1k
124 $647.68
105 $2k
149 $2k
104 $1k
133 $727.75
Riverside
171 $913.76
123 $610.60
127 $1k
205 $1k
65 $976.73
131 $1k
158 $2k
207 $1k
North Market
107 $528.60
108 $500.25
100 $916.32
76 $371.85
81 $1k
97 $942.25
107 $1k
116 $633.25

Top items

Revenue, margin, units
Chicken Grain Box Prepared Meals · $1,217 revenue · $596.22 GP · 49.0% margin · 91 units
Market Salad Prepared Meals · $1,202 revenue · $673.29 GP · 56.0% margin · 108 units
Harvest Bowl Prepared Meals · $1,197 revenue · $682.34 GP · 57.0% margin · 97 units
Hazelnut Butter Pantry · $1,126 revenue · $472.69 GP · 42.0% margin · 79 units
Ceramic Cup Home Goods · $1,077 revenue · $409.39 GP · 38.0% margin · 50 units
Miso Jar Ferments · $1,003 revenue · $541.32 GP · 54.0% margin · 85 units
Koji Hot Sauce Ferments · $993.79 revenue · $616.18 GP · 62.0% margin · 91 units
Roasted Veggie Wrap Prepared Meals · $987.38 revenue · $513.47 GP · 52.0% margin · 93 units

Inventory, marketing, and source health

Operational guardrails that make the dashboard trustworthy enough to use every week.

Inventory risk

Snapshot 2026-07-05
Downtown 12 low or out-of-stock items need review View items
House Drip Coffee
out
On hand
0
Reorder
23
Gap
23
7D sold
45
Days left
0
Kimchi Pint Ferments
out
On hand
0
Reorder
12
Gap
12
7D sold
40
Days left
0
Local Honey Pantry
low
On hand
3
Reorder
13
Gap
10
7D sold
22
Days left
1
Cacao Adaptogen Shake Wellness Drinks
low
On hand
8
Reorder
13
Gap
5
7D sold
25
Days left
2
Fruit Cup Grab And Go
low
On hand
9
Reorder
13
Gap
4
7D sold
28
Days left
2
Savory Galette Bakery
low
On hand
10
Reorder
21
Gap
11
7D sold
33
Days left
2
Morning Bun Bakery
low
On hand
11
Reorder
18
Gap
7
7D sold
38
Days left
2
Elderberry Spritz Wellness Drinks
low
On hand
11
Reorder
20
Gap
9
7D sold
28
Days left
3
Seeded Granola Pantry
low
On hand
11
Reorder
21
Gap
10
7D sold
26
Days left
3
Garlic Dill Kraut Ferments
low
On hand
11
Reorder
16
Gap
5
7D sold
24
Days left
3
Hazelnut Butter Pantry
low
On hand
14
Reorder
15
Gap
1
7D sold
19
Days left
5
Blueberry Bar Bakery
low
On hand
17
Reorder
25
Gap
8
7D sold
28
Days left
4
North Market 6 low or out-of-stock items need review View items
Seasonal Mocha Coffee
low
On hand
5
Reorder
12
Gap
7
7D sold
10
Days left
4
Harvest Bowl Prepared Meals
low
On hand
9
Reorder
17
Gap
8
7D sold
14
Days left
5
Cold Brew Chai Wellness Drinks
low
On hand
10
Reorder
19
Gap
9
7D sold
13
Days left
5
Blueberry Bar Bakery
low
On hand
14
Reorder
14
Gap
0
7D sold
21
Days left
5
Elderberry Spritz Wellness Drinks
low
On hand
15
Reorder
30
Gap
15
7D sold
15
Days left
7
Protein Bite Pack Grab And Go
low
On hand
21
Reorder
24
Gap
3
7D sold
13
Days left
11
Riverside 13 low or out-of-stock items need review View items
Cold Brew Chai Wellness Drinks
out
On hand
0
Reorder
17
Gap
17
7D sold
38
Days left
0
Turmeric Tonic Wellness Drinks
out
On hand
0
Reorder
12
Gap
12
7D sold
37
Days left
0
Sourdough Loaf Bakery
out
On hand
0
Reorder
15
Gap
15
7D sold
34
Days left
0
Blueberry Bar Bakery
out
On hand
0
Reorder
10
Gap
10
7D sold
30
Days left
0
Soup Pint Prepared Meals
out
On hand
0
Reorder
19
Gap
19
7D sold
28
Days left
0
Yogurt Parfait Grab And Go
out
On hand
0
Reorder
12
Gap
12
7D sold
20
Days left
0
Cacao Adaptogen Shake Wellness Drinks
low
On hand
6
Reorder
24
Gap
18
7D sold
27
Days left
2
Miso Jar Ferments
low
On hand
13
Reorder
17
Gap
4
7D sold
9
Days left
10
Hazelnut Butter Pantry
low
On hand
14
Reorder
28
Gap
14
7D sold
29
Days left
3
Miso Noodle Cup Prepared Meals
low
On hand
15
Reorder
25
Gap
10
7D sold
32
Days left
3
Hummus Snack Box Grab And Go
low
On hand
18
Reorder
22
Gap
4
7D sold
26
Days left
5
Elderberry Spritz Wellness Drinks
low
On hand
20
Reorder
25
Gap
5
7D sold
33
Days left
4
Tea Towel Home Goods
low
On hand
25
Reorder
32
Gap
7
7D sold
8
Days left
22
Westside 14 low or out-of-stock items need review View items
Seeded Granola Pantry
out
On hand
0
Reorder
15
Gap
15
7D sold
25
Days left
0
Cold Brew Chai Wellness Drinks
out
On hand
0
Reorder
16
Gap
16
7D sold
24
Days left
0
Morning Bun Bakery
out
On hand
0
Reorder
13
Gap
13
7D sold
24
Days left
0
Hazelnut Butter Pantry
out
On hand
0
Reorder
12
Gap
12
7D sold
22
Days left
0
Pickled Carrots Ferments
low
On hand
4
Reorder
10
Gap
6
7D sold
23
Days left
1
Trail Mix Cup Grab And Go
low
On hand
6
Reorder
23
Gap
17
7D sold
36
Days left
1
Savory Galette Bakery
low
On hand
12
Reorder
13
Gap
1
7D sold
26
Days left
3
Cardamom Latte Coffee
low
On hand
13
Reorder
16
Gap
3
7D sold
22
Days left
4
Market Salad Prepared Meals
low
On hand
17
Reorder
18
Gap
1
7D sold
19
Days left
6
Protein Bite Pack Grab And Go
low
On hand
23
Reorder
26
Gap
3
7D sold
15
Days left
11
Sourdough Loaf Bakery
low
On hand
26
Reorder
31
Gap
5
7D sold
22
Days left
8
Green Ginger Shot Wellness Drinks
low
On hand
27
Reorder
32
Gap
5
7D sold
32
Days left
6
Cocoa Rye Cookie Bakery
low
On hand
28
Reorder
31
Gap
3
7D sold
27
Days left
7
Hummus Snack Box Grab And Go
low
On hand
30
Reorder
31
Gap
1
7D sold
21
Days left
10

Marketing health

Jun 29 - Jul 5
5,786 website visitors 901 order/category clicks · 15.6% click rate Reporting week: Jun 29 - Jul 5.
6,351 emails delivered 305 clicks · 4.8% click rate Reporting week: Jun 29 - Jul 5.

Raw to clean

Demo artifact count
108,814 raw ordersMessy POS order export
204,605 raw line itemsProduct cleanup source
12,480 inventory rowsStore/product weekly snapshots
10 cleaned tablesDashboard-ready manager data model

Data quality cleanup

The part prospects need to see: useful dashboards depend on cleaned definitions, not prettier charts.

Issue Source Rows Severity Cleanup rule Dashboard impact
Duplicate synthetic customer rows raw_customer_export 34 medium Match repeated customer refs and normalize labels before counting active customers. Prevents overcounting customer base and trade-area density.
Inconsistent product names raw_pos_order_lines 1,186 high Map raw item names to standardized product IDs. Makes item heatmaps and top-product views reliable.
Missing sales channel raw_pos_orders 97 medium Infer from order source where possible; keep unresolved rows in quality table. Avoids silent channel-mix distortion.
Inventory item/store aliases raw_inventory_export 312 high Standardize store aliases and item names before low-stock checks. Connects sales velocity to current stock by store.
Marketing metrics use source-specific names raw_marketing_export 12 low Rename GA4 and Brevo fields into manager-facing KPI names. Keeps marketing cards readable for non-technical users.

Want this shape for your business?

Start with a Business Systems Review or Custom Systems Sprint: source inventory, cleanup rules, KPI definitions, and one weekly operating view your team can use.

Start with a Systems Review