CRM filters

Updated by Mikkel Settnes

This feature is available to Team, Business and Enterprise customers and works for your primary CRM.
Team customers can add up to to 20 fields, Business and Enterprise have unlimited fields.

CRM filters allows you to filter directly on properties from your CRM. This allows additional control to generate the exact report needed.

  • Advanced segmentation
  • ABM filtering targeting the right contacts and accounts
  • Re-use properties defined in the CRM

After selecting the Add CRM Property filter you will be able to select properties added to the CRM source (see below for setup)

The available options varies depending on the report. Not all reports support all options ie. a report focusing solely on companies and deals might not offer the option to filter by contact properties.
The Stage filer adapts to the current Stage Model setting on the report
If you select the MQL stage model, then the stage properties will automatically change to be the ones available for the MQL.

The stage properties depend on the underlying CRM object used to create the Stage Model. If you are not sure what CRM object was used, go to the Settings - Stage Models to see more.

If the SQL stage model is based on the Opportunity object from Salesforce, then whenever the SQL stage model is selected, the properties from the Opportunity object will be available.

Setup

  1. To import properties into Dreamdata filters, go to Data Platform > Sources
  2. Select your primary CRM
  3. Select an object from the CRM.
  4. Use the dropdown to select between available properties for that object.

After the next model build the selected properties will be available and if you have enabled the Data Export feature the data will also be exported to your data warehouse.

The properties will automatically be available on all Stage Models build using the respective objects.

Marketing Automation Platforms

Sometimes it's useful to filter on properties that are maintaining in your Marketing Automation Platform. To do this its recommended to sync those fields into your primary CRM.

Most marketing automation platforms, supports syncing data into your CRM. Read more about how that is done here:

How did we do?