Version: 3.0 - effective from: 07/04/2026
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 | Transaction ID | Number | Unique Social Sync transaction line item ID |
B | Created On | Datetime | Date + time transaction was made. ISO format: YYYY-MM-DD HH:MM |
C | Type | Single select | Transaction type; |
D | Status | Single select | Transaction status: |
E | Sender Currency | Short text | The native currency of the transaction. ISO currency code (ISO 4217) |
F | Sender Currency Amount | Number | The amount of the transaction in the sender's currency |
G | Currency | Short text | Localised (payout) currency of the transaction. ISO currency code (ISO 4217) |
H | Gross Amount | Number | The amount of the transaction in the payout currency before any adjustments. NOTE: Foreign currency transactions are estimated based on a daily rate which may differ slightly from payout amounts due to fluctuations in exchange rates and time of conversion. |
I | Platform | Single select | Transaction source platform: |
J | Category | Single select | The transaction category relates to our billing model. Transactions are categorised as: |
K | Platform ID | Number | Unique source platform transaction ID. E.g. Facebook's " |
L | Platform Reference | Short text | Additional info for attributing donations across platforms, e.g. JustGiving |
M | Platform Fee | Number | The fee applied by the platform. e.g. Registration fees for Social Sync ticket sales |
N | Charge Date | Date | This corresponds directly to the “ |
O | Product ID | Number | The purchasable product ID, where transaction type = "Product" in column C. |
P | Product Type | Single select | Available values: |
Q | Product Name | Short text | The name of the product sold, i.e. the item, ticket, or ticket group name Refer to previous column. |
R | Discount Code | Short text | The discount code applied to this transaction. Only applies where transaction type = "Product" in column C |
S | Discount Amount | Number | The discount value applied to this transaction. Shows as a positive value. |
T | Processor | Single select | Payment processor; |
U | Processor ID | Number | Unique payment processor (e.g. Paypal Giving Fund) transaction ID. Social Sync transactions do not have a separate Processor ID |
V | Processor Reference | Short text | Additional info for identifying transactions across platforms. Mainly used by Paypal Giving Fund. |
W | Payment Method | Single Select | The payment method used: |
X | Net Amount | Number | The gross amount of this transaction, minus discounts, platform and processor fees. Excludes Gift Aid |
Y | Gift Aid | Boolean | Transaction Gift Aid status: |
Z | Gift Aid Declaration | Long text | Gift Aid declaration associated with transaction. Customisable text |
AA | Gift Aid Amount | Number | Sum of Gift Aid |
AB | Gift Aid Status | Single select | Status of Gift Aid payment; |
AC | Payout ID | Number | For Social Sync transactions only. The unique ID of the weekly Payout containing this transaction |
AD | Payout Date | Datetime | Date + time payout was made. ISO format: YYYY-MM-DD HH:MM |
AE | Payout Status | Single select | Social Sync transaction payout status: |
AF | Recurring ID | Number | The ID of the recurring transaction. Used for identifying recurring transactions |
AG | Recurring Type | Single select | The type of recurring transaction: |
AH | Recurring Created On | Datetime | Date + time recurring donation was first created. ISO format: YYYY-MM-DD HH:MM |
AI | Anonymous | Boolean | Was the donation made anonymously? |
AJ | Display Name | Short text | The name left by the donor |
AK | Message | Long text | Message sent with transaction |
AL | Supporter ID | Number | Unique Social Sync supporter ID of transaction owner, i.e. the donor, ticket buyer |
AM | External ID | Short text | Unique external supporter ID (of transaction owner) |
AN | Title | Single select | Supporter title: |
AO | First Name | Short text | Supporter first name |
AP | Last Name | Short text | Supporter last name |
AQ | Supporter email | ||
AR | Phone | Number | Supporter phone number |
AS | Address Line 1 | Short text | Primary address line 1 |
AT | Address Line 2 | Short text | Primary address line 2 |
AU | City | Short text | Primary address city |
AV | County | Short text | Primary address county |
AW | Post Code | Short text | Primary address post code |
AX | Country | Short text | Primary address country |
AY | Email Consent | Boolean | Email marketing consent status: |
AZ | Email Statement | Long text | Statement associated with Email consent status |
BA | Email Consent Date Time | Datetime | Date/time consent status was updated. ISO format YYYY:MM:DD HH:MM |
BB | SMS Consent | Boolean | SMS marketing consent status: |
BC | SMS Statement | Long text | Statement associated with SMS consent status |
BD | SMS Consent Date Time | Datetime | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM |
BE | WhatsApp Consent | Boolean | WhatsApp marketing consent status: |
BF | WhatsApp Statement | Long text | Statement associated with WhatsApp consent status |
BG | WhatsApp Consent Date Time | Datetime | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM |
BH | Phone Consent | Boolean | Phone marketing consent status: |
BI | Phone Statement | Long text | Statement associated with phone consent status |
BJ | Phone Consent Date Time | Datetime | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM |
BK | Post Consent | Boolean | Post marketing consent status: |
BL | Post Statement | Long text | Statement associated with post consent status |
BM | Post Consent Date Time | Datetime | Date/time consent status was updated. ISO format: YYYY-MM-DD HH:MM |
BN | Linked Record ID | Number | The ID of the linked record. May be a |
BO | Linked Record Type | Single select | Denotes the type of record the transaction was made to. For a regular "Donation" this will be a " |
BP | Linked Record ID | Number | The ID of the linked record. May be a |
BQ | Linked Record Title | Long text | The title of the fundraiser page or team page the donation was made to. Ticket/Item purchases will have no value here |
BR | Linked Record URL | URL | The URL of the linked fundraiser page or team page. Tickets/Item purchases will have no value here |
BS | Linked Supporter ID | Number | The supporter ID of the linked record |
BT | Linked External ID | Number | The external ID (where available) of the linked supporter record |
BU | Linked First Name | Short text | First name of the linked supporter |
BV | Linked Last Name | Short text | Last name of the linked supporter |
BW | Linked Email | Email of the linked supporter | |
BX | Event ID | Number | Unique Social Sync event ID |
BY | Event Type | Single select | The type of event: |
BZ | Event Activity | Single select | Social Sync event activity type. Numerous options available, e.g. |
CA | Event Title | Long text | Editable event title |
CB | Event Code | Short text | Editable internal code |
CC | Campaign ID | Number | Unique Social Sync campaign ID |
CD | Campaign Type | Single select | Social Sync campaign type: |
CE | Campaign Title | Long text | Editable campaign title |
CF | Campaign Code | Short text | Editable internal code |
CG | Source ID | Number | Donation form version ID or Flow ID. |
CH | Source Type | Single select | Creation source type: |
CI | Source Title | Long text | Creation Source title, where available |