Instead of importing all records in a Report/List from the CRM, Koncert has introduced a new setting that allows managers to create additional filters on top of the existing reports in Salesforce.
These settings will give managers the ability to choose filter criteria and when the users import a report from the My Lists tab (Add Lists » Add from CRM), the filters will automatically remove the prospects that do not fit in the filter criteria.
The criteria must be set up in the Administration » CRM Import tab before importing records from the CRM.
Click on the icons to expand or collapse the Objects.
Below you can find instructions on how to set up the filter criteria:
- Expand the Object for which criteria you would like to set up. For example, Contact.
- Click on the Add Filter button and enter the following details to add filter criteria:
- Record Type – Defaults to the selected Object e.g. Contact.
- Field Name, Field Operator, and Field Value – Select the appropriate values to import prospects from Salesforce
- Add Filter – To add more filters, click on Add Filter.
NOTE: To delete an existing filter, click on the delete icon next to the filter (row), as shown below, that you wish to delete.
The confirmation message shown below will be displayed. Click OK to delete the filter or click Cancel to cancel the deletion process.
- Filtered By – When more than two filters are added, the Boolean logic “AND” and “OR” can be applied to the filters to query and import records from Salesforce, based on the values.
Example: Using the Boolean logic “AND” and “OR”
In the above screenshot, based on the filter logic applied, Koncert will check for Condition 1 (1 AND 2) i.e. Contacts with ‘State’ equals ‘CA’ and ‘Account Name’ that contains ‘Blue’. Contacts that match Condition 1 will be imported from Salesforce.
Koncert will check for Condition 2 (2 AND 3) i.e. Contacts with ‘Account Name’ that contains ‘Blue’ and ‘Title’ that contains ‘VP, Facilities’. Contacts that match Condition 2 will be imported from Salesforce.
- Click Save All Settings to save the criteria. The filter criteria for other objects can be configured here. Multiple filters can be applied by clicking the ‘Add Filter’ button.
Please contact Koncert Support for any questions at firstname.lastname@example.org or 603-952-2505.