Help with Reporting

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?

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.

Best regards

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?

159858iA4194A1EE17CB2DD.png

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

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?

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

Sorry - see attached.

@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”.

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.

@DMcLaren4 stage skipping can be blocked via pipeline rules: Set up rules for object pipelines