Illustrative — code-level attribution needs Shopify discountApplications capture (not in the ledger yet). Layout shown so it's ready to populate.
Net Sales Trend
Daily total sales
Channel Mix
Category Mix vs Network
Health Score Breakdown
Coaching Notes
Auto-generated from this period
Alert Rules
Weekly Digest
Weeks of Supply by Category
Green = healthy 6–10 wk
Sell-Through vs Inventory
Each dot = one store
Inventory by Store
On-hand value, cost, margin & weeks of supply
Store
Region
On Hand
At Cost
Margin %
Units
Weeks of Supply
Sales by Vendor
Vendor
Category
Net Sales
Units
Avg Price
Gross Margin
SSS vs LY
% of Net
Aged Inventory by Store
sample
Store
Inventory $
>90-Day $
>90-Day %
Top Aged Category
Suggested Action
Illustrative — aging needs received-date / inventory-age history Shopify doesn't expose per unit. Layout ready to populate.
Transfer Suggestions
sample
Online sales, mix, and adoption are live from your channel data. Sessions, conversion rate & the funnel are now live from Shopify Analytics (ShopifyQL) for stores with read_reports; stores still pending the scope are listed under the funnel.
Online Sales by Channel
Online Penetration
Stores by online % of sales
Online Adoption by Store
Store
Online Sales
Online %
Orders
Online AOV
Online Funnel
loading…
Sessions trend
Sessions → cart → checkout → conversion, live from Shopify Analytics over the selected period.
Top Online Products
sample
#
Product
Category
Units
Revenue
Illustrative — channel-tagged product sales need order line→channel attribution we don't capture yet.
Playbook
Top Vendors by Sales
Top Channel by Sales
Top Product Type by Sales
Sales Channel Performance
Sales Channel
Orders?Orders — orders containing a product sale. Gift-card-only orders aren't counted (matches Shopify).
Units?Units (Net items sold) — items ordered, including exchanges, minus items returned. Matches Shopify's "Net items sold."
Gross Sales?Gross sales — product price × quantity, before discounts, returns, tax, or shipping.
Discounts?Discounts — total discounts applied to orders (shipping discounts reduce Shipping, not this).
Returns?Returns — value of refunded merchandise, dated to when the return was processed.
Net Sales?Net sales — Gross Sales − Discounts − Returns. Excludes tax and shipping.
Shipping?Shipping — shipping charged to customers, net of shipping refunds.
Taxes?Taxes — tax collected, net of tax refunded on returns. Matches Shopify's "Taxes."
Total Sales?Total sales — Net Sales + Shipping + Taxes. Shopify's headline "Total sales."
Shop Performance
Store
Region
Orders?Orders — orders containing a product sale. Gift-card-only orders aren't counted (matches Shopify).
Units?Units (Net items sold) — items ordered, including exchanges, minus items returned. Matches Shopify's "Net items sold."
Gross Sales?Gross sales — product price × quantity, before discounts, returns, tax, or shipping.
Discounts?Discounts — total discounts applied to orders (shipping discounts reduce Shipping, not this).
Returns?Returns — value of refunded merchandise, dated to when the return was processed.
Net Sales?Net sales — Gross Sales − Discounts − Returns. Excludes tax and shipping.
Shipping?Shipping — shipping charged to customers, net of shipping refunds.
Taxes?Taxes — tax collected, net of tax refunded on returns. Matches Shopify's "Taxes."
Total Sales?Total sales — Net Sales + Shipping + Taxes. Shopify's headline "Total sales."
Channel Breakdown by Store
POS vs Online vs other channels per location
Store
Region
Total Sales
POS Sales
POS %
Online Sales
Online %
Social Sales
Other
Store Name
Region
Domain
Connection
Last Updated
Loading…
Invite a user
Admin: everything, including user management · Home Office: all stores, read-only · Store: only their assigned store(s).
Invited users get an email to set their own password.
User
Role
Store Access
Last Sign-in
Added By
Loading…
Returns by Store
Store
Region
Gross Sales
Returns
Return Rate
Orders
Avg Return/Order
Apple Valley, MN
In-store (POS) sales only — this matches how the store files. Minnesota exempts clothing from sales tax, so only taxable goods (jewelry, accessories, sunglasses, greeting cards, etc.) are listed. Online orders are remitted separately and excluded.
Taxable Goods
Product
Units Sold
Units Ret.
Net Units
Gross
Discounts
Sales
Returns
Net Sales
Tax Sold
Tax Ret.
Tax
Prior week
Organic metrics are live from Google Analytics (mainstreamboutique.com franchise pages).
Greyed blocks are wired up and waiting on API keys.
Top Landing Pages
Page
Sessions
vs Previous Week
Sessions Trend
Weekly · organic sessions
Top Traffic Source (selected week)
Demand Generation
ActiveCampaign
Apple Valley — QR Card
Phase 2 — Sales Funnel
Meta Ads
Meta Ads access token needed
Total Views (prior week)—
$ Spent—
CPL—
Leads Converted—
Lead %—
Store & date range use the filters at the top of the page.
Date
Store
Region
Channel
Items
Gross
Discounts
Returns
Tax
Shipping
Net Total
Select a date range to load orders.
New vs Returning Customers
live
New Returning
Monthly new (first-ever purchase) vs returning customers, from real purchase history.
Cohort Retention
live
Month 0 = first-purchase month (100%). Each later cell = % of that cohort who purchased again that month.
Network Capture Rate
live
Monthly % of orders with a customer record attached · target ≥ 80%.
Customer Data Quality
Customers by Store
Store
Region
Customers
Capture
Trend
Repeat Rate
Avg LTV
Avg Orders
Customers, Capture, Repeat Rate, Avg LTV & Avg Orders are live. The Trend column is an illustrative shape — real per-store capture history accrues as customer capture accumulates.
Your Profile
Add Store
Log in with email
Or
Two-factor authentication
Enter the 6-digit code from your authenticator app.
