Need more freedom with data transformation and automation? Check out Mipler Data Workflow!

Shopify Sales by Discount Code Report

Track the efficacy of promo campaigns in your store.

Why Shopify Sales by Discount report is important

shopify sales by discount

Shopify reports coupon data in a clear and organized manner, providing valuable insights into your e-commerce store's success, so you can track the efficiency of the promotional efforts you launch.

This can be done by tracking the usage of Shopify Sales and discount codes your store issues for each promo campaign.

With the help of the Advanced Reports app, you can extend the reporting functionality of the Shopify plan or higher to any plan and generate a sales by Shopify discount code report. This summary on purchases shows the breakdown of revenue and expenses for products per each promo code.

Use the functionality of this Shopify reporting app to compare the costs and revenue across different marketing campaigns launched in your store to better understand which one brings the most profits.

Additionally, use the presented summary to get information on the changes in key sales indicators. Easily contrast current data with earlier time periods.

The default configuration of this report offers general sales data split by the discount code that was utilized for each order. You will get figures on the number of transactions, gross, returns, discounts, net quantity, and totals for each discount code.

Enhance the clarity of the summary output by applying filters, which help to make the data more representative according to your needs. For example, you can add customer type (new or recurring one), shipping method, fulfillment, and financial statuses for orders. Such information can be used when making decisions for future inventory planning and marketing purposes.

What questions summary on sales by discount code can answer

Get a detailed sales breakdown based on the promo codes customers have used for making purchases in your store. This type of summary aggregates information on each coupon that was used within the specific date range chosen for the report generation.

Using the summary on discount codes, the executive managers of the store can receive several benefits. For example, using reporting apps they can obtain a high-level overview of sales made with coupons.

Discover Shopify data with well-tailored reports.

The document also gives detailed information on each coupon used within the selected time range. The sales data includes key metrics for further analysis, which can be used to answer such questions as:

  • what is the number of transactions made with a specific coupon within the specified time period
  • how to see the sum of gross sales that were obtained for each discount code
  • what are the key sales indicators (total, gross, net sales) for each promotional coupon within the given time range
  • how many refunds does each discount coupon have
  • what coupons are mostly used by first-time customers
  • what sums of taxes and shipping fees are referred to each discount code

Expand this list of answers by extending the report with the help of additional data columns and data filters.

Key sales indicators in a discount report Shopify

Using this summary, get an accurate look at the popularity of discount coupons in a store and determine how each of the issued codes performs.

Furthermore, the store managers can get additional insights by adding more data or filters to the report. Expand the summary with additional columns to get a detailed view.

For example, track what types of customers use the discount codes and what is the customer lifetime value for each coupon.

shopify sales by discount

Track the number of transactions, gross and net sales, items quantity within the chosen time period. Sales overview output for each sales day displays such data as:

  • Number of orders
  • Gross, Net sales
  • Taxes
  • Discounts
  • Refunds

Use these columns to glance at the current sales situation for each discount code used in your store within the range of selected dates.

Reports similar to Sales by Discount Code

A summary on sales with discount codes is an easy-to-view approach for getting the current status of each promo campaign launched in the store. However, the focus on sales data can be changed to another scope.

shopify sales by discount

The reporting apps allows switching time periods and comparing data between selected time ranges. Furthermore, the report on sales can be generated on other factors that can be extracted from the store database.

In conjunction with the variant sales, a store manager can often use such summaries as:

  • Sales by Payment Method. Know which payment gateways are most widely used by your shoppers for making purchases. Use this data to enhance the shopping experience for customers.
  • Sales by Channel. See what channels bring sales to your store. Get information on whether it is an offline POS or online store.
  • Average Order Value Over Time. It shows how the average check has changed over a certain time period, for example, a month.
  • Sales by POS location. Find which locations with your store’s POS bring you the most profits.
  • Sales by Order tags. Analyze sales on meta information of orders – their tags. It is another way to focus on sales.

Key columns for sales by discount code

Typically, the table with the data on Shopify sale and discount codes consists of such columns as:

shopify sales by discount
  • ORDERS Discount Code
  • ORDERS Number of orders
  • ORDER ITEMS Gross Sales
  • ORDER ITEMS Discounts
  • REFUND ITEMS Returns
  • ORDER ITEMS Net Sales
  • ORDERS Shipping
  • ORDER ITEMS Total Sales

An executive manager responsible for analytics in the store is totally free to exclude any of the existing columns from the default configuration or add several additional ones. Simply choose available columns from the list.

Here is how some of the key columns in the default report are calculated:

  • ORDER ITEMS Net Sales. The net sales column of the default report is calculated through gross sales, discounts, and refunds of purchased products.

    [ORDER ITEMS Net Sales] = [ORDER ITEMS Gross Sales] - [ORDERS Discounts] – [REFUNDS Returns]
  • ORDERS Shipping. The shipping fees are obtained from the total shipping price and amount of purchased products.

    [ORDERS Shipping] = [ORDERS Shipping amount] - [ORDER ADJUSTMENTS Total Shipping Amount]
  • ORDER ITEMS Total Sales. Get the sum of total sales calculated as:

    [ORDERS Total Sales] = [ORDERS Net Sales] + [ORDERS Shipping] + [ORDERS Tax]

How to run a report on Discount Codes Shopify

Run report on discount code Shopify is a straightforward process that provides essential clarity into the effectiveness of your promotions. To access valuable insights about your discount codes in Shopify, you'll need to follow a few simple steps within your Shopify admin dashboard:

  • Log In to Your Shopify Admin Dashboard
  • Access the 'Analytics' Tab
  • Select 'Reports'
  • Choose 'Discount Codes' as Your Report Type

Variations of Sales by Discount Code Shopify Reports

You can get another view on purchases besides viewing the default discount sales data. Using variations of the basic report, a store manager is able to obtain a clearer insight into the business performance of the online business.

Comparing a specific date range to a previous period can be named one of the easiest ways to glance at the business's success.

Use filters and sorting options this app provides to expand the reporting abilities and get answers to some other questions regarding sales. Here are a few examples of the basic report variations.

How to see discount sales by location

shopify sales by discount

You can easily see the purchase data for each discount coupon with data on the geographical distribution of customers and the number of transactions.

See what provinces, cities, and countries you have the most or least purchases.

How to see customer’s lifetime value

shopify sales by discount

It is well known that existing customers cost less than attracting new ones for a store. Depending on the purchases each customer makes, they set their individual value for a store.

You can easily see the customer lifetime value with the CUSTOMERS CLV data column. Use it to monitor for signs of shoppers' attrition in your store.

Make the purchase picture clear by adding a column with the number of total transactions for each discount code.

How to see gross margin in percent

Gross margin is one of the parameters for the business performance, which shows how much financial funds the store retains. The higher this indicator is, the more capital is available to pay for other costs.

See the gross margin in percent by activating a corresponding column.

[ORDERS Gross Margin, %] = ([ORDERS Net Sales] - [ORDERS COGS]) ÷ [ORDERS Net Sales] × 100

The result is rounded to two numbers after the comma sign. If the calculation result is negative, the report shows zero value in the table.

How to see the total cost of purchased products

The total cost of ordered products in the order is calculated as:


How to see what type of customer made the order

shopify sales by discount

A store can have both new and recurring customers, the latter being preferable. Merchants can easily see what types of customers buy in their stores within the ORDERS Customer Type column.

In case the date of the customer’s first order is equal to the order processing date, then the customer is considered a first-time buyer. Otherwise, they are assigned to a Returning type. If the report cannot detect the customer ID, it will display the Unknown value.

How to get total sales for orders

Get the sum of total sales calculated as:

[ORDERS Total Sales] = [ORDERS Net Sales] + [ORDERS Shipping] + [ORDERS Tax]

The ORDERS Net Sales are obtained as:

[ORDERS Net Sales] = [ORDERS Gross Amount] - [ORDERS Discounts] - [REFUNDS Returns]

The ORDERS Shipping is obtained as:

[ORDERS Shipping] = [ORDERS Shipping amount] - [ORDER ADJUSTMENTS Total Shipping Amount]

The ORDERS Shipping is obtained as:

[ORDERS Tax] = [ORDERS Taxes] – [REFUND ITEMS Total Tax Amount]
Wanna talk?
Let’s book a call!

We want to provide value for all our customers. Start with a call to discover how we can help your business.

© 2024 Mipler. All rights reserved.
Choose a Platform