Re: Changes to Marketo Salesforce Sync – Questions and Discussion

Anonymous
Not applicable

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

When wanting to choose the new fields, I found I needed to choose the second of the 2 duplicates in the picklist.

Mike_Reynolds2
Level 10

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

Hi Dawn Richcreek

If you've already created any of the fields, then your instance is already going through the backfill process and resulting resync now. Best to avoid that in general so we can stick to the schedule, but it's not any kind of critical problem. Just be aware that it's already running for those three fields. Probably ought to wait for the scheduled time to recreate the other fields though. You can do them now if you need to--the trade off here is that any leads who have already done the backfill and then the resulting resync from SFDC back to Marketo will have to go through that same process again. Not the end of the world, but since it's outside of the schedule, it could put a small drain on the others in the current schedule. We planned ahead with a buffer for these type of scenarios though.

You're not the first person we've heard from that had that same confusion about how the field creation is what actually starts the backfill process. I don't think that point was clear enough in our documentation, so I just went back through and added some notes about that in multiple locations. Sorry for the confusion on that part.

pastedImage_0.png

In terms of the backfill process, this data passes through a separate "pipeline" outside of the normal SFDC sync, so it won't conflict with your regular sync and it also won't use up your SFDC API calls.

With the field names, one trick I heard another customer try was changing the friendly name / friendly label for the older existing fields to something a little different so that it's easily identifiable as the one you don't want to choose. Try that and let me know if that helps.

Thanks,

Mike

Sheila_Baker__2
Level 2

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

I've run through the process with one instance so far. Overall, the process worked great. I wanted to provide some feedback/suggestions for others from my experience.

  1. Disable the sync to SFDC in Marketo before you start to create the new fields in SFDC. Once all the new fields are created, then re-enable the sync in Marketo.
  2. Take the opportunity to really think about whether you need all those fields syncing. If they aren't being used in SFDC then you probably should not recreate them. You can always sync additional fields at a later time.
  3. Once the new fields exist in SFDC, create an SFDC Lead report  and a separate SFDC Contact report that you can use to  compare the old and new fields. This will allow you to make sure that the backfill completed properly. As an example, I used the following filter in the Lead report so only those that don't match are shown. Make sure to change for the fields you created.
    pastedImage_8.png
    The SFDC reports allowed me to see that I had an issue where most but not all of the fields were properly backfilled in Leads. I am fairly certain that it had to do with timing on creation of the new fields across multiple standard sync cycles. Hence, my recommendation to disable the sync while you are creating the fields. The good news is that a simple sync of the leads where the backfill wasn't fully completed and everything was fine.
  4. Don't forget to update any places in SFDC that refer to the old fields with the news ones. Obvious is page layouts and reports. But don't forget formula fields and workflows too!

Hope others find this useful.

Sheila

Mike_Reynolds2
Level 10

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

Thank you Sheila Baker (247)​ this is great info!

Dory_Viscoglio
Level 10

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

Definitely helpful, as we ran into a few records where not all of the info synced over because of the time that the records were created. A resync seems to have solved the issue!

Grégoire_Miche2
Level 10

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

Hi Mike Reynolds​,

We have a customer which accoutn stream starts with a "t". Apparently, the lead score does not sync any longer (I have done quite some testing both ways. The lead sync works perfectly well for all fields, but the lead score). And yet, per the release schedule, they belong to group 6. Is this normal? Should we anticipate the change to the fields?

Thx for your help.

-Greg

Mike_Reynolds2
Level 10

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

Greg,

The sync of data to the fields will keep going until January 31st, 2017. That's the cut off date when the sync stops. Whether you recreate the fields or not, data still passes to the old fields until that date--no change has been made there yet. So, if you're seeing problems with values syncing, it's got to be caused by something else. My first suspicion is permissions on the SFDC side, but if you're not seeing the trouble, you probably ought to Contact Marketo Support so we can dig in deeper.

Thanks,

Mike

Grégoire_Miche2
Level 10

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

Hi Mike,

the weird thing is that only the lead score field seems to have a problem.

-Greg

Mike_Reynolds2
Level 10

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

Greg,

Makes me suspect field permissions. Check the field level security setting and make sure the "read only" access is un-checked. In Adding Marketo Fields to Salesforce Enterprise/Unlimited Edition it's step 8. If the sync user can't write to the field, that would definitely cause the issue there. Old field, new field, either way it's the most likely cause. If that's not it, I'd open up a ticket with Support.

Mike

Grégoire_Miche2
Level 10

Re: Changes to Marketo Salesforce Sync – Questions and Discussion

Hi again Mike Reynolds​,

Unfortunately, field permission is not guilty here. Marketo sync user is system admin in SFDC... And there is not "block field update" set on the lead score field either

-Greg