Overview
You can report on your coupons by exporting the data directly from Klaviyo. It’s possible to export information about both Klaviyo-generated and uploaded coupons. For Klaviyo coupons, you can determine which customer a code was sent to, coupon name, sent date, and more. The export for uploaded coupons includes details about which codes are assigned versus unassigned.
In this article, we will explain how to export both types of coupons and what information is included.
Klaviyo-Generated Coupons (Integration-Specific)
Navigate to the Coupons tab, find the coupon you want, then click View History from the Actions dropdown. On the coupon history page, select which versions of the coupon definitions you’d like to export. Any coupon versions created before August 26, 2020 will show as “unknown,” as coupon information before this point was not logged.
When you finish selecting the definitions, click Export in the upper right corner. The Export Coupon Report modal will appear. There, select whether you want to export:
- Active and expired codes (the default)
- Active codes only
- Expired codes only
Next, click the Export Coupon Report button.
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
Uploaded Coupons
In the Coupons tab, head to Uploaded Coupons. On the right-hand side, click the Actions dropdown menu for one of the coupons and select Export.
When you do so, the Export Code Report modal will appear. There, choose what you want to export:
- Active and expired codes (the default)
- Active codes only
- Expired codes only
Further, choose whether you want to include codes that were sent, are still available, or both. Click Export.
The resulting CSV file will show both unassigned and assigned codes and include the following columns:
- Unique code
- Klaviyo profile ID
- Klaviyo coupon ID
- Current coupon name
- Assigned date
- Expiration date
- Code status
- Coupon definition
- Definition start
- Definition end
Additional Resources
- Learn more about exporting data from Klaviyo:
- Find out how to Edit Coupons in Klaviyo