Ads
Mainstream Boutique Dashboard
Real-time overview of franchise locations
Today
Yesterday
Last 7 days
Last 30 days
Last 90 days
This month
Last month
This quarter
Last quarter
This year
Last 12 months
Custom range
Last 30 days
—
✕ Clear Filters
Net Sales Over Time
Current Previous
Sales by Region
Sales by Channel
Store Finder Activity
Brand site · /pages/locationsSales by Market Size
Net sales by store tierStore Performance — Top & Bottom Movers
Same-store sales growth vs the same period last year
Top Movers
Bottom Movers
All Store Locations
| Location | Region | Net Sales?Net sales — gross sales − discounts − returns (excludes tax & shipping). ▾ | vs Previous Period | Orders?Orders — orders containing a product sale. Gift-card-only orders aren't counted (matches Shopify). | AOV?Average order value — Total Sales ÷ Orders. | Customers?Customers — distinct customers who placed an order in this period. |
|---|
| # | Size | Store | Net Sales | SSS Growth?Same-store sales growth — net/total sales vs the same period last year (same store). | ATV | UPT | Disc % | Ret % | Cust %?Returning-customer share — orders from repeat customers ÷ orders. | H. Score?Health score (v1) — composite percentile blend of SSS growth, returning rate, and (low) discount & return rates. Refined in Phase 6. |
|---|
Cohort Medians
Size = corporate market-size tier (Large / Medium / Small).
⚠ Watchlist
Discount Rate Trend
Daily discount % of gross This year Last year Alert threshold (20%)
Discounts by Type
sample⚠ Manual POS discounts are largely untracked — needs discount-code capture (
discountApplications).Discount Rate by Store
Discount Code Performance
sample| Code | Type | Uses | Gross Sales | Discount $ | Discount % | New Customers % | Repeat Purchase Rate |
|---|
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 salesChannel Mix
Category Mix vs Network
Health Score Breakdown
Coaching Notes
Auto-generated from this periodAlert Rules
Weekly Digest
Weeks of Supply by Category
Green = healthy 6–10 wkSell-Through vs Inventory
Each dot = one storeInventory 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
sampleOnline 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 salesOnline 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
Pipeline metrics come from Google Analytics (property MB Final, franchise pages);
leads from Close. Franchise page views now count page views of the franchise pages
rather than sessions that landed on them — a deliberate change to a truer top-of-funnel number.
A greyed block means that source couldn't be reached.
Executive performance
How interest becomes a lead
Website Conversion Funnel?Website Conversion Funnel — the weekly path from GA4 franchise page views to tracked franchise CTA clicks and Close “Shopify Form” leads. Paid and re-engagement leads are excluded.
?Google Search Console — How prospects discover you before the funnel — Google organic search.
this week
Where intent happens
Franchise Content & Click Paths
what attracts interest and what visitors do nextWhere they land page views
What they click, and where it goes
CRM Pipeline
Close · Phase 2What's Driving Clicks
Where Franchise Leads Come From
Demand Generation
Ads
QR Campaigns
In-store cards
Traffic Source
Shopper engagement with the store-finder buttons on mainstreamboutique.com/pages/locations
(GA4 MB Final). This is the brand marketing site — separate from the 57 Shopify stores,
and not comparable to Sales figures. Shop This Store is the highest-intent action.
Actions by Type
Where Engagement Concentrates
Top Stores by Shopper Engagement
Shop-Through Spotlight
Email marketing across every boutique's Constant Contact account, via the
franchise technology partnership. Contact counts are account totals; campaign stats
are unique per recipient, with rates measured against delivered (sends minus bounces).
Recent Campaigns
| Store | Campaign | Sent | Delivered | Open Rate | Click Rate | Bounces | Unsubs |
|---|
Accounts & Data Flow
Every Constant Contact account under the partnership — and whether its data is flowing
| Store | Workspace Login | Contacts | New (30d) | Campaigns | Last Campaign | Billing | Data |
|---|
This tool only creates drafts. It cannot send anything. Each store finds the
draft in their own Constant Contact account, reviews it, and sends it themselves.
1 · The email
2 · What will be personalized, and for whom
Stores that will get a draft
select all ready · none
3 · Final check — every store, every link
Open a preview for any store before creating anything
| Store | Links |
|---|
| Store | Result | Notes |
|---|
Each store now has this campaign as a draft in their Constant Contact account —
they review it, pick their list, and send when ready. Nothing has been sent.
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
liveMonth 0 = first-purchase month (100%). Each later cell = % of that cohort who purchased again that month.
Network Capture Rate
liveMonthly % 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.
