Help with Reporting

DMcLaren4
Participant

Hello, 

 

I want to be able to show in this report another bar which displays the conversion of deals moving to a stage within the pipeline. 

 

Organe is people, blue is deals, I wish for another column to the right showing how many of those deals went to 'Survey Booked' for example. 

 

Can this be done?

Screenshot 2025-10-22 at 18.37.33.png

0 Upvotes
2 Accepted solutions
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Hi @DMcLaren4,

 

The HubSpot report builder does not have any options to do so, unfortunately. If you want to see conversion rates, you would have to create a separate funnel report for deal stages.

 

https://knowledge.hubspot.com/reports/create-new-custom-funnel-reports

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

@DMcLaren4 stage skipping can be blocked via pipeline rules: https://knowledge.hubspot.com/object-settings/set-up-pipeline-rules

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

0 Upvotes
9 Replies 9
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Hi @DMcLaren4,

 

The HubSpot report builder does not have any options to do so, unfortunately. If you want to see conversion rates, you would have to create a separate funnel report for deal stages.

 

https://knowledge.hubspot.com/reports/create-new-custom-funnel-reports

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
DMcLaren4
Participant

Okay, this is great, and I've now done this. 

 

The next issue is that the CRM isn't tracking correctly.

 

As you can see from the attachments, Chris Farmer is in Quote sent, and then moved to Deposit paid. The sankey graph however is not tracking this. Why would this be?

 

Screenshot 2025-10-28 114847.pngScreenshot 2025-10-28 114842.pngScreenshot 2025-10-28 114828.pngScreenshot 2025-10-28 114805.png

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

@DMcLaren4 I'm not seeing a sankey graph / funnel report configuration – am I missing something?

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
DMcLaren4
Participant

No you're quite right. 

 

The Chris Farmer standalone screenshot is in 'Formal quote sent' then lost of contacts in the other screenshot is in the stage 'Deposit Paid'. However, as you can see by the contact records it did enter deposit paid. Why wouldn't the sankey track it?

 

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

@DMcLaren4 I wouldn't be able to say what causes this without seeing the report configuration.

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
DMcLaren4
Participant

Sorry - see attached. Screenshot 2025-10-28 120354.png

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

@DMcLaren4 this report only includes deals that entered the "Survey booked" and subsequently entered the step "Formal Quote Sent", all within the last 90 days, excluding today. Can you confirm that that is the case for the missing deals that you're expecting to appear in the report?

 

In your screenshots I'm not seeing any indicator that the deal actually was in the stage "Formal Quote Sent".

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
DMcLaren4
Participant

You're right it skipped this stage on our system. It went directly from 'Survey Booked' to 'Deposit Paid'. 

 

This confirms what I'm thinking, deal stages are being skipped on the pipeline. 

0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

@DMcLaren4 stage skipping can be blocked via pipeline rules: https://knowledge.hubspot.com/object-settings/set-up-pipeline-rules

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes