Report Columns for TeamRaiser Coaching Email Constituent Performance Report

The following tables contain the available columns you can add to the TeamRaiser Coaching Email Constituent Performance report.

Constituent Information

Address
Accept Mail Yes or No setting, typically enabled by default, for whether the email recipient will accept other email from the site
Address Information Constituent's address information
Advocacy Information
Congressional District (Automatic) Name of the federal legislative geographic area automatically assigned to this person based on the residential address entered
Congressional District (Manual Override) Name of the federal legislative geographic area to which this person is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
County (Manual Override) Name of the county legislative geographic area to which this person is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Municipality (Automatic) Name of the municipality automatically assigned to this person based on the residential address entered
Municipality (Manual Override) Name of the municipality to which this person is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
State House District (Automatic) Name of the state house legislative geographic area automatically assigned to this person based on the residential address entered
State House District (Manual Override) Name of the state house legislative geographic area to which this person is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
State Senate District (Automatic) Name of the state senate legislative geographic area automatically assigned to this person based on the residential address entered
State Senate District (Manual Override) Name of the state senate legislative geographic area to which this person is manually reassigned to cover the cases where the address information is not exact or redistricting has occurred
Biographical Information
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

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.

Constituent ID System-generated identifier that is unique to this person (also called ConsID)
Created By Name of the administrator who created the contact record
Creation Time Month, day, year, and time when the contact record was created
Date of Birth Month, day, year entered as the date of birth for this person
Donor Status

Indication of when this person last made a gift of money to the site:

  • Never

  • Undefined

  • Indirect

  • Direct

  • Unknown

  • Non-donor

Exchange ID System-generated identification number used for importing data about this person into the BlackBaud Raiser's Edge offline donor database
First Name The constituent's first name
Gender Male or Female
Last Modified By Name of the administrator who last modified the contact record
Last Name The constituent's last name
Matched Donor Indicates whether any gifts made by this person are matched by an employer
Member ID Member identification number typically uploaded from an offline database if organization uses member numbers
Middle Name Extra name information entered for this person. Can be a middle name, maiden name, nickname, and so on
Modification Time Month, day, year, and time when the contact record was modified
Origin Application Reference ID System-generated string that identifies the feature through which the person became a registered user of the site
Origin Application Type  
Origin Source Code A string defined by an administrator identifying a page or campaign that generated the user's registration
Origin Subsource Code A string defined by an administrator qualifying the Origin Source Code
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

Professional Suffix Abbreviated respect/education label selected to follow the last name of the person (for example, MD or Esq)
Suffix Abbreviated label selected to follow the last name of the person (for example, Jr)
Title Introductory title that appears before the first name of the person (for example, Mr. or Mrs.)
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.
Data Privacy
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.

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.

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.

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.

Email
Accept Email Yes or No- Typically enabled by default, for whether the email recipient will accept other email from the site
Email The constituent's email address
Hard-Bounce Count Number of coaching emails that were sent back as undeliverable because of an invalid email address
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
Opt-Out Method

Indicates who or how the Opt-Out option was disabled:

  • Undefined
  • Admin
  • User (constituent)
  • Link
  • Exchange
Opt-Out Reference ID System-generated identifier that tracks the opt-in/opt-out status change of this person
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

Employment
Employer Name of the constituent's employer
Occupation The constituent's occupation
Phone
Phone Ten-digit telephone number listed for contacting this person
Transaction Information  
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
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
Lifetime Alert Response Count Total number of alerts to which this person responded since becoming a registered user of your site
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
Previous Year Alert Response Count Number of alerts to which this person responded during the previous calendar year
Recency PCTL Percentile ranking of how recently this person made a donation relative to other donors
YTD Alert Response Count Number of alerts to which this person responded so far this year

Email Information

Email Campaign  
Email Application Name TeamRaiser
Email Campaign Name TeamRaiser Emails
Email Campaign Purpose Coaching Emails
Email Campaign Type TeamRaiser
Interest Name Name provided by administrator to associate an interest with a campaign
Email Message  
Application Name TeamRaiser
Message Name Label the author provided for the coaching email message to identify it in the list of Coaching Emails
Message Purpose Details the author provided for the coaching email message to identify its usage in the list of Coaching Emails
Email Performance Statistics  
Actions Taken Th number of actions (clickthroughs, registrations, action alerts) taken by the recipient of an email
Clickthroughs  
Emails Delivered How many coaching email messages reached their intended email addresses and did not bounce back
Emails Sent The number of coaching emails sent
Forwarded Click-Through Count Number of coaching emails opened by both the original recipient and all the recipients to whom it was forwarded
Forwarded Open Count How many coaching emails that, forwarded by the original recipient to another email address, were subsequently opened by the new recipients
Hard Bounces Number of coaching emails that were sent back as undeliverable because of an invalid email address
Opens How many delivered coaching emails that were opened by the recipient
Soft Bounces How many coaching email messages returned because of a temporary condition (such as full mailbox, the email server was temporarily unavailable, and so on)
TellAFriend Forward Recipients How many email addresses to which the email was forwarded by a participant using the Tell-A-Friend feature
TellAFriend Forwards How many emails forwarded by a participant using the Tell-A-Friend feature
Total Clickthroughs How many times a link was clicked in the coaching email message
Total Open Count Number of coaching emails opened by both the original recipient and all the recipients to whom it was forwarded
Unsubscribes How many email recipients clicked the Unsubscribe link in the coaching email message
Email Response Actions  
Advocacy Actions How many email recipients took an action alert
Donation Amount ($) The amount of money raised as a result of the coaching email message
Donations The number of donations made as a result of the coaching email message
eCommerce Purchase Amount ($) The amount of eCommerce purchases resulting from the coaching email message
eCommerce Purchases The number of eCommerce purchases resulting from the coaching email message
Registrations The number of new constituents who registered as a result of the coaching email message
RSVPs The number of electronic RSVPs received for an event in response to the coaching email message
Surveys Taken The number of surveys taken in response to the coaching email message
TeamRaiser Registrations The number of new participants registered for the TeamRaiser in response to the coaching email message
Ticket Purchases The number of tickets purchased in response to the coaching email message
Message  Variant  
Date Created Date the author created the message, if applicable
Date Modified Date the author modified the message, if applicable
Email Variant Name Name the administrator gave to the test email
Sender Address Email address of individual or organizational representative whose email address will be displayed as the sender's
Sender Name Name of individual or organizational representative to be displayed as the sender
Subject The subject provided by the administrator for a test email
Tentative Send Date Date set by administrator as the day and time when a test email should be initiated

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

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 Classification both for comparison reporting and for grouping this TeamRaiser with similar TeamRaisers associated with the same registration upsells and national companies
Event Type 2 Secondary group for associating this TeamRaiser with other, similar TeamRaisers for reporting purposes
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