Contact funnel and reporting inconsistencies
This is kindof a support/idea/bug question for fellow database users and Hubspot developers and it has to do with an inconsistency in the contact funnel reports.
Hubspot's funnel reports look at funnels in two ways:
- First, a simple snap shot of who's in what stage.
- Second, what contacts have progressed to each stage down the funnel.
The problem lies in Number 2. If a contact skips a stage (eg goes from "Lead" to "Sales Qualified Lead"), Hubspot does not date stamp the middle stage between them - MQL. By virtue of being a SQL, the contact did pass through the MQL status. So when building a funnel report, the data is thrown off because some contacts are missing funnel dates.
My question to the community is if there is a way I can backfill the data on those have skipped stages? Or am I stuck with having to building new properties that date stamp the stages independent of Hubspot's since it doesn't track a funnel properly?
TIA and I look forward to the conversation.