Sales dashboard

Weekly view of the funnel, channels, spend, and product mix. Order revenue comes from the Revenue Tracker sheet (ground truth); funnel, channel, and category splits come from the GA4 BigQuery export and undercount by design (see data quality at the bottom).

Window: 2026-03-30 → 2026-06-12 · generated 2026-06-12 16:48 UTC * current partial week. Refresh: python3 scripts/fetch-dashboard.py

1. Sales funnel — last 28 days

Viewed a product
20,064
Started the designer
6,185
30.8% of previous step
Began checkout
1,078
17.4% of previous step
Purchased
670
62.2% of previous step

Unique users per step (GA4). Overall 3.34% of product viewers purchase. The designer is the big gate: 83% of people who start designing never reach checkout. add_to_cart is excluded — the event is broken in GA4 (fires on a small subset of paths only).

2. Funnel conversion over time

0% 20% 40% 60% Mar 30Apr 6Apr 13Apr 20Apr 27May 4May 11May 18May 25Jun 1Jun 8*
product view → purchase began checkout → purchase

3. Revenue by channel (GA4, weekly)

$0 $5,000 $10,000 $15,000 $20,000 Mar 30Apr 6Apr 13Apr 20Apr 27May 4May 11May 18May 25Jun 1Jun 8*
Paid SearchCross-networkDirectOrganic SearchPaid Shopping

Last-click attribution. Cross-network = Performance Max.

4. Ad spend vs sales (Revenue sheet, weekly)

$0 $16,000 $32,000 $48,000 $64,000 Mar 30Apr 6Apr 13Apr 20Apr 27May 4May 11May 18May 25Jun 1Jun 8*
sales (actual orders) ad spend

Ground truth from the manually maintained Revenue Tracker — not subject to analytics undercount.

5. Revenue by product category (GA4, weekly)

$0 $8,000 $16,000 $24,000 $32,000 Mar 30Apr 6Apr 13Apr 20Apr 27May 4May 11May 18May 25Jun 1Jun 8*
Memorial/Prayer CardsPostersProgramsBookmarksOther

Categories classified from item names (GA4 item_category is not set on this site). "Programs" includes the MegaEdit funeral programs — the high-AOV products.

6. Data quality — how much of real revenue GA4 captures

0% 25% 50% 75% 100% Mar 30Apr 6Apr 13Apr 20Apr 27May 4May 11May 18May 25Jun 1Jun 8*
GA4 revenue ÷ sheet revenue

GA4's purchase event fires from a DOM-based trigger and misses orders (historically 9–24%). Weeks well below ~80% mean the GA4-based charts above understate that week — judge trends, not absolute dollars, from GA4 sections.