Reporting

Shopify Sales Reports: Definitions, Metrics, & Templates to Grow Your Online Store

Improve your understanding of Shopify sales data & reports and gain beneficial insights that will help you drive your online business growth.

Stefana Zaric Stefana Zaric on May 24, 2022 (last modified on June 15, 2022) • 14 minute read

Shopify’s analytics and reports are a very powerful feature that gives you the means to review almost any customer interaction made within your Shopify store – from your store’s recent activity to insights into your visitors to your store’s transactions, and more.

But how can you actually take advantage of this abundance of information, and where should you start from?

To better understand and optimize customer experiences and marketing efficiency, we recommend starting with your sales data. Understanding the sales data available in Shopify can be the key element that makes or breaks your online store’s success.

In this article, we’re breaking down Shopify sales reports: you’ll learn how to leverage them to gain practical insights into your performance and get templates to save your time and grow your online store more efficiently.

Navigate to the section you’re most interested in.

shopify_sales_overview_dashboard_databox

What Is a Shopify Sales Report?

Sales reports in Shopify help you accurately track the orders that take place on your website, breaking down each sale (and return) into valuable data that you can use to improve your sales process and performance.

In Shopify sales reports, you’ll find data such as net and gross sales, average order value, repeat customer rate, customer lifetime value, and more. You can filter your reports by product, channel, month, location, etc.

How to View Your Sales Reports in Shopify

Shopify sales reports allow you to track your data in real-time. Note that you might need to wait for a minute until the data updates or refresh your page to load it faster. Also, sales by discount reports take a bit longer to update: up to 72 hours.

To access your reports via different devices, follow the steps below.

  1. Desktop
  2. Android
  3. iPhone

Desktop

  1. Open your Shopify admin dashboard.
  2. Navigate to Analytics.
  3. Choose Reports and go to the Sales section.
  4. Select Show all and choose which reports you’d like to view.
Access Shopify sales report via desktop

Android

  1. Open your Shopify app.
  2. Tap on Store.
  3. Tap on Analytics and choose Reports.
  4. Navigate to the Sales section and tap on Show all.
  5. Select the report you’d like to view.
Access Shopify sales report via mobile (Android)

iPhone

  1. Open your Shopify app.
  2. Select your Store and go to Analytics.
  3. Choose Reports.
  4. Navigate to the Sales section and click on Show all.
  5. Choose the report you’d like to view.

Shopify Sales Report: Terminology and Definitions You Need to Know

To understand Shopify sales reports, you need to learn to speak Shopify first – there are some basic terms and definitions you should be familiar with. You can find the glossary on the platform’s official website, but we’re also giving you an overview.

  • Orders. The total number of orders your customers placed on a specific date.
  • Average Order Value. The average value of Customer Sales.
  • Units per Transaction. Net quantity divided by the total number of orders.
  • Gross Sales. Product Price multiplied by Quantity for a Sales collection. It includes Canceled, Pending, and Unpaid Orders, but not Test and Deleted. It’s calculated before Taxes, Shipping, Discounts, and Returns.
  • Net Sales. Returns and Discounts removed from Gross Sales.
  • Discounts. Order Level Discount Share added to the Line Item Discount for a Sales collection. Discounts are created using Discount codes and applied before Taxes. They can be applied to specific or all products in an order.
  • Shipping. Shipping Discounts and Refunded Shipping Amounts removed from Shipping Charges.
  • Returns. The total value of the goods your customers returned.
  • Tax. The total amount of taxes applied to your orders.
  • Total Sales. Your Gross Sales without Discounts and Returns, with Taxes and Shipping Charges included.

Shopify Sales Reports

Shopify provides powerful reporting tools for its users–they allow you to track much more than your average order value. You can learn a lot about how your customers buy, why they buy, and what you could improve for them, and adapt your strategy accordingly.

Note that Sales Reports are only available for Shopify, Advanced Shopify, and Shopify Plus Plan users.

There are 11 types of reports you can view in Shopify:

Sales Over Time

This report displays your total sales and number of orders over time. In Sales Over Time, you’ll see edited orders being shown as new ones, even though you didn’t really create a new order.

Sales by Product

This report shows the breakdown of your total sales, but without shipping because shipping applies as a single charge for whatever the number of products in one order. That said, you won’t be able to see shipping taxes in the Sales by Product report.

Shopify Sales By Product Report
Source: Shopify

What you will be able to see are: Product Vendor (if purchased from a third party), Product type, Product title, and Net quantity (returned items are removed).

If you see multiple rows for a product, or a dash instead of data, it means the original order has been changed or the data didn’t exist at the moment of creating the order.

Sales by Product Variant SKU

This report displays the breakdown of your gross sales of your best-selling products, without the shipping cost. It gives you more detailed information than a regular Sales by product report.

In this report, you can see details such as Product title, Variant title, Variant SKU (the ID code of the variant), and Net quantity.

Sales by Product Vendor 

This report displays your vendors and the products you get from them. You can see categories such as Product vendor (the vendor’s name, which you have to click to see products provided by them) and Net Quantity.

Sales by Discount

If you made a sale after May 1, 2017, it will be displayed in this report. Sales by Discount reports show your sales grouped by discount name or code. It lets you see how often your customers applied discounts to purchase your products and helps you determine which ones have been the most effective in driving sales.

In this report, you will see the following items: Name, Discount applied, Discount type, Discount code, Automatic discount title, Orders, Script discounts, Shipping, Shipping script discounts, Shipping discounts.

Sales by Traffic Referrer 

This report displays your sales based on where your customers came from: direct traffic, search, email, social, or unknown.

Shopify Sales By Channel or Traffic Referrer Report
Source: Shopify

Other than the traffic source, you can see the Traffic referrer host, the specific website of the referral. For example, if the source is Social, the website might be www.facebook.com.

Sales by Billing Location

This report displays the breakdown of your sales by country and region based on the billing address of your orders.

Shopify sales by billing location report
Source: Mapplinks

Sales by Checkout Currency

This report is only available to Shopify Payments users and displays the breakdown of sales by the currency your customers use at the checkout, if you accept different currencies. In the Total sales column, you will see the total sale value in your local currency.

Sales by Channel

This report displays the amount of sales for various sales channels you may be using. You will be able to see the Sales channel name (name of the channel or app the customer ordered through–Buy Button or Online Store) and Draft Orders (for sales that were initially draft orders). Unknown apps will be displayed under Other.

Sales by Customer Name

This report displays the breakdown of all orders a specific customer of yours has made over a certain time period. In the report, you can see the customer’s name and email address.

Shopify Sales by Customer Name Report
Source: Shopify

Average Order Value Over Time

This report displays the change in the average order value over a period of time. It doesn’t contain returns, and if you select the Group by option, you can see the sales sorted and grouped by hour, week, month, etc.

Note that you can customize your sales reports by using different filters and editing features.

6 Key Shopify Sales Reports Metrics

If you’ve set your sales goals and created a strategy, the third big thing you need to do is decide how you’re going to measure your success. You need to choose relevant metrics to track in Shopify so you can accurately evaluate your performance.

Your Shopify KPIs can help you modify your strategy to be more efficient and make informed decisions. Your choice depends on your individual sales goals, but there are a few universal metrics that every business should have in their dashboard.

Gross Sales

Gross Sales refer to the total amount of Sales you’ve made within a specific time range. Discounts, Shipping Expenses, and Outgoing don’t count.

You can use this metric to compare the amounts between two months, quarters, or years and track your progress. It also helps you identify any hiccups in your sales pipeline so you can fix them, and even compare your numbers with your competitors.

The formula: Product Price x Quantity Sold = Gross Sales

Net Sales

Net Sales refers to the overall amount of registered Sales without Discounts and Returns.

It’s recommended to use this metric in comparison with Gross Sales, so you can track how much you earn, and how much you take home. If the difference between your Gross and Net Sales is too big, you may be losing too much money into Discounts and Refunds.

The formula: Gross Sales – Discounts – Returns = Net Sales

Average Order Value

Average Order Value refers to the average amount of money a customer spends on a single order. The higher this metric, the better your profit margins–your business has an opportunity to grow.

The formula: Total Sales/Number of Orders = Average Order Value

Customer Lifetime Value

Customer Lifetime Value (CLV) refers to the worth that a customer has for your business during the time they engage with it (buy from you).

As customer retention is far more affordable than gaining new customers, this metric can give you insight into how much you should focus on optimizing your customer experience for higher lifetime value.

The formula: (Average Value of Sale x Number of Transactions x Retention Period) x Profit Margin

Customer Acquisition Cost

Customer Acquisition Cost (CAC) refers to the amount of money it costs you to convert a Prospect into a Loyal Customer. Businesses should aim to reduce this cost as much as possible and optimize customer acquisition so they can generate higher profit.

The formula: (Marketing Costs + Sales Costs)/Number of New Customers Acquired = CAC

Returning Customer Rate

Returning Customer Rate refers to the percentage of customers who have made more than one purchase in your online store. This percentage may depend on many factors, such as customer satisfaction and even your industry, which affects how often people buy products in your niche in general.

However, a large portion of online stores keep this percentage between 20 and 30%.

The formula: (Number of Customers who purchased before/Total Number of Customers) x100

How to Visualize Shopify Data in Databox

Databox offers a simple integration with Shopify so you can easily visualize your data and have all the necessary information at a glance.

To connect your Shopify store with your Databox account, open Data Sources in Databox and click on New connection. Enter Shopify in the search field and select the Connect button. Authorize Databox in the Activation window that pops up by typing in your shop’s URL (without the my.shopify.com part). If you have another shop, you need to connect it separately.

When you first connect Databox and Shopify, you will be able to see around 36 months of historical data, depending on the metric.

Popular metrics used in Databox dashboards for Shopify stores are:

  • Orders
  • Gross Sales
  • Abandoned Checkouts
  • Total Customers
  • Orders by New vs Returning Customers
  • Total Sales by New vs Returning Customers

…and more.

Here’s an example of a popular use case:

Reporting on Customer Lifetime Value

You need four Calculated Metrics in Databox to create this report: Purchase Frequency, Average Order value, Customer Value, and Customer Lifetime Value that practically build upon each other.

  1. First, create a Calculated Metric for Average Order Value.
  1. Then, calculate Purchase Frequency.
  1. Create a Customer Value Calculated Metric.
  1. Finally, create the Customer Lifetime Value Calculated Metric.

You can calculate the Customer Lifetime Value by multiplying Customer Value by Average Customer Lifespan. Shopify suggests three years for newer stores.

Free Shopify Dashboard Templates

With Databox, you gain access to free ecommerce dashboard templates so you don’t need to create them from scratch. Here are just some of the Shopify template we offer:

  1. Online Sales Overview Dashboard
  2. Shopify Store Overview Dashboard
  3. Shopify Conversion & Loyalty Analytics Dashboard

Online Sales Overview Dashboard

The Online Sales Overview dashboard unites Shopify, Facebook Ads, and Google Analytics and gives you a powerful overview of your online sales performance.

You can track metrics such as e-commerce conversion rate, amount spent (in Facebook Ads), abandoned checkouts, net sales, gross sales, and net quantity by top products.

Measuring these metrics can help you answer some important questions about your online store: what your top products are, how much an average user spends on your products, how your current results compare to your previous months’ performance, and more.

Shopify Store Overview Dashboard

The Shopify Store Overview dashboard allows you to get an at-a-glance overview of your online store’s performance.

It helps you quickly identify important answers: how many orders you receive daily or monthly, how much do you issue in discounts or refunds, how many repeating customers do you have, how well is your shopping cart set up, and more.

The metrics available in this dashboard are, for example, number of orders, net sales, discounts, unfulfilled orders, new customers, gross sales by top products, total customers.

Shopify Conversion & Loyalty Analytics Dashboard

The Shopify Conversion & Loyalty Analytics dashboard allows you to measure your success in converting first-time customers into loyal buyers.

It helps you evaluate your customer retention strategy and identify any weak points that you can improve.

Tracking metrics like average order value, e-commerce conversion rate, or transactions per user will help you find out how much you earned from repeat sales, what your conversion rate is, and average revenue per user, and more.

Track Your Shopify KPIs and Grow Your Online Store with Databox

Is your store profitable? Do you have an opportunity to grow? Are you building a loyal customer base?

You can only answer these questions if you regularly monitor your store metrics and KPIs. But that might be a challenge if your metrics are all over the place–data tracking becomes a time-consuming nightmare and you’re not sure what you’re looking at anymore.

shopify_sales_overview_dashboard_databox

That’s why Databox came up with a perfect solution.

By connecting your Shopify account with Databox, you gain instant access to over 4,000 metrics and over 70 integrations that allow you to track your success in a streamlined manner, all in one place.

And if you don’t want to use our free templates, you can build your own customized dashboard in just a few minutes.

Want to know more? Join over 20,000 businesses that already enjoy tracking their online store growth with Databox and sign up for a free trial today.

About the author
Stefana Zaric
Stefana Zaric Stefana Zarić is a freelance writer & content marketer. Other than writing for SaaS and fintech clients, she educates future writers who want to build a career in marketing. When not working, Stefana loves to read books, play with her kid, travel, and dance.
You may also like...
Read more

The Top 8 Dashboard Reporting Tools Chosen by Experienced Users

Looking for a dashboard reporting tool for your business? We consulted 78 expert users, and they had 8 top choices to share.

Reporting   |  Jun 24

Read more

Business Report: What is it & How to Write a Great One? (With Examples)

Why are business reports so important? Read our comprehensive, step-by-step guide on how to create an effective business report and get inspired by the examples we’ve shared.

Reporting   |  Jun 22

Read more

Salesforce Report Builder: A Step-By-Step Guide on How to Create Powerful Reports

Want to learn how to create captivating reports for your company? Read this guide on how to use Salesforce Report Builder.

Reporting   |  Jun 2