Report Columns for TeamRaiser Gift Summary By Participant Report

The following tables contain the available columns you can add to the Gift Summary By Participant report.

Company Information

Company
Ask Date of Sponsorship Date on which this sponsor was contacted for the contribution
Company Name of the donating company
Internal Company Name Alternative label, such as a short name, that identifies the donating company to administrators
Is Only Sponsor Determines if the company will not display for selection when Team Captains form teams in this TeamRaiser event
Projected Close Date of Sponsorship Date projected for receiving the money pledged by this sponsor
Sponsor Amount Committed Total monetary amount this sponsor has agreed to contribute
Sponsor Amount Paid Monetary amount that has been received from this sponsor so far
Sponsor Amount Pending Monetary amount yet to be collected from this sponsor
Sponsor Ask Amount Monetary amount that this sponsor has been (or will be) asked to contribute to this TeamRaiser event
Sponsor Contact Email Email address where the contact person at the sponsor company will accept email
Sponsor Contact Name Name of the person at the sponsor company with whom to communicate
Sponsor Contact Phone Telephone number of the contact person at the sponsor company
Sponsor Gift Type

Type of gift that this sponsor will provide:

  • Cash
  • Volunteer
  • Other
Sponsor Notes Details about this sponsor that other administrators may need to know
Sponsor Payment Type

Method of payment that this sponsor will use:

  • Cash

  • Check

  • Credit

  • In Kind

  • Other

Sponsor Staff Name Name of the person from your organization who contacted (or, will contact) this sponsor
Sponsor Status

Phase in the sponsorship process that this sponsor has completed:

  • Ask

  • Committed

  • Contract

  • Paid

  • Prospect

  • Declined

Sponsor Volunteer Manager Name Name of the volunteer who will work with the sponsor
Sponsorship Type

Type of company teams for this sponsor:

  • National

  • Regional

  • Local

  • Other

Gift Information

Gifts by Donor
Gifts Total donations
Number From Participant 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)
Number Not From Participant Total donations made by anyone other than the participant (identified through constituent_id)
Total From Participant ($) 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)
Total Not From Participant ($) Total of donations collected that are not part of the participant's registration payment
Unique Donors The number of individuals that donated to the event
Gifts by Status
All Confirmed Gifts Dollar sum of online gifts actually collected plus offline gifts marked as confirmed
Online Gifts  
Total of All Confirmed Gifts($) Dollar sum of online gifts actually collected plus offline gifts marked as confirmed
Total of All Not-Rejected Gifts($) 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
Total Offline Confirmed Gifts($) Sum of all offline gifts confirmed as received
Total Offline Gifts($) Dollar sum of offline gifts marked as confirmed, plus gifts still on the unconfirmed list, and rejected gifts
Total Offline Not-Rejected Gifts($) 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
Total Offline Rejected Gifts($) Total cash, check, and pay-later gifts recorded by the participant or an administrator and marked as rejected
Total Offline Unconfirmed Gifts($) Total cash, check, and pay-later gifts recorded by the participant or an administrator that have not been confirmed or rejected
Total Online Gifts($) Sum of all gift payments made with credit card or bank withdrawal payments

Miscellaneous Information

Interaction Source
Reference ID System-generated number that identifies the interaction performed
Source Code Text Parameter appended by the constituent to a linking URL
Source Code Type

One of the following:

  • Other

  • Link

  • Tell-A-Friend

  • Email (original or forwarded)

  • eCard

  • Referrer

  • Personal Outreach

Sub Source Code Text Substring within a parameter appended by the constituent to a linking URL

Participant Information

Participant Address
Participant Address The address of the participant
Participant Advocacy Information
Participant Congressional District (Automatic) Name of the federal legislative geographic area automatically assigned to this participant based on the residential address entered
Participant Congressional District (Manual Override) Name of the federal legislative geographic area to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant County (Manual Override) Name of the county legislative geographic area to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant Municipality (Automatic) Name of the municipality automatically assigned to this participant based on the residential address entered
Participant Municipality (Manual Override) Name of the municipality to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant State House District (Automatic) Name of the state house legislative geographic area automatically assigned to this participant based on the residential address entered
Participant State House District (Manual Override) Name of the state house legislative geographic area to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant State Senate District (Automatic) Name of the state senate legislative geographic area automatically assigned to this participant based on the residential address entered
Participant State Senate District (Manual Override) Name of the state senate legislative geographic area to which this participant is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Participant Biographical Information
Participant Active Detail

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
Participant Active Status

Active if the person is a registered user of your site and can log in

Inactive if the person is no longer a registered user of your site.
Participant Constituent ID System-generated identifier that is unique to this person (also called ConsID)
Participant Created By Name of the administrator who created the contact record
Participant Creation Time Month, day, year, and time when the contact record was created
Participant Date of Birth Month, day, year entered as the date of birth for this person
Participant Donor Status

Indication of when this person last made a gift of money to the site:

  • Never

  • Undefined

  • Indirect

  • Direct

  • Unknown

  • Non-donor
Participant Exchange ID System-generated identification number used for importing data about this person into the BlackBaud Raiser's Edge offline donor database
Participant First Name The constituent's first name
Participant Gender Male or Female
Participant Last Modified By Name of the administrator who last modified the contact record
Participant Last Name The constituent's last name
Participant Matched Donor Indicates whether any gifts made by this person are matched by an employer
Participant Member ID Member identification number typically uploaded from an offline database if organization uses member numbers
Participant Middle Name Extra name information entered for this person. Can be a middle name, maiden name, nickname, and so on
Participant Modification Time Month, day, year, and time when the contact record was modified
Participant Origin Application Reference ID System-generated string that identifies the feature through which the person became a registered user of the site
Participant Origin Application Type  
Participant Origin Source Code A string defined by an administrator identifying a page or campaign that generated the user's registration
Participant Origin Subsource Code A string defined by an administrator qualifying the Origin Source Code
Participant Password Type

Indicates the method used to generate the password:

  • Undefined

  • DES (in the DB, DES encrypted)

  • LDAP (in an external DB)

  • Luminate Online SHA (SHA-256 encrypted)

  • Luminate Online RSA

Participant Professional Suffix Abbreviated respect/education label selected to follow the last name of the person (for example, MD or Esq)
Participant Suffix Abbreviated label selected to follow the last name of the person (for example, Jr)
Participant Title Introductory title that appears before the first name of the person (for example, Mr. or Mrs.)
Participant User Name String of letters and numbers that this person enters to log in to the site. Can be entered by the person when registering as a user on this site or generated by the system.
Participant Data Privacy
Participant Global Privacy Control Opt-Out

  • Opted-Out Indicates that the Global Privacy Control setting in the constituent's browser was detected as enabled to opt-out.

  • No Preference (or blank) Indicates that the Global Privacy Control setting in the constituent's browser is not enabled.

This setting is not editable. The value is set automatically through detection of the browser setting. Once enabled, the option cannot be disabled.
Participant Targeted Ads Opt-Out

Indicates whether the constituent indicated that they want to opt out of targeted ads. This is a manual setting set by an administrator.
Participant Sale of Personal Data Opt-Out

Indicates whether the constituent indicated that they want to opt out of the sale of their personal data. This is a manual setting set by an administrator.
Participant Profiling Opt-Out

Indicates whether the constituent indicated that they want to opt out of profiling. This is a manual setting set by an administrator.
Participant Email
Participant Accept Email Yes or No- Typically enabled by default, for whether the email recipient will accept other email from the site
Participant Email The constituent's email address
Participant Hard-Bounce Count Number of coaching emails that were sent back as undeliverable because of an invalid email address
Participant Opt-Out Date Month, day, year, and time that the Opt-out option was disabled by or for this person so they do not receive site email messages by default
Participant Opt-Out Method

Indicates who or how the Opt-Out option was disabled:

  • Undefined
  • Admin
  • User (constituent)
  • Link
  • Exchange
Participant Opt-Out Reference ID System-generated identifier that tracks the opt-in/opt-out status change of this person
Participant Preferred Format

HTML if the person can receive email messages with formatting in them

Plain Text if the person can only receive emails without formatting in them
Participant Employment
Participant Employer Name of the constituent's employer
Participant Occupation The constituent's occupation
Participant Phone
Participant Phone Ten-digit telephone number listed for contacting this person
Participant Transaction Information  
Participant Engagement Factor 1 - 9 Relative ranking of this person who performed an interaction (defined to engage people with your site) with other constituents who performed the same interaction with your Web site
Participant Frequency PCTL Percentile ranking of the frequency at which this person made donations compared to your other donors. For example, 10% means that this person was in the top 90 percent of your most frequent donors; whereas, 90% means that this person was in the top 10 percent of your most frequent donors
Participant Lifetime Alert Response Count Total number of alerts to which this person responded since becoming a registered user of your site
Participant Monetary Value PCTL Percentile ranking of the amount of money this person has donated based on total dollar amount contributed relative to your other donors. For example, 10% means that this person was in the top 90 percent of actual dollars donated; whereas, 90% means that this person was in the top 10 percent of actual dollars
Participant Previous Year Alert Response Count Number of alerts to which this person responded during the previous calendar year
Participant Recency PCTL Percentile ranking of how recently this person made a donation relative to other donors
Participant YTD Alert Response Count Number of alerts to which this person responded so far this year

Participation Type Information

Participation Type Settings
Participant Waiver Required 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

Registration Information

Online Check-In
Offline Fees Paid Amount($) Registration fees collected from all registrants via offline payments
Online Check-In Flow Step Number of the step last completed by a participant in the online check-in process
Online Check-In Status Status that shows if a participant has started or completed the online check-in process, or if this is unknown.
Online Fees Paid Amount ($) Registration fees collected from all registrants via online payments
Registration
Is Team Captain Setting that indicates whether the participant is a Team Captain
Participant Constituent ID String that identifies a constituent registered on your site
Personal Page Last Updated Date The last time the participant updated their personal page
Registration Active Status Active or Inactive to indicate the participant's status within your organization
Registration Date Date when this donor registered for the event
Registration Type Online if participant completes registration form and processes it online; Offline if an administrator registers the participant
Registration Amounts
Additional Gift Amount ($) Dollar figure a registering participant can enter in the Additional Gift field on the Fundraising Options page, if that option is enabled
Discount Amount Dollar amount subtracted from registration fee when a participant applies a discount code
Discount Type Label that identifies the discount processed
Fees Paid Amount ($) Registration fees (including secondary ones) collected from all registrants
Participant Goal ($) The amount of money the participant hopes to raise
Upsell Total Amount ($) Total money value of additional option purchases
Registration Settings
Emergency Name and Phone Name and telephone number of the person to contact on behalf of a participant in the event of an emergency
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
Has Private Page Setting that blocks a participant's Personal Page from displaying in public searches
Honorary Team Name Label for the special honorary team, if this option is enabled on the Team Options page
Is Photo Use Allowed Setting that indicates whether a registrant will permit the hosting organization to display the registrant's photo online
Is Prior Participant Setting that indicates whether the participant registered for this event the last time it occurred
Is Secondary Registration Setting that indicates a participant was registered by another participant as part of that individual's registration
Race Number Personal ID number generated by the system for each appropriate participant if the Generate Race Numbers option is enabled on the Event Options page
Waiver Accepted Setting that confirms a participant checked the Accept Waiver Conditions checkbox
Registration Stats
Emails Sent How many email addresses to which the coaching email was sent
Recruited Participants Count

How many participants registered for the TeamRaiser and joined this team captain or team member's team using the registration link found on the Personal Page of the participant identified in this report.

Tip: When a participant registers and joins a team from the Personal Page link of a team captain or team member, the registrant is considered a recruit.

Security Information

Security Category  
Affiliate Abbreviation Abbreviated name of the organization's affiliate/chapter that created the email campaign
Security Category Name Setting that identifies who can modify the coaching email

Team Information

Team
Team The system generated identifier for the team
Team Creation Date Date when the Team Captain formed the team
Team Goal ($) The amount of money the team hopes to raise
Team Members Goal The amount of money each team member hopes to raise
Team Modified Date Date when changes were made to the team information
Team Name Label for a team competing in the event
Team Settings
Is Captainless Indicates whether the team does not include a captain
Is Honorary Team Setting that identifies whether the team is honorary
Is Private Setting that requires registrants to know the password of a team before joining it
Team Description Additional information about a team
Team Division Setting that identifies a group of teams competing against each other

TeamRaiser Campaign Information

Event  
Campaign Tax ID The tax identification number for the TeamRaiser
Event The system generated identifier for the event
Event Created Date Date when the event was first created
Event Date Month, day, and year when an event will take place
Event Description Details about the TeamRaiser event that search engines can use to locate TeamRaiser pages
Event Local Company Recruitment Goal The number of local companies the organization hopes to recruit for the event
Event Modified Date Date when an administrator changed the date of an event
Event Online Goal($) The amount of money the organization hopes to raise online for the event
Event Participant Recruitment Goal The number of participants the organization hopes to recruit for the event
Event Sponsor Goal ($) The amount of money the organization hopes to raise from sponsors for the event
Event Status Published, Unpublished, or Archived
Event Team Recruitment Goal The number of teams the organization hopes to recruit for the event
Fiscal Year Accounting period to which the funds raised will be applied
Internal Event Name Short name of the event for administrators
Lead Event Name The name of the main community event with which smaller events may be affiliated
Previous Campaign ID The system generated identifier for the previous event
Public Event Name Label that identifies the event on pages accessible to site visitors and participants
Public Event Type Classification both for comparison reporting and for grouping this TeamRaiser with similar TeamRaisers associated with the same registration Upsells and national companies
Suggested Participant Goal ($) How much money the organization hopes each participant will try to raise for this event
Suggested Team Goal ($) How much money the team intends to raise
Type of Affiliation Specifies whether the event is a lead or affiliate event
Event Settings  
Allow Donations Setting on the Fundraising Options page for whether donations will be accepted
Allow Goal Setting that lets participants specify fundraising goals (on the Event Options page)
Allow Multiple Registrants 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
Allow Personal Pages 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
Allow Team Gifts Event Options page setting to display a link on the Team pages allowing donations in support of the entire team
Allow Teams Setting that permits teams to be formed in the event
Area The geographical area in which an event will take place
City The city in which an event will take place
Country The country in which an event will take place
County The county in which an event will take place
Include Team Companies 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
Indicate Unconfirmed Event Options page setting to display unconfirmed gifts in the Gift History lists (on participant's Progress pages)
Location Name Label that specifies the name of the site where the event will take place
Max Captains Per Team Setting for whether a team has more than one captain, as well as the maximum number of co-captains allowed
National Companies Only 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
Progress Meter Threshold Administrator configuration that determines the step, in percentage of goal raised or dollar amount raised, at which the progress meter display changes
Region Label that specifies a geographical area in which an event will take place
State Label that specifies the state in which an event will take place
Street Address Label that specifies the number and name of the street on which an event will take place
Zip Code Label that specifies the ZIP Code in which an event will take place