Re: Smart List Filter by Date Before Became MQL

Gareth_Spencer
Level 3

Smart List Filter by Date Before Became MQL

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!

3 REPLIES 3
Grégoire_Miche2
Level 10

Re: Smart List Filter by Date Before Became MQL

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
Level 3

Re: Smart List Filter by Date Before Became MQL

OK that's a bit disappointing, but thanks.

G

Julz_James
Level 10

Re: Smart List Filter by Date Before Became MQL

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