Coupons Standard Export Template
The coupons template is based on the Coupons fact.
The template lets you export details of:
- Coupons issued at customer level and transaction level;
- Transaction numbers along with coupon details, redeemed and expired coupons, and coupon level custom fields.
Note
- While using the coupons template, you need to select custom fields manually.
- 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 | Identifier for the coupons event type, such as issuance or redemption. |
| User | Identifier of the user involved in the coupon event, set internally by Capillary. |
| User Segments | Segment details of the customers involved in the coupon event, such as valued customer or lapsed customer. |
| Date | Date attributes of the coupon issuance or redemption. |
| Time | Time attributes of the coupon issuance or redemption. |
| Store Hierarchy (zone till) | Identifier for the store, till id. |
| Concept Hierarchy | Identifier for the concept associated with the coupon event. |
| OU Hierarchy | Identifier for the organization unit where the coupon event occurred. |
| coupon_series | Coupon series against which the coupon has been issued or redeemed. |
| expiry_date | Date when the coupon is set to expire. |
| issual_date | Date when the coupon has been issued. |
| issual_time | Time when the coupon has been issued. |
| issual_type | Captures the issuance type, with possible values such as store or customer. |
| campaign_group | Identifier for the campaign group associated with the coupon issuance. |
| campaign | Identifier for the campaign under which the coupon is issued. |
| Issual Zone Till | Captures the store till where the coupon has been issued. |
| entry_type | Captures whether the coupon entry is manual or through Intouch. |
| latest_updated_date | Latest date when the data is updated. |
| latest_updated_time | Latest time when the data is updated. |
Updated 2 months ago