Most recent lifecycle stage change date of all changes

Marketing & Content Hub Reporting & Analytics
1

Hi all - I know in HubSpot there are properties showing become [lifecycle stage] date for each lifecycle stage, but after extensive research including in this forum, I cannot find information on how to get the most recent lifecycle stage change date of all changes. For example, John has 3 lifecycle stage changes on 1/1 (lead), 2/1 (MQL), and 3/1 (opportunity); his most recent lifecycle stage change date would be 3/1. How can I get this property populated? Thank you.

2

Hi @HAngeldones,

This would require access to workflows, available in Orofessional and Enterprise subscriptions. The easiest way I can think of is this:

  • Enroll contacts based in ‘When filter criteria is met’ - ‘Lifecycle stage is know’
  • Enable reenrollment
  • Create a custom date property ‘Entered most recent lifecycle stage date’
  • Use the ‘Set property value’ workflow action to update this new property to the current date

Best regards!

3

Thanks for your reply and suggested solution. I will keep you posted once I try your approach.