Free template

Shopify dashboard template

A free, ready-made Shopify sales dashboard: net sales, orders, average order value, units, discounts and returns, by day, product type and sales channel. Copy the template into Mammoth, connect Shopify, and get the same dashboard on your own store.

Use this template Book a demo

14-day Pro trial · No credit card · Viewers are always free

Shopify dashboard built in Mammoth, showing Net sales, Orders, Average order value, Units sold, Discounts, Returns — The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

In production at

What is a Shopify dashboard template?

A Shopify dashboard template is a ready-made dashboard for your store with the numbers and charts already chosen. You connect Shopify and it fills in with net sales, orders, average order value, units, discounts and returns, by day, product type and channel. It updates from Shopify, so nobody has to export sales each week.

What's on it

What's in the Shopify dashboard template

Six numbers at the top and three charts below them.

Six numbers at the top

Shopify dashboard: Net sales, Orders, Average order value, Units sold, Discounts, Returns

Net sales: Gross sales minus discounts and returns.
Orders: How many orders were placed.
Average order value: Net sales ÷ orders.
Units sold: How many items were sold, net of returns.
Discounts: The value of discount codes and markdowns.
Returns: The value of items sent back.

Daily net sales

Net sales for every day in the period.

Net sales by product type

Net sales from each product type, largest first.

Net sales by sales channel

Net sales from each channel: online store, point of sale, Shop app and social.

How it works

How to use this Shopify dashboard template

Step 1
Connect Shopify
Connect your Shopify account in Mammoth, or upload a report export.
Step 2
Paste the template
Copy the sentence at the top of this page into Mammoth. It builds the same dashboard from your data.
Step 3
Share or schedule it
Share a link, or have it emailed every week. Viewers are free.

Compare

Shopify dashboard templates compared

This template in Mammoth, Shopify's own analytics, and a Data Studio template. Data Studio is Google's free report builder, called Looker Studio until recently.

Mammoth template

For store reporting with your ad spend and email data, shared with anyone.

✓Ready-made template
~FreeFree plan for uploaded files
✓Ad spend or email data in the same dashboard
✓Share a link anyone can open

Shopify analytics

For checking sales inside Shopify admin.

~Ready-made templateBuilt-in reports
~FreeIncluded; more reports on higher plans
✕Ad spend or email data in the same dashboard
✕Share a link anyone can open

Data Studio template

For a free report when most of your data is Google's.

✓Ready-made template
~FreeShopify needs a paid partner connector
~Ad spend or email data in the same dashboardNeeds a paid partner connector
✓Share a link anyone can open

Shopify dashboard template questions

What should a Shopify dashboard include?

Net sales, orders, average order value, units, discounts and returns at the top, then a daily sales trend, sales by product type and sales by channel. Add returning customer rate or sales by discount code when you need to find out why a number moved.

What is the difference between gross sales and net sales?

Gross sales are the full price of everything sold. Net sales take away discounts and returns. The dashboard leads with net sales because that is what the store kept.

How do I use this Shopify dashboard template?

Connect Shopify to Mammoth, or upload a Shopify sales export as a CSV or Excel file. Then paste the template sentence from the top of this page. Mammoth builds the same numbers and charts from your data.

Is the template free?

The template is free to copy. Building it from an uploaded Shopify sales export works on Mammoth's free plan. Connecting your Shopify account directly needs a paid plan.

Can I change the template?

Yes. Ask for the change in plain words, such as "add clicks by device" or "show last month only", and Mammoth updates the dashboard.

Can Mammoth connect to Shopify directly?

Yes. Shopify is one of Mammoth's 100+ tested connectors, so the dashboard reads your account rather than an export.

How often does the dashboard update?

Each refresh pulls the latest Shopify data and every number and chart updates. Daily on Team and every 3 hours on Pro, with no copying and pasting.

Can I combine Shopify with other sources?

Yes. Connect Shopify alongside GA4, a CRM or a spreadsheet, join them in Mammoth, and build one dashboard across all of them, for example ad spend against the deals it produced.

Can I share it with clients?

Yes. Share a link or have it emailed on a schedule, and viewers are free on every plan. On the Mammoth Pro plan you can put your own logo and domain on it.

Is the data on this page real?

No. It is sample data for an invented brand, in the same columns a Shopify sales export uses. The dashboard itself is real: it was built in Mammoth, and you can open it live.