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 NameDescription
Bill IdIdentifier key for the bill against which the coupons have been issued or redeemed
Redemption Bill AmountTotal transaction amount of the bill against which coupon has been redeemed
Issual Coupon IdUnique Id assigned to the coupon which has been issued
Used Bill NumberBill_number  used while the redeeming the coupon
Auto Update Time CouponsDate and time when the coupons table is recently updated (Unix timestamp)
Coupon Code SrcIt is same as coupon code
Coupon CodeA unique id generated for the coupons
Event IdA unique id generated for the coupon's event by capillary system

Dimensions

Dimension NameDescription
coupon_event_typeCaptures the coupons event type (issual, redemption)
UserUser identifier for which the coupon event has occurred
User SegmentsThe segment to which the user belongs
DateMeasures the date when the event has occurred
TimeMeasures the time when the event has occurred
Store HierarchyCaptures the store details where  the coupon event has occurred
Concept HierarchyCaptures the concept details where  the coupon event has occurred
OU HierarchyCaptures the OU details where  the coupon event has occurred
coupon_seriesCaptures the Coupon Series against the coupon event.
expiry_dateCaptures the date when the coupon will expire
issual_dateCaptures the date when coupon has been issued
issual_timeCaptures the time when coupon has been issued
issual_typeCaptures the type of coupon issued
Issued to UserCaptures the customer details to whom the coupon has been issued
campaign_groupCaptures the campaign group for which the coupons related event has occurred
campaignCaptures the the campaigns for which the coupons related event has been done
Issual Zone TillCaptures the zone till where coupon has been issued
entry_typeCaptures the entry type for the coupons event
latest_updated_dateThe latest updated date when the coupons event occurred
latest_updated_timeThe latest updated time when the  coupons event occurred