The Points template is based on the fact Points

Lets you export the data of points related events such as points issual, and points deduction (redeemed, expired, and returned) including source details.  You will get only the detailed break up of deducted points but not the the summarized one.

The template will have the filters redeemable and not applicable (deducted), applied by default.

Note: Points that are redeemed will be tagged to a transaction only if both the transaction and points redemption occurs with in  the span of +/- 15 minutes.

Measures

MeasureDescription
allocated_pointsNumber of points allocated
auto_update_time_paDate and time when the Points Awarded table is recently updated (Unix timestamp)
auto_update_time_pabpDate and time when the Points Awarded Bill Promotion table is recently updated (Unix timestamp)
auto_update_time_pacpDate and time when the Points Awarded Customer Promotion table is recently updated (Unix timestamp)
auto_update_time_palDate and time when the Points Awarded Lineitem table is recently updated (Unix timestamp)
auto_update_time_palpDate and time when the Points Awarded Lineitem Promotion table is recently updated (Unix timestamp)
auto_update_time_pdDate and time when the Points Deductions table is recently updated (Unix timestamp)
awarded_ref_idThe reference id of the awarded points that were deducted
bill_idLoyalty log id or bill id for which the points are awarded or redeemed
bill_numberBill number for which the points are awarded or redeemed
deducted_pointsNumber of redeemed, returned or expired points
event_idUnique id of each event entry of the corresponding table


Dimensions

awarded_date, awarded_expiry_date, awarded_points_promotion, awarded_zone_till, category, deduction_type, event_date, event_time, event_user, event_zone_till, expiry_date, expiry_time, latest_updated_date, latest_updated_time, old_category, points_promotion, points_event_type, points_awarded_type


Note: Awarded date and expiry date will be deprecated. Instead you can use event_date and awarded_expiry_date respectively.