Virtuous Analytics includes tables with Virtuous Insights data, allowing you to report on donor giving capacity, giving likelihood, engagement, and other wealth information alongside your CRM+ data. Insights data is available at both the Contact level and the Individual level, and each record includes IDs to join the data to other tables from CRM+. This article explains what data is available and how to use it in Analytics.
Note: Virtuous Analytics and Virtuous Insights are both add-ons to CRM+. Your organization needs Insights enabled and access to Analytics to use this data. If your contract does not include Insights, these tables will be empty in Analytics. Contact your Customer Success Manager to discuss pricing and activation.
What Insights Data Is Available in Analytics?
All Insights data in Analytics is organized into two tables: INSIGHTS__CONTACT and INSIGHTS__INDIVIDUAL. In Virtuous Analytics, create or open a report. When adding a Table or Chart, search with the name or find them under the Virtuous CRM+ Source Tables folder.
Contact Data
The INSIGHTS__CONTACT table includes all available Insights Scores, categories, and confidence levels, as well as estimated capacities, suggested Gift potentials and more. This table has one record per Household Contact with available Insights data. Not every CRM+ Contact will have an Insights record as Insights requires First Name, Last Name, City, and State on a Household record.
Individual-Level Data
The INSIGHTS__INDIVIDUAL table includes third-party information like demographic data, political and religious affiliation, and education and occupation information. It also includes email and web engagement for each Individual. This table has one record per Individual with available Insights data. Individual match confidence is separate from Contact-level match confidence; blank values represent missing or unknown data, not zero or false.
Both tables include columns with data that ends in “3 P,” such as Occupation 3 P. This label indicates the data comes from a third-party source rather than from your CRM+ records. As with all third-party data, this information should be reviewed for accuracy.
To learn more about what each Insights Score and value means, check out this support article.
How Can I Use the Insights Data Tables?
Use Insights fields to filter report data and build visuals based on donor signals. Some examples of using the Insights tables include:
- To combine Individual Insights fields with the wealth and giving data from the Contact records, join INSIGHTS__INDIVIDUAL to INSIGHTS__CONTACT by Contact ID. Because Contact records may have multiple Individuals, the join repeats Contact-level values. For Contact-level totals, first aggregate Individual data by Organization ID and Contact ID, then join; grouping after the join does not by itself prevent double-counting. Keep Contact Individual ID when reporting at the Individual level.
- To retain CRM+ contacts without Insights, start from the CRM+ Contact table and use a left join to INSIGHTS__CONTACT.
- To create a list for a Recurring Giving Candidates Campaign, filter INSIGHTS__CONTACT for High Likelihood on Recurring Giving Candidates. Use Recurring Suggested Gift Ask column for proposals.
- To create a report of top donors, add Composite Giving Score, Wealth Score, and Likelihood Score columns to a CRM+ Contact table via a lookup. Filter the Contact table for Life to Date Giving is greater than $5,000.
- To create a visualization of the makeup of political affiliation, add a pie chart with INSIGHTS__INDIVIDUAL as the data source. Use Political Party 3 P as the category and a count of Individuals as the value.
- To create a list of supporters who speak other languages, filter INSIGHTS__INDIVIDUAL based on Preferred Language 3 P. Use this to target Individuals with appeals in their preferred language.