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 |
Updated 25 days ago