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?
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.