How to export coupon information

You will learn

Learn how to export information about Klaviyo-generated and uploaded coupons, so that you can report on your coupons with the data directly from Klaviyo.

• For Klaviyo-generated coupons, you can determine which customer a code was sent to, coupon name, sent date, and more.
• For uploaded coupons, the export includes details about which codes are assigned versus unassigned.

Export Klaviyo-generated coupon (integration-specific) information

1. Navigate to Content > Coupons in Klaviyo's left-hand navigation.
2. Find your coupon and click the 3 dots next to it.
3. From the dropdown, select View History.
   
4. On the coupons history page, select which versions of the coupon definitions you'd like to export.
   

   Note that any coupon versions created before August 26, 2020 will show as “unknown,” as coupon information before this point was not logged.

   
5. Once you have selected the definitions, click Export at the bottom of the page.
6. From the Export Coupon Report modal that appears, select whether you want to export:
   • Active and expired codes (the default)
   • Active codes only
   • Expired codes only
7. Select Export Coupon Report.
   

The exported CSV file will show all of the coupon codes from your selected definitions. In addition, the following information will be shown for each code:

• Customer email
• Klaviyo profile ID
• Klaviyo coupon ID
• Coupon name
• Sent date
• Expiration date
• Code expiration status
• Code definition

Export uploaded coupon information

1. Navigate to Content > Coupons in Klaviyo's left-hand navigation.
2. Toggle to Uploaded Coupons.
   
   
3. Find your coupon and click the 3 dots next to it.
4. Click Export.
   
5. On the Export Code Report modal that appears, select whether you want to export:
   • Active and expired codes (the default)
   • Active codes only
   • Expired codes only
6. Choose whether you want to include:
   • Sent codes
   • Available codes
   • All codes
7. Click Export Coupon Report.
   

The resulting CSV file will show both unassigned and assigned codes, and will include the following columns: 

• Unique code
• Email
• Klaviyo profile ID
• Klaviyo coupon ID
• Current coupon name
• Assigned date
• Expiration date
• Code status
• Coupon definition
• Definition start
• Definition end

Additional resources

• How to export a list or segment to a CSV File
• How to export all people in your account
• How to edit coupons in Klaviyo