Tracker Value Standard Export Template

The Tracker Value template is based on the fact Points.

Lets you export tracker values generated through the Loyalty Engine to update slabs and perform other activities. You will get bills by entry but not cummilative bills.

You can use this template to export:

tracker value at a bill or line-item level, and
all tracker bills of the specified duration irrespective of the slab

Limitations

You cannot export the current tracker value

To know more about trackers and configurations, see Trackers

Measures

Measure	Description
Allocated Points	Number of points allocated
Auto Update Time PA	Date and time when the Points Awarded table is recently updated (Unix timestamp)
Auto Update Time PABP	Date and time when the Points Awarded Bill Promotion table is recently updated (Unix timestamp)
Auto Update Time PACP	Date and time when the Points Awarded Customer Promotion table is recently updated (Unix timestamp)
Auto Update Time PAL	Date and time when the Points Awarded Lineitem table is recently updated (Unix timestamp)
Auto Update Time PALP	Date and time when the Points Awarded Lineitem Promotion table is recently updated (Unix timestamp)
Auto Update Time PD	Date and time when the Points Deductions table is recently updated (Unix timestamp)
Awarded Ref Id	The reference id of the source from where the points are awarded
Bill Id	Loyalty log id or bill id for which the points are awarded or redeemed
Bill Number	Bill number for which the points are awarded or redeemed
Event Id	Unique id of each event entry of the corresponding table
Deducted Points	Number of redeemed, returned or expired points

Dimensions

latest_updated_date, latest_updated_time, awarded_date, awarded_expiry_date,awarded_points_promotion, awarded_zone_till, category, deduction_type, Date, Time, User, User Segments,Store Hierarchy, Concept Hierarchy, expiry_date, expiry_time, points_awarded_type, points_event_type,points_promotion