The only solution is to export the activity log info and do it externally.
This is one of the points listed here: Tokens on Steroïds
you can also look here: Allow the use of tokens within Smart Lists of Smart Campaigns
OK that's a bit disappointing, but thanks.
1 of 1 people found this helpful
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.