Using the Coupons by Date Range Report

Kathryn Hamilton
Kathryn Hamilton
  • Updated

Overview: What are we talking about?

The Coupons by Date Range Report is a great way to way to see how many coupons were used in a specified date range and view a breakdown between the various coupons including the user who applied it, the attached invoice, and the discounted amount. 


This article includes:

Helpful Hints: Before you begin.
  • The list of available coupons will only show coupons that have been applied to a completed invoice at least once. 
  • Not selecting a coupon will result in all applied coupons populating in the report. 
  • Not selecting a user will result in all users populating in the report. 
  • Multiple locations can be selected and reported together. 
  • Coupons applied to the entire cart will show for each line item they were applied to. 
  • After generating the report, you will have the Add to Campaign option to add the customers tied to the invoices to a marketing campaign
How to: Use the Coupons by Date Range report.

To run the report, go to Left-Navigation: Reports & More » Reports » Coupons By Date Range. 

  1. Select the date range that you'd like to view.

  2. Choose the coupon(s) that you would like to analyze from the list of coupons available.
  3. Choose specific user(s) to filter the report by which users applied the selected coupon(s) to invoices during the selected date range.
  4. Select which location(s) to analyze when generating the report. 

  5. Click the Export to Excel? checkbox to export the report results to excel when clicking Generate Report. 

  6. Click the Generate Report button.

How to: Read the Coupons by Date Range report.

The report is comprised of two charts that allow you to view coupon usage in different ways.

Coupon Totals

The first section of the result reports on the total amount discounted per coupon type during the selected date range.


Invoice Details

This section breaks down each invoice the coupon type was applied to during the selected date range. An invoice will display on this report for each line item a coupon is applied to on the invoice. This section can be organized by the column headers. 




Variable Description
Invoice This is the invoice ID the coupon is associated with. Clicking on this will redirect the page to the full invoice.
Date This is the invoice completion date.
Owner The name of the owner the invoice is tied to. Clicking on the name will redirect the page to the owner's profile. 
Coupon The name of the coupon applied
Item Description The name of the line item the coupon was applied to.
Discount Amount The total amount discount from the line item as a result of the coupon.
Sale Price

This is the total of the line item after the coupon has been applied.

User This is the staff user that applied the coupon to the line item at the time of checkout.


Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request



Please sign in to leave a comment.