Export sample data files can be found here: Airtable, Google Sheet
Version: 2.0 - effective from: 02/10/23
The Exports version change log can be found here.
More info about our Export specs can be found here.
Column | Column Name | Column Description | Type | Data Sample |
A | Fundraiser ID | Unique Social Sync registration ID | Number | 12345 |
B | Platform Fundraiser ID | Unique platform fundraiser ID | Short text | 3.14036E+15 |
C | Platform | Fundraiser platform: Social Sync, Facebook, Instagram, JustGiving | Single select | |
D | Fundraiser Type | Fundraiser Type, e.g. API created fundraiser, Birthday fundraiser, etc | Single select | API created fundraiser |
E | Source ID | Creation source ID, where source type=”form” | Number | 119 |
F | Source Type | Creation source type. e.g. Form | API | Manual | Transaction import | Single select | Form |
G | Source Title | Creation Source title, where source type=”form” | Long text | Standard registration form |
H | Fundraiser Title | Title of fundraiser page | Long text | Help me Swim 50km in January for a good cause. |
I | Fundraiser Description | Description on fundraiser page | Long text | Id quidem aut vero rem sint cumque occaecati. |
J | Fundraiser Reference | Secondary text area used by several platforms to store qualitative data | Long text |
|
K | Created On | Date time fundraiser was created. ISO format: YYYY-MM-DD HH:MM | Date | 07/12/2022 07:13 |
L | Ends At | Date time fundraiser is set to end. ISO format: YYYY-MM-DD HH:MM | Date | 07/12/2023 07:13 |
M | Fundraiser Status | Fundraiser status: Active, Ended, Closed. | Single select | Active |
N | Fundraiser Link | URL to fundraiser page | URL | |
O | Target | Fundraiser target | Number | 150 |
P | Donations | Count of all transactions | Number | 3 |
Q | Amount Raised | Sum of all transactions | Number | 50 |
R | Gift Aidable Donations | Count of Gift Aid donations | Number | 1 |
S | Gift Aid Raised | Sum of all Gift Aid | Number | 10 |
T | Grand Total | Sum of all transactions and all Gift Aid | Number | 60 |
U | Registration ID | Unique Social Sync registration ID | Number | 42651 |
V | Event ID | Unique Social Sync Event ID | Number | 145 |
W | Event Type | Social Sync event type | Single select | Facebook challenge |
X | Event Title | Editable event title | Long text | Cycle 50 Miles in March |
Y | Event Code | Editable internal code 2 | Short text | CY50-MAR |
Z | External Event ID | The ID of an external event which is to be mapped to this campaign - e.g. JustGiving event ID | Short text | JG43671 |
AA | Campaign ID | Unique Social Sync Campaign ID | Number | 521 |
AB | Campaign Type | Social Sync campaign type | Single select | Fundraising |
AC | Campaign Title | Editable campaign title | Long text | Cycle 50 Miles |
AD | Campaign Code | Editable internal code 1 | Short text | CY50 |
AE | Supporter ID | Unique Social Sync supporter ID | Number | 12345 |
AF | External ID | External system supporter ID (requires data import) | Number | 652143 |
AG | Supporter Type | The supporter record type: Matched, Incognito, Anonymised | Single select | Matched |
AH | Title | Supporter title | Single select | Mr |
AI | First Name | Supporter first name | Short text | John |
AJ | Last Name | Supporter last name | Short text | Smith |
AK | Supporter email | |||
AL | Phone | Supporter phone number | Number | 07755 137572 |
AM | Meta Full Name | Supporter Meta full name | Short text | John Smith |
AN | Meta Email | Supporter Meta email | ||
AO | Address Line 1 | Primary address line 1 | Short text | 97 James Harbour Suite |
AP | Address Line 2 | Primary address line 2 | Short text | Promenade Street |
AQ | City | Primary address city | Short text | Blackpool |
AR | County | Primary address county | Short text | Lancashire |
AS | Post Code | Primary address post code | Short text | LA29 5BP |
AT | Country | Primary address country | Short text | United Kingdom |
AU | Campaign Tags | Comma separated list of all the supporter’s campaign specific tags | Long text | self-donate, met target |
AV | Supporter Tags | Comma separated list of all the supporter's supporter tags | Long text | VIP |
AW | Email Consent | Marketing consent status | Boolean | TRUE |
AX | Email Statement | Statement associated with consent status | Long text | I would like to be kept up to date via: |
AY | Email Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date | 04/06/2022 22:33 |
AZ | SMS Consent | Marketing consent status | Boolean | FALSE |
BA | SMS Statement | Statement associated with consent status | Long text |
|
BB | SMS Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date |
|
BC | Whatsapp Consent | Marketing consent status | Boolean | FALSE |
BD | Whatsapp Statement | Statement associated with consent status | Long text |
|
BE | Whatsapp Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date |
|
BF | Phone Consent | Marketing consent status | Boolean | FALSE |
BG | Phone Statement | Statement associated with consent status | Long text |
|
BH | Phone Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date |
|
BI | Post Consent | Marketing consent status | Boolean | FALSE |
BJ | Post Statement | Statement associated with consent status | Long text |
|
BK | Post Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date |
|
BL | Last Modified | Date/time the record was last modified. ISO format YYYY:MM:DD HH:MM | Date | 23/06/2022 12:37 |
BM | Last Modified By | Who the record was modified by | Short text | Barry Stevenson |