How can I create a Lifecycle Stage report that shows...

[brian1]

contacts with Lifecycle stage "Marketing Qualified Lead" that "Became a Marketing Qualified Lead" more than two weeks ago (rolling date range)?? 

Essentially in this report, I want to view contacts that have remained in a specific lifecycle stage for a period of two weeks or longer. 

[Phil_Vallender · Accepted solution]

Hi @brian1

You need to use HubSpot lists for this, rather than contact views. In lists you can set up a rule stating 'became MQL date is more than two weeks ago' like this:

Hope this helps.

[brian1]

Thanks Phil, it hadn't even occurred to me yet that you could filter for smart list membership on reports. Thought that was only under contacts tab. Thanks again!