Available Report Columns for TeamRaiser Performance By Team Report
The following tables contain the available columns you can add to the TeamRaiser Performance By Team report type.
Company Information
| Company | |
|---|---|
| Ask Date of Sponsorship | Date on which this sponsor was contacted for the contribution |
| Company | Name of the donating company |
| Company Fiscal Year | Accounting period to which the funds raised will be applied |
| Company Goal | How much money company hopes to raise |
| Company Notes | Details about this company that other administrators may need to know |
| Company Thermometer Adjustment | How much was subtracted from the fundraising Thermometer status indicator for registration subsidies, matching gifts, and so on |
| Company URL | The Web address of the homepage for the site that the company uses as their public Web site |
| Company Volunteer Manager | Name of the volunteer who will work with the company |
| Internal Company Name | Alternative label, such as a short name, to identify a company to administrators |
| Is Archived Company | Setting that determines whether the company is active or is no longer on the active list |
| Is National Company | Setting that determines whether a company supports teams in all events across a type of TeamRaiser |
| Is Only Sponsor | Whether or not the company is the only sponsor |
| Is Regional Company | |
| Participant Recruiting Goal | The number of participants the company hopes to recruit for the event |
| Projected Close Date of Sponsorship | Projected date for receiving the money pledged by this sponsor |
| Public Company Name | Name of the company who will be a 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:
|
| Sponsor Notes | Details about this sponsor that other administrators may need to know |
| Sponsor Payment Type | Method of payment that this sponsor will use:
|
| 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:
|
| Sponsor Volunteer Manager Name | Name of the volunteer who will work with the sponsor |
| Sponsorship Type | Type of company teams for this sponsor:
|
| Staff Name | Name of the person from your organization who contacted (or, will contact) this sponsor |
| Team Recruiting Goal | The number of teams the company hopes to recruit for the event |
Gift Information
| Gifts by Donor | |
|---|---|
| Gifts | Total donations |
| Number From Participant | Donations made by a 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 | How many individuals donated to the event |
| Gifts by Status | |
|---|---|
| All Confirmed Gifts | Count of the online gifts plus the number of offline gifts marked as confirmed |
| All Not-Rejected Gifts | Count of both confirmed and unconfirmed offline gifts |
| Offline Confirmed Gifts | Total number of received cash, check, and pay-later gifts recorded and marked as Confirmed |
| Offline Gifts | Total cash, check, and pay-later gifts recorded by the participant or administrator, but not yet confirmed as received |
| Offline Not-Rejected Gifts | 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 |
| Offline Rejected Gifts | Total cash, check, and pay-later gifts recorded by the participant or an administrator and then marked as Rejected |
| Offline Unconfirmed Gifts | Total cash, check, and pay-later gifts recorded by the participant or an administrator |
| Online Gifts | Sum of all gift payments made with credit card or bank withdrawal payments |
| Total of All Confirmed Gifts ($) | Dollar sum of online gifts actually collected plus offline gifts marked as confirmed |
| Total of All Not-Rejected Gifts ($) | Dollar sum of online gifts collected plus the value of offline gifts still on the unconfirmed list |
| 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 |
Registration Information
| Registration Summary | |
|---|---|
| Captains | How many captains a team has, if the multiple captains option is enabled on the Team Options page |
| Emails Sent | How many email addresses to which the coaching email was sent |
| Non-Zero Upsells Purchased | How many additional options were purchased without counting any unpriced options also selected |
| Participants | The total number of participants for the event |
| Primary Registrations | How many participants registered themselves (or were registered by an administrator if the Multiple Registrations option is enabled) |
| Recruits | The number of participants another participant recruited to participate in this event |
| Secondary Registrations | The number of participants were registered by another participant as part of that individual's registration |
| Teams | The number of teams are registered for this event |
| Total Fees Paid | Total fees collected through all registration transactions |
| Total Offline Fees Paid | The total amount of fees paid by credit card or automatic bank withdrawals |
| Total Online Fees Paid | The total amount of fees entered by an administrator |
| Total Participant Goals | The amount of money participants hope to raise together |
| Total Upsells Purchased | Total number of all additional options purchased and selected |
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 event information |
Team Captain Information
| Team Captain Address | |
|---|---|
| Team Captain Address | The team captain's street address |
| Team Captain Accept Mail | Yes if the team captain accepts postal mail No if the team captain does not accept postal mail |
| Team Captain Advocacy Information | |
|---|---|
| Team Captain Congressional District (Automatic) | Name of the federal legislative geographic area automatically assigned to this Team Captain based on the residential address entered |
| Team Captain Congressional District (Manual Override) | Name of the federal legislative geographic area to which this Team Captain is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred |
| Team Captain County (Manual Override) | Name of the county legislative geographic area to which this Team Captain is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred |
| Team Captain Municipality (Automatic) | Name of the municipality automatically assigned to this Team Captain based on the residential address entered |
| Team Captain Municipality (Manual Override) | Name of the municipality to which this Team Captain is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred |
| Team CaptainState House District (Automatic) | Name of the state house legislative geographic area automatically assigned to this Team Captain based on the residential address entered |
| Team CaptainState House District (Manual Override) | Name of the state house legislative geographic area to which this Team Captain is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred |
| Team Captain State Senate District (Automatic) | Name of the state senate legislative geographic area automatically assigned to this Team Captain based on the residential address entered |
| Team CaptainState Senate District (Manual Override) | Name of the state senate legislative geographic area to which this Team Captain is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred |
| Team Captain Biographical Information | |
|---|---|
| Team Captain Active Detail | One of the following:
|
| Team Captain 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. |
| Team Captain Constituent ID | System-generated identifier that is unique to this person (also called ConsID) |
| Team Captain Created By | Name of the administrator who created the contact record |
| Team Captain Creation Time | Month, day, year, and time when the contact record was created |
| Team Captain Date of Birth | Month, day, year entered as the date of birth for this person |
| Team Captain Donor Status | Indication of when this person last made a gift of money to the site:
|
| Team Captain Exchange ID | System-generated identification number used for importing data about this person into the BlackBaud Raiser's Edge offline donor database |
| Team Captain First Name | The constituent's first name |
| Team Captain Gender | Male or Female |
| Team Captain Last Modified By | Name of the administrator who last modified the contact record |
| Team Captain Last Name | The constituent's last name |
| Team Captain Matched Donor | Indicates whether any gifts made by this person are matched by an employer |
| Team Captain Member ID | Member identification number typically uploaded from an offline database if organization uses member numbers |
| Team Captain Middle Name | Extra name information entered for this person. Can be a middle name, maiden name, nickname, and so on |
| Team Captain Modification Time | Month, day, year, and time when the contact record was modified |
| Team Captain Origin Application Reference ID | System-generated string that identifies the feature through which the person became a registered user of the site |
| Team Captain Origin Application Type | |
| Team Captain Origin Source Code | A string defined by an administrator identifying a page or campaign that generated the user's registration |
| Team Captain Origin Subsource Code | A string defined by an administrator qualifying the Origin Source Code |
| Team Captain Password Type | Indicates the method used to generate the password:
|
| Team Captain Professional Suffix | Abbreviated respect/education label selected to follow the last name of the person (for example, MD or Esq) |
| Team Captain Suffix | Abbreviated label selected to follow the last name of the person (for example, Jr) |
| Team Captain Title | Introductory title that appears before the first name of the person (for example, Mr. or Mrs.) |
| Team Captain 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. |
| Team Captain Data Privacy | |
|---|---|
| Team Captain Global Privacy Control Opt-Out |
This setting is not editable. The value is set automatically through detection of the browser setting. Once enabled, the option cannot be disabled. |
| Team Captain 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. |
| Team Captain 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. |
| Team Captain 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. |
| Team Captain Email | |
|---|---|
| Team Captain Accept Email | Yes or No- Typically enabled by default, for whether the email recipient will accept other email from the site |
| Team Captain Email | The constituent's email address |
| Team Captain Hard-Bounce Count | Number of coaching emails that were sent back as undeliverable because of an invalid email address |
| Team Captain 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 |
| Team Captain Opt-Out Method | Indicates who or how the Opt-Out option was disabled:
|
| Team Captain Opt-Out Reference ID | System-generated identifier that tracks the opt-in/opt-out status change of this person |
| Team Captain 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 |
| Team Captain Employment | |
|---|---|
| Team Captain Employer | Name of the team captain's employer |
| Team Captain Occupation | The team captain's occupation |
| Team Captain Phone | |
|---|---|
| Team Captain Phone | The team captain's ten-digit phone number |
| Team Captain Transaction Information | |
|---|---|
| Team Captain 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 |
| Team Captain 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 |
| Team Captain Lifetime Alert Response Count | Total number of alerts to which this person responded since becoming a registered user of your site |
| Team Captain 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 |
| Team Captain Previous Year Alert Response Count | Number of alerts to which this person responded during the previous calendar year |
| Team Captain Recency PCTL | Percentile ranking of how recently this person made a donation relative to other donors |
| Team Captain Lifetime Alert Response Count | The total number of alerts to which the team captain responded since becoming a registered user of your site |
Team History Information
| Previous Event | |
|---|---|
| Previous Event Average Confirmed Gifts per Team Member ($) | Average amount of all online gifts actually collected plus offline gifts marked as confirmed generated by team members in the previous events |
| Previous Event Confirmed Gifts ($) | The total amount of all confirmed gifts from the previous events |
| Previous Event Date | The date that the previous event occurred |
| Previous Event Fiscal Year | Accounting period to which the funds raised in the previous event were applied |
| Previous Event Internal Name | Alternative label, such as a short name, to identify the previous event to administrators |
| Previous Event Public Name | Label identifying the previous event on participant and site visitor pages |
| Previous Event Team Members | The number of members in the previous event team |
| Previous Event Team Members Goal | The amount of money the team members hoped to raise in the previous event |
| Previous Event Team Name | The team names from the previous event |
| Previous Team Captain Email | The email address of the team captain from the previous event |
| Previous Team Captain First Name | The first name of the team captain from the previous event |
| Previous Team Captain Last Name | The last name of the team captain from the previous event |
| Previous Team Goal | The amount of money the team hoped to raise in the previous event |
| Team History | |
|---|---|
| Average Confirmed Gifts per Event ($) | Average amount per event of all online gifts actually collected plus offline gifts marked as confirmed generated by a team |
| Average Confirmed Gifts per Team Member ($) | Average amount of all online gifts actually collected plus offline gifts marked as confirmed generated by team members |
| Events | Events that the team has participated in |
| First Event Date | The date of the first event that the team participated in |
| First Event Fiscal Year | The accounting period to which the funds raised during the team's first event were applied |
| First Event Internal Name | Alternative label, such as a short name, to identify the team's first event to administrators |
| First Event Public Name | Label identifying the team's first event on participant and site visitor pages |
| Total Confirmed Gifts in Team History ($) | The total amount of all confirmed gifts from all of the events that the team has participated in |
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 Classification | |
|---|---|
| Event Type | Primary label both for comparison reporting and for grouping this TeamRaiser with similar TeamRaisers associated with similar registration Upsells and national companies |
| Event Type 2 | Primary label both for comparison reporting and for grouping this TeamRaiser with similar TeamRaisers associated with similar registration Upsells and national companies |
| Event Type 3 | Third way for associating this TeamRaiser with other, similar TeamRaisers for reporting purposes |
| 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 |