Aug 18, 2020 3:57 AM - edited Aug 18, 2020 4:45 AM
HubSpot currently has a few default contact properties for you to track the dates when contacts hit a new stage such as:
Using the default properties, you can dive deeper into your marketing insights by tracking the number of days contacts spend in each lifecycle stage.
✅ This can help you create reports to identify which stages do your prospects/customers tend to be stuck at and create strategies to prevent them from being stagnant leads.
✅ With this information, you can target your marketing campaigns to those customers who have been stuck at a particular stage for a long time, and help your sales team move them down the lifecycle stages faster to turn them into customers.
To set this up, we will need:
To better explain the process and visualize things, let us use the lifecycle stage “MQL” as an example. Feel free to change the names of the list, property and workflows to better suit your use case.
You can see the steps to create a custom property here. This property will be the contact property you’ll be using to store the number of days the contact has been an MQL.
You can see the steps to create a static list here. Do note that you should create a static list with no criteria on the left as this is a static list that’s going to be populated by one of the workflows and contacts will only be on this list based on that workflow itself. When you first create the list, it should be empty as it will be populated via a workflow later.
For example, Josh becomes an MQL on 10th August, and enrolls in workflow 1 as his Became a marketing qualified lead date is now known.
Josh is then put through a delay till 11th August and is “removed from the static list” (this is not that Josh was ever on the list but this part will only be important later). Essentially, this step makes sure he is not on the list at this time.
Josh then goes through the “no” branch as he are still an MQL on 11th August, and gets enrolled into workflow 2.
John enrolls into workflow 2 on 11th August and gets a +1 on the property “# of days as an MQL” as it’s been 1 day since he has been an MQL.
John then gets added to the MQL list. This action will then trigger him to re-enroll in workflow 1 again as this list is an enrollment (and re-enrollment) trigger for workflow 1.
John then gets added back to workflow 1 and the cycle will go on and on and the number of days will get added on every single day until John is no longer an MQL, then he will go down the “Yes” branch of workflow 1 which will stop the count.
Example of how your property history will look like:
With the above information, you can conduct various reports on the number of days your contacts are spending in each lifecycle stage such as this report:
This tells you the average number of days your leads are taking to reach other stages. Looking at the graphs, you can see that your MQLs are relatively new with their “age” being an average of 1.48 days old. You can also see that generally, your customers and prospects take about 15-18 days to move from an MQL to something more (i.e. SQL, Opportunity or Customer).
Therefore, drawing from these results, you can determine if this means your marketing campaigns are effective (if the # of days are short), or decide if you need to work on moving them along to other stages faster.
Jul 15, 2022 1:11 AM
This was an excellent tutorial- thank you. Is there any method for calculating this with contacts before you set up the workflow (retroactively)?
Jul 26, 2022 11:38 AM - edited Jul 26, 2022 11:50 AM
Thanks for reaching out! It's not possible to use this same workflow to set the lifecycle stage retroactively.
|Did you know that the Community is available in other languages?|
Join regional conversations by changing your language settings !
Jul 26, 2022 11:51 AM
Apr 19, 2022 7:21 AM
This is great! Thanks for sharing!
When building this out for SQL - do I need to exclude earlier lifecycle stages (ie. MQL) from "If/then" branch in the "SQL Tracker: Became an SQL" workflow?
Aug 19, 2021 1:11 PM
@sttang LOVE this tip. It was nice to have it all mapped out AND a suggestion on reporting. Thank you so much.
Could you do one showing how to measure the marketing funnel by Company. 🙂