Complete List of Columns for the Constituent Data Blend
Below you will find a complete list of columns that are available to be used in Insights and Pathways.
These columns (sometimes also referred to as fields) are the standard columns we generate when we create the constituent data blend. To utilize the data blend fully, please check that you have mapped all columns in the CRM that you would like to make available for use. When using these in Pathways, you can always choose List of Options in the drop down menu to see what each of these columns contain.
- Id - STRING
- Account Type - STRING
- Updated At - TIMESTAMP
- Contactability - STRING
- Contacts - RECORD
- Address - RECORD
- Address 1 - STRING
- Address 2 - STRING
- Address City - STRING
- Address Country - STRING
- Address Is Primary - BOOLEAN
- Address Postal Code - STRING
- Address Region - STRING
- Address Type - STRING
- Contact ID - STRING
- Custom - RECORD client specific and requires mapping
- Email - RECORD
- Email - STRING
- Email is Primary BOOLEAN
- Email Is Valid BOOLEAN
- Email Type STRING
- First Name - STRING
- Is Deceased - BOOLEAN
- Last Name - STRING
- Phone RECORD
- Phone - STRING
- Phone Is Primary - BOOLEAN
- Phone is Valid - BOOLEAN
- Phone Type - STRING
- Address - RECORD
- Giving History - RECORD
- First Gift - RECORD
- (see transactions below)
- Second Gift - RECORD
- (see transactions below)
- Last Gift - RECORD
- (see transactions below)
- Largest Gift - RECORD
- (see transactions below)
- First Recurring - RECORD
- (see transactions below)
- Last Recurring - RECORD
- (see transactions below)
- First Midlevel - RECORD
- (see transactions below)
- First Major - RECORD
- (see transactions below)
- First Gift - RECORD
- Giving Summary - RECORD
- Average Gift -NUMERIC
- Current Fiscal Year Cohort - STRING
- Current Fiscal Year Lifecycle - STRING
- Current Fiscal Year Segment - STRING
- Current Fiscal Year Recurring Status - STRING
- Current Trailing 12 Months Cohort -STRING
- Current Trailing 12 Months Lifecycle -STRING
- Current Trailing 12 Months Segment -STRING
- Fiscal Year Differential Amount - NUMERIC
- Given Online - BOOLEAN
- Given Recurring - BOOLEAN
- Giving Level - STRING
- Largest Gift Given Past 24 Months - NUMERIC
- Lifetime Gifts -INT64
- Lifetime Recurring Gifts -INT64
- Lifetime Recurring Revenue - NUMERIC
- Lifetime Revenue - NUMERIC
- Trailing 12 Months Differential Amount - NUMERIC
- Transactions - RECORD
- Overall Amount for Id - NUMERIC (SUM)
- Amount - NUMERIC
- Appeal Code - STRING
- Appeal Name - STRING
- Channel - STRING
- Custom - STRUCT client specific and requires mapping
- Date - DATETIME
- Days Since First Gift - INTEGER
- Id - STRING
- Is First Gift Donation - BOOLEAN
- Is Hard Credit - BOOLEAN
- Is Online - BOOLEAN
- Is Postal - BOOLEAN
- Is Recurring - BOOLEAN
- Line Item Number - INTEGER
- Payment Type - STRING
- Subchannel STRING
- Time Period - RECORD
- Is First Gift Transaction In Period - BOOLEAN
- Month Sort - INTEGER
- Period Transaction Revenue Differential Amount - NUMERIC
- Period Transaction Revenue Upgrade Segment - STRING
- Periods Back - INTEGER
- Transaction Order In Period - INTEGER
- Cohort - STRING
- Gift Order In Period - INTEGER
- Gift Revenue Differential Amount - NUMERIC
- Gift Revenue Upgrade Segment - STRING
- Giving Level At Time - STRING
- Giving Level In Period - STRING
- Giving Level Upgrade Segment - STRING
- Is First Gift Donor Period - BOOLEAN
- Is First Gift In Period - BOOLEAN
- Is Giving Level At Time Upgrade - BOOLEAN
- Is Giving Level In Period Upgrade - BOOLEAN
- Is Largest Gift in Period - BOOLEAN
- Lifecycle - STRING
- Periods Since First Gift - INTEGER
- Previous Cohort - STRING
- Previous Giving Level - STRING
- Previous Giving Level at Time - STRING
- Previous Lifecycle - STRING
- Previous Recurring Status - STRING
- Previous Segment - STRING
- Recurring Status - STRING
- Segment - STRING
- Year Label - STRING
- Year Type - STRING
- Type - STRING
- Updated At - TIMESTAMP
- Years Since First Gift - INTEGER