Online Help

Help Table of Contents

Understanding the Report Columns Available for TeamRaiser Data

The following table lists the columns that can be included in reports to show information about TeamRaiser events, participants, and so on.

Besides the name of each Column, the table contains the name of the Field Group in which the column is located on the Report Writer Report Columns page (or N/A if the report is not available in Report Writer) and a Description of the column content and how it is derived if appropriate.

COLUMN COLUMN GROUP DESCRIPTION
Accept Mail Biographical Information Yes or No setting, typically enabled by default, for whether the participant will accept email from the site (selected by a participant when completing the registration form)
Accepts Email Biographical Information Yes or No setting, typically enabled by default, for whether the participant will accept email from the site (selected by a participant when completing the registration form)
Accepts Email Recipient Constituent Information Yes or No setting, typically enabled by default, for whether the email recipient will accept other email from the site
Account Number Valued Transaction The bank account, entered during the payment stage of the transaction, on which a gift payment should be drawn
Acknowledged? Gifts Yes or No setting for whether the follow-up thank-you note has been sent from the Followups To-Do list (in the Participant Center)
Action Percent Email Performance Statistics Percent of emails that generated action responses
Actions Taken, Number of Email Performance Statistics Count of the number of actions (clickthroughs, registrations, action alerts) were taken by the recipient of an emanl
Action Alert Response Count, Lifetime Transaction Information Total number of action alerts taken by the person for all time
Action Alert Response Count, Previous Year Transaction Information Count of the number of action alerts taken by the person in the previous year
Action Alert Response Count, YTD (Year-to-Date) Transaction Information Count of the number of action alerts taken by the person so far this year
Active Detail Biographical Information One of the following:
  • Undefined
  • Unknown to Contact
  • Known to Contact
  • Accepted by Contact
  • Registered Contact
  • New Prospect
  • Interested Prospect
  • Removed by Administrator
  • Removed by Contact
  • Removed as Duplicate
Active Status Biographical Information Active or Inactive to indicated the status within your organization
Advocacy Actions, Number of Email Response Actions How many email recipients took an action alert
Additional Amount User Pledge Yes or No setting for whether a follow-up thank-you note, including reference to an additional amount pledged, has been sent from the Followups To-Do list (in the Participant Center)
Additional Gift Amount($) Registration Amounts Dollar figure a registering participant can enter in the Additional Gift field on the Fundraising Options page, if that option is enabled
Affiliate Abbreviation Email Campaign Abbreviated name of the organization's affiliate/chapter that created the email campaign
Affiliate Abbreviation Event Abbreviated name of the organization's affiliate/chapter sponsoring the event
Affiliate Abbreviation Participant Constituent Information Abbreviated name of the organization's affiliate/chapter to which the participant belongs
Affiliation Type Event Specifies whether the event is a lead or affiliate event
Amount Due, DSP Pledge (confirmed gifts only) Delayed Self Pledge Monetary amount due if only the amounts from confirmed gifts are counted in the total (not counting any unconfirmed gift amounts recorded but not received or amounts from recurring gifts pledged by donors)
Amount Due, DSP Pledge (confirmed and recurring gifts) Delayed Self Pledge Monetary amount due if only the amounts from confirmed gifts and amounts from recurring gifts pledged by donors are counted in the total (not counting any unconfirmed gift amounts recorded but not received)
Amount Due, DSP Pledge (confirmed and unconfirmed gifts) Delayed Self Pledge Monetary amount due if only the amounts from confirmed gifts and any entered but unconfirmed as payment received gifts are counted in the total (not counting the amounts from recurring gifts pledged by donors)
Amount Due, DSP Pledge (confirmed, unconfirmed, and recurring gifts) Delayed Self Pledge Monetary amount due for all gift amounts entered
Anonymous Donor Participant Constituent Information Indicates whether participant has opted to donate only anonymously
Anonymous Donor, Is Donor Recognition Log Yes or No setting, selected when completing a donation form, for whether the donor's name displays in the gift lists
Appeal ID User Pledge System-generated string identifying the Appeal to the operating software
Appeal Name User Pledge Name generated for the Appeal by the administrator
Application Name Email Message TeamRaiser
Autologin Link Link Information Link the email recipient can click to log into the system automatically
Ask Date of Sponsorship Team Company Date on which this sponsor was contacted for the contribution
Average Offline Gift Gifts by Status Monetary amount representing the average monetary amount of an unconfirmed and confirmed gift recorded into the system offline
Average Online Gift Gifts by Status Monetary amount representing the average monetary amount of a gift made through an online donation form
Average Team Size Registration Summary Average number of participants registered on one team
AVS Response Valued Transaction One character code:
  • X - Exact match, 9 digit zip - Street Address, and 9 digit ZIP Code match
  • Y - Exact match, 5 digit zip - Street Address, and 5 digit ZIP Code match
  • A - Partial match - Street Address matches, ZIP Code does not
  • W - Partial match - ZIP Code matches, Street Address does not
  • Z - Partial match - 5 digit ZIP Code match only
  • N - No match - No Address or ZIP Code match
  • U - Unavailable - Address information is unavailable for that account number, or the card issuer does not support
  • G - Service Not supported, non-US Issuer does not participate
  • R - Retry - Issuer system unavailable, retry later
  • E - Not a mail or phone order
  • S - Service not supported
AVS Decode Value Valued Transaction Either of true or false
Bank Name Gifts Name of the bank through which a payment is processed
Batch ID Gifts Letter and number string, optionally set by the person entering the gifts, to group all recorded gifts together for tracking in the system
Billing Name Valued Transaction Name on the credit card used to make an online transaction or the name entered by the administrator when recording or processing a transaction offline
Blueprint, Is Event Setting for whether the event is a Blueprint event
Campaign ID, Previous Event The system generated identifier for the previous event
Campaign Tax ID Event The tax identification number for the TeamRaiser
Campaign Title Valued Transaction Name of the donation campaign with which the donation form used to collect money is associated
Captains, Max Per Team Event Settings Setting for whether a team has more than one captain, as well as the maximum number of co-captains allowed
Captains, Number of Registration Summary How many captains a team has, if the multiple captains option is enabled on the Team Options page
Captain Accepts Email? Team Captain Constituent Information Yes or No setting that determines if this contact accepts email messages from your site
Captain Constituent ID Team Captain Constituent Information String that identifies a constituent who is registered on your site
Captain Email Opt-Out Date Team Captain Constituent Information Timestamp that shows when the person disabled (unchecked) the email Opt-In checkbox
Captain First Name Team Captain Constituent Information First name of the person
Captain Home City Team Captain Constituent Information Name of the city in which the residence of the person is located
Captain Home Country Team Captain Constituent Information Name of the country in which the residence of the person is located
Captain Home County Team Captain Constituent Information Name of the county in which the residence of the person is located
Captain Home Phone Team Captain Constituent Information Telephone number at which the person can be contacted
Captain Home State/Province Team Captain Constituent Information Name of the state or province in which the residence of the person is located
Captain Home Street 1 Team Captain Constituent Information Number and name of the street on which the residence of the person is located
Captain Home Street 2 Team Captain Constituent Information Extra information about the residence of the person (for example, Apartment Number)
Captain Home Street 3 Team Captain Constituent Information Extra information about the residence of the person
Captain Home Zip Team Captain Constituent Information ZIP code in which the residence of the person is located
Captain Last Name Team Captain Constituent Information Last name of the person
Captain Member ID Team Captain Constituent Information Number string that the system set for the person upon registration completion
Captain Middle Name Team Captain Constituent Information Name entered by the person; can be a maiden name, nickname, family name, or so on
Captain Preferred Email Format Team Captain Constituent Information Setting that determines if the person wants to receive HTML-formatted or plain text emails
Captain Primary Email Address Team Captain Constituent Information Web email address of this person
Captain Secondary Email Address Team Captain Constituent Information Alternate Web email address of the person
Captain Status Team Captain Constituent Information Setting that shows this person is a team captain
Captainless, Is Previous Teams Not Returned Information Indicates whether the previous team does not include a captain
Card Expiration Date Valued Transaction Date when the credit card used to make a gift payment will expire
Card Number Valued Transaction Number of the credit card used to make a gift payment
Check Number Gifts Number on the check received for a gift payment
City Donor Information City the donor entered as residence on a donation form
Click Count, Total Email Performance Statistics How many times coaching email recipients clicked the link to reach the email's target purpose
Clickthrough Count, Forwarded Email Performance Statistics How many times coaching email recipients clicked to forward the email to another person
Clickthrough, First Date Link Performance Date when a coaching email recipient first clicked a link in the email
Clickthroughs, Last Date Link Performance Date when a coaching email recipient last clicked a link in the email
Clickthrough Percent Email Performance Statistics Percentage of recipients who clicked the link in the coaching email message
Clickthroughs, Number of Link Performance How many times a link was clicked in the coaching email message
Clickthroughs, Number of Email Performance Statistics How many times a link was clicked in the coaching email message
Clickthroughs, Number of Forwarded Link Performance How many times a forwarding link to another email address was clicked in the coaching email message
Clickthroughs, Total Link Performance How many times links were clicked in the coaching email message
Client IP Valued Transaction Machine address of the computer used by the donor to make the gift
Companies, Include for Teams Event Settings Setting that, if enabled on the Team Options page, determines whether a Team Captain can enter or select a local company as a sponsor when forming a team during registration
Companies, National Only Event Settings Setting that, if enabled on the Team Options page, determines whether a Team Captain can select a sponsoring national company when forming a team during registration
Company Donor Recognition Log Name of the company donating
Company Team Company Name of the company who will be a sponsor
Company Name Milestones Alternative label, such as a short name, that identifies the company on lists viewed by tadministrators
Company Thermometer Adjustment Team Company How much was subtracted from the fundraising Thermometer status indicator for registration subsidies, matching gifts, and so on
Company URL Team Company The Web address of the homepage for the site that the company uses as their public Web site
Company, Is Archived Team Company Setting that determines whether the company is active or is no longer on the active list
Company, Is National Team Company Setting that determines whether a company supports teams in all events across a type of TeamRaiser
Company, Is Matching Donor Recognition Log Setting that determines whether a company will contribute match money raised by the participants and teams it sponsors
Company Name, Internal Team Company Alternative label, such as a short name, to identify a company to administrators
Company Name, Public Team Company Label identifying a company on participant and site visitor pages
Confirmation Code Valued Transaction The letter/number code combination the system assigned to the transaction system
Confirmation Code, User Valued Transaction The letter/number code combination the system assigned to the user
Confirmed Donation Amount ($) Milestones Monetary sum of offline gifts now marked as confirmed, plus gifts still on the unconfirmed list and rejected gifts
Congressional District (Automatic) Advocacy Information The number of the Congressional District to which this person is assigned by residence information
Congressional District (Manual Override) Advocacy Information The number of the Congressional District to which this person is assigned by a manual entry
County (Automatic) Advocacy Information The name of the county in which the person is assigned by residence information
County (Manual Override) Advocacy Information The name of the county to which this person is assigned by a manual entry
Constituent ID Participant Constituent Information String that identifies a constituent registered on your site
Constituent ID Recipient Constituent Information String that identifies an email recipient who is a constituent registered on your site
Contact ID Biographical Information A system-generated identifier unique to this constituent (sometimes referred to as the ConsID)
Contribution Creation Method Valued Transaction 0 = offline
1 = online
2 = recurring
Country Donor Information Country where a person who donates to the event resides
Custom Amount User Pledge Dollar amount the user enters when completing a donation form
Custom String User Pledge Additional notation user types into a donation form
Date Created Message Variant Date author created the message, if applicable
Date Modified Message Variant Date author modified the message, if applicable
Date Pledged User Pledge Date when user made a pledge (as opposed to when user was actually charged)
Date Recorded Gifts Date when the donation was made online or entered into the system
Discount Amount($) Registration Amounts Dollar amount subtracted from registration fee when a participant applies a discount code
Discount Type Registration Amounts Label that identifies the discount processed
Discount Value Valued Transaction Dollar figure of a discount applied to the transaction
Donation Amount Valued Transaction Dollar amount of the gift
Donation Amount($) Email Response Actions How much money responses to the coaching email message raised
Donations, Allow Event Settings Setting on the Fundraising Options page for whether donations will be accepted
Donations, Number of Email Response Actions How many email recipients made online donations in response to the coaching email message
Donation Date Valued Transaction Date when the gift was processed online or processed as Confirmed in the system
Donation Type Valued Transaction
  • 1 = Donation
  • 2 = Pledge
  • 3 = Recurring Gift
  • 4 = Ticket
  • 5 = Pending
  • 6 = Pending Accepted
  • 7 = Pending Rejected
  • 8 = Pending Accepted Failed
  • 9 = Pending Rejected Failed
  • 10 = Donation Accepted Failed
  • 11 = Donation Rejected Failed
  • 12 = Settled
  • 13 = Rejected
  • 20 = TeamRaiser Registration
  • 21 = Tribute Registration
  • 25 = Ecommerce
  • 30 = Refund
  • Donations, Allow Event Settings Setting on the Fundraising Options page for whether donations will be accepted
    Donor Status Participant Constituent Information Setting for whether the person who donates is Active or Not Active
    Donor Status Recipient Constituent Information Setting for whether an email recipient is Active or Not Active
    DSP Pledge ID Delayed Self Pledge Identifier assigned by the system to a self-pledge
    eCommerce Purchase Amount($) Email Response Actions Dollar value of ecommerce purchases made in response to the coaching email message
    eCommerce Purchases, Number of Email Response Actions How many eCommerce purchases were made in response to the coaching email message
    Email (address) Donor Information Email address of the donor
    Email Address, Primary Participant Constituent Information Email address of a registered event participant
    Email Address, Primary Recipient Constituent Information Email address of the person who receives the message
    Email Address, Secondary Participant Constituent Information Alternate Web email address of the person who registers for the event
    Email Address, Secondary Recipient Constituent Information Alternate Web email address of the person who receives the message
    Email Application Name Email Campaign TeamRaiser
    Email Campaign Name Email Campaign TeamRaiser Emails
    Email Campaign Purpose Email Campaign Coaching Emails
    Email Campaign Type Email Campaign TeamRaiser
    Email Link URL Link Information Web page address of the link
    Email Opt Out Date Participant Constituent Information Date when a participant disabled the email Opt-In
    Email Opt Out Date Recipient Constituent Information Date when a participant disabled the email Opt-In
    Email Variant Name Message Variant Name administrator gave to the test email
    Email, Format Preferred Participant Constituent Information Setting that indicates whether the participant has elected to receive emails in HTML-formatting or in plain text
    Email, Format Preferred Recipient Constituent Information Setting that indicates whether the recipient has elected to receive emails in HTML-formatting or in plain text
    Emails Delivered, Number of Email Performance Statistics How many coaching email messages reached their intended email addresses and did not bounce back
    Emails Forwarded, Number of Email Performance Statistics How many coaching email messages were forwarded to another email address
    Emails Sent Registration Stats How many email addresses to which the coaching email was sent
    Emails Sent, Number of Email Performance Statistics How many email addresses to which the coaching email was sent
    Emails Sent, Number of Registration Summary How many email addresses to which the coaching email was sent
    Emergency Contact Registration Settings Name and telephone number of the person to contact on behalf of a participant in the event of an emergency
    Employer Valued Transaction Company for which the donor works
    Event Event, Event Settings The system generated identifier for the event
    Event Date Event Month, day, and year when an event will take place
    Event Date, Created Event Date when the event was first created
    Event Date, First Team History Month, day, and year when the first event in which the team participated took place
    Event Date, Modified Event Date when an administrator changed the date of an event
    Event Description Event Details about the TeamRaiser event that search engines can use to locate TeamRaiser pages
    Event Goal, Online Event The amount of money the organization hopes to raise online for the event
    Event Goal, Participant Recruitment Event The number of participants the organizatoin hopes to recruit for the event
    Event Goal ($), Sponsor Event The amount of money the organization hopes to raise from sponsors for the event
    Event Goal, Team Recruitment Event The number of teams the organization hopes to recruit for the event
    Event ID Event The system generated identifier for the event
    Event Location, Area Event Label that specifies the geographical area in which an event will take place
    Event Location, City Event Label that specifies the city in which an event will take place
    Event Location, Country Event Label that specifies the country in which an event will take place
    Event Location, County Event Label that specifies the county in which an event will take place
    Event Location, Name Event Label that specifies the name of the site where the event will take place
    Event Location, Region Event Label that specifies a geographical area in which an event will take place
    Event Location, State Event Label that specifies the state in which an event will take place
    Event Location, Street Address Event Label that specifies the number and name of the street on which an event will take place
    Event Location, Zip Code Event Label that specifies the ZIP Code in which an event will take place
    Event Name, Internal Event Short name of the event for administrators
    Event Name, Internal First Event Team History Short name for administrators of the first event in which the team participated
    Event Name, Public Event Label that identifies the event on pages accessible to site visitors and participants
    Event Name, Public First Event Team History Label of the first event in which the team participated that identifies the event on pages accessible to site visitors and participants
    Event Specifier Event
    Event Status Event State of the event (one of Published, Unpublished, or Archived)
    Event Type Event Classification both for comparison reporting and for grouping this TeamRaiser with simila TeamRaisers associated with the same registration Upsells and national companies
    Event Type1 Event Classification Primary label both for comparison reporting and for grouping this TeamRaiser with similar TeamRaisers associated with similar registration Upsells and national companies
    Event Type2 Event Classification Secondary group for associating this TeamRaiser with other, similar TeamRaisers for reporting purposes
    Event Type3 Event Classification Third way for associating this TeamRaiser with other, similar TeamRaisers for reporting purposes
    Events Team History Events in which the team previously participated
    Fee Amount($) Participation Type Event registration fee collected from registrants of this participation type
    Fees Paid Amount($) Registration Amounts Registration fees (including secondary ones) collected from all registrants
    Fees Paid Amount($), Online Registration Amounts Registration fees collected from all registrants via online payments
    Fees Paid Amount($), Offline Registration Amounts Registration fees collected from all registrants via offline payments
    Fees, Total Paid Registration Summary Total fees collected through all registration transactions
    First Name Donor Information First name of donor
    First Name Participant Constituent Information First name of event registrant
    First Name Recipient Constituent Information First name of coaching email recipient
    First Time Donor User Pledge Yes or No setting indicating whether the donor has a donation history recorded within the system
    Fiscal Year Event Accounting period to which the funds raised will be applied
    Fiscal Year, First Event Team History Accounting period from the team's first event to which the funds raised were applied
    Frequency, Recurring Pledge Delayed Self Pledge Time interval selected for collecting each payment
    Fulfillment Complete User Pledge Either of true or false
    Fundraisers Gifts By Donor Number of participants raising money by collecting donations (not including registration fees paid for the event)
    Gift Aid Status Valued Transaction True or False if government will make partial match
    (UK only)
    Gift Notification Configuration set by administrator indicating whether an email notice should be sent (to an address also specified by the administrator) when a gift is made
    Gift Type Gifts Confirmed, unconfirmed, rejected, or blank
    Gift Type Donor Recognition Log Donation or Sustaining
    Gift Amount($) Gifts Dollar amount of gift
    Gift Amount($), Additional Registration Amounts Dollar figure a registering participant can enter in the Additional Gift field on the Fundraising Options page if that option is enabled
    Gifts ($), Average Confirmed Per Event Team History Average amount per event of all online gifts actually collected plus offline gifts marked as confirmed generated by a team
    Gifts ($), Average Confirmed Per Team Member Team History Average amount of all online gifts actually collected plus offline gifts marked as confirmed generated by team members
    Gifts ($), Total Confirmed in Team History Team History Dollar sum of online gifts actually collected plus offline gifts marked as confirmed generated by the team
    Gifts($), Total From Participant Gifts by Donor Participant's total donations as an additional gift or another gift (if the participant must add a gift to bring the total to a minimum fundraising goal)
    Gifts($), Total Not From Participant Gifts by Donor Total of donations collected that are not part of the participant's registration payment
    Gifts($), Total of All Confirmed Gifts by Status Dollar sum of online gifts actually collected plus offline gifts marked as confirmed
    Gifts($), Total of All Not-Rejected Gifts by Status Dollar sum of online gifts collected plus the value of offline gifts still on the unconfirmed list
    Gifts($), Total Offline Gifts by Status Dollar sum of offline gifts marked as confirmed, plus gifts still on the unconfirmed list, and rejected gifts
    Gifts($), Total Offline Confirmed Gifts by Status Sum of all offline gifts confirmed as received
    Gifts($), Total Offline Not-Rejected Gifts by Status Sum of cash, check, and pay-later gifts recorded by the participant or an administrator, but not yet confirmed as received, added to the offline gifts that have been confirmed
    Gifts($), Total Offline Rejected Gifts by Status Total cash, check, and pay-later gifts recorded by the participant or an administrator and marked as rejected
    Gifts($), Total Offline Unconfirmed Gifts by Status Total cash, check, and pay-later gifts recorded by the participant or an administrator that have not been confirmed or rejected
    Gifts($), Total Online Gifts Gifts by Status Sum of all gift payments made with credit card or bank withdrawal payments
    Gifts, Allow Team Event Settings Event Options page setting to display a link on the Team pages allowing donations in support of the entire team
    Gifts, Indicate Unconfirmed Event Settings Event Options page setting to display unconfirmed gifts in the Gift History lists (on participants' Progress pages)
    Gifts, Number From Participant Gifts by Donor Donations made by the participant (identified through constituent_id; typically, 1 if the participant gives an additional gift during registration; 2 if the participant must add a gift to bring the total to the minimum fundraising goal)
    Gifts, Number Not From Participant Gifts by Donor Total donations made by anyone other than the participant (identified through constituent_id)
    Gifts, Number of Gifts by Donor Total donations
    Gifts, Number of All Confirmed Gifts by Status Count of the online gifts plus the number of offline gifts marked as confirmed
    Gifts, Number of All Not Rejected Gift by Status Count of both confirmed and unconfirmed offline gifts
    Gifts, Number Offline Gifts by Status Total cash, check, and pay-later gifts recorded by the participant or administrator, but not yet confirmed as received
    Gifts, Number Offline Confirmed Gifts by Status Total number of received cash, check, and pay-later gifts recorded and marked as Confirmed
    Gifts, Number Offline Not Rejected Gift by Status Total number of cash, check, and pay-later gifts recorded by the participant or an administrator, but not yet confirmed as received, plus the number of offline gifts that have been confirmed
    Gifts, Number Offline Rejected Gifts by Status Total cash, check, and pay-later gifts recorded by the participant or an administrator and then marked as Rejected
    Gifts, Number Offline Unconfirmed Gifts by Status Total cash, check, and pay-later gifts recorded by the participant or an administrator
    Gifts, Number Online Gifts by Status Credit card and bank withdrawal donations
    Goal User Pledge How much money the user pledges
    Goal($), Event Event How much money the organization hopes to raise with this event
    Goal($), Participant Registration How much money a participant hopes to raise for the event
    Goal($), Suggested Participant Event How much money the organization hopes each participant will try to raise for this event
    Goal($), Team Team How much money the team intends to raise
    Goal, Team Members Team How much money a team participant intends to raise
    Goal, Company Team Company How much money a company earmarks for contribution to the event via sponsorship and team goals
    Goal, Allow Event Settings Setting that lets participants specify fundraising goals (on the Event Options page)
    Goal Amount($), Minimum Participation Type How much money a participant must agree to raise in order to register for the event (if feature enabled on the Fundraising Options page)
    Goals, Total Participant Registration Summary How much money participants hope to raise together
    Hard Bounce Count Email Count of the number of emails sent back as undeliverable because of an invalid email address
    Hard Bounce Percent Email Performance Statistics Percentage of coaching emails sent back as undeliverable because of an invalid email address
    Hard Bounces, Number of Email Performance Statistics Number of coaching emails that were sent back as undeliverable because of an invalid email address
    Home City Participant Constituent Information City in which the participant resides
    Home City Recipient Constituent Information City in which the recipient resides
    Home Country Participant Constituent Information County in which the participant resides
    Home Country Recipient Constituent Information County in which the recipient resides
    Home Phone Participant Constituent Information Participant's home telephone number
    Home Phone Recipient Constituent Information Recipient's home telephone number
    Home State/Province Participant Constituent Information State or province where the participant resides
    Home State/Province Recipient Constituent Information State or province the recipient resides
    Home Street 1 Participant Constituent Information Street and number where the participant resides
    Home Street 1 Recipient Constituent Information Street and number where the recipient resides
    Home Street 2 Participant Constituent Information Extra information about the participant's street address
    Home Street 2 Recipient Constituent Information Extra information about the recipient's street address
    Home Street 3 Participant Constituent Information Extra information about the residence of the participant
    Home Street 3 Recipient Constituent Information Extra information about the residence of the recipient
    Home Zip Participant Constituent Information ZIP code where the participant resides
    Home Zip Recipient Constituent Information ZIP code where the recipient resides
    Honorary Team Name Registration Settings Label for the special honorary team, if this option is enabled on the Team Options page
    Honorary Team, Is Team Settings Setting that identifies whether the team is honorary
    Honorary Teams, Allow Event Settings Setting on the Team Options page
    Honor Gift, Is Donor Recognition Log Setting that determines if donation is on someone else's behalf
    Host Reference Number Valued Transaction System-generated number for identifying the event host
    INV Number Valued Transaction Invoice number returned by ecommerce gateway
    Interest Name Email Campaign Name provided by administrator to associate an interest with a campaign
    Is Only Sponsor Team Company Determines if the company will not display for selection when Team Captains form teams in this TeamRaiser event
    Joint Donor, Is Donor Recognition Log Setting that indicates whether a second person, not making a payment, will be recognized as a donor
    Joint First Name Donor Recognition Log First name of a donor who is not directly making a gift payment
    Joint Last Name Donor Recognition Log Last name of a donor who is not directly making a gift payment
    Joint Middle Name Donor Recognition Log Middle name of a donor who is not directly making a gift payment
    Joint Title Donor Recognition Log Courtesy form of address for a donor who is not directly making a gift payment
    Last Modified By Biographical Name of the admin who made the most recent changes to the constituent record
    Last Name Biographical or Participant Constituent Information Last name of the person who registered for an event
    Last Name Recipient Constituent Information Last name of the person who is being sent the email
    Last Name Donor Information Last name of the donor
    Last Paid Date User Pledge Most recent installment payment on record at time of report
    Lead Event Name Event The name of the main community event with which smaller events may be affiliated
    Local Company Recruitment Goal Event

    The number of local companies the organization hopes to recruit for the event

    Matched Donor Biographical Information Setting that indicates whether this donor's contributions are matched by an employer
    Maximum Total Authorized Delayed Self Pledge Monetary amount that the participant will pay if they do not raise more funds before the deadline
    Member ID Biographical or Participant Constituent Information Identifying number the system set for the participant at registration
    Member ID Recipient Constituent Information Identifying number the system set for the recipient at registration
    Message Name Email Message Label the author provided for the coaching email message to identify it in the list of Coaching Emails
    Message Purpose Email Message Details the author provided for the coaching email message to identify its usage in the list of Coaching Emails
    Middle Name Biographical or Participant Constituent Information Middle name of the participant who registered for an event
    Middle Name Donor Information Middle name of donor
    Middle Name Recipient Constituent Information Middle name of the recipient who registered for an event
    Milestone Achieved Date Milestones Timestamp of the day, month, and year when the monetary amount of confirmed gifts made in support of this participant exceeded the threshold amount set for the milestone
    Milestone ID Milestones String of numbers that internally identifies this milestone goal
    Milestone Name Milestones Label entered for this milestone to identify it on lists that administrators, participants, and site visitors view
    Monetary Value PCTL Transaction Information Percentile ranking of this person's donations based on total dollar amount contributed relative to other donors (for example, a 10% ranking places the person's donations in the top ten percent of actual dollars)
    Multiple Registrants, Allow Event Settings Setting that indicates whether a person can register more people (typically, family members) and combine all registration fees and upsell purchases into one online payment
    National Companies Only Event Settings Determines that only National Companies are listed for joining or forming teams
    Nominal Amount Charged Delayed Self Pledge Monetary amount charged to participant for the self-pledge process
    Notify Amount Donor Recognition Log Amount of gift to be reported to the person honored
    Occupation (Participant) Biographical Information Employment as indicated by person who registered for this event
    Occupation (Donor) Valued Transaction Employment as indicated by person who will be billed for this transaction
    Offline Gifts ($) Milestones Monetary sum of offline gifts made in support of the participant (entered by the participant or an organization administrator) that are now marked as confirmed, still on the unconfirmed list, or marked as rejected
    Offline Status Gifts True or False to indicate offline donation
    Online Check-In Flow Step Online Check-In Number of the step last completed by a participant in the online check-in process
    Online Check-In Status Online Check-In Status that shows if a participant has started or completed the online check-in process, or if this is unknown.
    Online Gifts ($) Milestones Monetary sum of all gift payments made in support of the particpant with credit card or bank withdrawal payments
    Open Count, Forwarded Email Performance Statistics How many coaching emails that, forwarded by the original recipient to another email address, were subsequently opened by the new recipients
    Open Count, Total Email Performance Statistics Number of coaching emails opened by both the original recipient and all the recipients to whom it was forwarded
    Open Percent Email Performance Statistics Percentage of delivered coaching emails that were opened
    Opens, Number of Email Performance Statistics How many delivered coaching emails that were subsequently opened
    Opt-Out Date Email Timestamp that shows when this person indicated that they did not want future emails from your site
    Opt-Out Method Email Defines how the person chose to opt-out of receiving future email from your site
    Opt-Out Reference ID Email System generated number for the interaction where the person chose to opt-out of receiving future emails from your site
    Origin Application Reference ID Biographical Information System-generated string that identifies the Convio application through which a constituent first interacted with the site
    Origin Application Type Biographical Information Name of the Convio application through which a constituent first interacted with the site
    Origin Source Code Biographical Information Client-defined string returned when a constituent first interacts with a Convio application
    Origin Subsource Biographical Information Client-defined string, returned when a constituent first interacts with a Convio application, that amplifies the Origin Source Code
    Original Value Transacted Valued Transaction The donation or registration fee paid online or recorded
    Participants, Number of Registration Summary Count of the people registered for the event (will include secondary registrants)
    Participation Type Creation Date Participation Type Date when the participation type was created
    Participation Type Modified Date Participation Type Date when an administrator last modified the participation type
    Participation Type Name Participation Type Label that identifies how a person can take part in an event
    Participation Type Status Participation Type Active if available on registration forms; Not Active if not available for display on registration forms
    Password Changed (Participant) Biographical Information Setting that indicates the password has been changed
    Payment, Initial Delayed Self Pledge Month, day, and year of the first payment to be charged
    Payment Method Gifts Credit Card, Bank Account Withdrawal, Cash, or Check
    Payment Method User Pledge Credit Card or Bank Account Withdrawal
    Payment Installment Valued Transaction A number that indicates which payment transaction this is in a sequence of payments
    Payments, Number of Delayed Self Pledge Actual count of the payments based on the money raised by the participant since the self-pledge
    Payments, Number of expected Delayed Self Pledge Count of the payments selected by the participants
    Payments, Number of Failed Delayed Self Pledge Count of the payments not received
    Personal Pages, Allow Event Settings Setting (on the Event Options page) that indicates whether participants can customize their Personal Page, as opposed to inheriting the default page or the page customized by the Team Captain
    Personal Pages with Custom URL Registration Summary Number of Personal Pages where the participant set the URL to a custom setting
    Phone Donor Information Donor's telephone number
    Photo Use Allowed Registration Settings Setting that indicates whether a registrant will permit the hosting organization to display the registrant's photo online
    Postal Code Donor Information Donor's zip code
    Prior Participant Registration Settings Setting that indicates whether the participant registered for this event the last time it occurred
    Private Page Registration Settings Setting that blocks a participant's Personal Page from displaying in public searches
    Processor Transaction ID Valued Transaction Unique number and letter identifier assigned to the donation when it was processed in the system
    Professional Suffix Donor Information Information added to the last name of a donor, such as MD, Esq, and so on
    Progress Meter Threshold Event Settings Administrator configuration that determines the step, in percentage of goal raised or dollar amount raised, at which the progress meter display changes
    Projected Close Date of Sponsorship Team Company Date projected for receiving the money pledged by this sponsor
    Promotion Code Participation Type A code that registrants can enter to receive promotional discounts or options
    Proxy ID Valued Transaction Team ID, Event ID, or Constituent depending on for which of these the transaction was completed
    Proxy Name Valued Transaction As appropriate, one of:
    • Constituent's name
    • TeamRaiser name
    • TeamRaiser team name
    • Administrator
    • No proxy
    Proxy Type Valued Transaction Team, Event, or Participant for which the transaction was completed
    Questions (Additional or Survey) Survey Questions Text of the question asked on the registration, event, or volunteer survey form
    Race Number Registration Settings Personal ID number generated by the system for each appropriate participant if the Generate Race Numbers option is enabled on the Event Options page
    Reference ID (Interaction) Interaction Source System-generated number that identifies the interaction performed
    Real Reference Number Valued Transaction Internal number to track original payment in a sustaining gift series (for Clear Commerce)
    Receipt ID Valued Transaction Generated by system to track PDF receipt
    Recency PCTL Transaction Information Percentile ranking based on how recently this person made a donation relative to other donors
    Recipient Group Name Recipient Group Information Name of administrative group to which emails will be targeted
    Recognition, Is Set Valued Transaction Value set with a Recognition input in the donation form
    Recruited Participants Count Registration Stats How many participants (most likely teammates) a participant has recruited to register
    Recognition Name, Donor Gifts Name to display on gift honor rolls if donor specifies that this, rather than the billing, name should be used
    Recruits, Number Registration Summary How many participants another participant recruited to participate in this event
    Reference Number Valued Transaction Order number generated by Clear Commerce
    Registration, Is Gifts Yes if registration fees are recorded as gifts;
    No if registration fees are kept separate
    Registration Date Registration Date when this donor registered for the event
    Registration Enabled Registration Setting that indicates whether registration was enabled for the event
    Registration Type Registration Online if participant completes registration form and processes it online; Offline if an administrator registers the participant
    Registrations, Number of Email Response Actions How many new constituents registered in response to the coaching email message
    Registrations, Number of Primary Registration Summary How many participants registered themselves (or were registered by an administrator if the Multiple Registrations option is enabled)
    Registrations, Number of Secondary Registration Summary How many participants were registered by another participant as part of that individual's registration
    Routing Number Valued Transaction Specially encoded number that identifies the bank for an account withdrawal
    RSVPs, Number of Email Response Actions How many electronic RSVPs were returned for an event in response to the coaching email message
    Running Total User Pledge Monetary amount pledged at time report was run
    Running Total Delayed Self Pledge Monetary amount raised by the participant to date
    Secondary Registration Registration Settings Setting that indicates a participant was registered by another participant as part of that individual's registration
    Security Category Name Email Campaign Setting that identifies who can modify the coaching email
    Security Category Name Event Setting that identifies who can modify event information
    Security Category Name Participant Constituent Information Setting that indicates what pages and information the participant can view for the event
    Security Category Name Recipient Constituent Information Setting that identifies who can receive the coaching email message
    Send End Date Email Performance Statistics Date when final email was sent from the queue
    Send Start Date Email Performance Statistics Date when the first coaching email was sent from the queue
    Sender Address Donor Recognition Log Label displaying the Street Address of a person who makes a gift on behalf of another person
    Sender Address Message Variant Email address of individual or organizational representative whose email address will be displayed as the sender's
    Sender First Name Donor Recognition Log Label displaying the First Name of a person who makes a gift on behalf of another person
    Sender Last Name Donor Recognition Log Label displaying the Last Name of a person who makes a gift on behalf of another person
    Sender Name Message Variant Name of individual or organizational representative to be displayed as the sender
    Settlement Batch Valued Transaction The settlement batch ID associated with this transaction
    Settlement Date Valued Transaction Date when this transaction was settled.
    Settlement Status Valued Transaction Settled, Unsettled, or Submitted
    ACH only
    Soft Bounce Percent Email Performance Statistics Percentage of the coaching email messages returned because of a temporary condition (such as full mailbox, the email server was temporarily unavailable, and so on)
    Soft Bounces, Number of Email Performance Statistics How many coaching email messages returned because of a temporary condition (such as full mailbox, the email server was temporarily unavailable, and so on)
    Soft Credit Type Gifts Participant, Team, or Event, depending on whom the donor chose to support
    Source Code Text Interaction Source Parameter appended by the constituent to a linking URL
    Source Code Type Interaction Source One of the following:
    • Other
    • Link
    • Tell-A-Friend
    • Email (original or forwarded)
    • Ecard
    • Referrer
    • Personal Outreach
    Start Date Delayed Self Pledge Month, day, year when the recurring payments will begin
    Sponsor Amount Committed Team Company Total monetary amount this sponsor has agreed to contribute
    Sponsor Amount Paid Team Company Monetary amount that has been received from this sponsor so far
    Sponsor Amount Pending Team Company Monetary amount yet to be collected from this sponsor
    Sponsor Ask Amount Team Company Monetary amount that this sponsor has been (or will be) asked to contribute to this TeamRaiser event
    Sponsor Contact Email Team Company Email address where the contact person at the sponsor company will accept email
    Sponsor Contact Name Team Company Name of the person at the sponsor company with whom to communicate
    Sponsor Contact Phone Team Company Telephone number of the contact person at the sponsor company
    Sponsor Gift Type Team Company Type of gift that this sponsor will provide:
    • Cash
    • Volunteer
    • Other
    Sponsor Notes Team Company Details about this sponsor that other administrators may need to know
    Sponsor Payment Type Team Company Method of payment that this sponsor will use:
    • Cash
    • Check
    • Credit
    • In Kind
    • Other
    Sponsor Staff Name Team Company Name of the person from your organization who contacted (or, will contact) this sponsor
    Sponsor Status Team Company Phase in the sponsorship process that this sponsor has completed:
    • Ask
    • Committed
    • Contract
    • Paid
    • Prospect
    • Declined
    Sponsor Volunteer Manager Name Team Company Name of the volunteer who will work with the sponsor
    Sponsorship Type Team Company type of company teams for this sponsor:
    • National
    • Regional
    • Local
    • Other
    State/Province Donor Information State or Canadian Province where the donor lives
    Street1 Donor Information Number and name of the street where the donor lives
    Street2 Donor Information Additional information about the donor's street address (such as apartment number, and so on)
    Subject Message Variant The subject provided by the administrator for a test email
    Sub-Source Code Text Interaction Source Substring within a parameter appended by the constituent to a linking URL
    Suffix Donor Information Information that displays after the last name of a donor, such as Jr or Sr
    Surveys Taken, Number of Email Response Actions How many surveys were taken in response to the coaching email message
    Targeted Number of Email Delivery Count Email Performance Statistics How many email messages are expected to be sent
    Tax Deductible Amount($) Participation Type Dollar amount that a participant can deduct from their taxes
    Tax Deductible Value User Pledge Dollar amount of a gift that a donor can deduct from income taxes
    Tax ID Event Identification number for this event (if different from the one being used sitewide)
    Team Previous Teams Not Returned Information The system generated identifier for the team
    Team Captain, Is Registration Setting that indicates whether the participant is a Team Captain
    Team Creation Date Team Date when the Team Captain formed the team
    Team Description Team Settings Additional information about a team
    Team Division Team Settings Setting that identifies a group of teams competing against each other
    Team Goal ($), Suggested Event
    Team Members, Previous Event Previous Event The number of members in the previous event team
    Team Modified Date Team Date when changes were made to the team information
    Team Name Team Label for a team competing in the event
    Team Name Previous Teams Not Returned Information Label for the previous event team not registered for the current event
    Team Pages with Custom URL Registration Summary Number of Team Pages where the Team Captain set the URL to a custom setting
    Team, Is Private [via Password Protection] Team Settings Setting that requires registrants to know the password of a team before joining it
    TeamRaiser Registrations, Number of Email Response Actions How many new participants registered for the TeamRaiser in response to the coaching email message
    Teams, Allow Event Settings Setting that permits teams to be formed in the event
    Teams, Number of Registration Summary How many of teams are registered for this event
    TellAFriend Forward Recipients Email Performance Statistics How many email addresses to which the email was forwarded by a participant using the Tell-A-Friend feature
    TellAFriend Forwards Email Performance Statistics How many emails forwarded by a participant using the Tell-A-Friend feature
    Tender Instance Name User Pledge Code indicating Credit Card type
    Tender Type Name User Pledge Credit Card, Bank Account Withdrawal, Cash, or Check
    Tentative Send Date Message Variant Date set by administrator as the day and time when a test email should be initiated
    Tentmate Assignment Status Registration Tent Assignment One of:
    • Initial status
    • Eligible for pairing
    • No tent required
    • Single tent
    • Requested
    • Requested by tentmate
    • Requested by tentmate and eligible
    • Accepted awaiting eligibility
    • Accepted awaiting tentmate eligibility
    • Accepted and confirmed
    Tentmate, Eligible for Registration Tent Assignment Status that shows if a participant has completed the minimum fundraising requirement that allows them to choose a tentmate or be selected for a tent
    Ticket Purchases, Number of Email Response Actions How many tickets were purchased in response to the coaching email message
    Title Donor Information Courtesy title, such as Mr., displayed before the first name of a donor
    Total Amount ($) Milestones Monetary sum of all gift payments made in support of the participant (whether marked as confirmed or if they appear on the unconfirmed gift list) plus the monetary amount of registration fees that the participant paid
    Total Amount (No Fees) ($) Milestones Monetary sum of all gift payments made in support of the participant that are marked as confirmed or if they appear on the unconfirmed gift list but without the amount of registration fees paid included
    Total Offline Amount ($) Milestones Monetary sum of offline gifts made in support of the participant that are marked as confirmed, remain on the unconfirmed list, or have been rejected (usually because of duplicate entries)
    Total Online Amount ($) Milestones Monetary sum of all gift payments made in support of the participant with credit card or bank withdrawal payments
    Transaction ID Valued Transaction Unique number and letter identifier assigned to the donation when it was processed in the system
    Tribute Closing Donor Recognition Log Complimentary closing to the message body selected for the person in whose honor a gift is being made
    Tribute First Name Donor Recognition Log First name of the person in whose honor a gift is being made
    Tribute Last Name Donor Recognition Log Last name of the person in whose honor a gift is being made
    Tribute Message Donor Recognition Log The message for the person in whose honor a gift is being made
    Tribute Title Donor Recognition Log Courtesy form of address for the person in whose honor a gift is being made
    Unconfirmed Donation Amount ($) Milestones Monetary sum of all gift payments promised to the participant but not recorded as received
    Unique Donors Gifts by Donor How many individuals donated to the event
    Unsubscribe Percent Email Performance Statistics Percentage of email recipients who clicked the Unsubscribe link in the coaching email message
    Unsubscribes, Number of Email Performance Statistics How many email recipients clicked the Unsubscribe link in the coaching email message
    Upsell Total Amount($) Registration Amounts Total money value of additional option purchases
    Upsells, Number of Non-Zero Purchased Registration Summary How many additional options were purchased without counting any unpriced options also selected
    Upsells, Total Purchased Registration Summary Total number of all additional options purchased and selected
    User Name Biographical Information User name for logging into the system
    Vanity URLs Registration Summary Refer to Personal Pages with Custom URL or Team Pages with Custom URL for details
    Waiver Accepted Registration Settings Setting that confirms a participant checked the Accept Waiver Conditions checkbox
    Waiver Required Participation Type Settings Setting that requires a participant to click the Accept checkbox of the participant waiver in order to complete registration and take part in the event