Combine Two Reports Into One Report - When using different "date properties"
SOLVE
Hi All, I am trying to combine two reports together.
Report #1 - New Deals for the month, by the create date.
Report #2 - Won Deals for the month, by the close date.
In a nutshell, We want to see the "conversion ratio", how many deals were won this month, compared to how many deals were received this month.
The reason we must filter with different date properties is that some "won deals" could be from deals created 60, 90, 120 etc days beforehand. So if we sort "won deals" by create date it is not accurate as many deals take a long time to become CLOSED WON.
Ideally, we want a report that looks like this below, the red line shows deals won by the closed date, and the bars show new deals received by create date.
This is, as far as I know, not possible. HubSpot reports don't have options that would allow for combining this information within one report.
However, iff you're looking for a visualization of the conversion rate, I'd recommend taking a different approach. You can create a deal funnel report. Instead of including all pipeline stages in this funnel report, you would include all deals created and won deals: https://knowledge.hubspot.com/reports/create-custom-funnel-reports
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
This is, as far as I know, not possible. HubSpot reports don't have options that would allow for combining this information within one report.
However, iff you're looking for a visualization of the conversion rate, I'd recommend taking a different approach. You can create a deal funnel report. Instead of including all pipeline stages in this funnel report, you would include all deals created and won deals: https://knowledge.hubspot.com/reports/create-custom-funnel-reports
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer