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_expiring | Number 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_days | Days 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_id | Unique 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.