Unexpected Leads Showing Up On Smart List with 'Opportunity ID' Filter vs. SFDC List

A document by KCS Integration on behalf of aea09be53bd03f842fd77a4a1b029e4536e24786 on Feb 5, 2018Last modified by Roxann McGlumphy on Feb 6, 2018
Version 2Show Document
  • View in full screen mode

Issue Description
Customer created lists in SFDC and Marketo with identical filters/constraints for a field on the Opportunity Object, but the Marketo List is returning many more leads than the SFDC list.

Issue Resolution
The issue is due to Marketo field string values not being case-sensitive. Salesforce is case-sensitive, and will generate Opportunity IDs with the same letters, but with different capitalization arrangement.

For example:

    • In SFDC: "0060y000016PzXw" is a different Opportunity ID than "0060y000016PZxW"


    • In Marketo, these two IDs are considered identical.

As a result, Marketo will return leads that are not showing up on the Salesforce list.


Adding the varied-case ID to the SFDC list filters will return the extra leads from Marketo.




Smart List filters are not case-sensitive in Marketo, and will qualify leads with matching field values, regardless of letter case. One work-around option would be to use a 'Company Name' filter (or other known value) to further limit the leads in Marketo associated with the Opportunity. 


Who This Solution Applies To

Customers synced to SFDC