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