Filters in Marketo Smartlist

Jhey33
Level 1

Filters in Marketo Smartlist

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.

1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: Filters in Marketo Smartlist

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.