Filters in Marketo Smartlist | Community
Skip to main content
J
Jhey33
Level 1
October 3, 2024
Question

Filters in Marketo Smartlist

  • October 3, 2024
  • 1 reply
  • 546 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SanfordWhiteman
SanfordWhiteman
Level 10
October 3, 2024
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.
Terms & ConditionsAccessibility statement

Loading footer...