Analyse the data which are in salesforce but not in marketo | Community
Skip to main content
karthikbk
Level 2
August 8, 2023
Solved

Analyse the data which are in salesforce but not in marketo

Is there any ways to identify the records which are in salesforce but never been synced or deleted from marketo.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
August 8, 2023

From the Marketo side only? No, by definition Marketo doesn’t know about... people it’s never known about!

 

If you sync the Marketo Lead ID to SFDC, then you would with some room for error be able to look in SFDC and see who’s in Marketo and who’s not. (The room for error is if a person was synced to Marketo and later deleted from Marketo, but that field wasn’t properly cleared in SFDC.)

 

When doing this as a spot-check you simply export all Contact ID & Lead ID values from SFDC, export the Marketo SFDC ID from Marketo for the whole database, and join the 2 tables.

View reply

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
August 8, 2023

From the Marketo side only? No, by definition Marketo doesn’t know about... people it’s never known about!

 

If you sync the Marketo Lead ID to SFDC, then you would with some room for error be able to look in SFDC and see who’s in Marketo and who’s not. (The room for error is if a person was synced to Marketo and later deleted from Marketo, but that field wasn’t properly cleared in SFDC.)

 

When doing this as a spot-check you simply export all Contact ID & Lead ID values from SFDC, export the Marketo SFDC ID from Marketo for the whole database, and join the 2 tables.

Translate
Terms & ConditionsAccessibility statement

Loading footer...