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 (Airtable link) can be found here
Column | Column Name | Column Description | Type | Data Sample |
A | Campaign ID | Unique Social Sync campaign ID | Number | 145 |
B | Campaign Type | Social Sync campaign type | Single select | Fundraising |
C | Campaign Title | Editable campaign title | Long text | Cycle 50 Miles |
D | Campaign Code | Editable internal code 1 | Short text | CY50 |
E | Status | The current status of this campaign: Draft, Scheduled, Active, Ended, Archived | Single Select | Active |
F | Events | Count of events contained within this campaign | Number | 1 |
G | Audience | Count of unique individuals that form the campaign audience, includes fundraises, campaign registrants, donors and a broader pool of pre-registrants | Number | 6508 |
H | Registrations | Count of unique individuals registered for this campaign | Number | 5459 |
I | Fundraisers | Count of unique individuals with at least one fundraiser object | Number | 4009 |
J | Active Fundraisers | Count of unique individuals with at least one fundraiser object with at least one donation associated with Event ID | Number | 3651 |
K | Average Value | Total raised divided by active fundraisers count | Number | 7.39 |
L | Income Target | Editable event income target | Number | 20000 |
M | Donations | Count of all transactions | Number | 3601 |
N | Amount Raised | Sum of all transactions | Number | 26980.5 |
O | Gift Aidable Donations | Count of all Gift Aided transactions | Number | 243 |
P | Gift Aid Amount | Gift Aid sum attributed to Event | Number | 4000 |
Q | Grand Total | Sum of all transactions and all Gift Aid | Number | 30980.5 |
R | Activity Target | Event activity target | Number | 50 |
S | Activity Participants | Count of unique participants with at least 1 activity session logged | Number | 600 |
T | Activity Count | Count of unique activity sessions logged across all participants | Number | 10000 |
U | Activity Sum | Sum of all activity logged across all participants | Number | 35000 |
V | Social Sync | Event has Social Sync fundraiser objects | Boolean | TRUE |
W | Social Sync Fundraisers | Count of unique individuals with at least one Social Sync fundraiser object | Number | 100 |
X | Social Sync Donations | Count of Social Sync transactions | Number | 5 |
Y | Social Sync Amount Raised | Sum of Social Sync transactions | Number | 100 |
Z | Social Sync Gift Aid Raised | Gift Aid sum from Social Sync transactions | Number | 20 |
AA | Event has Facebook fundraiser objects | Boolean | TRUE | |
AB | Facebook Fundraisers | Count of unique individuals with at least one Facebook fundraiser object | Number | 100 |
AC | Facebook Donations | Count of Facebook transactions | Number | 10 |
AD | Facebook Amount Raised | Sum of Facebook transactions | Number | 200 |
AE | Facebook Gift Aid Raised | Gift Aid sum from Facebook transactions | Number | 80 |
AF | Event has Instagram fundraiser objects | Boolean | FALSE | |
AG | Instagram Fundraisers | Count of unique individuals with at least one Instagram fundraiser object | Number | 0 |
AH | Instagram Donations | Count of Instagram transactions | Number | 0 |
AI | Instagram Amount Raised | Sum of Instagram transactions | Number | 0 |
AJ | Instagram Gift Aid Raised | Gift Aid sum from Instagram transactions | Number | 0 |
AK | JustGiving | Event has JustGiving fundraiser objects | Boolean | FALSE |
AL | JustGiving Fundraisers | Count of unique individuals with at least one JustGiving fundraiser object | Number | 0 |
AM | JustGiving Donations | Count of JustGiving transactions | Number | 0 |
AN | JustGiving Amount Raised | Sum of JustGiving transactions | Number | 0 |
AO | JustGiving Gift Aid Raised | Gift Aid sum from JustGiving transactions | Number | 0 |
AP | Last Modified | Date/time the record was last modified. ISO format: YYYY-MM-DD HH:MM | Date | 23/06/2022 12:37 |
AQ | Last Modified By | Who the record was modified by | Short text | Barry Stevenson |