Skip to main content
Skip table of contents

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

Email

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.