The Points Expiry Reminder template is based on the fact Points Expiry Reminder Info.

Lets you export the details of points expiry reminders sent to customers through Loyalty Engine. These are automated reminders configured for points expiry.

Measures

Measure
Description
points_expiringNumber of points that are going to expire. The duration depends on the the reminded before days set. For example, if you set Remind_before_days as 29, you will get points that will be expiring in 29 days
reminded_before_daysDays prior to expiry when the reminder has to be sent. For example, if you set Remind_before_days as 29, you will get points that will be expiring in 29 days
reminder_idUnique id associated to the points expiry reminder (in Reminder table)


Dimensions

auto_update_time_point_exp_reminder, communication_channel, event_date, event_time, event_user, expiry_date, expiry_time, latest_updated_date, latest_updated_time.