Skip to main content
Gareth_Spencer
Gareth_Spencer
Level 2
November 11, 2016
Question

Smart List Filter by Date Before Became MQL

  • November 11, 2016
  • 3 replies
  • 2267 views

Hi,

Can anybody advise please?

We have a "Data Became MQL" field created in our Marketo instance as a "data value", however I would like to find the activities that each lead undertook in the 30 days before they became an MQL.

I am unsure how to filter in this way, due to the fact that these 30 days are not a fixed set of calendar days, but rather a variable period of time that changes for each person...


Does anybody have a solution or can offer some advice?

Thank you!

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

3 replies

Grégoire_Miche2
Grégoire_Miche2
Level 10
November 11, 2016

Hi Gareth,

The only solution is to export the activity log info and do it externally.

This is one of the points listed here:

you can also look here:

-Greg

Gareth_Spencer
Gareth_SpencerAuthor
Level 2
November 11, 2016

OK that's a bit disappointing, but thanks.

G

J
Julz_James
Level 8
November 11, 2016

As Greg said, because you want to track something that is a moving goal post, the only way to do that would be to look at all the previous 'Activity Logs' 30 days before 'Date Became MQL'.

Are opportunities created in a short period after the MQL is created (say within 48hrs if you have an SLA)?  If they are you could use the Opportunity Analyzer to look at all the interesting moments and activities before the opp was created, but you have to do this account by account.

Thanks

Juli

    Terms & ConditionsAccessibility statement

    Loading footer...