⚠ SAMPLE DATA — illustrative, not client actuals. Figures below are generated to show how the dashboard behaves; the web-store figures assume a rebuilt, working storefront.
Filter-life clock — who is due for a carbon filter right now
Each spoke is a month of cushion buyers. Inner band = already re-ordered · outer bands = still inside filter life, in the 3–6 month re-order window, or lapsed.
Revenue by channel
Monthly net revenue, USD
AmazonWeb store
Units: cushions vs replacement filters
Filters should outsell cushions — that is the razor-and-blade working
CushionsReplacement filters
Amazon listings — ads, reviews, Buy Box
Per ASIN, selected period
Inventory weeks-on-hand by print
At current sell-through across all channels · target band 8–16 weeks
Channel economics
Why every filter sold on the web store is worth more than one sold on Amazon
Data sources this would connect toAmazon Seller Central (orders, ads, reviews, Buy Box)Rebuilt web store (Shopify / WooCommerce — replaces X-Cart)Payment gateway (Authorize.net / PayPal — to confirm)QuickBooks (to confirm)Email / SMS platform (Klaviyo or Mailchimp)Google Analytics 4 (legacy UA seen — to confirm)
Delivery: Power BI is the primary delivery (requires Power BI licences — Pro, or Fabric capacity). A no-licence custom web version, like this page, is the alternative for a two-person team.