What data is in the Coupons - Bulk Unique Codes export?

The Coupons - Bulk Unique Codes export allows you to export all unique codes for a specific bulk coupon and see redemption information about each code. This export will only appear on the Exports page if you have created a bulk coupon on your site. Learn more about Bulk Unique Coupons.

 

Filters

Select the bulk coupon you want to export unique codes from the dropdown. The dropdown displays the internal name of the coupon, followed by the prefix of the codes in parentheses. The dropdown list is sorted by internal name in alphabetical order.

 

Time Range Filter

 

CREATED

Sets the date range to the date the unique code was created, which is the 'created_at' column in the export. Use "All Time" with Created to see the full list of your unique codes. If you added more codes to the bulk coupon throughout the campaign you can filter the dates down to the period in which you created a subset of codes.

 

MODIFIED

Sets the date range to the last date the unique code was modified, which is the 'modified_at' column in the export. A unique code is modified when it is redeemed (applied_at) or expired early (deactivated_at). expired_at is not a modifying event.

 

Export Contents

 

Column Name Example Description
bulk_coupon_id 769158967603640335 uuid of the bulk coupon campaign, which is the id in the Coupons export.
bulk_coupon_prefix save The prefix of all unique codes, which is the coupon_code of the bulk coupon in the Coupons export.
unique_coupon_code save-012478 Unique code for the bulk coupon. This value will be the coupon_code in the Coupon Redemptions export, reflecting what the customer entered at redemption.
discount 5 The fixed amount discount rule for the coupon. This value will only show after the unique code has been redeemed and the currency column will reflect the currency of the amount. This value will remain 0 if the coupon was a percentage discount coupon. If you see a 0 in the discount_percent column, you know the coupon discount is a fixed amount discount.
discount_percent 5 The percentage discount rule for the coupon. This value will always show, even if the unique code has not been redeemed. This value will be 0 if the coupon was a fixed amount discount coupon.
timeframe forever The duration of the coupon.
redeem_by_date 2015-10-10 11:59:59 PST The date and time the unique code will expire and can no longer be redeemed. Time is always 11:59:59 end of day pacific time.
created_at 2015-09-07 19:23:03 PST The date and time the unique code was created.
modified_at 2015-09-07 19:23:03 PST  The date and time the unique code was redeemed (applied_at) or expired early (deactivated_at).
deactivated_at 015-09-07 19:23:03 PST
 

The date and time the unique code was expired early, if applicable.

 
applied_at 2013-01-02 06:21:14 PST The date and time the unique code was redeemed on an account.
expires_at 2014-01-02 06:21:14 PST The date and time the unique code naturally expires on the account after its duration length.
redemption_uuid 306f7937d86f088f046dd945a1a24df2 The unique id for the unique code's redemption.
account_code 306f7937d86f088f046dd945a1a24df2 The unique id for the unique code's redemption.
subscription_id 306f7937d86f088f046dd945a1a24df2 The uuid of the subscription tied to the unique code redemption on a customer's account. This value will only exist if the coupon was subscription-level and the unique codes has been redeemed.
total_discount 100.50 The total amount discounted on the account to date from the unique code redemption.
currency USD The currency of the total_discount and discount column.
discount_type percent, fixed_amount, free_trial Whether the coupon is a percent off, amount off, or custom trial
free_trial_coupon_amount 14 If the discount_type is "free_trial", the number associated with the unit period (e.g. - 14 days would have "14" here)
free_trial_coupon_unit day,week,month If the discount_type is "free_trial", the period associated with the amount (e.g. - 14 days would have "day" here)