ao link
Affino

Coupons Report Guide

Coupons Report
Coupons Report

Overview

 

Control > Commerce > Coupons Report

 

The Coupons Report lets you view the success of coupons by number of subscriptions and value.

 

It helps you analyse the effectiveness of coupon codes on sales, displaying the number of paid orders and net revenue for each coupon code. 

 

Results are displayed per month over a period of 3 months, 6 months and a year.

 

Orders must have an Order Status of Paid Full (this covers orders where Payment Status is Paid or Awaiting Payment Confirmation).

 

The report uses the Order Date to determine the month in which the coupon code was used, sorted alphabetically.

 

Filters

Use the following filters to fine tune your report:

  • Subscription Plans
  • Subscription Types
  • Product Lines
  • Catalogue Items
  • Coupons
  • Date Range - Past 3 Months, Past 6 Months, Past Year

You can export the data to a xlsx, csv or tsv file.

 

NOTE: For renewal orders, coupons are not carried over (therefore, they will not be included).

 

Columns

The following are the available columns on your report, together with its definition:

  • Coupon: The coupon code
  • Description: The coupons description
  • Currency: The coupons currency
  • Total Orders: The total amount of orders, over 12 months
  • Total Revenue: The total amount of revenue, over 12 months

The Coupns Report also supports multi-currency coupons.

 

For each coupon used on an order in multi-currency, a new row will be displayed for that currency.

 

 

 

Rules

  • Credit Cards have to be paid in full, Direct Debit can be either:
    •  Paid
    • Currently in their payment cycle
    • Or awaiting their first payment
  • For Credit Card orders the payment date is used
  • For Direct Debit orders the first collection date is used
  • Free subscriptions are not included in this report
  • This is based on live paid orders (does not include cancelled or refunded orders)
  • Revenue values are reported as Net, not Gross

Did you find this content useful?

Thank you for your input

Thank you for your feedback

Driving business at some of the world's most forward thinking companies

Our Chosen Charity

Humanity Direct