Product Updates
Getting Started
- Overview
- Chargebee Billing Data Centers
- Object Relationship Model
- Chargebee Tech Glossary
- Articles and FAQ
Implementing Chargebee
AI in Chargebee
Developer Resources
Product Catalog
Subscriptions
Customers
Entitlements
Usage Based Billing
Chargebee CPQ
Invoices, Credit Notes, and Quotes
Taxes
Hosted Capabilities
- Overview
- Payment Components
- Managing Payments with Chargebee.js
- Mobile-Optimized Hosted Pages
- Articles and FAQ
Site Configuration
- Mandatory Fields
- File Attachments & Comments
- Advanced Filter Options
- Multi-decimal Support
- Configuring Reason Codes
- API Keys
- Time Zone
- Time Machine
- Transfer Configurations
- Articles and FAQ
Multi Business Entity
Mobile Subscriptions
Reports and Analytics
Integrations
Data Privacy & Security
- Two Factor Authentication
- SAML Single Sign-On
- System for Cross-Domain Identity Management (SCIM)
- EU-GDPR
- Consent Management
- Personal Data Management
- Compliance Certificates
- HIPAA Guidelines
- PCI Recommendations and Integration Types
- Articles and FAQ
Data Operations
How to find out list of coupon codes redeemed by the customer?
Problem Statement
You want to find the list of coupon codes redeemed by customers or export subscriptions with a specific coupon applied.
Related Scenarios
- Export coupons applied to subscriptions report
- Where can I see the info of the customers who have subscribed using a certain coupon?
- How to filter subscriptions with the specific coupon?
- Is there any way to export subscriptions with coupons?
- To get a list of Subscriptions which has a specific coupon applied to them using Filters
- We have a coupon (abcd) that had 2 redemptions, however, I am not able to find the list of Subscriptions associated with it
Solution
You can view and download the subscription with a specific coupon report using the Advanced filter option. You can also download the report from Settings > Import & Export Data > Export Data > Subscriptions.
Note
Currently, there is no direct mapping between the customer and coupon ID, but you can find the coupon redemptions from the SubscriptionCoupons.csv file (export the Export Subscription CSV) which provides the number of redemptions of coupon IDs against subscription IDs.
Download reports from Subscription Index Page
Step 1: Navigate from Subscription Index Page > Filter list > Subscription > Coupons > Contains only. Then you can 'Save filter' for future reference.
Note
On the recent UI enhancement you can now scroll the index pages - Customers, Subscriptions, Invoices, and Credit Notes vertically. Earlier, the pages will be paginated which may prolong your search; however with the new enhancement, as you scroll down the list it will load all other data in a single page as highlighted below on the screenshot. Refer to this link for more information.
Once you update the filter, you can download the report as a CSV file by clicking on Export.
Downloading reports from Export Data
Step 1: Navigate to Settings > Import & Export Data > Export Data > Subscription > Coupons > Contains only.
You can also export it as a CSV file from the 'Export' option.
A zip folder will be downloaded with 6 files and SubscriptionCoupons.csv file will have the required details as shown below.
This will have Subscription Id, Coupon Id, Coupon Code Id, No. of redemptions & Apply till. If you prefer to match this with the other Subscription details, you can refer to Subscriptions.csv file by performing a VLOOKUP formula using Subscription ID.
Was this article helpful?