Manually Uploaded Points and Offers Export
Filter options:
Date Range — Select a date range of 1-31 days 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 accou
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.
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 a Transaction event, this corresponds to the Transaction ID, which may also be referred to as the “Transaction Number”, “Order Number”, “Check Number”, or another identifier, depending on your point-of-sale system.
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 event total value.
Account Name — The Brand’s account name associated with the events (e.g., Bagel Joe’s).
Program — The Brand’s Program Name associated with the events (e.g., Bagel Joe Rewards).
Reason — The reason selected for manually adding points or offers to the member’s account. This value is determined based on the value selected when the points or offers were added to the member’s account via the Spendgo Dashboard Add Points Offers or Add Rewards Over Spendgo API.
Modified By User — The user’s name who requested the modification.
Example Export
spendgo external id | phone | first name | last name | loyalty status | spendgo join utc datetime | brand join utc datetime | event type | event id | event local datetime | event utc datetime | event total | account name | program | reason | modified by user | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 14155555555 | example@email.com | John | Doe | Registered | 2025-01-01T00:00:00Z | 2025-01-01T00:00:00Z | Points Added | 2025-01-01T07:00:00Z | 2025-01-01T00:00:00Z | 10 | Bagel Joe’s | Bagel Joe Rewards | Test | Jane Doe | |
1 | 14155555555 | example@email.com | John | Doe | Registered | 2025-01-01T00:00:00Z | 2025-01-01T00:00:00Z | Offer Added | 2025-01-01T07:00:00Z | 2025-01-01T00:00:00Z | 1 | Bagel Joe’s | Bagel Joe Rewards | Test | Jane Doe |