Are there coupon and discount exports?

 

There are many different exports you can use to understand the status or success of your coupon campaigns. All exports can be found on the Exports page under Reports.

 

Coupons

This export is essentially an inventory of your coupon campaigns. The export will show you all coupons that exist on your site, the rules for those coupons, and when they were created or expired.

See the details of this export in our Coupons export documentation.

 

Coupon Redemptions

This export will show you the success of your coupon campaign. The export will show you who has redeemed your coupons, when they redeemed it, and how much the redemption has discounted their account. Filter this report by your coupon and you can total the discount amount and build a chart that shows redemptions over time.

See the details of this export in our Coupon Redemptions export documentation.

 

Coupons - Bulk Unique Codes

This export will list a specific bulk coupon's unique codes, which you can import into your email system or other tools to distribute the codes to customers. This export can also be used to track the success of your bulk coupon campaign because it includes the same redemption information found in the Coupon Redemptions export.

See the details of this export in our Coupons - Bulk Unique Codes documentation.

 

Invoices - Summary

This export answers which coupons were applied to the invoice, noted in the coupon_code column.

  • The coupon_code column will show a comma separated list of coupon codes if the invoice had more than one coupon code applied.
  • The coupon codes are a unique list of coupons applied to the invoice. If the coupon had multiple redemptions applied to the invoice, you will see the coupon mentioned only once in this list.
  • Coupons used to calculate returned credits will show in this list.

See the details of this export in our Invoices - Summary export documentation.

 

Invoices - Line Items

This export answers which coupons were applied to the line item and the total discount they created on the line item.

  • The adjustment_discount column will show the total discount for the line item.
  • The adjustment_coupon_code column will show the coupons that created the discount on the line item. Free trial coupon redemptions expire immediately and therefore the adjustment_coupon_code will not be populated for free trial coupons.
  • You will see a comma separated list of coupon codes if the line item had more than one coupon code applied.
  • The coupon codes are a unique list of coupons applied to the line item. If the coupon had multiple redemptions applied to the line item, you will see the coupon mentioned only once in this list.
  • Coupons used to calculate returned credits will show in this list.

See the details of this export in our Invoices - Line Items export documentation.

 

Invoices - Line Items - Coupons

This export answers what the individual discounts were for each coupon applied to the line item. This export will only show if you have the Multiple Coupons Per Account feature enabled in your coupon Settings.

  • This export creates a row for each line item discount. A line item with multiple discounts applied will have multiple rows in the export.
  • The adjustment_discount column will show the portion of the line item discount created by the specific coupon in the adjustment_coupon_code column for that row.
  • The adjustment_coupon_code will only show one coupon code. If you see two rows for the same line item with the same coupon code, it means the coupon was redeemed more than once and more than one redemption discounted the line item. Free trial coupon redemptions expire immediately and therefore the adjustment_coupon_code will not be populated for free trial coupons.
  • Line items for credits will also show any coupons and discounts applied to calculate the correct credits to return.
  • Note that the “adjustment_origin” field is populated with “plan” (not “plan_trial”) if the subscription is discounted with a free trial coupon but the plan doesn’t have a free trial by default.

See the details of this export in our Invoices - Line Items Coupons export documentation.