Funnel Reports - dates per stage (creating a lag report)
lösung
Hi Hubspot Community.
We need to create a report on Hubsport that looks at how long and what the conversion rate is for when deals move from one stage to another on Hubspot.
Currently I have a report set up but I am getting stuck on creating it to look at things with a lag: what I am not able to do is look at Stage one, ie prospect and all deals that had the stage updated to prospect in a certain week and then look at the second stage I want to review ie Demo/Meeting schedule stage but look at that stage update over a two weeks period.
In other words I want to see all prospects that were created from 28 Sep to 04 October and how many of those prospects moved to demo/meeting scheduled over a two week period 28 Sep to 11th of Nov, is there a way to do this?
You can approach this using report filters, using the deal properties Entered stage date [Stage ID]: the date the deal entered the stage.
HubSpot does not have a built-in feature that would let you create cohorts or lag as you described, you would have to specify it through report filters and the date properties for each stage you want to narrow down.
Let me know if you have any follow-up questions!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer