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 SponsorshipDate on which this sponsor was contacted for the contribution
CompanyName of the donating company
Company Fiscal YearAccounting period to which the funds raised will be applied
Company GoalHow much money company hopes to raise
Company NotesDetails about this company that other administrators may need to know
Company Thermometer AdjustmentHow much was subtracted from the fundraising Thermometer status indicator for registration subsidies, matching gifts, and so on
Company URLThe Web address of the homepage for the site that the company uses as their public Web site
Company Volunteer ManagerName of the volunteer who will work with the company
Internal Company NameAlternative label, such as a short name, to identify a company to administrators
Is Archived CompanySetting that determines whether the company is active or is no longer on the active list
Is National CompanySetting that determines whether a company supports teams in all events across a type of TeamRaiser
Is Only SponsorWhether or not the company is the only sponsor
Is Regional Company 
Participant Recruiting GoalThe number of participants the company hopes to recruit for the event
Projected Close Date of SponsorshipProjected date for receiving the money pledged by this sponsor
Public Company NameName of the company who will be a sponsor
Sponsor Amount CommittedTotal monetary amount this sponsor has agreed to contribute
Sponsor Amount PaidMonetary amount that has been received from this sponsor so far
Sponsor Amount PendingMonetary amount yet to be collected from this sponsor
Sponsor Ask AmountMonetary amount that this sponsor has been (or will be) asked to contribute to this TeamRaiser event
Sponsor Contact EmailEmail address where the contact person at the sponsor company will accept email
Sponsor Contact NameName of the person at the sponsor company with whom to communicate
Sponsor Contact PhoneTelephone number of the contact person at the sponsor company
Sponsor Gift Type

Type of gift that this sponsor will provide:

  • Cash

  • Volunteer

  • Other

Sponsor NotesDetails 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 NameName 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 NameName of the volunteer who will work with the sponsor
Sponsorship Type

Type of company teams for this sponsor:

  • National

  • Regional

  • Local

  • Other

Staff NameName of the person from your organization who contacted (or, will contact) this sponsor
Team Recruiting GoalThe number of teams the company hopes to recruit for the event

 

eCommerce Information

eCommerce Product
Number Participant eCommerce PurchasesCount 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 DetailsThe 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:

  • 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 IDSystem-generated identifier that is unique to this person (also called ConsID)
Participant Created ByName of the administrator who created the contact record
Participant Creation TimeMonth, day, year, and time when the contact record was created
Participant Date of BirthMonth, 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 IDSystem-generated identification number used for importing data about this person into the BlackBaud Raiser's Edge offline donor database
Participant First NameThe constituent's first name
Participant GenderMale or Female
Participant Last Modified ByName of the administrator who last modified the contact record
Participant Last NameThe constituent's last name
Participant Matched DonorIndicates whether any gifts made by this person are matched by an employer
Participant Member IDMember identification number typically uploaded from an offline database if organization uses member numbers
Participant Middle NameExtra name information entered for this person. Can be a middle name, maiden name, nickname, and so on
Participant Modification TimeMonth, day, year, and time when the contact record was modified
Participant Origin Application Reference IDSystem-generated string that identifies the feature through which the person became a registered user of the site
Participant Origin Application Type 
Participant Origin Source CodeA string defined by an administrator identifying a page or campaign that generated the user's registration
Participant Origin Subsource CodeA 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 SuffixAbbreviated respect/education label selected to follow the last name of the person (for example, MD or Esq)
Participant SuffixAbbreviated label selected to follow the last name of the person (for example, Jr)
Participant TitleIntroductory title that appears before the first name of the person (for example, Mr. or Mrs.)
Participant User NameString 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 EmailYes or No- Typically enabled by default, for whether the email recipient will accept other email from the site
Participant EmailThe constituent's email address
Participant Hard-Bounce CountNumber of coaching emails that were sent back as undeliverable because of an invalid email address
Participant Opt-Out DateMonth, 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 IDSystem-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 EmployerName of the participant's employer
Participant OccupationThe participant's occupation

 

 

Participant Phone
Participant PhoneThe participant's ten-digit phone number

 

 

Participant Transaction Information
Participant Engagement Factor 1 - 10Constituent'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 PCTLPercentile 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 CountTotal number of times the constituent has taken action on alerts since first interacting with your site
Participant Monetary Value PCTLConstituent'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 CountTotal number of times the constituent has taken action on alerts in the previous calendar year
Participant Recency PCTLConstituent's percentile ranking based on how recently he or she made a donation relative to other donors
Participant YTD Alert Response CountTotal 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 CodeA 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 DateDate when the participation type was created
Participation Type Modified DateDate when an administrator last modified the participation type
Participation Type NameLabel that identifies how a person can take part in an event

 

Participation Type Settings
Participant Waiver RequiredSetting 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 StepNumber of the step last completed by a participant in the online check-in process
Online Check-In StatusStatus 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 CaptainSetting that indicates whether the participant is a Team Captain
Participant Constituent IDString that identifies a constituent registered on your site
Personal Page Last Updated DateThe last time the participant updated their personal page
Registration Active StatusActive or Inactive to indicate the participant's status within your organization
Registration DateDate when this donor registered for the event
Registration TypeOnline 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 AmountDollar amount subtracted from registration fee when a participant applies a discount code
Discount TypeLabel 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 PhoneName and telephone number of the person to contact on behalf of a participant in the event of an emergency
Gift NotificationConfiguration 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 PageSetting that blocks a participant's Personal Page from displaying in public searches
Honorary Team NameLabel for the special honorary team, if this option is enabled on the Team Options page
Is Photo Use AllowedSetting that indicates whether a registrant will permit the hosting organization to display the registrant's photo online
Is Prior ParticipantSetting that indicates whether the participant registered for this event the last time it occurred
Is Secondary RegistrationSetting that indicates a participant was registered by another participant as part of that individual's registration
Race NumberPersonal ID number generated by the system for each appropriate participant if the Generate Race Numbers option is enabled on the Event Options page
Waiver AcceptedSetting that confirms a participant checked the Accept Waiver Conditions checkbox

 

Registration Stats
Emails SentHow 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 AbbreviationAbbreviated name of the organization's affiliate/chapter that created the email campaign
Security Category NameSetting that identifies who can modify the coaching email

Team Information

Team
Team The system generated identifier for the team
Team Creation DateDate when the Team Captain formed the team
Team Goal ($)The amount of money the team hopes to raise
Team Members GoalThe amount of money each team member hopes to raise
Team Modified DateDate when changes were made to the team information
Team NameLabel for a team competing in the event

 

Team Settings
Is CaptainlessIndicates whether the team does not include a captain
Is Honorary TeamSetting that identifies whether the team is honorary
Is PrivateSetting that requires registrants to know the password of a team before joining it
Team DescriptionAdditional information about a team
Team Division Setting that identifies a group of teams competing against each other

TeamRaiser Campaign Information

Event 
Campaign Tax IDThe tax identification number for the TeamRaiser
EventThe system generated identifier for the event
Event Created DateDate when the event was first created
Event DateMonth, day, and year when an event will take place
Event DescriptionDetails about the TeamRaiser event that search engines can use to locate TeamRaiser pages
Event Local Company Recruitment GoalThe number of local companies the organization hopes to recruit for the event
Event Modified DateDate 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 GoalThe 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 StatusPublished, Unpublished, or Archived
Event Team Recruitment GoalThe number of teams the organization hopes to recruit for the event
Fiscal YearAccounting period to which the funds raised will be applied
Internal Event NameShort name of the event for administrators
Lead Event NameThe name of the main community event with which smaller events may be affiliated
Previous Campaign IDThe system generated identifier for the previous event
Public Event NameLabel that identifies the event on pages accessible to site visitors and participants
Public Event TypeClassification 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 AffiliationSpecifies whether the event is a lead or affiliate event

 

Event Settings 
Allow DonationsSetting on the Fundraising Options page for whether donations will be accepted
Allow GoalSetting that lets participants specify fundraising goals (on the Event Options page)
Allow Multiple RegistrantsSetting 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 PagesSetting (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 GiftsEvent Options page setting to display a link on the Team pages allowing donations in support of the entire team
Allow TeamsSetting that permits teams to be formed in the event
AreaThe geographical area in which an event will take place
CityThe city in which an event will take place
CountryThe country in which an event will take place
CountyThe county in which an event will take place
Include Team CompaniesSetting 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 UnconfirmedEvent Options page setting to display unconfirmed gifts in the Gift History lists (on participant's Progress pages)
Location NameLabel that specifies the name of the site where the event will take place
Max Captains Per TeamSetting for whether a team has more than one captain, as well as the maximum number of co-captains allowed
National Companies OnlySetting 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 ThresholdAdministrator configuration that determines the step, in percentage of goal raised or dollar amount raised, at which the progress meter display changes
RegionLabel that specifies a geographical area in which an event will take place
StateLabel that specifies the state in which an event will take place
Street AddressLabel that specifies the number and name of the street on which an event will take place
Zip CodeLabel that specifies the ZIP Code in which an event will take place