Online Help

Help Table of Contents

Understanding the Report Columns Available for Constituent Data

The following table lists the columns  that can be included in reports to show information about constituents. The columns correspond to the sections of fields in the Constituent360 contact records of people who performed an interaction on your site (such as registered for the site or a TeamRaiser event, made a donation, attended a Personal Event, and so on).

Note that the columns listed below represent the default fields that can be used in the contact records in the Constituent360 database. If the configuration of your contact records does not include a field, the column will not be available.

In addition to the name of each Column, the table contains the name of the Column Group in which this column is located on the Report Writer Column Configuration page (or, N/A if the report is not available in Report Writer) as well as a Description of the column content and how it is derived if appropriate.

 

COLUMN COLUMN GROUP DESCRIPTION
Accept Mail Address Yes if the person accepts postal mail
No if the person does not accept postal mail
Active Detail Biographical Information 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 Biographical Information 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.
(Advocacy Alerts) Lifetime Response Count Transaction Information Total number of alerts to which this person responded since becoming a registered user of your site
(Advocacy Alerts) Previous Year Alert Response Count Transaction Information Number of alerts to which this person responded during the previous calendar year
(Advocacy Alerts) YTD Alert Response Count Transaction Information Number of alerts to which this person responded so far this year
City Address Name of the city listed for the residence of the person
Constituent ID Biographical Information System-generated identifier that is unique to this person (also called ConsID)
Country Address Name of the country listed for the residence of this person
Created By Biographical Information Name of the administrator who created the contact record
Creation Time Biographical Information Month, day, year, and time when the contact record was created
Date of Birth Biographical Information Month, day, year entered as the date of birth for this person
Donor Status Biographical Information Indication of when this person last made a gift of money to the site:
  • Never
  • Undefined
  • Indirect
  • Direct
  • Unknown
  • Non-donor
(Donation) Frequency PCTL Transaction Information Percentile ranking of the frequency at which this person made donations compared to your other donors (For example, 10% means this person was in the top ten percent of your most frequent donors)
(Donation) Monetary Value PCTL (for donations made) Transaction Information Percentile ranking of the amount of money this person has donated based on total dollar amount contributed relative to your other donors (For example, a 10% ranking would place the donations made by this person in the top ten percent of actual dollars)
(Donation) Recency PCTL Transaction Information Percentile ranking of how recently this person made a donation relative to other donors
Email (Address) Email Email address at which this person can be sent email
Email Status Email Indication if the email address above is:
  • Unknown
  • Good
  • Bad (soft bounce)
  • Bad (hard bounce)
Employer Employment Name of the employer listed by the person
Engagement Factor 1 to 10 (Interactions) Transaction Information 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
Exchange ID Biographical Information System-generated identification number used for importing data about this person into the BlackBaud Raiser's Edge offline donor database
First Name Biographical Information First name of the person
Gender Biographical Information Male or Female
Hard-Bounce Count Email Total number of email messages that failed delivery due to invalid email address
Last Modified By Biographical Information Name of the administrator who last modified the contact record
Last Name Biographical Information Last name of this person
Matched Donor Biographical Information Indicates whether any gifts made by this person are matched by an employer
Member ID Biographical Information Member identification number typically uploaded from an offline database if organization uses member numbers
Middle Name Biographical Information Extra name information entered for this person. Can be a middle name, maiden name, nickname, and so on
Modification Time Biographical Information Month, day, year, and time when the contact record was modified
Occupation Employment Job type selected by this person
Opt-Out Date Email Month, day, year, and time that the Opt-out checkbox was disabled by or for this person so they do not receive site email messages by default
Opt-Out Method Email Indicates the way the Opt-Out checkbox was disabled:
  • Undefined
  • Admin
  • User (constituent)
  • Link
  • Exchange
Opt-Out Reference ID Email System-generated identifier that tracks the opt-in/opt-out status change of this person
Origin Biographical Information Name of the Convio feature through which the person became a registered user of the site
Origin Reference ID Biographical Information System-generated string that identifies the Convio feature through which the person became a registered user of the site
Origin Type Biographical Information System-generated string that qualifies Origin Reference ID
Origin Source Code Biographical Information A string defined by an administrator identifying a page or campaign that generated the user's registration
Origin Subsource Code Biographical Information A string defined by an administrator qualifying the Origin Source Code
Password Changed Biographical Information
Password Type Biographical Information Indicates the method used to generate the password:
  • Undefined
  • DES (in the Convio DB, DES encrypted)
  • LDAP (in an external DB)
  • Convio SHA (SHA-256 encrypted)
  • Convio RSA
Phone Phone Ten-digit telephone number listed for contacting this person
Preferred Format (Email) Email 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
Professional Suffix Biographical Information Abbreviated respect/education label selected to follow the last name of the person (for example, MD or Esq)
State/Province Address Two-letter abbreviation for the state listed for the residence of the person
Street 1 Address Number and name of the street listed as the residence of the person
Street 2 Address Additional information pertaining to the address of the residence (for example, Apt)
Street 3 Address Additional information pertaining to the address of the residence
Suffix Biographical Information Abbreviated label selected to follow the last name of the person (for example, Jr)
Title Biographical Information Salutatory title selected to appear before the first name of the person (for example, Mr)
User Name Biographical Information 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.
ZIP/Postal Code Address ZIP or Postal Code selected for the residence of the person
The following Advocacy columns refer to the legislative districts that represent this person in different levels of government:
Congressional District (Automatic) Advocacy Information Name of the federal legislative geographic area automatically assigned to this person based on the residential address entered
Congressional District (Manual Override) Advocacy Information 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 (Automatic) Advocacy Information Name of the county legislative geographic area automatically assigned to this person based on the residential address entered
County (Manual Override) Advocacy Information 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) Advocacy Information Name of the municipality automatically assigned to this person based on the residential address entered
Municipality (Manual Override) Advocacy Information 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) Advocacy Information Name of the state house legislative geographic area automatically assigned to this person based on the residential address entered
State House District (Manual Override) Advocacy Information 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) Advocacy Information Name of the state senate legislative geographic area automatically assigned to this person based on the residential address entered
State Senate District (Manual Override) Advocacy Information 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