SOLVED

Where is the Marketo 'Id' Field Pulling From!?

Go to solution
Virginia_Smith
Level 2

Where is the Marketo 'Id' Field Pulling From!?

Hello,

I am trying to create a smart list referencing the 'Id' field and I cannot figure out how to filter by this field. I cannot find it and none of the choices that pop up for me with Id in the title are even close. Has anyone else run into this problem?

pastedImage_1.png

Thanks,

Virginia

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Where is the Marketo 'Id' Field Pulling From!?

Yes, but why can't I find it when I try to add it as a filter in a smart list?

Because (for reasons incompletely explained, but we live with it!) it's not a supported feature.

Now, what you can do (and what I was holding off on until I heard your case) is have another custom (String) field that you keep in sync with the Lead ID using a Change Data Value flow step, then you can search on it. As you might imagine you need to be careful during merges.

View solution in original post

8 REPLIES 8
SanfordWhiteman
Level 10 - Community Moderator

Re: Where is the Marketo 'Id' Field Pulling From!?

That's the Marketo Lead Id: the most important core attribute of a lead/person.

Virginia_Smith
Level 2

Re: Where is the Marketo 'Id' Field Pulling From!?

Yes, but why can't I find it when I try to add it as a filter in a smart list?

SanfordWhiteman
Level 10 - Community Moderator

Re: Where is the Marketo 'Id' Field Pulling From!?

Yes, but why can't I find it when I try to add it as a filter in a smart list?

Because (for reasons incompletely explained, but we live with it!) it's not a supported feature.

Now, what you can do (and what I was holding off on until I heard your case) is have another custom (String) field that you keep in sync with the Lead ID using a Change Data Value flow step, then you can search on it. As you might imagine you need to be careful during merges.

Virginia_Smith
Level 2

Re: Where is the Marketo 'Id' Field Pulling From!?

Got it, thanks! I mostly wanted to make sure I wasn't missing something. 

SanfordWhiteman
Level 10 - Community Moderator

Re: Where is the Marketo 'Id' Field Pulling From!?

OK, could you mark my answer as Correct when you get a chance?

SanfordWhiteman
Level 10 - Community Moderator

Re: Where is the Marketo 'Id' Field Pulling From!?

... and it's uncommon to want a Smart List based on this field (doesn't make much sense because it's immutable for a given lead, and a List with those leads in it is exactly as granular).

What's your exact business case?

Virginia_Smith
Level 2

Re: Where is the Marketo 'Id' Field Pulling From!?

I did some duplicate management and I have about 89 records that I cannot merge due to a system error. I was going to filter by the 'Id' of the records that are not syncing properly and mass purge them.

SanfordWhiteman
Level 10 - Community Moderator

Re: Where is the Marketo 'Id' Field Pulling From!?

I did some duplicate management and I have about 89 records that I cannot merge due to a system error.

Does this error show up in their Activity Log as a filter in itself?