How do I track discount performance and usage in Shopify?

Tracking discount performance in Shopify helps you understand how your promotions affect sales, revenue, and profitability. Shopify provides built-in analytics and reports that show discount usage, total discount cost, and overall revenue impact.

1. Use the “Discounts by Order” Report (Primary Report)

This is the most detailed report for analyzing discount performance.

1. Go to Shopify Admin
2. Click Analytics > Reports
3. Select Discounts by order

What You Can Track

• Discount codes used at checkout
• Automatic discounts applied
• Line-item vs. order-level discounts
• Discount amount per order
• Order total and customer details
• Date-wise usage trends

You can filter by date range, search for a specific discount code, or export the report as CSV/Excel for deeper analysis.

2. Check the “Total Sales by Order” Report

This report shows how discounts impact your overall revenue.

• Gross Sales – Sales before discounts
• Discounts – Total discount value (shown as negative)
• Net Sales – Sales after discounts and returns
• Total Sales – Final revenue including tax and shipping

Compare gross sales and net sales to measure how much revenue was reduced due to discounts.

3. View Discount Usage from the Discounts Page

For a quick performance overview:

1. Go to Discounts in your Shopify admin
2. Check the Times used column

Clicking on a specific discount shows total uses, recent orders, status (Active/Scheduled/Expired), and campaign details.

4. (If Available) Use “Sales by Discount Codes” Report

Some Shopify plans include a dedicated report that groups performance by discount code.

You can search for it under Analytics > Reports using keywords like “discount” or browse the Sales category.

Metrics Typically Included

• Discount name and type
• Number of orders
• Total discount amount
• Total sales generated
• Automatic vs. code-based discount method

Key Discount Performance Metrics to Track

1. Usage Rate

Formula: Times Used ÷ Total Orders
Shows what percentage of orders used a discount.

2. Total Discount Cost

Total value of all discounts given during a selected period.

3. Revenue from Discounted Orders

Total sales generated from orders where a discount was applied.

4. Average Discount per Order

Formula: Total Discount Amount ÷ Number of Discounted Orders

5. Return on Investment (ROI)

Formula: (Revenue from Discounted Orders − Discount Cost) ÷ Discount Cost × 100

How to Export and Analyze Discount Data

1. Open Analytics > Reports > Discounts by order
2. Set your date range
3. Click Export
4. Download CSV or Excel file

You can use Excel or Google Sheets to create pivot tables and calculate:

• Total uses per discount code
• Total discount cost
• Total revenue generated
• Average order value (AOV)

Best Practices for Tracking Discount Performance

• Set clear goals before launching a discount (sales target, ROI target).
• Monitor active campaigns daily during major promotions.
• Review weekly and monthly performance trends.
• Compare automatic vs. code-based discounts.
• Track profitability, not just usage.

Summary

To track discount performance in Shopify:

• Use Discounts by order for detailed tracking.
• Use Total sales by order to measure revenue impact.
• Check the Discounts page for quick usage counts.
• Export reports to calculate ROI and profitability.

By combining these reports, you can accurately measure discount usage, revenue impact, and overall campaign effectiveness.