Filtering records bidirectionally using specific criteria

Hey there, nice of you to join us today!

Having trouble with one of SyncApps’ powerful features?

Well, you’ve definitely come to the right page!

 

Are you filtering from Dynamics CRM, Salesforce, Highrise CRM, NetSuite, Zoho CRM or others that are only syncing those CRM records who meet specific criteria?

If it happens that you are using Salesforce, test out this way on our trial using a subset of your database as shown here.

Also, filtering specific records into CRM from your Marketing Automation solution like Mailchimp, Constant Contact, Pardot, Salesforce Marketing Cloud, Delivra, and others?

If you want to filter into your CRM, this feature is also available for use cases where what you want to happen is that, any matching contact that opened or clicked, an active campaign within the last sync cycle (set to 24 hrs), would be updated in CRM with an entry in the Campaign Response field, or added to CRM if they aren’t.

 

Filtering is one of our most subscribed features which can be found in Step 5 of your setup.

Note: If using Filtering & Segmentation feature and need to automatically remove records from your Marketing Automation solution once the records do not meet your criteria any longer please also grab the Add-On for this feature explain here.

EXAMPLES:

Please see below an example on how to filter records from Highrise CRM to Constant Contact.

Filtering settings are optional. If filtering criteria is specified, then only records which match any of the filter criteria (AND/OR) within a segment will be synced from Highrise to Constant Contact. Each segment will be synced to the Master List in Constant Contact.

Check it out in your SyncApps dashboard today!

 

save image
 
save image
 
 

In a more complex example for those who integrate with Mailchimp, below you could sync each Sync Profile to a separate Mailchimp Master List for segmentation.

The existing Lists in Mailchimp will be the Master List for each Sync Profile. In this example each profile uses an existing List, no new List is created in Mailchimp:

 

Sync Profile 1 Checkbox A is checked Mailchimp Master List: Existing List A
Sync Profile 2 Checkbox B is checked

Mailchimp Master List: Existing List B

Sync Profile 3 Checkbox C is checked Mailchimp Master List: Existing List C
Sync Profile 4 Checkbox D is checked Mailchimp Master List: Existing List D
Sync Profile 5 Checkbox E is checked  Mailchimp Master List: Existing List E

 

Important note:

If on a Free Trial best practice is to place Leads or Contacts into a CRM Campaign, Saved Search or Marketing List then use Filtering, and then sync, after the syncing process you can then see how it works.

Please see use case below:

After enabling Filtering and Segmentation as shown below, the Sync Details are showing after a sync:

 

12 Dec 2017 13:01:41

DEBUG

First filter criteria: ((hasProperty("fields", map containing [OwnerName->a string containing "Justin"])) or (hasProperty("fields", map containing [OwnerName->a string containing "Kyle"])) or (hasProperty("fields", map containing [OwnerName->a string containing "Erika"])))

12 Dec 2017 13:01:41

DEBUG

Segmentation criteria: {Kyle=(hasProperty("fields", map containing [OwnerName->a string containing "Kyle"])), Justin=(hasProperty("fields", map containing [OwnerName->a string containing "Justin"])), Erika=(hasProperty("fields", map containing [OwnerName->a string containing "Erika"]))}

 

If on a Free Trial, please note that we sync unlimited records to match your criteria so best practice is to place at least 100 test Leads or Contacts into a CRM Campaign, Saved Search or Marketing List then use Filtering, and next sync, then you can see how it works.

In this case, no records have matched the filtering criteria in the first 100 records that we have come across in the trial which looks at the first 100 records in your CRM which might not contain the filter criteria:

To rectify this issue a Campaign in Salesforce is needed to test out the Filtering feature.

 

12 Dec 2017 13:01:43 DEBUG Not matched record: Contact [id=0036100001IAQKIAA5, 
12 Dec 2017 13:01:43 DEBUG Not matched record: Contact [id=0036100001IAQKKAA5

 

To test out this feature is super simple by just setting up a Salesforce Campaign, select it in Step 1 of your Sync Profile, then using it with 100 records to test your Filter against in Step 5.

Once testing is completed next remove the Campaign/Saved Search/Marketing List checkbox in Step 1 and then keep the Filter on a paid plan which then does look at all records and Filters based on your criteria. 

See our Wednesday Walkthrough replay here!

Have more questions? Submit a request

Comments