Coupons
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.
Measure Name
| Measure | 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 in Coupons template
| 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 5 months ago