topic Re: Multiple Goals on single report in Dashboards & Reporting

Multiple Goals on single report

spaulsen — Tue, 28 Feb 2023 21:44:30 GMT

Silly question time.... again.

I have a sales team with a 2 revenue targets that are set up in HS... a minimum quota and a stretch goal... the minimum quota is set up as User goals and the stretch goal is set up as a Team goal

How can I show YTD sales with both goals displayed in the same report?

Thanks in advance

Re: Multiple Goals on single report

PamCotton — Tue, 28 Feb 2023 23:19:34 GMT

Hello, @spaulsen thank you for posting in our Community! Let's ask our top experts about this matter:

@danmoyle @LVarvashevich @Josh any recommendations to @spaulsen matter?

Thank you,

Pam

Re: Multiple Goals on single report

danmoyle — Wed, 01 Mar 2023 13:35:01 GMT

If you have Goals set up in your Deals, you should be able to a custom report that includes both the sale rep goals and the team goals to show YTD sales. I'd try this:

Go to Reports, then Create a custom report.
Choose "Deals" as the primary data source.
Add the "Amount" property to your report to show the total revenue generated by your sales team.
Click on filters and select the date range you want to view.
Then select "User goal" and choose the minimum quota as the goal type and set the value to "Yes" to filter out the deals that have not met the quota.
Add another filter for "Team goal" and choose the stretch goal as the goal type and set the value to "Yes" to filter out the deals that have not met the stretch goal.
Save the report and run it to see the YTD sales with both goals displayed in the same report.

Hope that helps, @spaulsen!

Re: Multiple Goals on single report

spaulsen — Thu, 02 Mar 2023 20:28:47 GMT

@danmoyle thank you for the info.... silly follow up question time....

what do you mean by setting the Goals up in Deals?

I set them up by going to Settings, then Tracking & Analytics, then Goals

I searched Knowledge Base and couldn't find how to set Goals up in Deals, and it is evidently necessary because I can't follow your instructions past #4... Can't find User Goals anywhere.

Sorry to such nube and a pain, just trying to gain clarity.

Thanks

Re: Multiple Goals on single report

danmoyle — Thu, 02 Mar 2023 20:53:29 GMT

Not silly at all @spaulsen 😊 Follow up questions are always welcome!

I'm looking at creating goals and custom goals in HubSpot sales, and connecting them to the custom reports. I didn't create a report myself, just leaning on my understanding of Custom Reports and the various objects/properties in HubSpot, and other resources like KB articles. So I can't gurantee it's a perfect solution. Just hoping to spark the solution as you're working through it.

Re: Multiple Goals on single report

spaulsen — Thu, 02 Mar 2023 23:20:22 GMT

Thanks for the help @danmoyle

You did point me towards the answer...

I created one goal (Quota) as User goal and the other (Stretch) as Team goal.

Team goals can not be included in reports (see pic)

Re: Multiple Goals on single report

spaulsen — Thu, 02 Mar 2023 23:24:21 GMT

However...

the answer was staring me in the face the whole time.

I just had to check the box "Include monthly report goal" and set that to a monthly amount that would add up to my annual stretch goal and here's what I got...

my 2 lines!

Re: Multiple Goals on single report

danmoyle — Mon, 06 Mar 2023 14:21:00 GMT

Love that you found it and it was just a small nudge. Happy to help, even if it was a small kernel. Keep exploring @spaulsen! 😁