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