Skip navigation
All Places > MS Dynamics Virtual User Group > Blog

On Wednesday November 13th at 1pm ET, myself and Hilary German, both members of the team at Perkuto, will be discussing some of the considerations to make when syncing information between Marketo and Dynamics. We will be talking about best practices when it comes to data models, improving sync speed, and we will have time dedicated to answering questions towards the end of the presentation. 


Click here to register if you are interested in attending. 

Don’t get me wrong—when I hear Microsoft Dynamics (DCRM) marketers express a bit of jealousy over marketers who are using Salesforce with their Marketo instances, I completely understand. I mean, a quick look at the flow steps available in a Marketo/DCRM environment versus a Marketo/Salesforce environment gives even a non-technical marketer a good idea of which integration may offer more immediate flexibility and ease of use.


However, DCRM offers a number of benefits and advantages to the businesses and enterprises that use it. With 40,000 companies and 4.4 million users across the globe, it’s here to stay—and so our advice to marketers who are working in a DCRM environment would be to embrace using it and become adept at working with its nuances. With that in mind, here are three tips on how marketers can more effectively use DCRM and Marketo to achieve success.

1. Bypass import blunders by building a Marketo list import engine

It’s no secret that importing leads into DCRM is laborious on a good day and agonizing on others—and this is only exacerbated by the fact that any existing Dynamics records that fail during the import also lose their field updates, meaning you’ll need to go back, record-by-record and manually update each one with the correct information. Joy!


But don’t start pulling out your hair just yet. Remember, Marketo can automatically dedupe based on email addresses, updating existing records with new information you’re importing. Aha! That means that you can effectively use Marketo to get new records into DCRM and update existing records. You can accomplish this in one of two ways:

  • Standalone import program: You can create a standalone import program, then simply clone it so that you can track each specific individual import list, or
  • Master import engine: You can create a master import engine to use every time you need to import records into DCRM via Marketo.

2. Tweak the connector to change lead owners in DCRM (with a little help)

Working with Marketo, we’ve all gotten used to how quick and easy it tackles everyday activities like assigning tasks and changing owner records. However, making these tweaks in DCRM isn’t something that you can do right out of the box—you’ve got to enlist the help of your resident DCRM administrator to make a few simple changes to the way your system is set up.


For example, if you want to have the ability to change the record owner once it’s been synced with DCRM, asking your DCRM admin to do the following will let you tweak the record owner in Dynamics and Marketo:


  • Request that your admin set a custom option set field called  “New Owner” Along with your sales reps’ names, you’ll be able to sync that field to Marketo using this field in a “Change Data Value” flow step to set the new owner value.
  • Create a DCRM workflow that monitors for changes in the “New Owner” field, assigning a new owner based Marketo’s changed data value.

3. Don’t stress the native connector

Literally, and figuratively, that is. The more volume you place on the native connector, the slower you will find your instance. If you feel that your instance is operating at a slower rate than normal, check the Campaign Queue in Marketo, and also check the Sync Status in Dynamics (Admin permissions required) to see the number of inserts and updates and the direction they are running in. Make it a habit to check these numbers regularly to ensure the sync between the two systems is running smoothly.

A spike in the numbers usually indicates that something out of the ordinary is happening. For example, if you have a smart campaign running and are syncing records to Dynamics from Marketo, make sure that you are only syncing records with email addresses. The system will retry syncing records that fail, and if an email address is not present (or any of the other fields required for the sync, for that matter), you’ll slow down your system. A large volume of records appearing in the Sync Status section will cause a delay in new records being created, as well as a delay in record updates.

Put your org on the proper path

Ready to set your business up for success? By avoiding lead import pitfalls, working with your Dynamics admin to build in a little more flexibility and keeping tabs on your sync status, you’ll be moving your marketing and your business in the right direction.


These tips are based on a post authored for Perkutoby one of our former Solutions Architects, Paul Wilson. Thanks, Paul!


Hello everyone!


Unfortunately I need to defer today's meeting to the new year.


I hope everyone has a great last few weeks in December and I look forward to seeing you in January!



Hello all!


My apologies for being MIA for a couple of months - if you are free to join today I will provide you with an update form my side of the fence, and would love to hear what's on your Marketo / Dynamics todo list to the end of the year.


If you're free to join please register here:





Tyler Technologies is hiring a Senior Marketing DATA Manager. If you know anyone, send them my way and I'll route the resume direct. Thank you.

Marketing Data Manager | Plano, Texas | Tyler Technologies


Karen W. Sesona | Marketo Admin & Marketo User Group Leader | 5101 Tennyson Parkway, Plano, TX 75024

I have not checked the blog posting in a few months and I wanted to know if there was a way to receive email notifications if someone posts a new item to this User Group Blog?

Dave Wormell

User Group Meeting

Posted by Dave Wormell Sep 12, 2016

Has the Dynamics User Group Meeting been rescheduled yet?

Yesterday's announcement that Microsoft is acquiring LinkedIn caught almost everyone off guard. I think it is a brilliant move for Microsoft - in one transaction they become a serious player in the social network space. Despite attempts by Microsoft to make Skype into a quasi social network that plan failed miserably. The acquisition of Yammer in 2012 was also a miserable non-starter that went no where. So LinkedIn adds serious credibility to Microsoft's position as a key player in the workplace.


I think one of the most important benefits for Microsoft in this acquisition is the "self maintaining" nature of LinkedIn data. Yes, there are thousands of records that are stale where folks haven't updated their profile but the majority of LinkedIn users pretty much update their employer and job role as their 2nd activity (following setting up Outlook on their new work laptop). This can provide Microsoft with a stream of (mostly) accurate insight about companies and people.


Here's where some speculating on my part comes in. I have seen in recent releases of Dynamics a renewed commitment to bring that platform forward from it's formerly stale position in the Gartner CRM Magic Quadrant. Imagine a salesperson opening up an account in Dynamics and being able to see the public LinkedIn profiles of all the relevant executives from that account. As either a one off, or as part of a subscription offering you can send an InMail to those executives. Now extend that perspective into the opportunities tab in Dynamics. If one of the contacts associated with an opportunity changes employers (leaving the opportunity) the owner could get an alert letting them know they have to dig for a new contact.


Where this could get very interesting is when you combine Dynamics and Marketo. Imagine seeing LinkedIn data through Dynamics into Marketo where leads in Marketo can be targeted in programs because of LinkedIn data. Think about where Marketo Sales Insights might go as an iPad/tablet app with 3 engagement scores based on a lead's engagement with marketing content, the lead's engagement with sales delivered content, and an overall account engagement score based on relevant LinkedIn posts by people within that account on topics relevant to your business.


The landscape of data enrichment and social networks was destined to collide at some point, and I believe that is exactly what Microsoft is going to do with the LinkedIn acquisition.


I'd love to hear your thoughts on where you potentially see this going for Dynamics/Marketo users!