Report Columns for TeamRaiser eCommerce Purchase Revenue By Team Report
The following tables contain the available columns you can add to the TeamRaiser eCommerce Purchase By Revenue 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 | The company's accounting period to which the funds raised will be applied |
| Company Goal | The amount of money the company hopes to raise online for the event |
| Company Notes | Details about the 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 website |
| Company Volunteer Manager | Name of the volunteer who will work with the company |
| Internal Company Name | Alternative label, such as a short name, that identifies the donating 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 New Company | |
| Is Only Sponsor | Determines if the company will not display for selection when Team Captains form teams in this TeamRaiser event |
| Is Regional Company | |
| Participant Recruiting goal | |
| Priority | |
| 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:
|
| 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 | |
| Team Recruiting Goal | |
| 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 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 |
| 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 |