MQL to Rep Response Time

Data Hub 💬 RevOps Discussions
,
1

Hi all!

Looking to pull a report where we can assess how long it takes for any sales activity to occur once a lead enters into Lifecycle Stage = MQL.

Thought this would be a simpler solution! I do see the Lead Response Time boxed report, but not really what I’m after.

Thanks,

2

https://community.hubspot.com/t5/128172-RevOps-Discussions/Reporting-on-sales-first-response-time/td-p/405470
This thread has a ton of good information.

3

Hi @EMSYee,

I answered a similar question before here: https://community.hubspot.com/t5/128172-RevOps-Discussions/Reporting-on-sales-first-response-time/td-p/405470

If you’re interested in the response time after entering the MQL stage specifically, you will have to do the following things:

  1. Create a date property for the sales activity
  2. Create contact-based workflow that enrolls contacts when contacts are a MQL AND when the desired sales activity occurs (e.g. contact associated to activity with Activity type = Email sent AND Activity date is less than 0 days ago)
  3. Use the ‘Edit record’ workflow action to log the current date into that date property
  4. Create a calculation property to calculate the time between entering the MQL stage and your new date property: Create calculation and rollup properties
  5. [optional] build a report based on this new calculation property

Let me know if you need more detailed instructions about one of these steps!