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 | Transaction ID | Unique Social Sync transaction ID | Number | 235874 |
B | Platform Transaction ID | Unique payment processor transaction ID | Short text | 1232713499 |
C | Processor | Payment processor; Meta, Stripe, PayPal | Single select | Meta |
D | Transaction Type | Transaction type; Sponsorship, Donation, Ticket, Purchase | Single select | Sponsorship |
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 | Transaction Date Time | Date time transaction was made. ISO format: YYYY-MM-DD HH:MM | Date | 07/12/2022 07:13 |
I | Transaction Status | Transaction status; Live, Refund, Paid | Single select | Live |
J | Currency | Currency of the transaction | Short text | GBP |
K | Transaction Amount | The amount of the transaction | Number | 10 |
L | Processor Fee | The fee applied by the payment processor | Number |
|
M | Payout Amount | Transaction amount less processor fee | Number | 10 |
N | Transaction Message | Message sent with transaction | Long text | Good luck with the fundraiser mate! |
O | Gift Aid | Transaction Gift Aid status | Boolean | TRUE |
P | Gift Aid Declaration | Gift Aid declaration associated with transaction. Customisable text | Long text | I confirm I am a UK taxpayer |
Q | Gift Aid Amount | Sum of Gift Aid | Number | 2.5 |
R | Gift Aid Status | Status of Gift Aid payment; Pending, Submitted, Rejected, Approved, Paid | Single select | Pending |
S | Grand Total | The total of this transaction including Gift Aid | Number | 12.5 |
T | Fundraiser Supporter ID | Unique Social Sync supporter ID of fundraiser owner | Number | 17252 |
U | Fundraiser External ID | Unique external supporter ID of fundraiser owner | Short text |
|
V | Fundraiser First Name | First name of fundraiser owner | Short text | Larry |
W | Fundraiser Last Name | Last name of fundraiser owner | Short text | Draper |
X | Fundraiser ID | Unique Social Sync fundraiser ID | Number |
|
Y | Platform Fundraiser ID | Unique platform fundraiser ID | Short text |
|
Z | Platform | Fundraiser source platform: Social Sync, Facebook, Instagram, JustGiving | Single select | |
AA | Fundraiser Title | Title of fundraiser page | Long text | Help me Swim 50km in January for a good cause. |
AB | Fundraiser Link | URL to fundraiser page | URL | |
AC | Registration ID | Unique Social Sync registration ID of fundraiser owner | Number | 25836 |
AD | Event ID | Unique Social Sync Event ID | Number | 145 |
AE | Event Type | Social Sync event type | Single select | Facebook challenge |
AF | Event Tite | Editable event title | Long text | Cycle 50 Miles in March |
AG | Event Code | Editable internal code 2 | Short text | CY50-MAR |
AH | Campaign ID | Unique Social Sync Campaign ID | Number | 521 |
AI | Campaign Type | Social Sync campaign type | Single select | Fundraising |
AJ | Campaign Title | Editable campaign title | Long text | Cycle 50 Miles |
AK | Campaign Code | Editable internal code 1 | Short text | CY50 |
AL | Supporter ID | Unique Social Sync supporter ID of transaction owner | Number | 58963 |
AM | External ID | Unique external supporter ID (of transaction owner) | Short text | 652143 |
AN | Title | Supporter title | Single select | Mr |
AO | First Name | Supporter first name | Short text | John |
AP | Last Name | Supporter last name | Short text | Smith |
AQ | Supporter email | |||
AR | Phone | Supporter phone number | Number | 07755 137572 |
AS | Meta Full Name | Supporter Meta full name | Short text | John Smith |
AT | Meta Email | Supporter Meta email | ||
AU | Address Line 1 | Primary address line 1 | Short text | 97 James Harbour Suite |
AV | Address Line 2 | Primary address line 2 | Short text | Promenade Street |
AW | City | Primary address city | Short text | Blackpool |
AX | County | Primary address county | Short text | Lancashire |
AY | Post Code | Primary address post code | Short text | LA29 5BP |
AZ | Country | Primary address country | Short text | United Kingdom |
BA | Email Consent | Marketing consent status | Boolean | TRUE |
BB | Email Statement | Statement associated with consent status | Long text | I would like to be kept up to date via: |
BC | Email Consent Date Time | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM | Date | 04/06/2022 22:33 |
BD | SMS Consent | Marketing consent status | Boolean | FALSE |
BE | SMS Statement | Statement associated with consent status | Long text |
|
BF | SMS Consent Date Time | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM | Date |
|
BG | Whatsapp Consent | Marketing consent status | Boolean | FALSE |
BH | Whatsapp Statement | Statement associated with consent status | Long text |
|
BI | Whatsapp Consent Date Time | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM | Date |
|
BJ | Phone Consent | Marketing consent status | Boolean | FALSE |
BK | Phone Statement | Statement associated with consent status | Long text |
|
BL | Phone Consent Date Time | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM | Date |
|
BM | Post Consent | Marketing consent status | Boolean | FALSE |
BN | Post Statement | Statement associated with consent status | Long text |
|
BO | Post Consent Date Time | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM | Date |
|
BP | Last Modified | Date/time the record was last modified. ISO format: YYYY-MM-DD HH:MM | Date | 23/06/2022 12:37 |
BQ | Last Modified By | Who the record was modified by | Short text | Barry Stevenson |