PLEASE NOTE: This page has been superseded by our current export specs available here. This page is a reference for historic export files only, prior to 29/09/23
An export sample file (Google Sheet) can be downloaded 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. Rerum tempora accusantium numquam aut illo cum. Earum quas nemo enim corrupti. |
J | Created On | Date time fundraiser was created. ISO format: YYYY-MM-DD HH:MM | Date | 07/12/2022 07:13 |
K | Ends At | Date time fundraiser is set to end. ISO format: YYYY-MM-DD HH:MM | Date | 07/12/2023 07:13 |
L | Fundraiser Status | Fundraiser status: Active, Ended, Closed. | Single select | Active |
M | Fundraiser Link | URL to fundraiser page | URL | |
N | Target | Fundraiser target | Number | 150 |
O | Donations | Count of all transactions | Number | 3 |
P | Amount Raised | Sum of all transactions | Number | 50 |
Q | Gift Aidable Donations | Count of Gift Aid donations | Number | 1 |
R | Gift Aid Raised | Sum of all Gift Aid | Number | 10 |
S | Grand Total | Sum of all transactions and all Gift Aid | Number | 60 |
T | Registration ID | Unique Social Sync registration ID | Number | 42651 |
U | Event ID | Unique Social Sync Event ID | Number | 145 |
V | Event Type | Social Sync event type | Single select | Facebook challenge |
W | Event Title | Editable event title | Long text | Cycle 50 Miles in March |
X | Event Code | Editable internal code 2 | Short text | CY50-MAR |
Y | Campaign ID | Unique Social Sync Campaign ID | Number | 521 |
Z | Campaign Type | Social Sync campaign type | Single select | Fundraising |
AA | Campaign Title | Editable campaign title | Long text | Cycle 50 Miles |
AB | Campaign Code | Editable internal code 1 | Short text | CY50 |
AC | Supporter ID | Unique Social Sync supporter ID | Number | 12345 |
AD | External ID | External system supporter ID (requires data import) | Number | 652143 |
AE | Supporter Type | The supporter record type: Matched, Incognito, Anonymised | Single select | Matched |
AF | Title | Supporter title | Single select | Mr |
AG | First Name | Supporter first name | Short text | John |
AH | Last Name | Supporter last name | Short text | Smith |
AI | Supporter email | |||
AJ | Phone | Supporter phone number | Number | 07755 137572 |
AK | Meta Full Name | Supporter Meta full name | Short text | John Smith |
AL | Meta Email | Supporter Meta email | ||
AM | Address Line 1 | Primary address line 1 | Short text | 97 James Harbour Suite |
AN | Address Line 2 | Primary address line 2 | Short text | Promenade Street |
AO | City | Primary address city | Short text | Blackpool |
AP | County | Primary address county | Short text | Lancashire |
AQ | Post Code | Primary address post code | Short text | LA29 5BP |
AR | Country | Primary address country | Short text | United Kingdom |
AS | Campaign Tags | Comma separated list of all the supporter’s campaign specific tags | Long text | self-donate, met target |
AT | Email Consent | Marketing consent status | Boolean | TRUE |
AU | Email Statement | Statement associated with consent status | Long text | I would like to be kept up to date via: |
AV | Email Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date | 04/06/2022 22:33 |
AW | SMS Consent | Marketing consent status | Boolean | FALSE |
AX | SMS Statement | Statement associated with consent status | Long text |
|
AY | SMS Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date |
|
AZ | Whatsapp Consent | Marketing consent status | Boolean | FALSE |
BA | Whatsapp Statement | Statement associated with consent status | Long text |
|
BB | Whatsapp Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date |
|
BC | Phone Consent | Marketing consent status | Boolean | FALSE |
BD | Phone Statement | Statement associated with consent status | Long text |
|
BE | Phone Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date |
|
BF | Post Consent | Marketing consent status | Boolean | FALSE |
BG | Post Statement | Statement associated with consent status | Long text |
|
BH | Post Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date |
|
BI | Last Modified | Date/time the record was last modified. ISO format YYYY:MM:DD HH:MM | Date | 23/06/2022 12:37 |
BJ | Last Modified By | Who the record was modified by | Short text | Barry Stevenson |