Skip to main content
Skip table of contents

Offer Events Export

This report provides a detailed view of a member’s offer activity within your brand’s loyalty program. It combines member profile information with offer event activity (Earned, Used, Added, Expired) to help analyze engagement, campaign performance, and program effectiveness at specific locations for a selected offer.

Use this report to:

  • Track member offer activity over a selected date range.

  • Analyze activity at specific store locations for a selected campaign or offer.

  • Understand which members are earning, using, or expiring offers at particular stores.

  • Gain insights into program performance and engagement for targeted campaigns.

Filter Options:

  • Date Range — Select a date range of 1 to 366 days for analysis.

  • Store Locations — Filter activity by one or more store locations.

  • Campaign — Select the campaign offer for analysis.


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 ID associated with the event; for Offer events, this is where the offer was used, otherwise it defaults to the member’s Favorite Store.

  • Store Name —The store name associated with the event; for Offer events, this is where the offer was used, otherwise it defaults to the member’s Favorite Store.

  • Event Type — The event type of Offer Earned, Offer Used, Offer Expired, Offer Added which met the filter criteria.

  • Event ID — An optional identifier associated with the event. For Offer events this is the Campaign ID.

  • Earned Local Datetime — The local datetime of the offer earned event based on the associated store.

  • Used Local Datetime — The local datetime of the offer used event based on the associated store.

  • Expired Local Datetime — The local datetime of the offer expired event based on the associated store.

  • Event Total — The event total value.

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

earned local datetime

used local datetime

expired local 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

Offer Earned

2222

2025-01-01T07:00:00Z

1

1

14155555555

example@email.com

John

Doe

Registered

Opted In

True

2025-01-01T00:00:00Z

2025-01-01T00:00:00Z

1111

San Francisco

Offer Used

3333

2025-01-02T07:00:00Z

2025-01-01T00:00:00Z

1

1

14155555555

example@email.com

John

Doe

Registered

Opted In

True

2025-01-01T00:00:00Z

2025-01-01T00:00:00Z

1111

San Francisco

Offer Expired

4444

2025-01-01T07:00:00Z

2025-01-31T07:00:00Z

1

1

14155555555

example@email.com

John

Doe

Registered

Opted In

True

2025-01-01T00:00:00Z

2025-01-01T00:00:00Z

1111

San Francisco

Offer Added

4

2025-01-01T07:00:00Z

1

JavaScript errors detected

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

If this problem persists, please contact our support.