Multichannel Sales Dashboard.
Web, marketplace, and store sales rolled into one daily view.
About this template
Rolls daily orders from Stripe together with the marketplace and store exports you drop into Google Sheets or your warehouse, so every channel lands in one set of numbers. Compare revenue, units, and average order value by channel, then filter to any date range to watch channel mix shift over the season.
The live demo ships with sample data: Six months of daily orders across a web store, a marketplace channel, and two physical stores, with realistic weekend peaks and a holiday bump. Channel mix drifts toward the marketplace so the trend charts have something to say.
The prompt behind this template
This is the exact description the Prized agent built it from. Yours can be one sentence: the agent fills in the rest, and you refine from there.
Show the full prompt
Build a multichannel sales dashboard for the owner of Summit Trail Outfitters, an outdoor gear brand selling through a web store, a marketplace channel, and two physical shops, Downtown and Lakeside. Layout. Top: four stat cards for the selected range: Revenue (about $730,000 over the default 26 weeks), Units (18,400), Average order value ($47.30), Marketplace share of revenue (27 percent for the range, climbing from 16 percent at the start to 35 in the latest weeks). A date range control offers Last 4 weeks, Last 12 weeks, and Last 26 weeks (default), plus a channel multi-select; both drive every region. Second region: a stacked area chart of weekly revenue by channel, weeks on the x axis and dollars on the y, with a toggle to a 100 percent stacked view that makes the mix shift toward the marketplace unmistakable; include one visible spike about six weeks back from an anniversary sale. Third region, side by side: a donut of revenue share by channel for the selected range, and a channel comparison table with columns channel, revenue, units, orders, average order value, share of revenue, and change versus the prior period of equal length, sorted by revenue descending with green positive and red negative change values. Fourth: a small grouped bar chart of average revenue by day of week per channel, showing the shops peaking on weekends and the web store midweek. Data. Seed weekly rollups per channel for the last 26 weeks, 104 records with revenue, units, and orders, plus a small day-of-week revenue profile per channel. The web store holds steady near $9,000 to $11,000 a week; the marketplace climbs from about $4,000 to $11,000; Downtown runs $5,000 to $7,000 and Lakeside $3,500 to $5,500. The story: the marketplace is taking over the mix, but its average order value is the lowest at about $31 versus $58 on the web store, so blended order value drifts down even as total revenue grows. Behavior. All totals, shares, order values, and deltas are computed from the weekly records; nothing is entered by hand except the records themselves. Members can log a week's figures for a channel through a dialog; visitors get a complete read-only dashboard with the full 26 weeks already charted. Visual identity: use an olive green accent for primary actions and chart emphasis, with distinct muted hues for the four channels, on a clean light neutral base.
More like this
All templatesProduct Margin Tracker
See which SKUs are getting squeezed as costs rise faster than prices.
Ecommerce Returns Tracker
Track every return from request to restock and see what keeps coming back.
Retail Promotion Calendar
Plan promos week by week and see which ones actually lifted sales.