Expired Points Export
The Expired Points export is a premium feature, contact your Customer Success Manager (CSM) to enable or disable it for your program. If you do not have it enabled in your account, the report will be empty.
Retrieve a list of members whose points expired due to inactivity (no purchases for N months). The report includes members who met your brand’s expiration criteria for the selected month.
Filter options:
Month — Specify the month period for analysis.
Learn more about how to export data.
Data
Spendgo External ID — Member’s Spendgo external identifier.
Phone — Member’s unique account phone number.
Email — Member’s unique account email address.
First Name — Member’s first name.
Last Name — Member’s last name.
Loyalty Status — Member’s loyalty status. Options are:
“Starter” for members who have an entry-level account and have not yet completed their registration.
“Registered” for member who have a complete and verified account.
SMS Preference — Member’s SMS opt-in preference. Options are
“Opted In” for opted in to SMS.
“Opted Out” for opted out of SMS.
“Waiting for Double Opt In Confirmation” for a member who requested to opt-in and has not yet be confirmed their double opt-in to SMS.
“Not Yet Requested” for a member who have not requested to opt-in to SMS.
Email Preference — Member’s email op-in preference. Options are:
“True” for opted in to email.
“False” for opted out of email.
Spendgo Join UTC Datetime — The UTC join datetime to the Spendgo Network.
Brand Join UTC Datetime — The UTC join datetime to your brand’s program.
Store ID — The store location associated with the event. In the “Expired Points” event, this is the member’s favorite store ID.
Store Name — The store location associated with the event. In the “Expired Points” event, this is the member’s favorite store name.
Event Type — The event type, “Expired Points”.
Event ID — An optional ID associated with the event. In the “Expired Points” event, there is no associated event ID, this value will be blank.
Event Local Datetime — The local datetime of the event based on the associated store.
Event UTC Datetime — The UTC datetime of the event.
Event Total — The number of expired points.
Example Export
Spendgo External ID | Phone | First Name | Last Name | Loyalty Status | SMS Preference | Email Preference | Spendgo Join UTC Datetime | Brand Join UTC Datetime | Store ID | Store Name | Event Type | Event ID | Event Local Datetime | Event UTC Datetime | Event Total | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 14155555555 | example@email.com | John | Doe | Registered | Opted In | True | 2025-01-01T00:00:00Z | 2025-01-01T00:00:00Z | 1111 | San Francisco | Points Expired | 2025-01-01T07:00:00Z | 2025-01-01T00:00:00Z | 10 |