Version: 3.0 - effective from: 15/01/26
Export sample data files can be found here: Airtable, Google Sheet
More info about our Export specs can be found here.
Column | Column Name | Type | Column Description | Notes |
A | Fundraiser ID | Number | Unique Social Sync fundraiser ID |
|
B | Created On | Datetime | Date time fundraiser was created. ISO format: YYYY-MM-DD HH:MM |
|
C | Type | Single select | Fundraiser Type, e.g. | types need some thought inline with organics+reg types |
D | Status | Single select | Fundraiser status: |
|
E | Platform | Single select | Fundraiser platform: |
|
F | Platform Fundraiser ID | Short text | Unique source platform fundraiser ID, e.g. Facebook's " |
|
G | Fundraiser Title | Long text | Title of fundraiser page |
|
H | Fundraiser Description | Long text | Description on fundraiser page |
|
I | Fundraiser Reference | Long text | Secondary text area used by several platforms to store qualitative data |
|
J | Ends At | Date | Date time fundraiser is set to end. ISO format: YYYY-MM-DD HH:MM |
|
| Fundraiser URL | URL | URL to fundraiser page |
|
| Target | Number | Fundraiser target |
|
| Donations | Number | Count of all transactions |
|
| Amount Raised | Number | Sum of all transactions |
|
| Gift Aidable Donations | Number | Count of Gift Aid donations |
|
S | Gift Aid Raised | Number | Sum of all Gift Aid (assuming 100% claim success rate) |
|
| Pledged income? |
| can be stored against which FRs? |
|
T | Grand Total | Number | Sum of all transactions and all Gift Aid |
|
U | Registration ID | Number | Unique Social Sync registration ID |
|
| Supporter ID | Number | Unique Social Sync supporter ID |
|
| External ID | Number | External system supporter ID (requires data import) |
|
AH | Title | Single select | Supporter title |
|
AI | First Name | Short text | Supporter first name |
|
AJ | Last Name | Short text | Supporter last name |
|
AK | Supporter email |
| ||
AL | Phone | Number | Supporter phone number |
|
AM | Meta Full Name | Short text | Supporter Meta full name |
|
AN | Meta Email | Supporter Meta email |
| |
AO | Address Line 1 | Short text | Primary address line 1 |
|
AP | Address Line 2 | Short text | Primary address line 2 |
|
AQ | City | Short text | Primary address city |
|
AR | County | Short text | Primary address county |
|
AS | Post Code | Short text | Primary address post code |
|
AT | Country | Short text | Primary address country |
|
AU | Campaign Tags | Long text | Comma separated list of all the supporter’s campaign specific tags |
|
AV | Supporter Tags | Long text | Comma separated list of all the supporter's supporter tags |
|
AW | Email Consent | Boolean | Marketing consent status |
|
AX | Email Statement | Long text | Statement associated with consent status |
|
AY | Email Consent Date Time | Date | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM |
|
AZ | SMS Consent | Boolean | Marketing consent status |
|
BA | SMS Statement | Long text | Statement associated with consent status |
|
BB | SMS Consent Date Time | Date | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM |
|
BC | Whatsapp Consent | Boolean | Marketing consent status |
|
BD | Whatsapp Statement | Long text | Statement associated with consent status |
|
BE | Whatsapp Consent Date Time | Date | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM |
|
BF | Phone Consent | Boolean | Marketing consent status |
|
BG | Phone Statement | Long text | Statement associated with consent status |
|
BH | Phone Consent Date Time | Date | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM |
|
BI | Post Consent | Boolean | Marketing consent status |
|
BJ | Post Statement | Long text | Statement associated with consent status |
|
BK | Post Consent Date Time | Date | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM |
|
| Event ID | Number | Unique Social Sync Event ID |
|
| Event Type | Single select | Social Sync event type |
|
| Event Title | Long text | Editable event title |
|
| Event Code | Short text | Editable internal code |
|
| Event Details | Long text | The description used for supporter created events |
|
| Event Start Date | Date | Date event starts. Format: YYYY-MM-DD |
|
| Event End Date | Date | Date event ends. Format: YYYY-MM-DD |
|
| External Event ID | Short text | The ID of an external event which is to be mapped to this campaign - e.g. JustGiving event ID |
|
| Campaign ID | Number | Unique Social Sync Campaign ID |
|
| Campaign Type | Single select | Social Sync campaign type |
|
| Campaign Title | Long text | Editable campaign title |
|
| Campaign Code | Short text | Editable internal code |
|
| Source ID | Number | Creation source ID, where source type = |
|
| Source Type | Single select | Creation source type; |
|
| Source Title | Long text | Creation Source title, where available |
|
| Last Modified | Date | Date/time the record was last modified. ISO format YYYY:MM:DD HH:MM |
|
| Last Modified By | Short text | Who the record was modified by |
|