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 | Registration ID | Unique Social Sync campaign registration ID | Short text | 40557 |
B | Source ID | Creation source ID, where source type=”form” | Number | 119 |
C | Source Type | Creation source type. e.g. Form | API | Manual | Transaction import | Single select | Form |
D | Source Title | Creation Source title, where source type=”form” | Long text | Standard registration form |
E | Created On | Date time supporter registered. ISO format: YYYY-MM-DD HH:MM | Date | 07/12/2022 07:13 |
F | Registration Status | Registration status. Active, Cancelled, Ended | Single select | Active |
G | Event ID | Unique Social Sync Event ID | Number | 145 |
H | Event Type | Social Sync event type | Single select | Facebook challenge |
I | Event Title | Editable event title | Long text | Cycle 50 Miles in March |
J | Event Code | Editable internal code 2 | Short text | CY50-MAR |
K | 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 |
L | Campaign ID | Unique Social Sync Campaign ID | Number | 521 |
M | Campaign Type | Social Sync campaign type | Single select | Fundraising |
N | Campaign Title | Editable campaign title | Long text | Cycle 50 Miles |
O | Campaign Code | Editable internal code 1 | Short text | CY50 |
P | Supporter ID | Unique Social Sync supporter ID | Number | 12345 |
Q | External ID | External system supporter ID (requires data import) | Number | 652143 |
R | Supporter Type | The supporter record type: Matched, Incognito, Anonymised | Single select | Matched |
S | Title | Supporter title | Single select | Mr |
T | First Name | Supporter first name | Short text | John |
U | Last Name | Supporter last name | Short text | Smith |
V | Supporter email | |||
W | Phone | Supporter phone number | Number | 07755 137572 |
X | Meta Full Name | Supporter Meta full name | Short text | John Smith |
Y | Meta Email | Supporter Meta email | ||
Z | Address Line 1 | Primary address line 1 | Short text | 97 James Harbour Suite |
AA | Address Line 2 | Primary address line 2 | Short text | Promenade Street |
AB | City | Primary address city | Short text | Blackpool |
AC | County | Primary address county | Short text | Lancashire |
AD | Post Code | Primary address post code | Short text | LA29 5BP |
AE | Country | Primary address country | Short text | United Kingdom |
AF | Item Type | Item type of most recent merchandise order | Single select | T-shirt |
AG | Item Fit | Item fit of most recent merchandise order | Single select | Male |
AH | Item Size | Item size of most recent merchandise order | Single select | L |
AI | Item Colour | Item colour of most recent merchandise order | Single select | Red |
AJ | Motivation | Supporter motivation - fixed values from motivation form | Single select | In memory |
AK | Motivation Other | Supporter motivation other value (free text) | Long text |
|
AL | Supporter Story | Supporter personal story | Long text | Lorem ipsum dolor sit amet |
AM | Tribute ID | Unique Social Sync supporter ID of in memory connection | Number | 45236 |
AN | In Memory First Name | In memory connection first name | Short text | Mary |
AO | In Memory Last Name | In memory connection last name | Short text | Smith |
AP | In Memory Relationship | In memory connection relationship | Single select | Mother |
AQ | In Memory Date Of Birth | In memory connection date of birth ISO format: YYYY-MM-DD (no time included) | Date | 05/03/1982 |
AR | In Memory Date Of Death | In memory connection date of death ISO format: YYYY-MM-DD (no time included) | Date | 05/07/2022 |
AS | Activity Type | Event activity type | Single select | Walk |
AT | Activity Units | Event Activity units | Single select | Miles |
AU | Activity Target | Event activity target | Number | 150 |
AV | Activity Count | Count of activity logged | Number | 20 |
AW | Activity Sum | Sum of activity logged | Number | 50 |
AX | Social Sync | Supporter has at least one Social Sync fundraiser object | Boolean | TRUE |
AY | Social Sync Donations | Count of Social Sync transactions | Number | 5 |
AZ | Social Sync Amount Raised | Sum of Social Sync transactions | Number | 100 |
BA | Social Sync Gift Aid Raised | Gift Aid sum from Social Sync transactions | Number | 20 |
BB | Social Sync Fundraiser Link | The url of the primary Social Sync fundraiser | URL | |
BC | Social Sync Fundraiser IDs | Comma separated IDs of all Social Sync fundraisers | Long text | 3,456,734,568 |
BD | Supporter has at least one Facebook fundraiser object | Boolean | TRUE | |
BE | Facebook Donations | Count of Facebook transactions | Number | 10 |
BF | Facebook Amount Raised | Sum of Facebook transactions | Number | 200 |
BG | Facebook Gift Aid Raised | Gift Aid sum from Facebook transactions | Number | 80 |
BH | Facebook Fundraiser Link | The url of the primary Facebook fundraiser | URL | |
BI | Facebook Fundraiser IDs | Comma separated IDs of all Facebook fundraiser IDs | Long text | 134716222894775, 67845637284235 |
BJ | Supporter has at least one Instagram fundraiser object | Boolean | FALSE | |
BK | Instagram Donations | Count of Instagram transactions | Number | 0 |
BL | Instagram Amount Raised | Sum of Instagram transactions | Number | 0 |
BM | Instagram Gift Aid Raised | Gift Aid sum of Instagram transactions | Number | 0 |
BN | Instagram Fundraiser Link | The url of the primary Instagram fundraiser | URL |
|
BO | Instagram Fundraiser IDs | Comma separated IDs of all Instagram fundraisers | Long text |
|
BP | JustGiving | Supporter has at least one JustGiving fundraiser object | Boolean | FALSE |
BQ | JustGiving Donations | Count of JustGiving transactions | Number | 0 |
BR | JustGiving Amount Raised | Sum of JustGiving transactions | Number | 0 |
BS | JustGiving Gift Aid Raised | Gift Aid sum of JustGiving transactions | Number | 0 |
BT | JustGiving Fundraiser Link | The url of the primary JustGiving fundraiser | URL |
|
BU | JustGiving Fundraiser IDs | Comma separated IDs of all JustGiving fundraisers | Long text |
|
BV | Total Donations | Count of all transactions | Number | 15 |
BW | Total Amount Raised | Sum of all transactions | Number | 300 |
BX | Total Gift Aid Raised | Sum of all Gift Aid | Number | 100 |
BY | Grand Total | Sum of all transactions and all Gift Aid | Number | 400 |
BZ | Campaign Tags | Comma separated list of all the supporter's campaign specific tags | Long text | self-donate, met target |
CA | Supporter Tags | Comma separated list of all the supporter's supporter tags | Long text | VIP |
CB | Email Consent | Marketing consent status | Boolean | TRUE |
CC | Email Statement | Statement associated with consent status | Long text | I would like to be kept up to date via: |
CD | Email Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date | 04/06/2022 22:33 |
CE | SMS Consent | Marketing consent status | Boolean | FALSE |
CF | SMS Statement | Statement associated with consent status | Long text |
|
CG | SMS Consent Date Time | Date/time consent status was updated ISO format: YYYY-MM-DD HH:MM | Date |
|
CH | Whatsapp Consent | Marketing consent status | Boolean | FALSE |
CI | Whatsapp Statement | Statement associated with consent status | Long text |
|
CJ | Whatsapp Consent Date Time | Date/time consent status was updated ISO format: YYYY-MM-DD HH:MM | Date |
|
CK | Phone Consent | Marketing consent status | Boolean | FALSE |
CL | Phone Statement | Statement associated with consent status | Long text |
|
CM | Phone Consent Date Time | Date/time consent status was updated ISO format: YYYY-MM-DD HH:MM | Date |
|
CN | Post Consent | Marketing consent status | Boolean | FALSE |
CO | Post Statement | Statement associated with consent status | Long text |
|
CP | Post Consent Date Time | Date/time consent status was updated ISO format: YYYY-MM-DD HH:MM | Date |
|
CQ | Last Modified | Date/time the record was last modified ISO format: YYYY-MM-DD HH:MM | Date | 23/06/2022 12:37 |
CR | Last Modified By | Who the record was modified by | Short text | Barry Stevenson |