Expired Points Export

Discover the purpose and included data within the 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, 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:

• Date Range — Select a date range of up to 31 days for analysis.

Data

• Olo Loyalty External ID — Member’s Olo Loyalty 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 Olo Loyalty Directory.
• 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.