The following tables contain the available columns you can add to the Online Check-In Progress By Team report type.
Gifts by Donor| 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 | 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 | Credit card and bank withdrawal donations |
| 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 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 |
| Primary Registrations | How many participants registered themselves (or were registered by an administrator if the Multiple Registrations option is enabled) |
| Recruits | How many participants another participant recruited to participate in this event |
| Secondary Registrations | How many participants were registered by another participant as part of that individual's registration |
| Total Fees Paid | Total fees collected through all registration transactions |
| Total Offline Fees Paid | Registration fees collected from all registrants via offline payments |
| Total Online Fees Paid | Registration fees collected from all registrants via online payments |
| Total Participant Goals | How much money participants hope to raise together |
| Total Upsells Purchased | Total number of all additional options purchased and selected |
Team Captain Constituent Information| Accepts Email | Yes or No setting that determines if this contact accepts email messages from your site |
| Constituent ID | String that identifies a constituent who is registered on your site |
| Donor Status | Setting that shows this person is a team captain |
| Email Opt Out Date | Timestamp that shows when the person disabled (unchecked) the email Opt-In checkbox |
| First Name | First name of the person |
| Home City | Name of the city in which the residence of the person is located |
| Home Country | Name of the country in which the residence of the person is located |
| Home Phone | Telephone number at which the person can be contacted |
| Home State/Province | Name of the state or province in which the residence of the person is located |
| Home Street 1 | Number and name of the street on which the residence of the person is located |
| Home Street 2 | Extra information about the residence of the person (for example, Apartment Number) |
| Home Street 3 | Extra information about the residence of the person |
| Home Zip | ZIP code in which the residence of the person is located |
| Last Name | Last name of the person |
| Member ID | Number string that the system set for the person upon registration completion |
| Middle Name | Name entered by the person; can be a maiden name, nickname, family name, or so on |
| Preferred Email Format | Setting that determines if the person wants to receive HTML-formatted or plain text emails |
| Primary Email Address | Web email address of this person |
| Secondary Email Address | Alternate Web email address of the person |
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 Goal($) | How much money the organization hopes to raise with this event |
| 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 | State of the event (one of 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 |
| 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 hopes 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 Honorary Teams | Setting on the Team 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 | Label that specifies the geographical area in which an event will take place |
| City | Label that specifies the city in which an event will take place |
| Country | Label that specifies the country in which an event will take place |
| County | Label that specifies the county in which an event will take place |
| Event | The system generated identifier for the event |
| Event ID | The system generated identifier for the event |
| 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 |
| Is Blueprint | Setting for whether the event is a Blueprint event |
| 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 |