Available Report Columns for the TeamRaiser eCommerce Purchase Revenue By Participant Report
The following tables contain the available columns you can add to the TeamRaiser eCommerce Purchase By Revenue By Participant 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 |
eCommerce Information
| eCommerce Product | |
|---|---|
| Number Participant eCommerce Purchases | Count of the products purchased in support of a specific participant |
| Total Participant eCommerce Additional Donations($) | |
| Total Participant eCommerce Purchases($) | Monetary amount accumulated from all online purchase transactions of this product when purchased in support of a specific participant, including the price, shipping fees, and sales tax, but subtracting any discount amounts applied |
| Total Participant Item eCommerce Purchases($) | |
Participant Information
| Participant Address | |
|---|---|
| Participant Address Details | The address of the participant |
| Participant Accept Mail | Yes if the participant accepts email No if the participant does not accept email |
| Participant 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:
|
| 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:
|
| 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:
|
| 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 |
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:
|
| 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 participant's employer |
| Participant Occupation | The participant's occupation |
| Participant Phone | |
|---|---|
| Participant Phone | The participant's ten-digit phone number |
| Participant Transaction Information | |
|---|---|
| Participant Engagement Factor 1 - 10 | Constituent's rank relative to other constituents who perform the same interaction with your website (such as member logins, donations, ticket purchases, and so on). Each additional engagement factor continues to factor in unique interactions |
| Participant Frequency PCTL | Percentile ranking of the frequency at which this constituent has 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 times the constituent has taken action on alerts since first interacting with your site |
| Participant Monetary Value PCTL | Constituent's percentile ranking 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 | Total number of times the constituent has taken action on alerts in the previous calendar year |
| Participant Recency PCTL | Constituent's percentile ranking based on how recently he or she made a donation relative to other donors |
| Participant YTD Alert Response Count | Total number of LTE alerts taken by the advocate so far for the current calendar year |
Participation Type Information
| Participation Type | |
|---|---|
| Participant Fee Amount ($) | Event registration fee collected from registrants of this participation type |
| Participant Minimum Goal Amount ($) | The minimum dollar amount expected from people registered in this participation type |
| Participant Promotion Code | A code that registrants can enter to receive promotional discounts or options |
| Participant Tax Deductible Amount ($) | Dollar amount that a participant can deduct from their taxes |
| Participation Type Creation Date | Date when the participation type was created |
| Participation Type Modified Date | Date when an administrator last modified the participation type |
| Participation Type Name | Label that identifies how a person can take part in an event |
| 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 |