Coupons Standard Export Template

The coupons template is based on the fact - Coupons. The template

lets you export all the details of coupons issued at customer level and transaction level
lets you 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.

Measures

Measure Name	Description
Bill Id	Identifier key for the bill against which the coupons have been issued or redeemed
Redemption Bill Amount	Total transaction amount of the bill against which coupon has been redeemed
Issual Coupon Id	Unique Id assigned to the coupon which has been issued
Used Bill Number	Bill_number used while the redeeming the coupon
Auto Update Time Coupons	Date and time when the coupons table is recently updated (Unix timestamp)
Coupon Code Src	It is same as coupon code
Coupon Code	A unique id generated for the coupons
Event Id	A unique id generated for the coupon's event by capillary system

Dimensions

Dimension Name	Description
coupon_event_type	Captures the coupons event type (issual, redemption)
User	User identifier for which the coupon event has occurred
User Segments	The segment to which the user belongs
Date	Measures the date when the event has occurred
Time	Measures the time when the event has occurred
Store Hierarchy	Captures the store details where the coupon event has occurred
Concept Hierarchy	Captures the concept details where the coupon event has occurred
OU Hierarchy	Captures the OU details where the coupon event has occurred
coupon_series	Captures the Coupon Series against the coupon event.
expiry_date	Captures the date when the coupon will expire
issual_date	Captures the date when coupon has been issued
issual_time	Captures the time when coupon has been issued
issual_type	Captures the type of coupon issued
Issued to User	Captures the customer details to whom the coupon has been issued
campaign_group	Captures the campaign group for which the coupons related event has occurred
campaign	Captures the the campaigns for which the coupons related event has been done
Issual Zone Till	Captures the zone till where coupon has been issued
entry_type	Captures the entry type for the coupons event
latest_updated_date	The latest updated date when the coupons event occurred
latest_updated_time	The latest updated time when the coupons event occurred