Reporting: Fields glossary

Clear and accurate reporting is essential for understanding supporter behavior, measuring performance, and maintaining clean records across fundraising activity. Reliable data supports better decision-making, stronger donor relationships, and long-term organizational impact.

Funraisin’s data exports make it possible to access detailed information across areas such as Donations, Fundraisers, and Transactions. Each export includes a range of available fields that can be selected depending on reporting needs.

This article provides a glossary of available reporting fields to support accurate and consistent data exports.

Transactions

Transaction Info

add remove

Field Value	Label	Description
transaction_id	TransactionID	Unique transaction identifier in the database; not visible in the admin unless you hover over a transaction
crm_transaction_id	External CRM ID	ID used in the charity's CRM to refer to this transaction
related_transaction_id	Related Transaction ID (refunds)	If a refund has been made, this field shows the ID of the transaction that processed the refund
transaction_value	Transaction Value	Full amount paid, including fees
transaction_tax	Transaction Tax	Tax on the transaction, calculated when the transaction record is created and based on the platform's tax settings
payment_type	Payment Method	How payment was made, e.g., credit card, PayPal, EFT, Link, etc.
payment_reference	Payment Reference	Payment processor reference, e.g., ch_1CQ7CyDxBFae0ZN4AuOfEoTd
po_number	Po Number	Number printed on the receipt, e.g., REG471
date_created	Transaction Date	Date the transaction was made
transaction_type	Transaction Type	Shows what the payment was for, e.g., a donation, registration, or ticket purchase
optin_fee	Optional Contribution	Optional contribution amount paid by the user, if any
gateway_fee	Gateway Fee	Fee paid to the payment processor, e.g., Stripe or PayPal
mandatory_fee	Mandatory Fee	If using a fixed fee model, this shows the amount paid to Funraisin for this transaction
net_amount	Net Amount (Total - Fees)	Amount the charity receives (transaction value - gateway fee - mandatory fee/optional contribution)
email	Email Address	Payee email address; the payee could be the donor, entrant, ticket purchaser, etc.
first_name	First Name	Payee first name
last_name	Last Name	Payee last name
address_unit	Unit	Payee unit number
address_number	Street Number	Payee street number
address_street	Street Name / Address Line 1	Payee street name/street address
address_2	Address Line 2	Payee street address line 2
address_suburb	Suburb	Payee suburb
address_pcode	Postcode	Payee postcode/postal/ZIP code
address_state	State	Payee state/province
address_country	Country	Payee country
phone_home	Phone (Home)	Payee home phone
phone_mobile	Phone (Mobile)	Payee mobile phone
currency	Currency	Currency the transaction was made in, e.g., AUD, EUR, GBP, USD, etc.
currency_rate	Currency Rate	Exchange rate for the currency at the time of the transaction
gl_code1	GL Code 1	First GL code assigned to an event/page and used to help identify where a transaction is made on the site
gl_code2	GL Code 2	Second GL code assigned to an event/page and used to help identify where a transaction is made on the site
charity_name	Charity Name (multi-charity)	Name of the charity this transaction is assigned to (if using multi-charity)

Payout Info (if applicable)

add remove

Field Value	Label	Description
payout_id	Payout Reference	Stripe reference for the payout this transaction will be a part of
payout_date	Payout Date	Date for the payout this transaction will be a part of
payout_status	Payout Status	Status of the payout this transaction will be a part of

Donor Info (if applicable)

add remove

Field Value	Label	Description
donation_id	DonationID	Unique donation identifier in the database
crm_donation_id	Donation CRM ID	Unique CRM identifier for the donation
is_donation	Is Donation	Indicates whether the transaction is considered a donation; returns Y for transactions that are deemed donations
d_amount	Donation Amount	Full amount donated, including all fees
payment_type	Payment Method	How payment was made, e.g., credit card, PayPal, EFT, Link, etc.
payment_reference	Payment Reference	Payment processor reference, e.g., ch_1CQ7CyDxBFae0ZN4AuOfEoTd
stripe_fee	Gateway Fee	Fee paid to the online payment processor, e.g., Stripe or PayPal
optin_fee	Optional Contribution	Optional contribution amount paid by the user, if any
date_paid	Payment Date	Date the donation was made
donation_type	Donation Type	Type of donation, e.g., sponsorship or personal
d_title	Title	Donor title, e.g., Mr., Mrs., Miss, etc.
d_fname	First Name	Donor first name
d_lname	Last Name	Donor last name
d_lname_prefix	Last Name Prefix	Donor last name prefix
d_email	Email Address	Donor email address
is_fundraiser_email	Is Fundraiser Email	Indicates whether the donor is also a fundraiser/entrant in an event
d_gender	Gender	Donor gender
d_dob	DOB	Donor DOB
d_phone_home	Phone (Home)	Donor home phone
d_phone_mobile	Mobile	Donor mobile
d_address_unit	Unit	Donor unit
d_address_number	Street Number	Donor street number
d_address_street	Street Name / Address Line 1	Donor street name or address line 1
d_address_2	Address Line 2	Donor address line 2
d_address_suburb	Suburb	Donor suburb
d_address_pcode	Postcode	Donor postcode/postal/ZIP code
d_address_state	State	Donor state/province
d_address_country	Country	Donor country
d_address_street_number_unit	Unit + Number + Street	Donor unit, number, and street in one field
d_organisation	Company	Donor company/organization
ecard_first_name	eCard First Name	First name of the eCard recipient (Email Card)
ecard_last_name	eCard Last Name	Last name of the eCard recipient (Email Card)
ecard_email	eCard Email	Email address of the eCard recipient (Email Card)
ecard_address	eCard Address	Address of the eCard recipient (Email Card)
ecard_comments	eCard Message	eCard message to the recipient
in_memory	In Memory	Indicates whether the page is an In Memory page; returns Y or N
in_memory_title	In Memory/Celebration Title	Title of the person the donation is in memory or celebration of
in_memory_fname	In Memory/Celebration First Name	First name of the person the donation is in memory or celebration of
in_memory_lname	In Memory/Celebration Last Name	Last name of the person the donation is in memory or celebration of
in_memory_email	In Memory Email	Email address of the person the donation is in memory of
in_memory_address1	In Memory Address 1	Address line 1 of the person the donation is in memory of
in_memory_address2	In Memory Address 2	Address line 2 of the person the donation is in memory of
date_created	Date Created	Date the donation record was created
last_updated	Last Updated	Date the donation record was last updated
po_number	Po Number	Number printed on the receipt, e.g., REG471
d_optin	Marketing Optin	Marketing communication opt-in
d_optin_sms	Optin (SMS)	Marketing communication opt-in specifically for SMS communications
d_optin_email	Optin (Email)	Marketing communication opt-in specifically for email communications
d_optin_post	Optin (Post)	Marketing communication opt-in specifically for postal communications
d_optin_phone	Optin (Phone)	Marketing communication opt-in specifically for phone communications
gift_aid	Gift Aid	Indicates whether Gift Aid applies; a UK charity can claim 25% of the donation value from the government
card_name	Card Name	Name on the credit card used to process the transaction
card_type	Card Type	Type of credit card used to make the purchase, e.g., Visa, Mastercard, etc.
utm_campaign	UTM Campaign	UTM campaign tag value associated with the record
utm_source	UTM Source	UTM source tag value associated with the record
utm_medium	UTM Medium	UTM medium tag value associated with the record
utm_content	UTM Content	UTM content tag value associated with the record
utm_term	UTM Term	UTM term tag value associated with the record
donor_ip	IP Address	Donor's IP address
donor_lat_lng	Lat/Long Location	Latitude and longitude coordinates of the donor

Member Info (if applicable)

add remove

Field Value	Label	Description
member_id	MemberID	Unique member identifier in the database
crm_member_id	Member CRM ID	Unique CRM identifier for the member
crm_history_id	Member Event CRM ID	Unique CRM identifier for the member event entry
member_type	Member Type	Can be set in the entry form/registration flow, e.g., Captain, Co-driver, etc.
m_title	Title	Member/fundraiser/participant/entrant title, e.g., Mr., Mrs., Miss, etc.
m_fname	First Name	Member first name
m_lname	Last Name	Member last name
m_lname_prefix	Last Name Prefix	Member last name prefix
m_name_alt	Display Name	Member's alternate name displayed on their fundraising page
m_email	Email Address	Member email address
m_username	Username	Member username; forms part of their page URL
m_company	Company	Member company/organization
m_position	Position	Member's position within their organization, e.g., CEO, Partner, General Manager
m_status	Status	Status of the member profile: 0 = Draft, 1 = Live, 2 = Archived
m_gender	Gender	Member gender
m_dob	DOB	Member DOB
m_phone_home	Phone (Home)	Member home phone
m_phone_mobile	Mobile	Member mobile phone
m_address_unit	Unit	Member unit number
m_address_number	Street Number	Member street number
m_address_street	Street Name / Address Line 1	Member street name or address line 1
m_address_2	Address Line 2	Member address line 2; used when the platform setting is Address Line 1, Address Line 2
m_address_suburb	Suburb	Member suburb, parish, city, town, etc.
m_address_pcode	Postcode	Member postcode/postal/ZIP code
m_address_state	State	Member state/province/county
m_address_country	Country	Member country
kw_address	Google Address Lookup	Result of Google lookup (also usable for all lookups)
m_address_street_number_unit	Unit + Number + Street	Member unit number, street number, and street in one field
date_created	Date Account Created	Date the member first created an account for the charity on the platform
date_registered	Date Registered (Event)	Date the member registered for a particular event
in_team	In Team	Participating as part of a team
is_active	Is Active	Marked as active in the event
is_complete	Is Complete	Has completed the full entry process
is_paid	Has Paid	Has paid the registration or entry fee
total_paid	Total Paid	Total amount paid to the charity, including entry, registration, donations, merchandise, ticket purchases, etc.
total_paid_entry	Total Paid Entry	Amount paid as an entry or registration fee
total_paid_merchandise	Total Paid Merchandise	Amount paid for merchandise, e.g., T-shirt or eCard, etc.
total_paid_ticket	Total Paid Promo Code	Amount paid with a promo code, e.g., a discount or free entry
total_paid_donation	Total Paid Donation	Amount paid as a donation
m_target	Fundraising Target	Default or self-created fundraising target
m_target_distance	Distance Target	Default or self-created distance (km/m) target
fundraiser_url	Fundraiser URL	Unique URL for a fundraiser's page where sponsors can donate
personal_donation	Personal Donation	Indicates whether a personal donation has been made; returns the donation value or is blank
last_logged_in	Last Logged In	Date and time the member last logged in to their account
m_photo	Photo	Indicates whether the member has added a photo to their fundraising page; returns Y or 0
m_optin	Optin	Indicates whether the member has opted in to receive marketing communications; returns Y or 0
in_memory_name	In Memory/Celebration Name	Name of the person the funds are being raised in memory or celebration of
in_memory_next_of_kin	Is Next of Kin	Indicates whether the person setting up the In Memory/Celebration page is the next of kin of the person the funds are being raised in memory of; returns Y or 0
in_memory_relationship	In Memory/Celebration Relationship	Relationship of the person setting up the In Memory/Celebration page to the person the funds are being raised in memory or celebration of, e.g., husband, mother, sister, etc.
m_emergency_contact	Emergency Contact First	Emergency contact first name
m_emergency_contact_alt	Emergency Contact Last	Emergency contact last name
m_emergency_phone	Emergency Contact Phone	Emergency contact phone number
m_medical_conditions	Has Medical Condition	Indicates whether the member has a medical condition; returns Y or 0
m_medical_conditions_text	Medical Conditions	List of medical conditions

Event Info (if applicable)

add remove

Field Value	Label	Description
event_id	EventID	Unique event identifier in the database
crm_event_id	Event CRM ID	Unique CRM identifier for the event
event_code	Event Code	Unique database identifier for the event
event_name	Event Name	Name of the event as stated in the platform
event_type	Event Type	Indicates whether the event is an Online, Offline, or DIY event
event_date	Event Date	Date the event will take place, if held on a particular day
event_time	Event Time	Time the event will take place, if held at a particular time
event_expiry	Event End Date	Date the event will end, if it has a specified end date
event_expiry_time	Event End Time	Time the event will end, if it has a specified end time
event_location	Event Location	Location of the event, if applicable; not all events have these details set in the admin
event_number	Event Address Street Number	Street number of the event, if held at a particular location
event_street	Event Address Street	Street address of the event, if held at a particular location
event_city	Event Address City	City where the event is taking place, if held at a particular location
event_suburb	Event Address Suburb	Suburb where the event is taking place, if held at a particular location, e.g., suburb, parish, city, town, etc.
event_postcode	Event Address Postcode	Postcode/postal/ZIP code of the event, if held at a particular location
event_state	Event Address State	State/province/county of the event, if held at a particular location
event_country	Event Address Country	Country of the event, if held at a particular location
total_event_raised	Total Event Raised	Total amount raised for this particular event
diy_category	DIY Category	Category of DIY event the event is part of, e.g., giving something up or requesting donations instead of birthday gifts

Sale Info (if applicable)

add remove

Field Value	Label	Description
sale_id	SaleID	Unique sale identifier in the database
crm_sale_id	Sale CRM ID	Unique CRM identifier for the sale
sale_first_name	First Name	Purchaser's first name
sale_last_name	Last Name	Purchaser's last name
sale_email	Email	Purchaser's email address

Page Info (if applicable)

add remove

Field Value	Label	Description
page_id	PageID	Unique page identifier in the database
crm_page_id	Page CRM ID	Unique CRM identifier for the page
page_name	Page Name	Name of the page as set in the page settings in the admin

Multi-Charity (if applicable)

add remove

Field Value	Label	Description
charity_id	Charity ID	The ID of the charity this record is assigned to (if using multi-charity)
charity_name	Charity Name	The name of the charity this record is assigned to (if using multi-charity)

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Donations

Donor Info

add remove

Field Value	Label	Description
donation_id	DonationID	Unique donation identifier in the database
crm_donation_id	Donation CRM ID	Unique CRM identifier for the donation
is_donation	Is Donation	Indicates whether the transaction is considered a donation; returns Y for transactions that are deemed donations
gift_aid	Gift Aid	Indicates whether Gift Aid applies; a UK charity can claim 25% of the donation value from the government
d_receipt	Receipt As	Type of receipt sent (Personal or Business)
d_amount	Donation Amount	Full amount donated, including all fees
d_amount_local	Donation Amount (Local Currency)	If using multiple currencies and d_amount_local is set, this field returns the local currency donation amount
d_currency	Currency	Currency the transaction was made in, e.g., AUD, EUR, GBP, USD, etc.
d_refund_amount	Refund Amount	Amount refunded for this donation
d_status	Payment Status	Status of the donation, e.g., Paid or Refund
payment_type	Payment Method	How payment was made, e.g., credit card, PayPal, EFT, Link, etc.
payment_reference	Payment Reference	Payment processor reference, e.g., ch_1CQ7CyDxBFae0ZN4AuOfEoTd
stripe_fee	Stripe Fee	Fee paid to the online payment processor, e.g., Stripe or PayPal
optin_fee	Optional Contribution	Optional contribution amount paid by the user, if any
net_amount	Net Amount	Amount the charity receives (transaction value - gateway fee - mandatory fee/optional contribution)
date_paid	Payment Date	Date the donation was made
donation_type	Donation Type	Type of donation, e.g., sponsorship or personal
donation_frequency	Donation Frequency	How often a recurring donation is processed, e.g., weekly, monthly, or yearly
d_title	Title	Donor title, e.g., Mr., Mrs., Miss, etc.
d_fname	First Name	Donor first name
d_lname	Last Name	Donor last name
d_lname_prefix	Last Name Prefix	Donor last name prefix
d_email	Email Address	Donor email address
is_fundraiser_email	Is Fundraiser Email	Indicates whether the donor is also a fundraiser/entrant in an event
d_gender	Gender	Donor gender
d_dob	DOB	Donor date of birth
d_phone_home	Phone (Home)	Donor home phone
d_phone_mobile	Mobile	Donor mobile phone
d_address_unit	Unit	Donor unit number
d_address_number	Street Number	Donor street number
d_address_street	Street Name / Address Line 1	Donor street name or address line 1
d_address_suburb	Suburb	Donor suburb
d_address_2	Address Line 2	Donor address line 2
d_address_pcode	Postcode	Donor postcode/postal/ZIP code
d_address_state	State	Donor state/province
d_address_country	Country	Donor country
d_address_street_number_unit	Unit + Number + Street	Donor unit, number, and street in one field
kw_address	Google Address Lookup	Result of Google address lookup (also usable for all lookups)
d_organisation	Company	Donor company/organization
ecard_first_name	eCard First Name	First name of the eCard recipient (Email Card)
ecard_last_name	eCard Last Name	Last name of the eCard recipient (Email Card)
ecard_email	eCard Email	Email address of the eCard recipient (Email Card)
ecard_address	eCard Address	Address of the eCard recipient (Email Card)
ecard_comments	eCard Message	eCard message to the recipient
in_memory	In Memory	Indicates whether the donation is in memory of someone
in_memory_title	In Memory/Celebration Title	Title of the person the donation is in memory or celebration of
in_memory_fname	In Memory/Celebration First Name	First name of the person the donation is in memory or celebration of
in_memory_lname	In Memory/Celebration Last Name	Last name of the person the donation is in memory or celebration of
in_memory_email	In Memory Email	Email address of the person the donation is in memory of
in_memory_address1	In Memory Address 1	Address line 1 of the person the donation is in memory of
in_memory_address2	In Memory Address 2	Address line 2 of the person the donation is in memory of
date_created	Date Created	Date the donation record was created
last_updated	Last Updated	Date the donation record was last updated
po_number	Po Number	Number printed on the receipt, e.g., REG471
d_optin	Marketing Optin	Marketing communication opt-in
d_optin_sms	Optin (SMS)	Marketing communication opt-in specifically for SMS communications
d_optin_email	Optin (Email)	Marketing communication opt-in specifically for email communications
d_optin_post	Optin (Post)	Marketing communication opt-in specifically for postal communications
d_optin_phone	Optin (Phone)	Marketing communication opt-in specifically for phone communications
card_name	Card Name	Name on the credit card used to process the transaction
card_type	Card Type	Type of credit card used to make the purchase, e.g., Visa, Mastercard, etc.
d_anonymous	Is Anonymous	Indicates whether the donation displays as anonymous to the public
d_display_name	Display Name	Alternate donor name displayed to the public
display_on	Display On Page	Indicates whether the donation displays on a public fundraising page
d_leave_message	Leave Message	Indicates whether the donor wants to leave a message
d_comments	Message	Content of the message left by the donor
utm_campaign	UTM Campaign	UTM campaign tag value associated with the record
utm_source	UTM Source	UTM source tag value associated with the record
utm_medium	UTM Medium	UTM medium tag value associated with the record
utm_content	UTM Content	UTM content tag value associated with the record
utm_term	UTM Term	UTM term tag value associated with the record
donor_ip	IP Address	Donor's IP address
donor_lat_lng	Lat/Long Location	Latitude and longitude coordinates of the donor

Event Info (if applicable)

add remove

Field Value	Label	Description
event_id	EventID	Unique event identifier in the database
crm_event_id	Event CRM ID	Unique CRM identifier for the event
event_code	Event Code	Unique database identifier for the event
event_name	Event Name	Name of the event as stated in the platform
event_type	Event Type	Type of event, e.g., Online, Offline, or DIY
event_date	Event Date	Date the event will take place, if set for a particular day
event_time	Event Time	Time the event will take place, if set for a particular time
event_expiry	Event End Date	Date the event will end, if set for a particular date
event_expiry_time	Event End Time	Time the event will end, if set for a particular time
event_location	Event Location	Location of the event, if set in the admin
event_number	Event Address Street Number	Street number of the event, if set for a particular location
event_street	Event Address Street	Street address of the event, if set for a particular location
event_city	Event Address City	City where the event is taking place, if set for a particular location
event_suburb	Event Address Suburb	Suburb, parish, city, or town where the event is taking place, if set for a particular location
event_postcode	Event Address Postcode	Postcode/postal/ZIP code of the event, if set for a particular location
event_state	Event Address State	State/province of the event, if set for a particular location
event_country	Event Address Country	Country of the event, if set for a particular location
total_event_raised	Total Event Raised	Total amount raised for the event
diy_category	DIY Category	Category the DIY event belongs to, e.g., giving something up or donations instead of birthday gifts
crm_category_id	DIY CRM ID	Unique CRM identifier for the DIY category
event_status	Event Status	Status of the event the entrant is registered in

Member Info (if applicable)

add remove

Field Value	Label	Description
member_id	MemberID	Unique member identifier in the database
crm_member_id	Member CRM ID	Unique CRM identifier for the member
history_id	Member Event ID	Unique member event entry identifier in the database
crm_history_id	Member Event CRM ID	Unique CRM identifier for the member event entry
member_type	Member Type	Can be set in the entry form/registration flow, e.g., Captain, Co-driver, etc.
m_title	Title	Member/fundraiser/participant/entrant title, e.g., Mr., Mrs., Miss, etc.
m_fname	First Name	Member first name
m_lname	Last Name	Member last name
m_lname_prefix	Last Name Prefix	Member last name prefix
member_name	Full Name	Member's full name
m_email	Email Address	Member email address
m_username	Username	Member username; forms part of their page URL
m_company	Company	Member company/organization
m_position	Position	Member's position within their organization, e.g., CEO, Partner, General Manager
m_status	Status	Status of the member profile: 0 = Draft, 1 = Live, 2 = Archived
m_gender	Gender	Member gender
m_dob	DOB	Member DOB
m_phone_home	Phone (Home)	Member home phone
m_phone_mobile	Mobile	Member mobile phone
m_address_unit	Unit	Member unit number
m_address_number	Street Number	Member street number
m_address_street	Street Name / Address Line 1	Member street name or address line 1
m_address_2	Address Line 2	Member address line 2; used when the platform setting is Address Line 1, Address Line 2
m_address_suburb	Suburb	Member suburb, parish, city, town, etc.
m_address_pcode	Postcode	Member postcode/postal/ZIP code
m_address_state	State	Member state/province/county
m_address_country	Country	Member country
kw_address	Google Address Lookup	Result of Google lookup (also usable for all lookups)
m_address_street_number_unit	Unit + Number + Street	Member unit number, street number, and street in one field
member_date_created	Date Account Created	Date the member first created an account for the charity on the platform
date_registered	Date Registered (Event)	Date registered in a particular event
in_team	In Team	Participating as part of a team
is_active	Is Active	Marked as active in the event
is_complete	Is Complete	Has completed the full entry process
is_paid	Has Paid	Has paid the registration or entry fee
total_paid	Total Paid	Total amount paid to the charity, including entry, registration, donations, merchandise, ticket purchases, etc.
total_paid_entry	Total Paid Entry	Amount paid as an entry or registration fee
total_paid_merchandise	Total Paid Merchandise	Amount paid for merchandise, e.g., T-shirt or eCard, etc.
total_paid_ticket	Total Paid Promo Code	Amount paid with a promo code, e.g., a discount or free entry
total_paid_donation	Total Paid Donation	Amount paid as a donation
m_target	Fundraising Target	Default or self-created fundraising target
m_target_distance	Distance Target	Default or self-created distance (km/m) target
fundraiser_url	Fundraiser URL	Unique URL for a fundraiser's page where sponsors can donate
personal_donation	Personal Donation	Indicates whether a personal donation has been made; returns the donation value or is blank
last_logged_in	Last Logged In	Date and time the member last logged in to their account
m_photo	Photo	Indicates whether the member has added a photo to their fundraising page; returns Y or 0
m_optin	Optin	Indicates whether the member has opted in to receive marketing communications; returns Y or 0
in_memory_name	In Memory/Celebration Name	Name of the person the funds are being raised in memory or celebration of
in_memory_next_of_kin	Is Next of Kin	Indicates whether the person setting up the In Memory/Celebration page is the next of kin of the person the funds are being raised in memory of; returns Y or 0
in_memory_relationship	In Memory/Celebration Relationship	Relationship of the person setting up the In Memory/Celebration page to the person the funds are being raised in memory or celebration of, e.g., husband, mother, sister, etc.
m_emergency_contact	Emergency Contact First	Emergency contact first name
m_emergency_contact_alt	Emergency Contact Last	Emergency contact last name
m_emergency_phone	Emergency Contact Phone	Emergency contact phone number
m_medical_conditions	Has Medical Condition	Indicates whether the member has a medical condition; returns Y or 0
m_medical_conditions_text	Medical Conditions	List of medical conditions

Team Info (if applicable)

add remove

Field Value	Label	Description
team_id	Team ID	Unique team identifier in the database
crm_team_id	Team CRM ID	Unique CRM identifier for the team
team	Team Name	Name of the team as created by the team captain
team_captain_name	Team Captain Name	Name of the team captain
team_url	Team URL	Unique URL based on the team name
t_target	Team Target	Fundraising target set by the team
t_event_date	Team Event Date	Date the team's event will take place
t_event_time	Team Event Time	Time the team's event will take place

Organization Page Info (if applicable)

add remove

Field Value	Label	Description
org_id	Org ID	Unique organization identifier in the database
crm_org_id	Org CRM ID	Unique CRM identifier for the organization
org_name	Org Name	Name of the organization page as created by the captain
org_captain_name	Org Captain Name	Name of the organization page captain
org_url	Org URL	Unique URL based on the organization name
org_target	Org Target	Fundraising target set by the organization

Page Info (if applicable)

add remove

Field Value	Label	Description
page_id	PageID	Unique page identifier in the database
crm_page_id	Page CRM ID	Unique CRM identifier for the page
page_name	Page Name	Name of the page from the page settings in the admin

Multi-charity (if applicable)

add remove

Field Value	Label	Description
charity_id	Charity ID	ID of the charity this record is assigned to (if using multi-charity)
charity_name	Charity Name	Name of the charity this record is assigned to (if using multi-charity)

Payout Info (if applicable)

add remove

Field Value	Label	Description
payout_id	Payout Reference	Stripe reference for the payout this transaction will be a part of
payout_date	Payout Date	Date for the payout this transaction will be a part of
payout_status	Payout Status	Status of the payout this transaction will be a part of

Web Forms

add remove

Field Value	Label	Description
Webform Name	Webform Name	Each field collected in the webform is added to the report as an individual column.

Other

add remove

Field Value	Label	Description
total_donations	Total Donations	Sum of donations for the site

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Events

Event Info

add remove

Field Value	Label	Description
event_id	EventID	Unique event identifier in the database
crm_event_id	Event CRM ID	Unique CRM identifier for the event
event_code	Event Code	Unique database identifier for the event
event_name	Event Name	Name of the event as stated in the platform
event_type	Event Type	Type of event, e.g., Online, Offline, or DIY
event_date	Event Date	Date the event will take place, if set for a particular day
event_time	Event Time	Time the event will take place, if set for a particular time
event_expiry	Event End Date	Date the event will end, if set for a particular date
event_expiry_time	Event End Time	Time the event will end, if set for a particular time
event_location	Event Location	Location of the event, if set in the admin
event_number	Event Address Street Number	Street number of the event, if set for a particular location
event_street	Event Address Street	Street address of the event, if set for a particular location
event_city	Event Address City	City where the event is taking place, if set for a particular location
event_suburb	Event Address Suburb	Suburb, parish, city, or town where the event is taking place, if set for a particular location
event_postcode	Event Address Postcode	Postcode/postal/ZIP code of the event, if set for a particular location
event_state	Event Address State	State/province of the event, if set for a particular location
event_country	Event Address Country	Country of the event, if set for a particular location
total_event_raised	Total Event Raised	Total amount raised for the event
total_entry_fees	Total Entry Fees	Total income from entry fees for the event
total_merchandise	Total Merchandise	Total income from merchandise for the event
total_optin_fees_all	Total Funraisin Fees	Total Funraisin fees (d_fee) from donations for the event
total_optin_fees	Funraisin Fees on Registrations	Total fees on entries from member event records for the event ID (total_paid_fees)
total_optin_fees_donations	Funraisin Fees on Donations	Total transaction fees from transactions that include a donation for the event
gateway_fee	Gateway Fees	Fee paid to the online payment processor, e.g., Stripe or PayPal
diy_category	DIY Category	Category the DIY event belongs to, e.g., giving something up or donations instead of birthday gifts
total_entries	Total Entries	Number of member event records (members_history) for the event, regardless of whether they are active or complete
total_donations	Total Donations	Sum of donations for the site
total_teams	Total Teams	Number of teams in the event
total_active_entries	Total Active Entries	Number of entrants who are active (is_active = Y)
total_complete_entries	Total Complete Entries	Number of entrants who have completed registration (is_complete = Y)
total_incomplete_entries	Total Incomplete Entries	Number of entrants who have not completed registration (is_complete is not Y)
total_tickets	Total Tickets (offline)	Total number of tickets from member event records for the event
total_paid_tickets	Total Paid Tickets (offline)	Total number of tickets from member event records where is_paid = Y for the event
date_created	Date Created	Date the event was created in the admin

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Fundraisers/Members

Member Info

add remove

Field Value	Label	Description
member_id	MemberID	Unique member identifier in the database
crm_member_id	Member CRM ID	Unique CRM identifier for the member
history_id	Member Event ID	Unique member event entry identifier in the database
crm_history_id	Member Event CRM ID	Unique CRM identifier for the member event entry
member_type	Member Type	Can be set in the entry form/registration flow, e.g., Captain, Co-driver, etc.
member_hash	Member Hash	Member's unique hash string, often used for PURLs
m_title	Title	Member/fundraiser/participant/entrant title, e.g., Mr., Mrs., Miss, etc.
m_fname	First Name	Member first name
m_lname	Last Name	Member last name
m_lname_prefix	Last Name Prefix	Member last name prefix
m_name_alt	Display Name	Member's alternate name displayed on their fundraising page
m_email	Email Address	Member email address
m_username	Username	Member username; forms part of their page URL
m_company	Company	Member company/organization
m_position	Position	Member's position within their organization, e.g., CEO, Partner, General Manager
m_status	Status	Is the profile live or in draft mode 0 = Draft 1 = Live 2 = Archived
m_gender	Gender	Member gender
m_dob	DOB	Member DOB
m_phone_home	Phone (Home)	Member home phone
m_phone_mobile	Mobile	Member mobile phone
m_address_unit	Unit	Member unit number
m_address_number	Street Number	Member street number
m_address_street	Street Name / Address Line 1	Member street name or address line 1
m_address_2	Address Line 2	Member address line 2; used when the platform setting is Address Line 1, Address Line 2
m_address_suburb	Suburb	Member suburb, parish, city, town, etc.
m_address_pcode	Postcode	Member postcode/postal/ZIP code
m_address_state	State	Member state/province/county
m_address_country	Country	Member country
kw_address	Google Address Lookup	Result of Google lookup (also usable for all lookups)
m_address_street_number_unit	Unit + Number + Street	Member unit number, street number, and street in one field
date_created	Date Account Created	Date the member first created an account for the charity on the platform
date_registered	Date Registered (Event)	Date registered in a particular event
in_team	In Team	Participating as part of a team
is_active	Is Active	Marked as active in the event
is_complete	Is Complete	Has completed the full entry process
is_paid	Has Paid	Has paid the registration or entry fee
date_paid	Date Paid	Date the entry fee was paid
total_paid	Total Paid	Total amount paid to the charity, including entry, registration, donations, merchandise, ticket purchases, etc.
total_paid_entry	Total Paid Entry	Amount paid as an entry or registration fee
total_paid_merchandise	Total Paid Merchandise	Amount paid for merchandise, e.g., T-shirt or eCard, etc.
total_paid_ticket	Total Paid Promo Code	Amount paid with a promo code, e.g., a discount or free entry
total_paid_donation	Total Paid Donation	Amount paid as a donation
total_paid_fees	Optional Contribution	Optional contribution amount paid by the user, if any
m_target	Fundraising Target	Default or self-created fundraising target
amount_raised	Amount Raised	Entrant's fundraising amount for the event
total_amount_raised	Total Amount Raised	Entrant's lifetime fundraising amount across all events on the site
fundraiser_url	Fundraiser URL	Unique URL for a fundraiser's page where sponsors can donate
fundraiser_url_sms	Shortened URL (SMS)	Shortened unique URL for the fundraiser's page, intended for use in SMS
reset_password_url	Reset Password URL	Entrant's unique URL for resetting their password
personal_donation	Personal Donation	Indicates whether a personal donation has been made; returns the donation value or is blank
last_logged_in	Last Logged In	Date and time the member last logged in to their account
m_photo	Photo	Indicates whether the member has added a photo to their fundraising page; returns Y or 0
m_optin	Optin	Indicates whether the member has opted in to receive marketing communications; returns Y or 0
in_memory_name	In Memory/Celebration Name	Name of the person the funds are being raised in memory or celebration of
in_memory_next_of_kin	Is Next of Kin	Indicates whether the person setting up the In Memory/Celebration page is the next of kin of the person the funds are being raised in memory of; returns Y or 0
in_memory_relationship	In Memory/Celebration Relationship	Relationship of the person setting up the In Memory/Celebration page to the person the funds are being raised in memory or celebration of, e.g., husband, mother, sister, etc.
m_emergency_contact	Emergency Contact First	Emergency contact first name
m_emergency_contact_alt	Emergency Contact Last	Emergency contact last name
m_emergency_phone	Emergency Contact Phone	Emergency contact phone number
m_diet_notes	Dietary Requirements	Entrant's dietary requirements
m_medical_conditions	Has Medical Condition	Indicates whether the member has a medical condition; returns Y or 0
m_medical_conditions_text	Medical Conditions	List of medical conditions
wave	Wave Name	Name of the entrant's selected wave
wave_description	Wave Description	Description of the entrant's selected wave
wave_time	Wave Time	Time of the entrant's selected wave
wave_date	Wave Date	Date of the entrant's selected wave
wave_code	Wave Code	Reporting code of the entrant's selected wave
has_been_invited	Has Been Invited	Indicates whether the entrant was invited to the event during a multi-step sign-up process
invited_by	Invited By	Person who invited the entrant
number_donations	Total Number of Donations	Total number of donations received across all events this person has participated in for the charity
number_event_donations	Number of Donations (Active Event)	Number of donations the participant has received for the active event being reported on
number_events	Number of Events	Number of events the participant has joined for the charity
promo_id	Promo Code	Promo code used for the entry fee
m_shirt_size	Shirt Size	Entrant's shirt size on their fundraising account
bib_number	Bib Number	Bib number assigned to the fundraiser's event entry
utm_campaign	UTM Campaign	UTM campaign tag value associated with the record
utm_source	UTM Source	UTM source tag value associated with the record
utm_medium	UTM Medium	UTM medium tag value associated with the record
utm_content	UTM Content	UTM content tag value associated with the record
utm_term	UTM Term	UTM term tag value associated with the record
activity_lat_lng	Lat/Lng Location	Latitude and longitude coordinates associated with the member activity
activity_useragent	Browser/Useragent	User agent string identifying the user's device and browser
has_fb_fundraiser	Has Facebook Fundraiser	Returns Y if the member's event record has a Facebook fundraiser ID set
fb_fundraiser_page	Facebook Fundraiser Page	Facebook fundraiser page URL when has_fb_fundraiser is Y

Event Info

add remove

Field Value	Label	Description
event_id	EventID	Unique event identifier in the database
crm_event_id	Event CRM ID	Unique CRM identifier for the event
event_code	Event Code	Unique database identifier for the event
event_name	Event Name	Name of the event as stated in the platform
event_type	Event Type	Type of event, e.g., Online, Offline, or DIY
event_date	Event Date	Date the event will take place, if set for a particular day
event_time	Event Time	Time the event will take place, if set for a particular time
event_expiry	Event End Date	Date the event will end, if set for a particular date
event_expiry_time	Event End Time	Time the event will end, if set for a particular time
event_location	Event Location	Location of the event, if set in the admin
event_number	Event Address Street Number	Street number of the event, if set for a particular location
event_street	Event Address Street	Street address of the event, if set for a particular location
event_city	Event Address City	City where the event is taking place, if set for a particular location
event_suburb	Event Address Suburb	Suburb, parish, city, or town where the event is taking place, if set for a particular location
event_postcode	Event Address Postcode	Postcode/postal/ZIP code of the event, if set for a particular location
event_state	Event Address State	State/province of the event, if set for a particular location
event_country	Event Address Country	Country of the event, if set for a particular location
total_event_raised	Total Event Raised	Total amount raised for the event
diy_category	DIY Category	Category the DIY event belongs to, e.g., giving something up or donations instead of birthday gifts
crm_category_id	DIY CRM ID	Unique CRM identifier for the DIY category
event_status	Event Status	Status of the event the entrant is registered in

Team Info

add remove

Field Value	Label	Description
team_id	Team ID	Unique team identifier in the database
crm_team_id	Team CRM ID	Unique CRM identifier for the team
team	Team Name	Name of the team as created by the team captain
is_captain	Is Team Captain	Indicates whether the member is the team captain
team_url	Team URL	Unique URL based on the team name
t_target	Team Target	Fundraising target set by the team
t_event_date	Team Event Date	Date the team's event will take place
t_event_time	Team Event Time	Time the team's event will take place
team_raised	Team Amount Raised	Total amount raised by the team for the event, including amounts raised by individual team members and donations made directly to the team
bib_number	Bib Number	Bib number assigned to the team
team_members	# Team Members	Number of members in the team
team_members_paid	# Paid Team Members	Number of members in the team that are marked as paid
team_members_unpaid	# Unpaid Team Members	Number of members in the team that are not marked as paid
team_members_active	# Active Team Members	Number of members in the team that are marked as active
t_distance	Team Distance Achieved	Total distance achieved by the team
t_duration	Team Duration Achieved (Hours)	Total duration achieved by the team
t_steps	Team Steps Achieved	Total number of steps achieved by the team

Organization Page Info

add remove

Field Value	Label	Description
org_id	Organization Page ID	Unique organization identifier in the database
crm_org_id	Organization Page CRM ID	Unique CRM identifier for the organization
org_name	Organization Page Name	Name of the organization page as created by the captain
is_org_captain	Is Page Captain	Indicates whether the team member is a page captain; returns Y or N
org_url	Organization Page URL	Unique URL based on the organization name
org_target	Organization Page Target	Fundraising target set by the organization
org_captain_name	Organization Page Captain	Name of the organization page captain
org_raised	Org Amount Raised	Total amount raised by the organization and its members
org_distance	Org Distance Achieved	Total distance achieved by the organization
org_duration	Org Duration Achieved (Hours)	Total duration achieved by the organization
org_steps	Org Steps Achieved	Total number of steps achieved by the organization

Interactions

add remove

Field Value	Label	Description
has_added_pic	Has Added Profile Pic	Indicates whether the entrant has added a profile picture to their fundraising page; returns Y or 0
added_blog	Has Added Blog Post	Indicates whether the entrant has added a blog post to their fundraising page; returns Y or 0
has_self_donated	Has Self Donated	Indicates whether the entrant has made a self/personal donation to their fundraising page; returns Y or 0
has_changed_target	Has Changed Fundraising Target	Indicates whether the entrant has changed their fundraising target; returns Y or 0
has_shared_page	Has Shared Page	Indicates whether the entrant has shared their fundraising page; returns Y or 0
has_thanked_donor	Has Thanked Donor	Indicates whether the entrant has thanked their donors; returns Y or 0
has_reached_goal	Has Reached Fundraising Target (At Least Once)	Indicates whether the entrant has reached their fundraising target at least once; returns Y or 0
has_sent_email	Has Sent Get Support Email	Indicates whether the entrant has sent an email asking for support; returns Y or 0
is_attending	Has Checked-in	Indicates whether the entrant has used their QR code to check in; returns Y or 0
date_attending	Check-in Date	Date and time the entrant used their QR code to check in
has_checkedout	Has Checked-out	Indicates whether the entrant has used their QR code to check out; returns Y or 0
date_checkedout	Check-out Date	Date and time the entrant used their QR code to check out

Fitness Related Information

add remove

Field Value	Label	Description
has_fitness_app	Has Fitness App	Indicates whether the fundraiser has connected a fitness app for the event entry
has_strava	Connected Strava	Indicates whether the fundraiser has connected Strava
has_fitbit	Connected Fitbit	Indicates whether the fundraiser has connected Fitbit
has_garmin	Connected Garmin	Indicates whether the fundraiser has connected Garmin
has_mapmyfitness	Connected Mapmyfitness	Indicates whether the fundraiser has connected MapMyFitness
m_target_distance	Distance Target	Default or self-created distance (km/m) target
distance_achieved	Distance Achieved	Entrant's distance recorded for the event
total_distance_achieved	Total Distance Achieved	Entrant's distance recorded across all events
m_target_steps	Steps Target	Default or self-created steps target
steps_achieved	Steps Achieved	Entrant's steps recorded for the event
total_steps_achieved	Total Steps Achieved	Entrant's steps recorded across all events
m_target_duration	Duration Target	Default or self-created duration target
hours_achieved	Hours Achieved	Entrant's duration recorded for the event
total_hours_achieved	Total Hours Achieved	Entrant's duration recorded across all events

Custom Fields

add remove

Field Value	Label	Description
customfield[field_name]	Field Name	Additional information captured or stored against an entrant record

Web Forms

add remove

Field Value	Label	Description
Webform Name	Webform Name	Each field collected in the webform is added to the report as an individual column.

Multi-Charity (if applicable)

add remove

Field Value	Label	Description
charity_id	Charity ID	The ID of the charity this record is assigned to (if using multi-charity)
charity_name	Charity Name	The name of the charity this record is assigned to (if using multi-charity)

Transaction Info

add remove

Field Value	Label	Description
total_paid	Transaction Value	Full amount paid, including fees
tax_ref	Payment Reference	Payment processor reference, e.g., ch_1CQ7CyDxBFae0ZN4AuOfEoTd
po_number	Po Number	Number printed on the receipt, e.g., REG471
date_paid	Transaction Date	Date the transaction was made

Payout Info (if applicable)

add remove

Field Value	Label	Description
payout_id	Payout Reference	Stripe reference for the payout this transaction will be a part of
payout_date	Payout Date	Date for the payout this transaction will be a part of
payout_status	Payout Status	Status of the payout this transaction will be a part of

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Teams

Team Info

add remove

Field Value	Label	Description
team_id	TeamID	Unique team identifier in the database
event_code	Event Code	Unique database identifier for the event
t_name	Team Name	Name of the team as created by the team captain
t_url	Team Url	Unique URL based on the team name
t_target	Team Target	Fundraising target set by the team
t_captain	Team Captain	Name of the team captain
t_raised	Amount Raised	Total amount raised by the team for the event
t_distance	Total Distance	Total distance achieved by the team
t_steps	Total Steps	Total number of steps achieved by the team
t_duration	Total Duration	Total duration achieved by the team
date_created	Date Created	Date the team was created
number_members	# Members	Number of members in the team
number_paid_members	# Paid Members	Number of members in the team that are marked as paid
number_active_members	# Active Members	Number of members in the team that are marked as active
number_complete_members	# Complete Members	Number of members in the team that are marked as complete
bib_number	Bib Number	Bib number assigned to the team
t_status	Status	Status of the team: 0 = Draft, 1 = Live, 2 = Archived

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Organizations

Organization Info

add remove

Field Value	Label	Description
org_id	Organisation Page ID	Unique organization identifier in the database
crm_org_id	CRM ID	Unique CRM identifier for the organization
org_name	Organisation Page Name	Name of the organization page as created by the captain
org_url	Organisation Page Url	Unique URL based on the organization name
org_address_street	Street Address	Organization address line 1
org_adddress_2	Street Address 2	Organization address line 2
org_address_suburb	Suburb	Organization suburb
org_address_pcode	Postcode	Organization postcode/postal/ZIP code
org_address_state	State	Organization state/province
org_address_country	Country	Organization country
org_target	Organisation Page Target	Fundraising target set by the organization
org_captain	Organisation Page Captain	Name of the organization page captain
org_raised	Amount Raised	Total amount raised by the organization and its members
date_created	Date Created	Date the organization page was created
number_members	# Members	Number of members in the organization
number_paid_members	# Paid Members	Number of members in the organization that are marked as paid
number_active_members	# Active Members	Number of members in the organization that are marked as active
number_complete_members	# Complete Members	Number of members in the organization that are marked as complete
org_status	Status	Status of the organization: 0 = Draft, 1 = Live, 2 = Archived

Event Info

add remove

Field Value	Label	Description
event_id	EventID	Unique event identifier in the database
crm_event_id	Event CRM ID	Unique CRM identifier for the event
event_code	Event Code	Unique database identifier for the event
event_name	Event Name	Name of the event as stated in the platform
event_type	Event Type	Type of event, e.g., Online, Offline, or DIY
event_date	Event Date	Date the event will take place, if set for a particular day
event_time	Event Time	Time the event will take place, if set for a particular time
event_expiry	Event End Date	Date the event will end, if set for a particular date
event_expiry_time	Event End Time	Time the event will end, if set for a particular time
event_location	Event Location	Location of the event, if set in the admin
event_number	Event Address Street Number	Street number of the event, if set for a particular location
event_street	Event Address Street	Street address of the event, if set for a particular location
event_city	Event Address City	City where the event is taking place, if set for a particular location
event_suburb	Event Address Suburb	Suburb, parish, city, or town where the event is taking place, if set for a particular location
event_postcode	Event Address Postcode	Postcode/postal/ZIP code of the event, if set for a particular location
event_state	Event Address State	State/province of the event, if set for a particular location
event_country	Event Address Country	Country of the event, if set for a particular location
total_event_raised	Total Event Raised	Total amount raised for the event
diy_category	DIY Category	Category the DIY event belongs to, e.g., giving something up or donations instead of birthday gifts
crm_category_id	DIY CRM ID	Unique CRM identifier for the DIY category
event_status	Event Status	Status of the event the entrant is registered in

Captain Info

add remove

Field Value	Label	Description
member_id	Member ID	Unique member identifier in the database
crm_member_id	CRM Member ID	Unique CRM identifier for the member
m_fname	First Name	Member first name
m_lname	Last Name	Member last name
m_email	Email	Member email address
m_phone_mobile	Mobile	Member mobile phone

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Ticketholders

Ticketholder Info

add remove

Field Value	Label	Description
guest_id	GuestID	Unique guest identifier in the database
crm_guest_id	Guest CRM ID	Unique CRM identifier for the guest
related_member_id	Related Member ID	Unique member identifier in the database relating to the ticket holder
g_fname	First Name	Guest first name
g_lname	Last Name	Guest last name
g_email	Email	Guest email address
g_phone	Phone	Guest phone number
g_notes	Notes	Guest notes
g_dob	DOB	Guest date of birth
g_gender	Gender	Guest gender
g_company	Company	Guest company
g_emergency_contact	Emergency Contact First Name	Emergency contact first name for the guest
g_emergency_contact_alt	Emergency Contact Last Name	Emergency contact last name for the guest
g_emergency_phone	Emergency Contact Phone	Emergency contact phone number for the guest
g_emergency_contact_type	Emergency Contact Type	Emergency contact type for the guest
g_shirt_size	Shirt Size	Guest shirt size
wave_name	Wave	Name of the guest's selected wave
ticket_name	Ticket	Name of the ticket assigned to the guest
bib_number	Bib Number	Bib number assigned to the guest

Related Fundraiser Info

add remove

Field Value	Label	Description
related_member_id	Member ID	Unique member identifier in the database relating to the ticket holder
related_m_target	Fundraising Target	Default or self-created fundraising target for the related fundraiser
related_m_target_distance	Distance Target	Default or self-created distance target for the related fundraiser
related_m_target_duration	Duration Target	Default or self-created duration target for the related fundraiser
related_m_target_steps	Step Target	Default or self-created step target for the related fundraiser
related_m_raised	Amount Raised	Amount raised by the related fundraiser
related_distance_achieved	Distance Achieved	Distance achieved by the related fundraiser
related_steps_achieved	Steps Achieved	Number of steps achieved by the related fundraiser
related_duration_achieved	Duration Achieved (hrs)	Duration achieved by the related fundraiser

Event Info

add remove

Field Value	Label	Description
event_id	EventID	Unique event identifier in the database
crm_event_id	Event CRM ID	Unique CRM identifier for the event
event_code	Event Code	Unique database identifier for the event
event_name	Event Name	Name of the event as stated in the platform
event_type	Event Type	Type of event, e.g., Online, Offline, or DIY
event_date	Event Date	Date the event will take place, if set for a particular day
event_time	Event Time	Time the event will take place, if set for a particular time
event_expiry	Event End Date	Date the event will end, if set for a particular date
event_expiry_time	Event End Time	Time the event will end, if set for a particular time
event_location	Event Location	Location of the event, if set in the admin
event_number	Event Address Street Number	Street number of the event, if set for a particular location
event_street	Event Address Street	Street address of the event, if set for a particular location
event_city	Event Address City	City where the event is taking place, if set for a particular location
event_suburb	Event Address Suburb	Suburb, parish, city, or town where the event is taking place, if set for a particular location
event_postcode	Event Address Postcode	Postcode/postal/ZIP code of the event, if set for a particular location
event_state	Event Address State	State/province of the event, if set for a particular location
event_country	Event Address Country	Country of the event, if set for a particular location

Web Forms

add remove

Field Value	Label	Description
Webform Name	Webform Name	Each field collected in the webform is added to the report as an individual column.

Custom Fields

add remove

Field Value	Label	Description
customfield[field_name]	Field name	Additional information captured or stored against an entrant record

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Offline Entrants

Member Info

add remove

Field Value	Label	Description
member_id	MemberID	Unique member identifier in the database
crm_member_id	Member CRM ID	Unique CRM identifier for the member
history_id	Member Event ID	Unique member event entry identifier in the database
crm_history_id	Member Event CRM ID	Unique CRM identifier for the member event entry
m_title	Title	Member/fundraiser/participant/entrant title, e.g., Mr., Mrs., Miss, etc.
m_fname	First Name	Member first name
m_lname	Last Name	Member last name
m_lname	Last Name Prefix	Member last name prefix
m_email	Email Address	Member email address
m_username	Username	Member username; forms part of their page URL
m_company	Company	Member company/organization
m_position	Position	Member's position within their organization, e.g., CEO, Partner, General Manager
m_status	Status	Is the profile live or in draft mode 0 = Draft 1 = Live 2 = Archived
m_gender	Gender	Member gender
m_dob	DOB	Member date of birth
m_phone_home	Phone (Home)	Member home phone
m_phone_mobile	Mobile	Member mobile phone
m_address_unit	Unit	Member unit number
m_address_number	Street Number	Member street number
m_address_street	Street Name / Address Line 1	Member street name or address line 1
m_address_2	Address Line 2	Member address line 2; used when the platform setting is Address Line 1, Address Line 2
m_address_suburb	Suburb	Member suburb, parish, city, town, etc.
m_address_pcode	Postcode	Member postcode/postal/ZIP code
m_address_state	State	Member state/province/county
m_address_country	Country	Member country
kw_address	Google Address Lookup	Result of Google lookup (also usable for all lookups)
m_address_street_number_unit	Unit + Number + Street	Member unit number, street number, and street in one field
date_created	Date Account Created	Date the member first created an account for the charity on the platform
date_registered	Date Registered (Event)	Date registered in a particular event
is_active	Is Active	Marked as active in the event
is_complete	Is Complete	Has completed the full entry process
is_paid	Has Paid	Has paid the registration or entry fee
number_tickets	Total Tickets	Number of tickets purchased
number_tables	Total Tables	Number of tables purchased
total_paid	Total Paid	Total amount paid to the charity, including entry, registration, donations, merchandise, ticket purchases, etc.
total_paid_entry	Total Paid Entry	Amount paid as an entry or registration fee
total_paid_merchandise	Total Paid Merchandise	Amount paid for merchandise, e.g., T-shirt or eCard, etc.
total_paid_ticket	Total Paid Promo Code	Amount paid with a promo code, e.g., a discount or free entry
total_paid_donation	Total Paid Donation	Amount paid as a donation
total_paid_fees	Optional Contribution	Optional contribution amount paid by the user, if any
tax_ref	Payment Reference	Payment processor reference, e.g., ch_xxx
po_number	Po Number	Number printed on the receipt, e.g., REG471
last_logged_in	Last Logged In	Date and time the member last logged in to their account
m_photo	Photo	Indicates whether the member has added a photo to their fundraising page; returns Y or 0
m_optin	Optin	Indicates whether the member has opted in to receive marketing communications; returns Y or 0
m_emergency_contact	Emergency Contact First	Emergency contact first name
m_emergency_contact_alt	Emergency Contact Last	Emergency contact last name
m_emergency_phone	Emergency Contact Phone	Emergency contact phone number
m_diet_notes	Dietary Requirements	Entrant's dietary requirements
m_medical_conditions	Has Medical Condition	Indicates whether the member has a medical condition; returns Y or 0
m_medical_conditions_text	Medical Conditions	List of medical conditions
wave_name	Wave Name	Name of the entrant's selected wave
wave_description	Wave Description	Description of the entrant's selected wave
wave_time	Wave Time	Time of the entrant's selected wave
wave_date	Wave Date	Date of the entrant's selected wave
wave_code	Wave Code	Reporting code of the entrant's selected wave
promo_id	Promo Code	Promo code used for the entry fee
is_attending	Has Checked-in	Indicates whether the entrant has checked in
date_attending	Check-in Date	Date the entrant checked in
has_checkedout	Has Checked-out	Indicates whether the entrant has checked out
date_checkedout	Check-out Date	Date the entrant checked out

Event Info

add remove

Field Value	Label	Description
event_id	EventID	Unique event identifier in the database
crm_event_id	Event CRM ID	Unique CRM identifier for the event
event_code	Event Code	Unique database identifier for the event
event_name	Event Name	Name of the event as stated in the platform
event_type	Event Type	Type of event, e.g., Online, Offline, or DIY
event_date	Event Date	Date the event will take place, if set for a particular day
event_time	Event Time	Time the event will take place, if set for a particular time
event_expiry	Event End Date	Date the event will end, if set for a particular date
event_expiry_time	Event End Time	Time the event will end, if set for a particular time
event_location	Event Location	Location of the event, if set in the admin
event_number	Event Address Street Number	Street number of the event, if set for a particular location
event_street	Event Address Street	Street address of the event, if set for a particular location
event_city	Event Address City	City where the event is taking place, if set for a particular location
event_suburb	Event Address Suburb	Suburb, parish, city, or town where the event is taking place, if set for a particular location
event_postcode	Event Address Postcode	Postcode/postal/ZIP code of the event, if set for a particular location
event_state	Event Address State	State/province of the event, if set for a particular location
event_country	Event Address Country	Country of the event, if set for a particular location

Web Forms

add remove

Field Value	Label	Description
Webform Name	Webform Name	Each field collected in the webform is added to the report as an individual column.

Custom Fields

add remove

Field Value	Label	Description
customfield[field_name]	Field name	Additional information captured or stored against an entrant record

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Raffles

Sale Info

add remove

Field Value	Label	Description
sale_id	SaleID	Shop sale identifier in the database
crm_sale_id	CRM SaleID	Unique CRM identifier for the sale
first_name	First Name	Purchaser's first name
last_name	Last Name	Purchaser's last name
email	Email	Purchaser's email address
mobile	Mobile	Purchaser's mobile phone number
phone	Phone	Purchaser's phone number
unit	Billing Unit	Purchaser's billing unit number
number	Billing Street Number	Purchaser's billing street number
street	Billing Street	Purchaser's billing street
suburb	Billing Suburb	Purchaser's billing suburb
postcode	Billing Postcode	Purchaser's billing postcode/postal/ZIP code
state	Billing State	Purchaser's billing state/province
country	Billing Country	Purchaser's billing country
total	Total Paid	Total amount the purchaser spent on the tickets
tickets	Tickets	Total number of tickets purchased
date_created	Date Created	Date the purchase was made
utm_campaign	UTM Campaign	UTM campaign tag value associated with the record
utm_source	UTM Source	UTM source tag value associated with the record
utm_medium	UTM Medium	UTM medium tag value associated with the record
utm_content	UTM Content	UTM content tag value associated with the record
utm_term	UTM Term	UTM term tag value associated with the record
optin	Marketing Optin	Marketing communication opt-in preference
optin_text	Marketing Optin Copy	Marketing communication opt-in message
optin_email	Email Optin	Marketing communication opt-in preference for email communications
optin_sms	SMS Optin	Marketing communication opt-in preference for SMS communications
opin_post	Post Optin	Marketing communication opt-in preference for post communications
optin_phone	Phone Optin	Marketing communication opt-in preference for phone communications

Raffle Info

add remove

Field Value	Label	Description
raffle_name	Raffle Name	Name of the raffle
raffle_id	Raffle ID	Raffle sale identifier in the database
crm_raffle_id	Raffle CRM ID	Unique CRM identifier for the raffle

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Shop Sales

Sale Info

add remove

Field Value	Label	Description
sale_id	SaleID	Unique shop sale identifier in the database
crm_sale_id	CRM Sale ID	Unique CRM identifier for the sale
po_number	Po Number	Number printed on the receipt, e.g., REG471
sub_total	Sub Total	Total amount paid for the quantity of the selected product
total	Total Paid	Total amount paid for all products purchased in the transaction
gst	Tax	Tax included in the subtotal of the sale
tax_ref	Payment Reference	Payment processor reference, e.g., ch1CQ7CyDxBFae0ZN4AuOfEoTd
payment_method	Payment Method	How payment was made, e.g., credit card, PayPal, EFT, Link, etc.
quantity	Quantity	Number of units of the product purchased in the transaction
unit_cost	Unit Cost	Cost to manufacture one unit of the product
gst	GST	Tax included in the subtotal of the sale
donation_amount	Optional Donation	Optional donation amount paid by the purchaser, if any
delivery	Delivery Fee	Delivery fee charged for the sale
optin_fees	Optional Contribution Fee	Optional contribution amount paid to Funraisin
stripe_fee	Stripe Fee	Fee paid to the online payment processor, e.g., Stripe or PayPal
card_type	Card Type	Credit card type, e.g., Mastercard or Visa
card_name	Card Name	Name of the credit card holder
promo_id	Promo Code	Promo code used for the sale
date_created	Date of Sale	Date the sale was made
shipped	Is Shipped	Indicates whether the items in the sale have been sent to the purchaser
shipping_ref	Shipping Reference	Reference number the customer can use to track the shipment
shipped_date	Date Shipped	Date the items in the sale were marked as shipped
recipient_first_name	Recipient First Name	First name of the person the eCard is being sent to
recipient_last_name	Recipient Last Name	Last name of the person the eCard is being sent to
recipient_email	Recipient Email	Email address of the person the eCard is being sent to
recipient_comments	Recipient Comments	Message entered by the purchaser and sent to the eCard recipient
recipient_address	Recipient Address	Address of the recipient of a gift

Customer Info

add remove

Field Value	Label	Description
event_name	Event Name	Name of the event as stated in the platform
title	Title	Purchaser's title
first_name	First Name	Purchaser's first name
last_name	Last Name	Purchaser's last name
email	Email	Purchaser's email address
mobile	Mobile	Purchaser's mobile phone number
phone	Phone	Purchaser's phone number
company	Company	Purchaser's company
unit	Billing Unit	Purchaser's billing address unit number
number	Billing Street Number	Purchaser's billing address street number
street	Billing Street	Purchaser's billing address street
street_number_unit	Billing Unit+Number+Street	Purchaser's billing unit number, street number, and street name in one field
suburb	Billing Suburb	Purchaser's billing suburb, parish, city, town, etc.
postcode	Billing Postcode	Purchaser's billing postcode/postal/ZIP code
state	Billing State	Purchaser's billing state/province/county
country	Billing Country	Purchaser's billing country
deliver_to_billing	Deliver to Billing	Indicates whether the purchaser's delivery address is the same as their billing address
delivery_unit	Delivery Unit	Purchaser's delivery address unit number
delivery_number	Delivery Street Number	Purchaser's delivery address street number
delivery_street	Delivery Street Name	Purchaser's delivery address street name
delivery_suburb	Delivery Suburb	Purchaser's delivery suburb, parish, city, town, etc.
delivery_postcode	Delivery Postcode	Purchaser's delivery postcode/postal/ZIP code
delivery_state	Delivery State	Purchaser's delivery state/province/county
delivery_country	Delivery Country	Purchaser's delivery country

Product Info

add remove

Field Value	Label	Description
product_name	Product Name	Name of the product purchased
product_type	Product Type	Type of product purchased, e.g., product or virtual gift
product_category	Product Category	Category assigned to the product purchased
product_code	Product Code (SKU)	SKU of the product purchased
product_cost	Product Cost	Cost to manufacture the product purchased
product_price	Product Price	Price to purchase one unit of the product
product_description	Product Description	Description of the product
crm_product_id	CRM Product ID	Unique CRM identifier for the product
is_donation	Treat as Donation	Indicates whether sales of the product also create a donation record
additional_info	Additional Questions	Responses to additional questions configured for the product, displayed as individual columns in the report
option_name	Product Option	Option selected for the product purchased, e.g., size or color
option_code	Product Option SKU	SKU of the product option purchased

Event Info

add remove

Field Value	Label	Description
member_id	Member ID	Unique member identifier in the database
event_name	Event Name	Name of the event as stated in the platform

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Shop Stock

Product Info

add remove

Field Value	Label	Description
product_name	Product Name	Name of the product purchased
product_type	Product Type	Type of product purchased, e.g., product or virtual gift
product_category	Product Category	Category assigned to the product purchased
product_code	Product Code (SKU)	SKU of the product purchased
product_cost	Product Cost	Cost to manufacture the product purchased
product_price	Product Price	Price to purchase one unit of the product
product_description	Product Description	Description of the product
crm_product_id	CRM Product ID	Unique CRM identifier for the product
is_donation	Treat as Donation	Indicates whether sales of the product also create a donation record
additional_info	Additional Questions	Responses to additional questions configured for the product, displayed as individual columns in the report
option_name	Product Option	Option selected for the product purchased, e.g., size or color
option_code	Product Option SKU	SKU of the product option purchased

Stock Info

add remove

Field Value	Label	Description
product_stock	Product Stock	Returns the product option stock if set; otherwise, returns the total product stock if it is set to more than 0
qty	Amount Sold	Total quantity sold for the shop sale item
stock_remaining	Stock on Hand	Returns the remaining product option stock if set; otherwise, returns the total remaining product stock if it is set to more than 0
total_raised	Total Raised	Total income from shop sales

Event Info

add remove

Field Value	Label	Description
member_id	Member ID	Unique member identifier in the database
event_name	Event Name	Name of the event as stated in the platform

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Scheduled Donations

Donor Info

add remove

Field Value	Label	Description
donation_id	DonationID	Unique donation identifier in the database
crm_donation_id	Donation CRM ID	Unique CRM identifier for the donation
is_donation	Is Donation	Indicates whether the transaction is considered a donation; returns Y for transactions that are deemed donations
gift_aid	Gift Aid	Indicates whether Gift Aid applies; a UK charity can claim 25% of the donation value from the government
d_receipt	Receipt As	Type of receipt sent (Personal or Business)
d_amount	Donation Amount	Full amount donated, including all fees
d_amount_local	Donation Amount (Local Currency)	If using multiple currencies and d_amount_local is set, this field returns the local currency donation amount
d_currency	Currency	Currency the transaction was made in, e.g., AUD, EUR, GBP, USD, etc.
d_refund_amount	Refund Amount	Amount refunded for this donation
d_status	Payment Status	Status of the donation, e.g., Paid or Refund
payment_type	Payment Method	How payment was made, e.g., credit card, PayPal, EFT, Link, etc.
payment_reference	Payment Reference	Payment processor reference, e.g., ch_1CQ7CyDxBFae0ZN4AuOfEoTd
stripe_fee	Stripe Fee	Fee paid to the online payment processor, e.g., Stripe or PayPal
optin_fee	Optional Contribution	Optional contribution amount paid by the user, if any
net_amount	Net Amount	Amount the charity receives (transaction value - gateway fee - mandatory fee/optional contribution)
date_paid	Payment Date	Date the initial recurring donation was made
donation_type	Donation Type	Type of donation, e.g., sponsorship or personal
donation_frequency	Donation Frequency	How often a recurring donation is processed, e.g., weekly, monthly, or yearly
d_title	Title	Donor title, e.g., Mr., Mrs., Miss, etc.
d_fname	First Name	Donor first name
d_lname	Last Name	Donor last name
d_lname_prefix	Last Name Prefix	Donor last name prefix
d_email	Email Address	Donor email address
is_fundraiser_email	Is Fundraiser Email	Indicates whether the donor is also a fundraiser/entrant in an event
d_gender	Gender	Donor gender
d_dob	DOB	Donor date of birth
d_phone_home	Phone (Home)	Donor home phone
d_phone_mobile	Mobile	Donor mobile phone
d_address_unit	Unit	Donor unit number
d_address_number	Street Number	Donor street number
d_address_street	Street Name / Address Line 1	Donor street name or address line 1
d_address_suburb	Suburb	Donor suburb
d_address_2	Address Line 2	Donor address line 2
d_address_pcode	Postcode	Donor postcode/postal/ZIP code
d_address_state	State	Donor state/province
d_address_country	Country	Donor country
d_address_street_number_unit	Unit + Number + Street	Donor unit, number, and street in one field
kw_address	Google Address Lookup	Result of Google address lookup (also usable for all lookups)
d_organisation	Company	Donor company/organization
ecard_first_name	eCard First Name	First name of the eCard recipient (Email Card)
ecard_last_name	eCard Last Name	Last name of the eCard recipient (Email Card)
ecard_email	eCard Email	Email address of the eCard recipient (Email Card)
ecard_address	eCard Address	Address of the eCard recipient (Email Card)
ecard_comments	eCard Message	eCard message to the recipient
in_memory	In Memory	Indicates whether the donation is in memory of someone
in_memory_title	In Memory/Celebration Title	Title of the person the donation is in memory or celebration of
in_memory_fname	In Memory/Celebration First Name	First name of the person the donation is in memory or celebration of
in_memory_lname	In Memory/Celebration Last Name	Last name of the person the donation is in memory or celebration of
in_memory_email	In Memory Email	Email address of the person the donation is in memory of
in_memory_address1	In Memory Address 1	Address line 1 of the person the donation is in memory of
in_memory_address2	In Memory Address 2	Address line 2 of the person the donation is in memory of
date_created	Date Created	Date the donation record was created
last_updated	Last Updated	Date the donation record was last updated
po_number	Po Number	Number printed on the receipt, e.g., REG471
d_optin	Marketing Optin	Marketing communication opt-in
d_optin_sms	Optin (SMS)	Marketing communication opt-in specifically for SMS communications
d_optin_email	Optin (Email)	Marketing communication opt-in specifically for email communications
d_optin_post	Optin (Post)	Marketing communication opt-in specifically for postal communications
d_optin_phone	Optin (Phone)	Marketing communication opt-in specifically for phone communications
card_name	Card Name	Name on the credit card used to process the transaction
card_type	Card Type	Type of credit card used to make the purchase, e.g., Visa, Mastercard, etc.
d_anonymous	Is Anonymous	Indicates whether the donation displays as anonymous to the public
d_display_name	Display Name	Alternate donor name displayed to the public
display_on	Display On Page	Indicates whether the donation displays on a public fundraising page
d_leave_message	Leave Message	Indicates whether the donor wants to leave a message
d_comments	Message	Content of the message left by the donor
utm_campaign	UTM Campaign	UTM campaign tag value associated with the record
utm_source	UTM Source	UTM source tag value associated with the record
utm_medium	UTM Medium	UTM medium tag value associated with the record
utm_content	UTM Content	UTM content tag value associated with the record
utm_term	UTM Term	UTM term tag value associated with the record
donor_ip	IP Address	Donor's IP address
donor_lat_lng	Lat/Long Location	Latitude and longitude coordinates of the donor

Event Info (if applicable)

add remove

Field Value	Label	Description
event_id	EventID	Unique event identifier in the database
crm_event_id	Event CRM ID	Unique CRM identifier for the event
event_code	Event Code	Unique database identifier for the event
event_name	Event Name	Name of the event as stated in the platform
event_type	Event Type	Type of event, e.g., Online, Offline, or DIY
event_date	Event Date	Date the event will take place, if set for a particular day
event_time	Event Time	Time the event will take place, if set for a particular time
event_expiry	Event End Date	Date the event will end, if set for a particular date
event_expiry_time	Event End Time	Time the event will end, if set for a particular time
event_location	Event Location	Location of the event, if set in the admin
event_number	Event Address Street Number	Street number of the event, if set for a particular location
event_street	Event Address Street	Street address of the event, if set for a particular location
event_city	Event Address City	City where the event is taking place, if set for a particular location
event_suburb	Event Address Suburb	Suburb, parish, city, or town where the event is taking place, if set for a particular location
event_postcode	Event Address Postcode	Postcode/postal/ZIP code of the event, if set for a particular location
event_state	Event Address State	State/province of the event, if set for a particular location
event_country	Event Address Country	Country of the event, if set for a particular location
total_event_raised	Total Event Raised	Total amount raised for the event
diy_category	DIY Category	Category the DIY event belongs to, e.g., giving something up or donations instead of birthday gifts
crm_category_id	DIY CRM ID	Unique CRM identifier for the DIY category
event_status	Event Status	Status of the event the entrant is registered in

Member Info (if applicable)

add remove

Field Value	Label	Description
member_id	MemberID	Unique member identifier in the database
crm_member_id	Member CRM ID	Unique CRM identifier for the member
history_id	Member Event ID	Unique member event entry identifier in the database
crm_history_id	Member Event CRM ID	Unique CRM identifier for the member event entry
member_type	Member Type	Can be set in the entry form/registration flow, e.g., Captain, Co-driver, etc.
m_title	Title	Member/fundraiser/participant/entrant title, e.g., Mr., Mrs., Miss, etc.
m_fname	First Name	Member first name
m_lname	Last Name	Member last name
m_lname_prefix	Last Name Prefix	Member last name prefix
member_name	Full Name	Member's full name
m_email	Email Address	Member email address
m_username	Username	Member username; forms part of their page URL
m_company	Company	Member company/organization
m_position	Position	Member's position within their organization, e.g., CEO, Partner, General Manager
m_status	Status	Is the profile live or in draft mode 0 = Draft 1 = Live 2 = Archived
m_gender	Gender	Member gender
m_dob	DOB	Member DOB
m_phone_home	Phone (Home)	Member home phone
m_phone_mobile	Mobile	Member mobile phone
m_address_unit	Unit	Member unit number
m_address_number	Street Number	Member street number
m_address_street	Street Name / Address Line 1	Member street name or address line 1
m_address_2	Address Line 2	Member address line 2; used when the platform setting is Address Line 1, Address Line 2
m_address_suburb	Suburb	Member suburb, parish, city, town, etc.
m_address_pcode	Postcode	Member postcode/postal/ZIP code
m_address_state	State	Member state/province/county
m_address_country	Country	Member country
kw_address	Google Address Lookup	Result of Google lookup (also usable for all lookups)
m_address_street_number_unit	Unit + Number + Street	Member unit number, street number, and street in one field
member_date_created	Date Account Created	Date the member first created an account for the charity on the platform
date_registered	Date Registered (Event)	Date registered in a particular event
in_team	In Team	Participating as part of a team
is_active	Is Active	Marked as active in the event
is_complete	Is Complete	Has completed the full entry process
is_paid	Has Paid	Has paid the registration or entry fee
total_paid	Total Paid	Total amount paid to the charity, including entry, registration, donations, merchandise, ticket purchases, etc.
total_paid_entry	Total Paid Entry	Amount paid as an entry or registration fee
total_paid_merchandise	Total Paid Merchandise	Amount paid for merchandise, e.g., T-shirt or eCard, etc.
total_paid_ticket	Total Paid Promo Code	Amount paid with a promo code, e.g., a discount or free entry
total_paid_donation	Total Paid Donation	Amount paid as a donation
m_target	Fundraising Target	Default or self-created fundraising target
m_target_distance	Distance Target	Default or self-created distance (km/m) target
fundraiser_url	Fundraiser URL	Unique URL for a fundraiser's page where sponsors can donate
personal_donation	Personal Donation	Indicates whether a personal donation has been made; returns the donation value or is blank
last_logged_in	Last Logged In	Date and time the member last logged in to their account
m_photo	Photo	Indicates whether the member has added a photo to their fundraising page; returns Y or 0
m_optin	Optin	Indicates whether the member has opted in to receive marketing communications; returns Y or 0
in_memory_name	In Memory/Celebration Name	Name of the person the funds are being raised in memory or celebration of
in_memory_next_of_kin	Is Next of Kin	Indicates whether the person setting up the In Memory/Celebration page is the next of kin of the person the funds are being raised in memory of; returns Y or 0
in_memory_relationship	In Memory/Celebration Relationship	Relationship of the person setting up the In Memory/Celebration page to the person the funds are being raised in memory or celebration of, e.g., husband, mother, sister, etc.
m_emergency_contact	Emergency Contact First	Emergency contact first name
m_emergency_contact_alt	Emergency Contact Last	Emergency contact last name
m_emergency_phone	Emergency Contact Phone	Emergency contact phone number
m_medical_conditions	Has Medical Condition	Indicates whether the member has a medical condition; returns Y or 0
m_medical_conditions_text	Medical Conditions	List of medical conditions

Team Info (if applicable)

add remove

Field Value	Label	Description
team_id	Team ID	Unique team identifier in the database
crm_team_id	Team CRM ID	Unique CRM identifier for the team
team	Team Name	Name of the team as created by the team captain
team_captain_name	Team Captain Name	Name of the team captain
team_url	Team URL	Unique URL based on the team name
t_target	Team Target	Fundraising target set by the team
t_event_date	Team Event Date	Date the team's event will take place
t_event_time	Team Event Time	Time the team's event will take place

Organization Page Info (if applicable)

add remove

Field Value	Label	Description
org_id	Org ID	Unique organization identifier in the database
crm_org_id	Org CRM ID	Unique CRM identifier for the organization
org_name	Org Name	Name of the organization page as created by the captain
org_captain_name	Org Captain Name	Name of the organization page captain
org_url	Org URL	Unique URL based on the organization name
org_target	Org Target	Fundraising target set by the organization

Page Info (if applicable)

add remove

Field Value	Label	Description
page_id	PageID	Unique page identifier in the database
crm_page_id	Page CRM ID	Unique CRM identifier for the page
page_name	Page Name	Name of the page from the page settings in the admin

Multi-charity (if applicable)

add remove

Field Value	Label	Description
charity_id	Charity ID	The ID of the charity this record is assigned to (if using multi-charity)
charity_name	Charity Name	The name of the charity this record is assigned to (if using multi-charity)

Payout Info (if applicable)

add remove

Field Value	Label	Description
payout_id	Payout Reference	Stripe reference for the payout this transaction will be a part of
payout_date	Payout Date	Date for the payout this transaction will be a part of
payout_status	Payout Status	Status of the payout this transaction will be a part of

Web Forms

add remove

Field Value	Label	Description
Webform Name	Webform Name	Each field collected in the webform is added to the report as an individual column.

Other

add remove

Field Value	Label	Description
total_donations	Total Donations	Sum of donations for the site

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Scheduled Donation Errors

Error Info

add remove

Field Value	Label	Description
error_message	Error Message	Error message returned when an attempt to process the recurring donation fails
has_retried	Have Retried	Indicates whether the scheduled donation was attempted to be processed again
last_retried_date	Retry Date	Date the scheduled donation was attempted to be processed again
last_retried_error_message	Retry Error Message	Error message returned when another attempt to process the recurring donation fails

Donor Info

add remove

Field Value	Label	Description
donation_id	DonationID	Unique donation identifier in the database
crm_donation_id	Donation CRM ID	Unique CRM identifier for the donation
is_donation	Is Donation	Indicates whether the transaction is considered a donation; returns Y for transactions that are deemed donations
gift_aid	Gift Aid	Indicates whether Gift Aid applies; a UK charity can claim 25% of the donation value from the government
d_receipt	Receipt As	Type of receipt sent (Personal or Business)
d_amount	Donation Amount	Full amount donated, including all fees
d_amount_local	Donation Amount (Local Currency)	If using multiple currencies and d_amount_local is set, this field returns the local currency donation amount
d_currency	Currency	Currency the transaction was made in, e.g., AUD, EUR, GBP, USD, etc.
d_refund_amount	Refund Amount	Amount refunded for this donation
d_status	Payment Status	Status of the donation, e.g., Paid or Refund
payment_type	Payment Method	How payment was made, e.g., credit card, PayPal, EFT, Link, etc.
payment_reference	Payment Reference	Payment processor reference, e.g., ch_1CQ7CyDxBFae0ZN4AuOfEoTd
stripe_fee	Stripe Fee	Fee paid to the online payment processor, e.g., Stripe or PayPal
optin_fee	Optional Contribution	Optional contribution amount paid by the user, if any
net_amount	Net Amount	Amount the charity receives (transaction value - gateway fee - mandatory fee/optional contribution)
date_paid	Payment Date	Date the initial recurring donation was made
donation_type	Donation Type	Type of donation, e.g., sponsorship or personal
donation_frequency	Donation Frequency	How often a recurring donation is processed, e.g., weekly, monthly, or yearly
d_title	Title	Donor title, e.g., Mr., Mrs., Miss, etc.
d_fname	First Name	Donor first name
d_lname	Last Name	Donor last name
d_lname_prefix	Last Name Prefix	Donor last name prefix
d_email	Email Address	Donor email address
is_fundraiser_email	Is Fundraiser Email	Indicates whether the donor is also a fundraiser/entrant in an event
d_gender	Gender	Donor gender
d_dob	DOB	Donor date of birth
d_phone_home	Phone (Home)	Donor home phone
d_phone_mobile	Mobile	Donor mobile phone
d_address_unit	Unit	Donor unit number
d_address_number	Street Number	Donor street number
d_address_street	Street Name / Address Line 1	Donor street name or address line 1
d_address_suburb	Suburb	Donor suburb
d_address_2	Address Line 2	Donor address line 2
d_address_pcode	Postcode	Donor postcode/postal/ZIP code
d_address_state	State	Donor state/province
d_address_country	Country	Donor country
d_address_street_number_unit	Unit + Number + Street	Donor unit, number, and street in one field
kw_address	Google Address Lookup	Result of Google address lookup (also usable for all lookups)
d_organisation	Company	Donor company/organization
ecard_first_name	eCard First Name	First name of the eCard recipient (Email Card)
ecard_last_name	eCard Last Name	Last name of the eCard recipient (Email Card)
ecard_email	eCard Email	Email address of the eCard recipient (Email Card)
ecard_address	eCard Address	Address of the eCard recipient (Email Card)
ecard_comments	eCard Message	eCard message to the recipient
in_memory	In Memory	Indicates whether the donation is in memory of someone
in_memory_title	In Memory/Celebration Title	Title of the person the donation is in memory or celebration of
in_memory_fname	In Memory/Celebration First Name	First name of the person the donation is in memory or celebration of
in_memory_lname	In Memory/Celebration Last Name	Last name of the person the donation is in memory or celebration of
in_memory_email	In Memory Email	Email address of the person the donation is in memory of
in_memory_address1	In Memory Address 1	Address line 1 of the person the donation is in memory of
in_memory_address2	In Memory Address 2	Address line 2 of the person the donation is in memory of
date_created	Date Created	Date the donation record was created
last_updated	Last Updated	Date the donation record was last updated
po_number	Po Number	Number printed on the receipt, e.g., REG471
d_optin	Marketing Optin	Marketing communication opt-in
d_optin_sms	Optin (SMS)	Marketing communication opt-in specifically for SMS communications
d_optin_email	Optin (Email)	Marketing communication opt-in specifically for email communications
d_optin_post	Optin (Post)	Marketing communication opt-in specifically for postal communications
d_optin_phone	Optin (Phone)	Marketing communication opt-in specifically for phone communications
card_name	Card Name	Name on the credit card used to process the transaction
card_type	Card Type	Type of credit card used to make the purchase, e.g., Visa, Mastercard, etc.
d_anonymous	Is Anonymous	Indicates whether the donation displays as anonymous to the public
d_display_name	Display Name	Alternate donor name displayed to the public
display_on	Display On Page	Indicates whether the donation displays on a public fundraising page
d_leave_message	Leave Message	Indicates whether the donor wants to leave a message
d_comments	Message	Content of the message left by the donor
utm_campaign	UTM Campaign	UTM campaign tag value associated with the record
utm_source	UTM Source	UTM source tag value associated with the record
utm_medium	UTM Medium	UTM medium tag value associated with the record
utm_content	UTM Content	UTM content tag value associated with the record
utm_term	UTM Term	UTM term tag value associated with the record
donor_ip	IP Address	Donor's IP address
donor_lat_lng	Lat/Long Location	Latitude and longitude coordinates of the donor

Member Info (if applicable)

add remove

Field Value	Label	Description
member_id	MemberID	Unique member identifier in the database
crm_member_id	Member CRM ID	Unique CRM identifier for the member
history_id	Member Event ID	Unique member event entry identifier in the database
crm_history_id	Member Event CRM ID	Unique CRM identifier for the member event entry
member_type	Member Type	Can be set in the entry form/registration flow, e.g., Captain, Co-driver, etc.
m_title	Title	Member/fundraiser/participant/entrant title, e.g., Mr., Mrs., Miss, etc.
m_fname	First Name	Member first name
m_lname	Last Name	Member last name
m_lname_prefix	Last Name Prefix	Member last name prefix
member_name	Full Name	Member's full name
m_email	Email Address	Member email address
m_username	Username	Member username; forms part of their page URL
m_company	Company	Member company/organization
m_position	Position	Member's position within their organization, e.g., CEO, Partner, General Manager
m_status	Status	Is the profile live or in draft mode 0 = Draft 1 = Live 2 = Archived
m_gender	Gender	Member gender
m_dob	DOB	Member DOB
m_phone_home	Phone (Home)	Member home phone
m_phone_mobile	Mobile	Member mobile phone
m_address_unit	Unit	Member unit number
m_address_number	Street Number	Member street number
m_address_street	Street Name / Address Line 1	Member street name or address line 1
m_address_2	Address Line 2	Member address line 2; used when the platform setting is Address Line 1, Address Line 2
m_address_suburb	Suburb	Member suburb, parish, city, town, etc.
m_address_pcode	Postcode	Member postcode/postal/ZIP code
m_address_state	State	Member state/province/county
m_address_country	Country	Member country
kw_address	Google Address Lookup	Result of Google lookup (also usable for all lookups)
m_address_street_number_unit	Unit + Number + Street	Member unit number, street number, and street in one field
member_date_created	Date Account Created	Date the member first created an account for the charity on the platform
date_registered	Date Registered (Event)	Date registered in a particular event
in_team	In Team	Participating as part of a team
is_active	Is Active	Marked as active in the event
is_complete	Is Complete	Has completed the full entry process
is_paid	Has Paid	Has paid the registration or entry fee
total_paid	Total Paid	Total amount paid to the charity, including entry, registration, donations, merchandise, ticket purchases, etc.
total_paid_entry	Total Paid Entry	Amount paid as an entry or registration fee
total_paid_merchandise	Total Paid Merchandise	Amount paid for merchandise, e.g., T-shirt or eCard, etc.
total_paid_ticket	Total Paid Promo Code	Amount paid with a promo code, e.g., a discount or free entry
total_paid_donation	Total Paid Donation	Amount paid as a donation
m_target	Fundraising Target	Default or self-created fundraising target
m_target_distance	Distance Target	Default or self-created distance (km/m) target
fundraiser_url	Fundraiser URL	Unique URL for a fundraiser's page where sponsors can donate
personal_donation	Personal Donation	Indicates whether a personal donation has been made; returns the donation value or is blank
last_logged_in	Last Logged In	Date and time the member last logged in to their account
m_photo	Photo	Indicates whether the member has added a photo to their fundraising page; returns Y or 0
m_optin	Optin	Indicates whether the member has opted in to receive marketing communications; returns Y or 0
in_memory_name	In Memory/Celebration Name	Name of the person the funds are being raised in memory or celebration of
in_memory_next_of_kin	Is Next of Kin	Indicates whether the person setting up the In Memory/Celebration page is the next of kin of the person the funds are being raised in memory of; returns Y or 0
in_memory_relationship	In Memory/Celebration Relationship	Relationship of the person setting up the In Memory/Celebration page to the person the funds are being raised in memory or celebration of, e.g., husband, mother, sister, etc.
m_emergency_contact	Emergency Contact First	Emergency contact first name
m_emergency_contact_alt	Emergency Contact Last	Emergency contact last name
m_emergency_phone	Emergency Contact Phone	Emergency contact phone number
m_medical_conditions	Has Medical Condition	Indicates whether the member has a medical condition; returns Y or 0
m_medical_conditions_text	Medical Conditions	List of medical conditions

Team Info (if applicable)

add remove

Field Value	Label	Description
team_id	Team ID	Unique team identifier in the database
crm_team_id	Team CRM ID	Unique CRM identifier for the team
team	Team Name	Name of the team as created by the team captain
team_captain_name	Team Captain Name	Name of the team captain
team_url	Team URL	Unique URL based on the team name
t_target	Team Target	Fundraising target set by the team
t_event_date	Team Event Date	Date the team's event will take place
t_event_time	Team Event Time	Time the team's event will take place

Event Info (if applicable)

add remove

Field Value	Label	Description
event_id	EventID	Unique event identifier in the database
crm_event_id	Event CRM ID	Unique CRM identifier for the event
event_code	Event Code	Unique database identifier for the event
event_name	Event Name	Name of the event as stated in the platform
event_type	Event Type	Type of event, e.g., Online, Offline, or DIY
event_date	Event Date	Date the event will take place, if set for a particular day
event_time	Event Time	Time the event will take place, if set for a particular time
event_expiry	Event End Date	Date the event will end, if set for a particular date
event_expiry_time	Event End Time	Time the event will end, if set for a particular time
event_location	Event Location	Location of the event, if set in the admin
event_number	Event Address Street Number	Street number of the event, if set for a particular location
event_street	Event Address Street	Street address of the event, if set for a particular location
event_city	Event Address City	City where the event is taking place, if set for a particular location
event_suburb	Event Address Suburb	Suburb, parish, city, or town where the event is taking place, if set for a particular location
event_postcode	Event Address Postcode	Postcode/postal/ZIP code of the event, if set for a particular location
event_state	Event Address State	State/province of the event, if set for a particular location
event_country	Event Address Country	Country of the event, if set for a particular location
total_event_raised	Total Event Raised	Total amount raised for the event
diy_category	DIY Category	Category the DIY event belongs to, e.g., giving something up or donations instead of birthday gifts
crm_category_id	DIY CRM ID	Unique CRM identifier for the DIY category
event_status	Event Status	Status of the event the entrant is registered in

Page Info (if applicable)

add remove

Field Value	Label	Description
page_id	PageID	Unique page identifier in the database
crm_page_id	Page CRM ID	Unique CRM identifier for the page
page_name	Page Name	Name of the page as set in the page settings in the admin

Multi-charity (if applicable)

add remove

Field Value	Label	Description
charity_id	Charity ID	The ID of the charity this record is assigned to (if using multi-charity)
charity_name	Charity Name	The name of the charity this record is assigned to (if using multi-charity)

Web Forms

add remove

Field Value	Label	Description
Webform Name	Webform Name	Each field collected in the webform is added to the report as an individual column.

Other

add remove

Field Value	Label	Description
total_donations	Total Donations	Sum of donations for the site

Custom Query

add remove

Field Value	Label	Description
custom	Custom	Value returned by the custom query field

Still need help? Check out our other Reports and Data Exports support articles, or reach out to the Funraisin Support team by logging a ticket through the Support Module in your platform.

Last updated: 21 Sep 2026

Reporting: Fields glossary