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
Column | Column Name | Column Description | Type | Data Sample |
A | Event ID | Unique Social Sync Event ID | Number | 145 |
B | Event Type | Social Sync event type | Single select | Facebook challenge |
C | Event Title | Editable event title | Long text | Cycle 50 Miles in March |
D | Event Code | Editable internal code 2 | Short text | CY50-MAR |
E | Status | Status of event; draft, scheduled, active, closed, archived | Single select | Active |
F | Campaign ID | Unique Social Sync Campaign ID | Number | 521 |
G | Campaign Type | Social Sync campaign type | Single select | Fundraising |
H | Campaign Title | Editable campaign title | Long text | Cycle 50 Miles |
I | Campaign Code | Editable internal code 1 | Short text | CY50 |
J | Registration Open Date | Date form submissions open. ISO format: YYYY-MM-DD HH:MM | Date | 23/02/2022 11:30 |
K | Registration Close Date | Date form submissions close. ISO format: YYYY-MM-DD HH:MM | Date | 08/03/2022 23:30 |
L | Event Start Date | Date event activity starts. ISO format: YYYY-MM-DD HH:MM | Date | 01/03/2022 07:00 |
M | Event End Date | Date event activity ends. ISO format: YYYY-MM-DD HH:MM | Date | 31/03/2022 23:30 |
N | Fundraiser End Date | Date fundraisers are set to close. ISO format: YYYY-MM-DD HH:MM | Date | 14/04/2022 23:30 |
O | Audience | Count of unique individuals that form the campaign audience, includes fundraises, campaign registrants, donors and a broader pool of pre-registrants | Number | 6508 |
P | Registrations | Count of unique individuals registered for this campaign | Number | 5459 |
Q | Fundraisers | Count of unique individuals with at least one fundraiser object | Number | 4009 |
R | Active Fundraisers | Count of unique individuals with at least one fundraiser object with at least one donation associated with Event ID | Number | 3651 |
S | Average Value | Total raised divided by active fundraisers count | Number | 7.39 |
T | Income Target | Editable event income target | Number | 20000 |
U | Donations | Count of all transactions | Number | 3601 |
V | Amount Raised | Sum of all transactions | Number | 26980.5 |
W | Gift Aidable Donations | Count of all Gift Aided transactions | Number | 243 |
X | Gift Aid Amount | Gift Aid sum attributed to Event | Number | 4000 |
Y | Grand Total | Sum of all transactions and all Gift Aid | Number | 30980.5 |
Z | Activity Type | Event activity type | Short text | Run |
AA | Activity Units | Event activity units | Short text | Miles |
AB | Activity Target | Event activity target | Number | 50 |
AC | Activity Participants | Count of unique participants with at least 1 activity session logged | Number | 600 |
AD | Activity Count | Count of unique activity sessions logged across all participants | Number | 10000 |
AE | Activity Sum | Sum of all activity logged across all participants | Number | 35000 |
AF | Social Sync | Event has Social Sync fundraiser objects | Boolean | TRUE |
AG | Social Sync Fundraisers | Count of unique individuals with at least one Social Sync fundraiser object | Number | 100 |
AH | Social Sync Donations | Count of Social Sync transactions | Number | 5 |
AI | Social Sync Amount Raised | Sum of Social Sync transactions | Number | 100 |
AJ | Social Sync Gift Aid Raised | Gift Aid sum from Social Sync transactions | Number | 20 |
AK | Event has Facebook fundraiser objects | Boolean | TRUE | |
AL | Facebook Fundraisers | Count of unique individuals with at least one Facebook fundraiser object | Number | 100 |
AM | Facebook Donations | Count of Facebook transactions | Number | 10 |
AN | Facebook Amount Raised | Sum of Facebook transactions | Number | 200 |
AO | Facebook Gift Aid Raised | Gift Aid sum from Facebook transactions | Number | 80 |
AP | Event has Instagram fundraiser objects | Boolean | FALSE | |
AQ | Instagram Fundraisers | Count of unique individuals with at least one Instagram fundraiser object | Number | 0 |
AR | Instagram Donations | Count of Instagram transactions | Number | 0 |
AS | Instagram Amount Raised | Sum of Instagram transactions | Number | 0 |
AT | Instagram Gift Aid Raised | Gift Aid sum from Instagram transactions | Number | 0 |
AU | JustGiving | Event has JustGiving fundraiser objects | Boolean | FALSE |
AV | JustGiving Fundraisers | Count of unique individuals with at least one JustGiving fundraiser object | Number | 0 |
AW | JustGiving Donations | Count of JustGiving transactions | Number | 0 |
AX | JustGiving Amount Raised | Sum of JustGiving transactions | Number | 0 |
AY | JustGiving Gift Aid Raised | Gift Aid sum from JustGiving transactions | Number | 0 |
AZ | Last Modified | Date/time the record was last modified. ISO format: YYYY-MM-DD HH:MM | Date | 23/06/2022 12:37 |
BA | Last Modified By | Who the record was modified by | Short text | Barry Stevenson |