Online Marketplaces Dashboard in Google Sheets

The Online Marketplaces Dashboard in Google Sheets reports 16 KPI cards and 18 charts across six tabs, driven by 15 native slicers and native pivot tables. It ships with 500 sample orders spread over 8 marketplaces, 8 product categories and 5 regions, and every pivot, slicer and formula is already stretched to 1,000 data rows. Setup takes under 10 minutes — paste your own order log onto the Data sheet and the whole workbook recalculates. It is a multi-channel marketplace sales dashboard: one file that puts every channel, category, region and buyer segment on the same set of axes.

🌎 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

⚠️ Read this before you buy: this is a reporting workbook, not a connector. It does not link to Amazon, eBay, Etsy, Shopify, Walmart or any other marketplace API, and it does not import orders, settlements or fee reports on its own. You export or paste your order rows onto the Data sheet — that is the only input it needs.

🔑 Key Features of the Online Marketplaces Dashboard in Google Sheets

📊 Four slicer-driven analysis pages. Overview, Marketplaces, Categories and Buyers each carry four colour-coded KPI cards and their own filter strip. Overview carries three slicers (Month, Marketplace, Category); the three deeper pages carry four each, so 15 slicers in total control the charts and pivots on their own page.

📈 Built on native pivot tables, not helper formulas. Every chart reads a pivot table parked to the right of its page — scroll past the spacer column to inspect the numbers behind any visual. Because no helper grid sits between the data and the charts, the file stays fast as your order log grows toward the 1,000-row ceiling.

💰 Take Rate is calculated per order. Take Rate is the commission fee divided by gross sales on each order, plotted as a secondary-axis line against volume on both Monthly Gross Sales vs Average Take Rate and Region Sales vs Average Take Rate, so you can see the real cost of selling on each channel instead of a blended average.

🔍 An order lookup page. The Search tab resolves any Order ID to a 16-field record — order date, marketplace, category, seller, buyer name, fulfilment method, gross sales, units, commission fee, region, payment method, order status, buyer segment, month and take rate.

🎨 Recolour the whole workbook from one place. The shipped Rose / Amber theme is defined in a single palette block at the top of the build script (ink #5A1030, accent #F5A524, secondary #9AD1D4). Change those values and every banner, card and chart follows.

📝 KPI cards are deliberately unfiltered. The KPI cards and the AT A GLANCE lists use SUMIFS and COUNTIFS against the Data sheet, so they always show whole-period totals. The charts, pivots and Top 5 panels are slicer-aware. That split is intentional: you always keep a stable reference number on screen while you drill.

📦 What’s Inside the Online Marketplaces Dashboard in Google Sheets

Page 1: Overview — marketplace-wide performance

The landing tab answers “how did we do everywhere”. Its four KPI cards read Total Gross Sales $78,134, Total Orders 500, Units Sold 1,417 and Avg Order Value $156, with Month, Marketplace and Category slicers above them. Charts are Monthly Gross Sales vs Average Take Rate, Gross Sales Composition by Category and Month-over-Month Gross Sales Variance. The right rail adds a Marketplace Snapshot (delivered rate, units per order, commission fees), a 12-Month Gross Sales Trend, Top 5 Marketplaces by Gross Sales, an Order Status Mix bar list and an At a Glance table.

Page 2: Marketplaces — channel sales, fulfilment mix and commission cost

This page compares the eight channels in the sample data: Alibaba, Amazon, eBay, Etsy, Mercado Libre, Shopify Market, Walmart Marketplace and Wish. KPI cards show Amazon Gross Sales $17,288, Commission Fees $10,816, Avg Take Rate 13.8% and Cross-Border Orders 46. Charts are Gross Sales by Marketplace, Gross Sales by Marketplace & Fulfilment, Units Shipped by Month and Commission Fees by Marketplace. The rail carries a Channel Snapshot with net-after-fees, Top 5 Regions by Gross Sales and a Marketplace Sales Share list.

Page 3: Categories — catalogue performance and order outcomes

Eight categories (Apparel & Footwear, Beauty & Personal Care, Books & Media, Electronics, Home & Kitchen, Pet Supplies, Sports & Outdoors, Toys & Games) are measured against ten listed sellers. KPI cards read Electronics Sales $28,665, Units Sold 1,417, Avg Unit Price $55.14 and Return Rate 8.8%. Charts are Gross Sales by Category, Units vs Gross Sales by Seller, Order Outcome Rates, Units by Category, Monthly Gross Sales and Sales by Category & Buyer Segment. Two gauges show delivered and returned percentages side by side.

Page 4: Buyers — who buys, how they pay, how it ships

This tab splits demand across three buyer segments (New Buyer, Repeat Buyer, Subscriber), six payment methods and five fulfilment types. KPI cards read Repeat Buyer Sales $38,592, Unique Buyers 302, Digital Wallet Orders 140 and Subscriber Sales $15,301. Charts are Orders by Fulfilment Type, Orders by Buyer Segment, Gross Sales by Payment Method, Monthly Order Volume and Region Sales vs Average Take Rate. The rail adds a Buyer Snapshot, Top 5 Sellers by Gross Sales and a Fulfilment Mix list.

Page 5: Search — order lookup

Pick any Order ID from the dropdown and the Order Details panel returns the complete record on one screen. It is the page you open when a buyer queries a charge or a return, and it needs no filtering of the Data sheet.

Page 6: Instructions — the ten-step user guide

A plain-English guide covering how slicers drive each page, how to clear a filter with Select all, why the KPI cards stay unfiltered, how Take Rate is derived, how to swap in your own orders, and how the 1,000-row auto-expand works. The About block records the pivot-plus-slicer architecture and the theme codes.

📊 Online Marketplaces Dashboard in Google Sheets vs. a Microsoft Excel Dashboard vs. Sellerboard / Helium 10

For sellers who want one cross-channel view of sales, fees and buyers without paying a per-month seat fee for a tool they only open at month-end, the Online Marketplaces Dashboard in Google Sheets sits in the sweet spot — an ecommerce marketplace dashboard template you own outright.

👥 Who This Template Is For — and Who It’s Not For

✅ This template is built for:

• Multi-channel sellers listing on two or more of Amazon, eBay, Etsy, Walmart, Shopify or Alibaba who need one combined view
• E-commerce managers and account managers who report monthly gross sales, commission fees and return rate to an owner or a client
• Agencies and virtual assistants managing seller accounts who want a shareable, branded report instead of a raw CSV
• Finance and operations staff who need net-after-fees and take-rate figures per channel before a pricing decision

❌ This template is NOT for:

• Anyone who needs orders to arrive automatically — there is no API connection to any marketplace, and you will be pasting an export each period
• Sellers carrying more than 1,000 orders per reporting period, unless you extend the pivot and formula ranges yourself
• Teams needing live inventory or repricing — this reports on orders that already happened, it does not manage listings or stock
• Accounting or tax filing — the commission figures are for internal analysis, not a settlement reconciliation

⚙️ How to Use the Online Marketplaces Dashboard in Google Sheets

1. Open the PDF in your download and click the “Make a copy” link to create your own editable Google Sheets file.
2. Open the Instructions tab first and read the ten-step guide; it explains the slicer behaviour in two minutes.
3. Go to the Data sheet, delete the 500 sample rows and paste your own orders. Keep the column headers exactly as they are.
4. Stay at or under row 1001. Pivots, slicers and formulas already cover 1,000 rows, so nothing else needs resizing.
5. Return to Overview and click any slicer. Charts, pivots and the Top 5 panel on that page update together.
6. To clear a filter, open the slicer and choose Select all. Slicers are per-page, so other tabs keep their own filters.
7. Use the Search tab to look up a single Order ID when a buyer or a seller queries an order.
8. To rebrand, edit the palette block at the top of the script and the ink, accent and secondary colours flow through every page.

💼 Real-World Use Cases

Priya sells home and kitchen goods on Amazon, eBay and Etsy. At the end of each month she exports three order reports, stacks them on the Data sheet, and opens the Marketplaces tab. The Commission Fees by Marketplace chart and the 13.8% average take rate told her that one channel was quietly costing her three points more than the others — a fact her three separate seller dashboards had never put side by side.

Marco runs operations for a 12-person brand selling across five regions. He uses the Buyers tab to watch the repeat-buyer share and the digital-wallet mix, then shares a view-only link with the founders before the monthly call. Because the KPI cards stay unfiltered, the headline numbers on his screen match the ones on theirs even while he drills into a single region.

Anita is a virtual assistant managing seller accounts for four small clients. She keeps one copy of the workbook per client, pastes each order export in, and delivers the same six-tab report to all four — without buying four seats of a subscription tool she would only open once a month.

❓ Frequently Asked Questions

Does the Online Marketplaces Dashboard in Google Sheets connect to Amazon or eBay automatically?

No. The Online Marketplaces Dashboard in Google Sheets has no API connection to Amazon, eBay, Etsy, Shopify, Walmart or any other marketplace. You export your order report from each channel and paste the rows onto the Data sheet, which is the only input the workbook needs.

How many orders can it hold?

Pivots, slicers and every formula are pre-stretched to 1,000 data rows, and the file ships with 500 sample orders. Paste new rows anywhere up to row 1001 and the dashboard updates on its own. Beyond that you would extend the pivot and formula ranges manually.

What KPIs does this dashboard track?

It carries 16 KPI cards across four pages: gross sales, orders, units sold and average order value on Overview; Amazon gross sales, commission fees, average take rate and cross-border orders on Marketplaces; category sales, units, average unit price and return rate on Categories; and repeat-buyer sales, unique buyers, digital wallet orders and subscriber sales on Buyers.

Why don’t the KPI cards change when I click a slicer?

That is by design. The KPI cards and the At a Glance lists use SUMIFS and COUNTIFS on the Data sheet so they always show whole-period totals, giving you a stable reference while the charts, pivots and Top 5 panels respond to the slicers on that page.

How does this compare to Sellerboard or Helium 10?

Those tools sync your marketplace data automatically and charge $19 to $229 a month. This template is a one-time purchase with no seat fees, and every formula is open to edit — but you paste the order export in yourself. It suits periodic reporting rather than live operational monitoring.

How long does setup take?

Under 10 minutes. Copy the sheet from the link in the PDF, replace the 500 sample rows on the Data sheet with your own orders, keep the headers unchanged, and all six tabs recalculate. Recolouring the workbook to your brand takes another two minutes in the palette block.

Can I use it on a phone or a Mac?

Yes. It runs in any browser and in the Google Sheets mobile app, on Windows, macOS, ChromeOS, iOS and Android. Nothing needs to be installed, and no macros are involved, so there is no Windows-only restriction.

👤 About the Author

Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PKAnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

📊 Seller Analytics Dashboard in Google Sheets — the single-storefront companion, focused on listing and seller performance rather than cross-channel comparison.

🚚 Drop Shipping Dashboard in Google Sheets — supplier lead times and margin per order, for the dropship side of a marketplace business.

📦 Shipping Dashboard in Google Sheets — carrier cost, transit time and delivery performance once the order leaves you.

📈 Online Marketplaces KPI Dashboard in Google Sheets — the month-picker KPI scorecard version of this topic, with traffic lights and MTD/YTD targets instead of analysis pages.

Also available as: Online Marketplaces Dashboard in Excel and Online Marketplaces Dashboard in Power BI.

Browse the full Google Sheets Dashboards collection or the wider Google Sheets templates library for more ready-to-use reporting files.

New to pivot tables and slicers in Sheets? Google’s own guides on creating pivot tables and filtering with slicers explain the two features this workbook is built on.

📖 Click here to read the Detailed Blog Post

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

Watch the step-by-step video Demo:

📅 Last updated: September 2026