This is a long article, please use the subheadings on the right hand side to navigate to the section you want to see.
Registration export
You can choose to include as many of these fields in your registration export depending on your event and reporting requirements.
Registration Information
Column | Description | Data source |
registrationId | GivePanel registration UUID | GivePanel Database |
shortRegistrationId | 18-character hash of registration ID (for systems that can’t store long UUIDs) | Calculated from GivePanel Database |
registrationType | Primary or Secondary registrant | GivePanel Database |
registrationStatus | Confirmed, Unconfirmed, or Cancelled | GivePanel Database |
registrationMode | Live or test registration | GivePanel Database |
registrationDate | When the registration was created | GivePanel Database |
registrationLastEditedAt | Last manual edit timestamp | GivePanel Database |
cancelledDate | When registration was cancelled (if applicable) | GivePanel Database |
Personal information
Column | Description | Data source |
firstName | Registrant’s first name | Form Response |
lastName | Registrant’s last name | Form Response |
fullName | Full name (first + last) | Calculated from Form Response |
Registrant’s email address | Form Response | |
phoneNumber | Registrant’s phone number | Form Response |
dateOfBirth | Registrant’s date of birth | Form Response |
addressLine1 | First line of address | Form Response |
addressLine2 | Second line of address | Form Response |
cityOrTown | City or town | Form Response |
county | County or state | Form Response |
postcode | Postal code | Form Response |
country | Country | Form Response |
Emergency Contact
Column | Description | Data source |
emergencyContactFullName | Emergency contact name | Form Response |
emergencyContactEmail | Emergency contact email | Form Response |
emergencyContactPhone | Emergency contact phone | Form Response |
Marketing Preferences
Column | Description | Data source |
marketingOptInStatement | Marketing opt-in statement text | Form Response |
marketingOptinEmail | Email marketing consent (yes/no) | Form Response |
marketingOptinSMS | SMS marketing consent (yes/no) | Form Response |
marketingOptinPhone | Phone marketing consent (yes/no) | Form Response |
marketingOptinPost | Post marketing consent (yes/no) | Form Response |
Terms and Conditions & In-Memory
Column | Description | Data source |
termsAndConditionsAccepted | T&Cs accepted (yes/no) | Form Response |
termsAndConditionsAcceptedDate | When T&Cs were accepted | Form Response |
inMemory | Registration in memory of someone (yes/no) | Form Response |
inMemoryOf | In Memory Name | Form Response |
Additional registrations
Column | Description | Data source |
additionalRegistrations | Has additional registrants (yes/no) | GivePanel Database |
registeredById | Main registrant ID (for secondary registrants) | GivePanel Database |
shortRegisteredById | Short hash of main registrant ID | Calculated from GivePanel Database |
Ticket information
Column | Description | Data source |
ticketName | Name of ticket purchased | GivePanel Database |
variant | Variant option selected (e.g., distance) | Form Response |
startTime | Start time selected | Form Response |
ticketPrice | Original ticket price | GivePanel Database |
ageRestrictions | Over 18 or Under 18 years old | GivePanel Database |
discountCode | Discount code used | GivePanel Database |
discountAmount | Discount amount applied | GivePanel Database |
grossTicketAmount | Ticket price before VAT | Calculated from GivePanel Database |
netTicketAmount | Ticket price after VAT | Calculated from GivePanel Database |
ticketVatAmount | VAT amount on ticket | Calculated from GivePanel Database |
Payment information (payer only)
Column | Description | Data source |
paymentId | Payment transaction ID | GivePanel Database |
paymentCreatedDate | When payment was created | GivePanel Database |
paymentLastEditedAt | Last payment edit timestamp | GivePanel Database |
paymentStatus | Payment status | GivePanel Database |
ticketPriceAmount | Total ticket price | Calculated from GivePanel Database |
paymentDiscountCode | Discount code used | GivePanel Database |
paymentDiscountAmount | Discount amount | GivePanel Database |
netPaymentAmount | Payment amount after discount | Calculated from GivePanel Database |
vatPaymentAmount | VAT amount on payment | Calculated from GivePanel Database |
grossPaymentAmount | Total payment amount | Calculated from GivePanel Database |
currency | Payment currency | GivePanel Database |
paymentMethod | Payment method used | GivePanel Database |
numberOfTickets | Number of tickets purchased | GivePanel Database |
refundDate | When payment was refunded | GivePanel Database |
refundAmount | Refund amount | GivePanel Database |
Fundraising Information
Column | Description | Data source |
fundraiserUserId | JustGiving account ID of fundraiser owner | JustGiving |
fundraiserFirstName | Fundraiser’s first name | Form Response |
fundraiserLastName | Fundraiser’s last name | Form Response |
fundraiserFullName | Fundraiser’s full name | Calculated from Form Response |
fundraiserEmailAddress | Fundraiser’s email address | Form Response |
fundraisingPageId | Fundraising page ID (campaignID) | GivePanel Database |
fundraisingPageUrl | Fundraising page URL | GivePanel Database |
fundraisingPageTitle | Fundraising page title | GivePanel Database |
fundraisingPageStartDate | Fundraising page start date | GivePanel Database |
fundraisingPageTarget | Fundraising target amount | GivePanel Database |
fundraisingPageClaimed | JustGiving page claimed (yes/no) | JustGiving |
amountRaisedNoGiftAid | Amount raised excluding Gift Aid | Calculated from GivePanel Database |
giftAidAmount | Gift Aid amount claimed | Calculated from GivePanel Database |
amountRaisedIncludingGiftAid | Total amount including Gift Aid | Calculated from GivePanel Database |
donorCount | Number of donors | Calculated from GivePanel Database |
giftAidCount | Number of Gift Aid donations | Calculated from GivePanel Database |
averageDonationAmount | Average donation amount | Calculated from GivePanel Database |
averageGiftAidAmount | Average Gift Aid amount | Calculated from GivePanel Database |
selfDonation | Fundraiser made self-donation (yes/no) | Calculated from GivePanel Database |
Team Membership
Column | Description | Data source |
teamId | Team ID | GivePanel Database |
teamCreatedDate | When team was created | GivePanel Database |
teamName | Team name | GivePanel Database |
teamCaptainId | Team captain’s ID | GivePanel Database |
teamStatus | Team status | GivePanel Database |
teamMembers | Number of team members | Calculated from GivePanel Database |
teamFundraisingPageId | Team fundraising page ID | GivePanel Database |
teamFundraisingPageUrl | Team fundraising page URL | GivePanel Database |
teamFundraisingPageTitle | Team fundraising page title | GivePanel Database |
teamFundraisingPageTarget | Team fundraising target | GivePanel Database |
teamAmountRaisedNoGiftAid | Team amount raised excluding Gift Aid | Calculated from GivePanel Database |
teamGiftAidAmount | Team Gift Aid amount | Calculated from GivePanel Database |
teamAmountRaisedIncludingGiftAid | Team total amount including Gift Aid | Calculated from GivePanel Database |
teamDonorCount | Team donor count | Calculated from GivePanel Database |
teamGiftAidCount | Team Gift Aid count | Calculated from GivePanel Database |
teamAverageDonationAmount | Team average donation amount | Calculated from GivePanel Database |
teamAverageGiftAidAmount | Team average Gift Aid amount | Calculated from GivePanel Database |
teamRole | Team member role | GivePanel Database |
teamMemberStatus | Team member confirmation status | GivePanel Database |
Tracking
Column | Description | Data source |
eventId | GivePanel event/campaign ID | GivePanel Database |
eventName | Event/campaign name | GivePanel Database |
justGivingEventId | JustGiving event ID | JustGiving |
justGivingCampaignName | JustGiving campaign slug | JustGiving |
formId | Form ID | GivePanel Database |
formName | Form name | GivePanel Database |
formType | Form type/focus | GivePanel Database |
formURL | Form URL | GivePanel Database |
formSlug | Form slug | GivePanel Database |
utmCampaign | UTM campaign parameter | GivePanel Database |
utmContent | UTM content parameter | GivePanel Database |
utmMedium | UTM medium parameter | GivePanel Database |
utmSource | UTM source parameter | GivePanel Database |
utmTerm | UTM term parameter | GivePanel Database |
Fundraiser Export
You can choose to include as many of these fields in your Fundraiser export depending on your event and reporting requirements.
Column | Description | Data source |
registrationId | GivePanel registration UUID (if fundraiser matched to registration) | GivePanel Database |
shortRegistrationId | 18-character hash of registration ID (if matched) | Calculated from GivePanel Database |
fundraiserUserId | JustGiving account ID of fundraiser owner | JustGiving |
fundraiserFirstName | Fundraiser’s first name | GivePanel Database |
fundraiserLastName | Fundraiser’s last name | GivePanel Database |
fundraiserFullName | Fundraiser’s full name | GivePanel Database |
fundraiserEmailAddress | Fundraiser’s email address | GivePanel Database |
fundraisingPageId | Fundraising page ID (campaignID) | GivePanel Database |
fundraisingPageUrl | Fundraising page URL | GivePanel Database |
fundraisingPageTitle | Fundraising page title | GivePanel Database |
fundraisingPageStartDate | Fundraising page start date | GivePanel Database |
fundraisingPageEndDate | Fundraising page end date | GivePanel Database |
fundraisingPageCreatedDate | When fundraising page was created | GivePanel Database |
fundraisingPageTarget | Fundraising target amount | GivePanel Database |
fundraisingPageClaimed | JustGiving page claimed (yes/no) | JustGiving |
amountRaisedNoGiftAid | Amount raised excluding Gift Aid | Calculated from GivePanel Database |
giftAidAmount | Gift Aid amount claimed | Calculated from GivePanel Database |
amountRaisedIncludingGiftAid | Total amount including Gift Aid | Calculated from GivePanel Database |
donorCount | Number of donors | Calculated from GivePanel Database |
giftAidCount | Number of Gift Aid donations | Calculated from GivePanel Database |
averageDonationAmount | Average donation amount | Calculated from GivePanel Database |
averageGiftAidAmount | Average Gift Aid amount | Calculated from GivePanel Database |
selfDonation | Fundraiser made self-donation (yes/no) | Calculated from GivePanel Database |
inMemory | Fundraiser in memory of someone (yes/no) | GivePanel Database |
Payment Transaction Export
You can choose to include as many of these fields in your Payment Transaction export depending on your event and reporting requirements.
Column | Description | Data source |
paymentId | Payment transaction ID | GivePanel Database |
registrationId | GivePanel registration UUID | GivePanel Database |
shortRegistrationId | 18-character hash of registration ID | Calculated from GivePanel Database |
paymentCreatedDate | When payment was created | GivePanel Database |
paymentLastEditedAt | Last payment edit timestamp | GivePanel Database |
paymentStatus | Payment status | GivePanel Database |
ticketPriceAmount | Total ticket price | Calculated from GivePanel Database |
paymentDiscountCode | Discount code used | GivePanel Database |
paymentDiscountAmount | Discount amount | GivePanel Database |
netPaymentAmount | Payment amount after discount | Calculated from GivePanel Database |
vatPaymentAmount | VAT amount on payment | Calculated from GivePanel Database |
grossPaymentAmount | Total payment amount | Calculated from GivePanel Database |
currency | Payment currency | GivePanel Database |
paymentMethod | Payment method used | GivePanel Database |
numberOfTickets | Number of tickets purchased | GivePanel Database |
refundDate | When payment was refunded | GivePanel Database |
refundAmount | Refund amount | GivePanel Database |
Team Registration Export
You can choose to include as many of these fields in your Team Registration export depending on your event and reporting requirements.
Column | Description | Data source |
teamId | Team ID | GivePanel Database |
teamCreatedDate | When team was created | GivePanel Database |
teamName | Team name | GivePanel Database |
teamCaptainId | Team captain’s ID | GivePanel Database |
shortTeamCaptainRegistrationId | Short hash of team captain’s registration ID | Calculated from GivePanel Database |
teamStatus | Team status | GivePanel Database |
teamMembers | Number of team members | Calculated from GivePanel Database |
teamFundraisingPageId | Team fundraising page ID | GivePanel Database |
teamFundraisingPageUrl | Team fundraising page URL | GivePanel Database |
teamFundraisingPageTitle | Team fundraising page title | GivePanel Database |
teamFundraisingPageTarget | Team fundraising target | GivePanel Database |
teamAmountRaisedNoGiftAid | Team amount raised excluding Gift Aid | Calculated from GivePanel Database |
teamGiftAidAmount | Team Gift Aid amount | Calculated from GivePanel Database |
teamAmountRaisedIncludingGiftAid | Team total amount including Gift Aid | Calculated from GivePanel Database |
teamDonorCount | Team donor count | Calculated from GivePanel Database |
teamGiftAidCount | Team Gift Aid count | Calculated from GivePanel Database |
teamAverageDonationAmount | Team average donation amount | Calculated from GivePanel Database |
teamAverageGiftAidAmount | Team average Gift Aid amount | Calculated from GivePanel Database |
Dashboard Export
You can choose to include as many of these fields in your Dashboard export depending on your event and reporting requirements.
Column | Description | Data source |
eventId | GivePanel event/campaign ID | GivePanel Database |
eventName | Event/campaign name | GivePanel Database |
eventStartDate | Event start date | GivePanel Database |
eventEndDate | Event end date | GivePanel Database |
eventCategory | Event category | GivePanel Database |
eventType | Event type | GivePanel Database |
eventParticipantTarget | Participant target | GivePanel Database |
eventFundraisingTarget | Fundraising target | GivePanel Database |
formId | Form ID | GivePanel Database |
formName | Form name | GivePanel Database |
formType | Form type/focus | GivePanel Database |
formUrl | Form URL | GivePanel Database |
justGivingEventId | JustGiving event ID | JustGiving |
justGivingCampaignName | JustGiving campaign slug | JustGiving |
registrations | Total number of registrations | Calculated from GivePanel Database |
fundraisersCreated | Number of fundraisers created | Calculated from GivePanel Database |
activeFundraisers | Number of active fundraisers | Calculated from GivePanel Database |
donationCount | Total number of donations | Calculated from GivePanel Database |
giftAidCount | Total Gift Aid count | Calculated from GivePanel Database |
payments | Total number of payments | Calculated from GivePanel Database |
teams | Total number of teams | Calculated from GivePanel Database |
amountRaisedNoGiftAid | Total amount raised excluding Gift Aid | Calculated from GivePanel Database |
giftAidAmount | Total Gift Aid amount | Calculated from GivePanel Database |
totalAmountRaisedWithGiftAid | Total amount including Gift Aid | Calculated from GivePanel Database |
donationsPerActiveFundraiser | Average donations per active fundraiser | Calculated from GivePanel Database |
averageRaisedAllFundraisers | Average raised across all fundraisers | Calculated from GivePanel Database |
averageRaisedActiveFundraisers | Average raised by active fundraisers | Calculated from GivePanel Database |
averageRaisedTeams | Average raised by teams | Calculated from GivePanel Database |
ticketPriceAmount | Total ticket price amount | Calculated from GivePanel Database |
totalDiscountAmount | Total discount amount | Calculated from GivePanel Database |
netPaymentAmount | Total net payment amount | Calculated from GivePanel Database |
vatPaymentAmount | Total VAT amount | Calculated from GivePanel Database |
grossPaymentAmount | Total gross payment amount | Calculated from GivePanel Database |
marketingOptingRate | Marketing opt-in rate | Calculated from GivePanel Database |
justGivingClaimRate | JustGiving claim rate | Calculated from GivePanel Database |
registrationsToFundraisersCreatedRate | Conversion rate: registrations to fundraisers | Calculated from GivePanel Database |
registrationsToActiveFundraiserRate | Conversion rate: registrations to active fundraisers | Calculated from GivePanel Database |
fundraisersCreatedToActiveRate | Conversion rate: fundraisers created to active | Calculated from GivePanel Database |
totalTicketsSold | Total tickets sold | Calculated from GivePanel Database |
refundsIssued | Number of refunds issued | Calculated from GivePanel Database |
refundAmount | Total refund amount | Calculated from GivePanel Database |
totalDiscountCodesUsed | Total discount codes used | Calculated from GivePanel Database |
selfDonations | Number of self-donations | Calculated from GivePanel Database |