Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceE-commerce OperationsE-commerce Sales Dashboard by Channel

SpreadsheetE-commerce OperationsFree

E-commerce Sales Dashboard by Channel

Monthly orders, revenue, ad spend and refunds for each channel, with AOV, ROAS and refund rate.

Shown with sample data

Colour

E-commerce Sales Dashboard by Channel

Monthly orders, revenue, ad spend and refunds for each channel, with AOV, ROAS and refund rate.

Revenue
$159,850
Average order value
$38.54
ROAS
7.4
Revenue ÷ ad spend
Refund rate
4.4%
Net revenue by channel
  • Amazon$54,410
  • Own store$53,430
  • Etsy$23,240
Share of net revenue by channel
  • Amazon$54,41042%
  • Own store$53,43041%
  • Etsy$23,24018%

How to use it

  1. 1Export monthly totals from each channel.
  2. 2Add one row per channel per month.
  3. 3Compare ROAS and refund rate between channels.
  4. 4Move budget towards channels with rising ROAS.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Each sales channel has its own dashboard and none of them agree. Bring monthly orders, revenue, ad spend and refunds for every channel into one sheet; it calculates average order value, return on ad spend and refund rate and shows where growth and problems are coming from.

Who it’s for

  • Monthly performance reviews
  • Deciding where to move ad budget
  • Reporting to partners or investors

What’s included

  • Monthly sales sheet: One row per channel per month.
  • Summary by Channel sheet: Net revenue and Revenue and the number of entries for each channel, calculated from the Monthly sales sheet.

How to use it

  1. 1Export monthly totals from each channel.
  2. 2Add one row per channel per month.
  3. 3Compare ROAS and refund rate between channels.
  4. 4Move budget towards channels with rising ROAS.
Related searchesecommerce dashboardonline sales reportmultichannel sales trackerroas reportaverage order value

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetE-commerce OperationsFree

E-commerce Sales Dashboard by Channel

Monthly orders, revenue, ad spend and refunds for each channel, with AOV, ROAS and refund rate.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More e-commerce operations templates

View all
E-commerce Profit Calculator2 sheets

Listings analysed

8

Average net margin

21%

Losing money

1

Entries by channel
3
2
2
1
Own storeAmazonEtsyeBay
SpreadsheetE-commerce Operations

E-commerce Profit Calculator

True profit per order after product cost, shipping, marketplace and payment fees, ads and returns.

10 min setupPreview

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

Full name *

Email *

Phone *

Place order
FormE-commerce Operations

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

10 min setupPreview
Product Catalogue with Margins2 sheets

Products

7

Average margin

64%

Low-margin products

1

ABCD
1ProductCategoryVariantSupplier
2Organic cotton teeApparelBlack / MGreenThread
3Heavyweight hoodieApparelGrey / LGreenThread
4Canvas tote bagAccessoriesNaturalBagCo
5Embroidered capAccessoriesNavyCapWorks
Products
SpreadsheetE-commerce Operations

Product Catalogue with Margins

SKUs with cost, price, margin, markup, stock and status for every product.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ