Reporting based on History of a property

[caroline_at_hv]

Looking to create a report using the create date of a property or date the property is changed, which can be found in the history of the property, as one of the metrics for the report. 

A report that will give me the number of deals that were changed to "Deal Stage #5" on that day or in a specific date range. Also, want to filter it based on another property similar to HubSpot Owner that shows the number of deals each person moved to "Deal Stage #5" in a specific date range.

Also could possibly base it off of the date a property is filled out rather than the date the deal stage is changed.

Have been working with HubSpot Support team but would love some help if anyone has ideas of how to do this based on the history of a property or has another possible workaround. 

[caroline_at_hv]

Thank you all for sharing your feedback. We are currently reviewing this issue. We plan to make significant progress in 2020 and we will update this issue as we make progress. In the meantime, please don't hesitate to add additional use cases for reporting on property change history. 

[#3]

This is solved currently by the Lead to Procedure Deal Stage Properties filter in reports

[#4]

Different use case, but same suggestion: I'd like to use the history of a contact property when reporting.

I'm trying to report using date a contact unsubscribed to better understand correlations and patterns in unsubscribes. 

[#5]

 I'd like to be able to sort Contacts by the date when they booked a meeting using the Meetings module

[#6]

I have a different, but related use case: I would like to find all contacts that were ever owned by a specific user (but are not currently owned by that user).

[#7]

This has not yet been solved, but we would also like the ability to:

- Create filters on when specific properties were "last modified" 

...since there is a recording of the history, it would be nice if it was filterable.

Example:

If someone updated the "Close Date" of a specific deal, and I was able to filter on Close Date modified after a certain date, then I could create a list of deals changed/modified around the close date of a deal and use that report as an actionable list of deals to follow-up on with the Sales Rep/Opportunity owner as to why a Close Date is being updated - which will have an affect on financial forecasting.

[#8]

Same concept, different use case. We need a way to pull a report of how many times a deal has changed stages and/or how many times a deal's close date has changed. Goal is to identify problematic deals to rid them from our pipeline or use as a coaching opportunity. Thanks!

[#9]

I'm having similar issues with non-date properties. We have an integration setup that pulls data from our in-house tool that is specific to a contact. Since these are not date properties, I can't pull the historical trends for them, even though they exist in the property history. This is a huge loss for our team as the trend is more important to us than the current data set.

[#10]

+1

Want a report or a filter based on when a custom property changes.

[#11]

Has this feature been created yet?

[#12]

This functionality has not yet been created but we need it. If you look at the property history for any record, you'll see four columns... "Property", "Changed To", "Made On", and "Source". Three of the four sections (Property, Changed To, and Source) are reportable. The report everyone is looking for is an ability to report on the "Made On" date and date and time stamp. It shouldn't be difficult to make this a reportable or filterable field as the data is listed right there for every record in HubSpot.

[#13]

Same feature - different use case. We pipe user numbers for apps created (as part of a deal) over time into hubspot and I need to be able to track the field historically

[#14]

Intersted in the same features, different use case. We want to track how many Contacts purchased a specific product, located under a specific property, during a specific month. 

[#15]

Sounds like this is a popular request!  @Hubspot when are we going to get reports based on historical data?

[#16]

We also would like to be able to report on the dates that fields changed for various reasons.

[#17]

We absolutely need this! This would make Hubspots Reports a BI tool competitive enough to stand next to some serious niche players. This feature would also let our company connect more APIs and gather intelligence to report on the change!

Kudos!

[#18]

We are also interested in tapping into a Contacts Custom Property History in the Report creator.  Would be very useful.

Thanks!

[#19]

We would love to see this also.

We currently have to store historic data in a seperate property which is a pain, seriously complicates reporting and is only really possible for the first status change. In our use case we are tracking the location at which our customer last used our services and our need is further complicated by an integration to our primary software which also relies upon this field.

[#20]

Really keen for this feature to get pushed through for several reports.

One example, I set-up a custom property for sales to reject or accept MQLs and called it 'MQL status', it has 3 options:

Disqualify - never going to be suitable / suppliers / staff etc.

Nurture - not ready yet

Advance - progress to SQL

I can see how many SQLs we generate each week/month/quarter, I can't see how many contacts were sent to 'Nurture' or 'Disqualify'.

In a nutshell: I need a report that will show me the count of contacts that have had the 'MQL status' property set to 'Disqualify' or 'Nurture' within a certain timeframe.

Thanks. 

[#21]

@Hubspot, we need to access the data you already capture. Please let us use the field history date in reporting.

[#22]

This would be great to use for selecting which clients were active during a specific period so we can send them an NPS survey.