How to Keep Salesforce Records From Syncing to Marketo

In:

There are many reasons why you would want to keep Salesforce leads or contacts out of Marketo. Maybe you are reaching your Marketo database limit and you want to remove anyone who you can no longer email (hard bounces). Or perhaps you have a bunch of leads or contacts in Salesforce without an email address, that are taking up space in your Marketo database. The bad news is that if you delete these people from your Marketo database, once the Salesforce sync runs, they will be added to your Marketo database again. The good news is there’s an easy way to keep Salesforce records from syncing to Marketo, using a custom sync rule.

Step 1: Create a custom Salesforce field

First you need to create a custom checkbox field on the lead and contact in Salesforce. I ususally call the field ‘sync to marketo’ and make the default value ‘checked’.

Map the lead and contact fields in Salesforce.

Wait for the Marketo integration to sync the new field over to Marketo.

Step 2: Update the leads/contacts you don’t want to sync to Marketo

Now that you have a checkbox on both the lead and contact to flag if you want them to sync over to Marketo, you need to update the field to false for the records you don’t want to sync. This can be done through Salesforce data loader, manually in Salesforce, through a Marketo smart campaign, or through a Marketo list action.

Step 3: Contact Marketo Support to add the custom sync filter

You will need to open a case with Marketo support to get them to create the custom sync rule for you. Here’s what I use for my case details.

  • Priority: P3: Concern, Minor Issue
  • Case Issue: Salesforce.com
  • Case Sub Issue: Sync
  • Case Type: Help me setup/create
  • Subject: Custom Sync Rule Creation
  • Description:
    Hello,
    I need a custom sync rule created for both leads and contacts. If Sync_to_Marketo__c is FALSE the record should not sync.
    Thanks!

Step 4: Delete the records out of Marketo

Once the sync rule is in place, it will not automatically delete any records in Marketo. You will need to delete the records via a smart campaign or a list action.

Questions?

Send them to me via email, send me a tweet @jennamolby, or leave a comment

Related Posts

  • 07/07/2020
    How I Passed The Salesforce Certified Pardot Consultant Exam: Flashcards, Resources & Tips

    Are you already a Salesforce Certified Pardot Specialist? Do you have around 12 months or more of hands-on experience implementing and administering the Pardot Lightning App and Salesforce platform? The next step in your Pardot certification journey is to take the Salesforce Certified Pardot Consultant exam. In this post, I share how I prepared for the exam, what study resources I used and share the flashcards I created to pass the exam.

  • 01/07/2020
    How to Prevent Lead Source From Being Overwritten in Salesforce

    Creating a validation rule in Salesforce is a great way to restrict certain users from making updates to a particular field. Let’s look at how a validation rule can be used to restrict who can update the lead source once the lead source has a value.

  • 23/06/2020
    How to Use Pardot Form Handlers

    Pardot form handlers allow you to use your own forms to post your data to Pardot. A Form handler is a great alternative to use instead of Pardot iFrame forms. They allow you to fully customize the look of your form and submit data to more than 1 database. In this tutorial, you will learn how to create a form handler from scratch.

Leave A Comment

Your email address will not be published. Required fields are marked *

About Me

Welcome to my blog, where I share, tips, tricks, thoughts and solutions that I learn in my daily life as a Marketing Operations leader.

Categories
Most Commented
Popular Posts