This content has been marked as final. Show 7 replies
I Think SFDC ID is a system column view and it won't allow you to export. Try to add SFDC Lead ID and SFDC Contact ID. This will give you the ability to export your list with IDs intact.
Thanks for trying to help me, Edward! Unfortunately, when I try to edit the view of my smart list in the Lead Database to implement the changes you recommended, neither SFDC Lead ID nor SFDC Contact ID were listed as possible column/field options to view.
Thanks so much for your follow up response, Edward! I reached out to my Marketo/Salesforce admin and she was completely bewildered by the image you shared with all of those possible SFDC columns.
Specifically, she told me she was stumped because the Marketing Integration profile is configured for FULL control over leads and contacts- read/write/modify all. Further, she asked me if she was missing something, and unfortunately, I have no idea.
I don't have the privilege enabled to submit a support ticket, but my admin does. Do you think Marketo Support would walk her through where we went wrong with our setup?
Thanks in advance!!
For SFDC ID to be visible in list exports, you'll need to include the Marketo Lead ID("ID" in the view editor) in your visible columns as well.
Kenny E, thank you so very much- your suggestion worked!!
As Kenny suggested, by adding Marketo’s ID in your custom view will now show SFDC ID when exporting but take note: The SFDC ID that gets exported will be the 18 digit ID and not the 15 digit ID if you viewed that lead/contact in SFDC.
e.g. when your viewing leads/contacts in SFDC there is a direct URL link to every object. You generally see something like : https://salesforce.com/0035000001X4XXX - 15 Digit ID
When you export from Marketo, it will be 18 digit ID version. This is something to be aware of in case you do get your other fields working (SFDC Lead ID and SFDC Contact ID) as they will be 15 digit IDs
This still works if you copy and paste that 18 digit ID into SFDC URL when you want to view the lead/contact.
The difference between 18 and 15 digit is that 18 digit ID ios used for SOAP API or backend data base access vs. viewing as a SFDC user in a browser.
Hope all that makes sense.