Version: 3.0 - effective from: 07/04/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 |
A | Registration ID | Short text | Unique Social Sync campaign registration ID |
B | Created On | Datetime | Date + time transaction was made. ISO format: YYYY-MM-DD HH:MM |
C | Type | Single select | Type of registration:
|
D | Status | Single select | Registration status: |
E | Primary Fundraiser URL | URL | The primary fundraising page URL for this registration. Where multiple fundraisers are enabled, the Social Sync fundraiser is the default primary. |
F | Fundraiser Target | Number | The fundraiser target associated with this registration. Where targets don't match across platform's the Social Sync target will be shown. |
G | Donations | Number | Count of all donations |
H | Raised | Number | Sum of all donations |
I | Amount Pledged | Number | Offline donations which have not yet been received will be recorded here separate from the "Raised" column (H). In the transactions export these transactions will have a status of |
J | Total Raised |
| Sum of all transactions including pledged income. Excludes Gift Aid and ticket/item purchases. |
K | Gift Aid Raised | Number | Sum of all Gift Aid |
L | Grand Total | Number | Total Raised, including Gift Aid. (excludes tickets/items) |
M | Ticket ID | Number | The ID of the ticket attached to this registration, if available |
N | Ticket Title | Short text | The title of the ticket attached to this registration, if available |
O | Discount Code | Short text | The discount code applied when creating this registration, if available |
P | Ticket Cost | Number | The cost of the ticket attached to this registration, after discounts have been applied. |
Q | Team ID | Number | The ID of the team page that this registrant is attached to, if available |
R | Team Role | Single select | Available values: |
S | Team URL | URL | The URL of the team page that this registrant is attached to, if available |
T | Activity Target | Number | Event activity target |
U | Activity Units | Single select | Event activity units. Numerous options. |
V | Activity Count | Number | Count of activity logged |
W | Activity Sum | Number | Sum of activity logged |
X | Motivation | Single select | Supporter motivation - fixed values from motivation form |
Y | Motivation other | Long text | Supporter motivation other value (free text) |
Z | Supporter ID | Number | Unique Social Sync supporter ID |
AA | External ID | Number | External system supporter ID (requires data upload) |
AB | Title | Single select | Supporter title: |
AC | First Name | Short text | Supporter first name |
AD | Last Name | Short text | Supporter last name |
AE | Supporter email | ||
AF | Phone | Number | Supporter phone number |
AG | Date Of Birth | Date | Format: YYYY MM DD |
AH | Address Line 1 | Short text | Primary address line 1 |
AI | Address Line 2 | Short text | Primary address line 2 |
AJ | City | Short text | Primary address city |
AK | County | Short text | Primary address county |
AL | Post Code | Short text | Primary address post code |
AM | Country | Short text | Primary address country |
AN | Campaign Tags | Long text | Comma separated list of all the supporter's campaign specific tags |
AO | Supporter Tags | Long text | Comma separated list of all the supporter's supporter tags |
AP | Email Consent | Boolean | Email marketing consent status: |
AQ | Email Statement | Long text | Statement associated with Email consent status |
AR | Email Consent Date Time | Date | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM |
AS | SMS Consent | Boolean | SMS marketing consent status: |
AT | SMS Statement | Long text | Statement associated with SMS consent status |
AU | SMS Consent Date Time | Date | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM |
AV | Whatsapp Consent | Boolean | Whasapp marketing consent status: |
AW | Whatsapp Statement | Long text | Statement associated with Whatsapp consent status |
AX | Whatsapp Consent Date Time | Date | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM |
AY | Phone Consent | Boolean | Phone marketing consent status: |
AZ | Phone Statement | Long text | Statement associated with phone consent status |
BA | Phone Consent Date Time | Date | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM |
BB | Post Consent | Boolean | Post marketing consent status: |
BC | Post Statement | Long text | Statement associated with post consent status |
BD | Post Consent Date Time | Date | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM |
BE | Event ID | Number | Unique Social Sync Event ID |
BF | Event Type | Single select | The type of event: |
BG | Event Activity | Single select | Social Sync event activity type. Numerous options available, e.g. |
BH | Event Title | Long text | Editable event title |
BI | Event Code | Short text | Editable internal code |
BJ | Event Details | Long text | The description used for supporter created events |
BK | Event Start Date | Date | Date event starts. Format: YYYY-MM-DD |
BL | Event End Date | Date | Date event ends. Format: YYYY-MM-DD |
BM | External Event ID | Short text | The ID of any linked external event - e.g. JustGiving event ID |
BN | Campaign ID | Number | Unique Social Sync Campaign ID |
BO | Campaign Type | Single select | Social Sync campaign type: |
BP | Campaign Title | Long text | Editable campaign title |
BQ | Campaign Code | Short text | Editable internal code |
BR | Source ID | Number | Flow or Form ID which created this registration |
BS | Source Type | Single select | Creation source type; |
BT | Source Title | Long text | Creation Source title, where available |