1. Product Catalog
  2. Coupon sets

Coupon sets

coupon_sets
copy
Click to Copy

A coupon set is a collection of coupon codes associated with a single coupon. Each code in the set can be redeemed by customers during checkout. Coupon sets are typically used to group codes under a common promotion or discount offer.

UPSERT KEY
id

Each row is uniquely identified by this column. Use it as the upsert key when applying incremental datasets to your warehouse.

Columns

No match found
id string, not null
Primary Key
A unique identifier for the coupon set.
coupon_id string, not null
Foreign Key coupons.id
The identifier of the coupon associated with this coupon set.
archived_count null
The number of coupon codes in the set that have been archived.
change_type string
The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly.
name string, not null
The name of the coupon set.
record_exported_at timestamp
The column represents the timestamp when the data was exported to the configured destination.
record_extracted_at timestamp
The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.
redeemed_count null
The number of coupon codes in the set that have been redeemed.
total_count null
The total number of coupon codes present in the coupon set.