clearing Date entered "Marketing Qualified Lead (Lifecycle Stage Pipeline)"

Marketing & Content Hub Reporting & Analytics
, , ,
1

How do I clear this date field "Date entered “Marketing Qualified Lead (Lifecycle Stage Pipeline)”

We had 25 contacts reach mql erroneously and now it is skewing out dashboard.

2

Hi @Huntscape-Ops,

Unfortunately, HubSpot does not allow you to directly clear or delete system-calculated properties like “Date entered Marketing Qualified Lead” through the UI or workflows.

Here are some workarounds you can consider:

  • Manually reset the Lifecycle Stage of the affected contacts to a previous stage, such as Lead, and then back to MQL. This may update the date but it is manual and not always reliable.
  • Use a custom date property to track MQL dates going forward, which you can clear or adjust as needed. Then build your dashboards using this custom property instead.
  • If you have access to HubSpot’s API, you could write a script to clear or update that property for those contacts but this requires developer resources.
  • Alternatively, filter your dashboards or reports to exclude those contacts or use additional properties and criteria to keep the data clean.

System lifecycle stage dates are designed to be immutable to keep accurate historical tracking.

Best,

Jes

3

Hi @Huntscape-Ops,

This is unfortunately not possible directly* at this stage. However, other users have requested this before: https://community.hubspot.com/t5/HubSpot-Ideas/Edit-Became-a-quot-Lifecycle-Stage-quot-Date/idi-p/745668

These requests submitted to the HubSpot Ideas section of the community are reviewed by the HubSpot product team, based on their popularity and the assumed demand. I’d recommend commenting and upvoting.

You can also help other HubSpot users find this request more easily (and drive traction) by accepting my reply as a solution. I’d appreciate it, too.

* As far as workarounds go, you can reset the lifecycle stage of a record using a workflow and the ‘Edit record’ workflow action, then set the contacts to their current correct lifecycle stage. When HubSpot moved away from the ‘Became a…’ properties towards the ‘Entered…’ properties, unfortunately, this didn’t clear the values in the date properties reliably anymore. In recent tests, it didn’t work for me but it’s worth a try on your end.

If it doesn’t, here’s what you would do:

  • Even if the date doesn’t get cleared, the contacts are now in their correct (presumably earlier) lifecycle stage.
  • You can exclude contacts with that earlier lifecycle stage from your MQL report.

Have a great day!