SFDC ID – A Deep Dive

Brian_Law_MKTO
Marketo Employee
Marketo Employee

The SFDC Id token can be used in emails and the value can be viewed in a Smart List and on individual records. You unfortunately can't search by a SFDC Id in the database area of Marketo.

pastedImage_0.png

pastedImage_1.png

The SFD id can’t be used in a Change Data Value flow step to populate a custom field. The SFDC Id also can’t be used as filter in a smart list. You can populate a custom string field with the 18 character SFDC id using the tokens {{lead.sfdc lead id}} and {{lead.sfdc contact id}}.

Flow example

pastedImage_2.png

If you have a large database, I recommend running 100K batches at night and on the weekends and waiting a few hours after each is completed so you don't impact system performance.

By the way, after a lead is converted to a contact you will need to run a daily batch campaign to set the new SFDC Id.

Here is an example of how to set the Smart List of the batch campaign.

pastedImage_0.png

4251
2
2 Comments
Delinda_Tinkey1
Level 5

I have the 18 digit IDs created as formula fields in SFDC. It's handy to have there in addition to Marketo so that when you export to Excel from SFDC you have a unique ID that excel can recognize (the default 16 digit IDs that export are not unique unless you count capitalization, which Excel does not).

Those formula fields sync to Marketo without any batch campaigns needed and can be used to filter, change data flows, etc.

Brian_Law_MKTO
Marketo Employee

Yes, absolutely you can use SFDC to populate a field with the SFDC ID, thanks!