The coupons template is based on the fact Coupons.
Lets you export all details coupons issued at customer level and transaction level, and also export the details of
- transaction numbers along with coupon details,
- redeemed and expired coupons, and
- coupon level custom fields. You need to select custom fields manually
Note: Coupons that are issued or redeemed will be tagged to a transaction only if both the transaction and coupon issual or redemption occurs within the span of - +/- 15 minutes.
|auto_update_time_coupons||Date and time (in Unix timestamp) when coupon details are updated|
|bill_id||Unique id generated for each transaction|
|coupon_code||Code used to redeem a coupon against transaction. A coupon code can be unique across customers or same for all customers which is configured through Offers Management|
|event_id||Unique id generated internally for an event|
|issual_coupon_id||Unique id generated internally for a coupon issual|
|redemption_bill_amount||Total transaction amount that involved coupons or points redemption|
|used_bill_number||External bill number used in coupon redemption|
|year||Year in YYYY format|
campaign_group, campaign, coupon_issual_type, coupon_series, entry_type, event_date, event_time, event_user, event_zone_till, expiry_date, issual_campaign_group, issual_date, issual_time, issual_type, issual_zone_till, issued_to_user, latest_updated_date, latest_updated_time, year, coupon_event_type,