Filters in Marketo Smartlist

[Jhey33]

Can you help me to identify filters in Marketo Smartlist that show those who has MQL create date year 2023 & 2024 (no matter what is the MQL create date) that no opportunity has been created on the day they become MQLd.

Is there anyone who also experience this kind of scenario? I am thinking that it has anything to do with the automation in SFDC because opportunity is automatically being created if they have Mql create date.

[SanfordWhiteman]

There's no Smart List that can give you this because there's no way to constrain 'same day' across filters.

You could get it by doing an Activity Log extract via the API and grouping the data. The appropriate SQL query is very easy to write, though getting the data out and into your SQL database takes time.

Like you said, the Oppty is gonna be due to an automation on the SFDC side.