Deals making up the KPI for Sales Goals

Hey Everyone -

I am stepping into using Goals to set up Quota tracking for Sales Goals. Is there a way within the Goals area to have the ability to drill into the KPI to see what Deals are contributing to the KPI value? Or does this need to occur in reporting?

Hi @KInvie and welcome, we are so glad to have you here! :hugs:
Thanks for asking the HubSpot Community!
To start with, for information, I’d like to share these resources around the topic:
- Create sales goals
- Report on goals
- Understand goals
Also, I’d love to put you in touch with some of our Top Experts: Hi @RSchweighart, @ArtyCele and @Josh do you have suggestions to help @KInvie, please?
Have a lovely day and thanks so much in advance for your contributions! :star:
Warmly,
Bérangère

Hi @KInvie,

If you navigate to the Sales Analytics Tools > Forecast and Revenue > Quota Attainment, you will see a report that will allow you to see the deals that account toward goal achievement. If you click on the bars in the chart, it will give you a popup box with the goals.

Aside from this, it’s really challenging to show the makeup of goals (frustrating, I know). I have resorted to creating a dashboard that shows the goal reporting and then a pivot table below the report to do a breakdown of the deals using filters that essentially match the filters applied to the goals. It’s not a perfect scenario, but it works for now.

Thanks for the ping, @BérangèreL!

Thanks, but it’s a bummer as this doesn’t work for us as we use a custom field to only track expansions and not the total amount. The analytics tool reports appear to only use amount.

Hi @KInvie, I hope that you are well!
Sorry to hear that this doesn’t fit your unique use case.
For new feature suggestions, I’d recommend first to search and check if this idea is already present on our Ideas Forum here. If you find a similar idea, give it an upvote and share your unique use case in the comments.
If the idea doesn’t exist already, please consider posting and creating a new Idea on our Ideas Forum here.
Thank you for being part of the discussion!
Have a great day!
Warmly,
Bérangère

@KInvie, you can drill into the deals in the total progress breakdown. Go to the goal in question, then into user performance, and hover the user click on Actions > Quick details and you’ll see a section with the current progress (representing the KPI value), the amount is clickable, when you click a pop up window will show the deals contributed to the goal, which you can save as report. You’d need to do this by user goal (depending on how your goals are set up).

You can also achieve this using a custom report, which gives you more flexibility. I hope this helps!

Hi @indiracatmedia,

Can you clarify whether or not you still have the ability to see the goal makeup after a report is created? From what I see on my side it will show the goal amounts and trends, but when clicking on the points after creating the reports, the goals don’t show when clicking the points.

Josh

Thank you. This is super helpful. It works but definitely clunky given you have to go find the right month and then double-click on the number. But it does work…I did move to reporting and hopefully that will work for other leaders.