The Coupons report aggregates data from each coupon that is used during a specific date range. Because coupons are applied from the shopping cartA grouping of products that the customer wishes to purchase at the end of their shopping session., the report includes data from all redeemed coupons, regardless of order status. As a result, the report might include both projected and actual totals. The report can be filtered for a specific store view, time period, order status, and cart price rule.
In the following example, the coupon code “H20” was used by two customers. One of the orders is invoiced, but the other is still “pending.” The projected Sales Subtotal, Sales Discount, and Sales Total columns show the aggregated amounts from both orders, but only the actual invoiced order appears in the Subtotal, Discount, and Total columns. Each row in the report represents a single coupon promotion.
To run the report:
|1.||On the Admin sidebar, tap Reports. Then under Sales choose Coupons.|
|2.||If you have multiple store views, set Store View in the upper-left corner to establish the scope of the report.|
|3.||To refresh the sales statistics for the day, click the “Last updated” message at the top of the workspace. Then, mark the Coupons checkbox, and tap Refresh.|
|4.||To filter the data, do the following:|
|a.||Set Date Used to one of the following:|
- Order Created
- Order Updated
The Order Updated report is created in real-time, and does not require a refresh.
|b.||To define the period of time covered by the report, set Period to one of the following:|
|c.||Enter the From and To dates in M/D/YY format to define the date range of the report.|
|d.||To print a report for a specific order status, set Order Status to “Specified,” Then, choose the order status from the list.|
|e.||Set omit rows without data from the report, set Empty Rows to “No.”|
|f.||Do one of the following:|
- To include all coupon activity from all price rules, set Cart Price Rule to “Any.”
- To include only activity that is related to a specific price rule, set Cart Price Rule to “Specified,” Then, select the specific cart price rule in the list.
|5.||When ready to run the report, tap Show Report. The report appears at the bottom of the page.|
Identifies the date field that is used as the basis of the report. Options:
Generates the report based on the date the order was placed by the customer.
To ensure that the most current data is included, click the link in the message to refresh statistics.
Generates the report based on the date orders were last updated.
This report uses real-time data, and does not require statistics to be refreshed.
Determines the type of date range that is used for the report.
Options: Day / Month / Year
Indicates the first date in the range of order data that is included in the report.
Indicates the last date in the range of order data that is included in the report.
Filters the report by order status. The report can be generated for all orders, or limited to a specific order status. Options:
Includes all orders regardless of status.
Includes only orders with the specified status. Canceled orders are not included in the report.
Determines if the report includes any rows of empty data that might be retrieved. Options: Yes / No
Cart Price Rules
Determines which coupon promotions are included in the report. Options:
Includes order information from any coupon promotion that was used during the specified date range.
Includes only order information from the specified coupon promotion during the specified date range.
Report Column Descriptions
Indicates the date range of coupon usage to be included in the report. The interval can be a specific day, month, or year, or range of dates. The interval date is formatted as follows, according to the Period setting:
The Discount Code that is entered by customers in the shopping cart to receive the discount.
The name of the price rule that is associated with the coupon.
The number of times the coupon has been used during the date range specified for the report.
The projected Subtotal from all orders that were placed with the coupon.
The Sales Subtotal represents the aggregated Subtotal from all qualifying orders, and includes “pending” sales orders that are not yet invoiced.
The projected Discount amount from all orders that were placed with the coupon.
The Discount represents the aggregated discount amount from all qualifying orders, and includes “pending” sales orders that are not yet invoiced.
The projected Grand Total from all orders that were placed with the coupon. The Sales Total includes any shipping and handling fees, less the discount amount.
The Sales Total represents the aggregated Grand Total amount from all qualifying orders, and includes “pending” sales orders that are not yet invoiced. The value includes the Subtotal plus Shipping & Handling, less the Discount, plus Tax.
((Subtotal + Shipping & Handling) - Discount) + Tax
The aggregated Subtotal from all invoiced orders that used the coupon.
The aggregated Discount from all invoiced orders that used the coupon.
The aggregated Order Total from all invoiced orders that used the coupon.