Difficulty reporting due to deletion of Became x Lifecycle Stage Date property?
A lot of our reporting is made very difficult by the fact that when someone is revrted to a previous lifecycle stage, HubSpot automatically deletes the value for the property "Became x Lifecycle Stage Date" for the further along the funnel stage.
An MQL becomes an SQL, then is reverted back to MQL by the sales team --> this deletes the property for the date on which the Became an SQL.
This deletion seems illogical to me, and makes it difficult to do any historical reporting, for example: how many contacts in total became an SQL in month x, or month y? Querying by Became an SQL Date is not accurate due to that data being deleted for contacts who were reverted back to MQL (instead of moving to Opportunity).
Has anyone else had this issue? How do you go about accurately querying for number of SQLs in a month? Thanks!