Effective date: 7 April 2026 Notice issued: 9 March 2026
This changelog details all changes between the Fundraisers Export v2.0 and v3.0 specifications. It is intended to help customers update downstream data processes such as CRM upload mappings, data warehouse ETL jobs, and reporting integrations.
Transition period: v2.0 exports will remain available alongside v3.0 after the 7 April go-live date. You do not need to update your downstream processes immediately. We will provide advance notice before v2.0 exports are retired.
Note: Column positions have changed significantly in v3.0. Do not rely on column letter/index - use column headers for mapping.
Summary of changes
6 new columns added (pledged income, total raised, event activity, event details, event dates)
7 columns removed (Meta fields, Supporter Type, audit fields, consent columns removed)
5 columns renamed (shorter, more consistent naming)
Several value sets updated (Fundraiser Type, Platform, Event Type, Campaign Type, Source Type)
Consent columns removed - marketing consent is no longer included in this export. Use the Registrations export for consent data.
Column ordering restructured - all column positions have shifted. Map by header name, not position.
New columns
v3.0 Ref | Column Name | Type | Description |
O | Amount Pledged | Number | Offline donations not yet received. Moves to "Raised" (N) when marked as received |
P | Total Raised | Number | Sum of all donations including pledged amounts |
AL | Event Activity | Single select | Event activity type (Walk, Run, Marathon, Swim, etc.) |
AO | Event Details | Long text | Description used for supporter-created events |
AP | Event Start Date | Date | Format: YYYY-MM-DD |
AQ | Event End Date | Date | Format: YYYY-MM-DD |
Removed columns
v2.0 Ref | Column Name | Notes |
AG | Supporter Type | Removed (was: Matched, Incognito, Anonymised) |
AM | Meta Full Name | Removed |
AN | Meta Email | Removed |
BL | Last Modified | Removed |
BM | Last Modified By | Removed |
Consent columns removed
All 15 marketing consent columns (AW-BK in v2.0) have been removed from the Fundraisers export. This covers Email, SMS, WhatsApp, Phone, and Post consent fields (status, statement, and date/time for each). Marketing consent data is available in the Registrations export.
v2.0 Ref | Column Name |
AW | Email Consent |
AX | Email Statement |
AY | Email Consent Date Time |
AZ | SMS Consent |
BA | SMS Statement |
BB | SMS Consent Date Time |
BC | Whatsapp Consent |
BD | Whatsapp Statement |
BE | Whatsapp Consent Date Time |
BF | Phone Consent |
BG | Phone Statement |
BH | Phone Consent Date Time |
BI | Post Consent |
BJ | Post Statement |
BK | Post Consent Date Time |
Renamed columns
v2.0 Name (Ref) | v3.0 Name (Ref) | Notes |
Fundraiser Type (D) | Type (C) | Values also changed - see below |
Fundraiser Status (M) | Status (D) | No change to values |
Fundraiser Link (N) | Fundraiser URL (E) | Renamed for consistency |
Amount Raised (Q) | Raised (N) | Shortened name; no change to data |
Event Title (X) | Event Title (AM) | No change to data; position moved |
Changed values and definitions
Fundraiser Type (D) → Type (C)
v2.0 values | v3.0 values |
Generic list including "API created fundraiser", "Birthday fundraiser", etc. | API created fundraiser, Organic |
Key change: Simplified to two values.
Platform (C → F)
v2.0 values | v3.0 values |
Social Sync, Facebook, Instagram, JustGiving | Social Sync, Facebook, Instagram, JustGiving, GoFundMe |
Event Type (W → AK)
v2.0 values | v3.0 values |
Generic "Social Sync event type" | Standard, Own Place, Charity Place, Supporter Created |
Key change: Specific values now defined, consistent with the Registrations and Transactions exports.
Campaign Type (AB → AT)
v2.0 values | v3.0 values |
Fundraising | Fundraising, Programme, DIY |
Source Type (F → AX)
v2.0 values | v3.0 values |
Form, API, Manual, Transaction import | Flow, Form |
Key change: Simplified to two values. "Flow" is a new creation method.
Other structural changes
Pledged income tracking
New columns Amount Pledged (O) and Total Raised (P) mirror the same pattern introduced in the Registrations export. Offline donations that haven't been confirmed move from Amount Pledged into Raised (N) when their status is updated to received.
Event fields expanded
New fields for Event Activity (AL), Event Details (AO), Event Start Date (AP), and Event End Date (AQ) bring the Fundraisers export in line with the Registrations export for event detail.
Source columns
Source ID and Source Type remain but their values have been updated. Source Type (AX) is now "Flow" or "Form", and Source ID (AW) is described as a Flow or Form ID.