view leads that were MQL then became SQL

[kelly_h]

Is there a way I can view leads that have changed from one stage to another? I want to pull a list of contacts that have changed from MQL to SQL and then SQL to Opportunity, and so on. I know I can pull a report that includes current lifecycle stage, but I want to see which ones have changed from one stage to another. Thanks!

[Josh · Accepted solution]

As far as I am aware, there is not a way to do this in bulk. You can look at revision history for that field, but that would happen on a contact-by-contact basis.

The reporting tool will allow you to create a report that shows numbers of deals that move through your stages, which is helpful. 

In your sales process, do you tend to follow the lifecycle stage steps? For example, are you at times moving someone from lead directly to SQL or do they always go Lead > MQL >SQL > Opportunity?

[Adrien_MB]

Hi Josh,

There is still no way to track or analyze leads that have become MQL then SQL ?

Regards,

Adrien,

[Josh]

Unfortunately, I am still unaware of anyway to accomplish this as you had previously described.

[seanreed]

Hi guys

I've started looking at this as well and just created a report in the Contact Funnel that measures "any" lead as they move through the various stages.

I've added a custom date field and then the measures are added for each lifecycle stage.

I'm using Sales Pro and Marketing Pro - Does that help at all or have I missed the mark in what you were looking for?

[Andy3]

That report is helpful, but it doesn't show, for a set of MQLs, the converion rate to SQLs.

What I think everyone would like is to select a time period for MQLs, say a quarter, and then see how many of them converted to SQLs later. Note, the SQL time period may be within the same quarter as the MQL, or a later quarter.

That would allow us to determine our conversion rate from MQL to SQL.

--

As a further update, I was able to create a custom report using the Became Marketing Qualified Lead Date and Became Sales Qualified Lead Date to figure out the conversion rate.

[2chars]

Hey @Andy3 ! Do you mind sharing screenshots of your custom report?