Quota Attainment

Smart CRM & Sales Hub Dashboards & Reporting
1

Hi Everyone,

I have a Quota Attainment created but i cannot, for the life of me, figure out how to make it not just annual year, and look only at the specific pipeline, its not accurate bc it doesnt look back into Q4 of the previous year, when a lot of the annual deals close.

I would like a quota attainment for pipeline 2024 and 2025.

Anyone have any advice or support?

2

Hi @ESvendsen! Thank you for your post.

Please note, that when using the pipeline filter, the report will only show deals currently in that pipeline and will not show closed deals (Sales Reporting Knowledge Base article). Is your goal to see all open and closed deals for both 2024 and 2025? Additionally, are the goals you set for this report also spanning across those years?

Best,
Kennedy

3

Hi Kennedy, thanks for the quick response. In this example of our quota attainment, where it says date range, you can’t select pipelines. What my boss is trying to do is get a quota for quota attainment for pipeline 2024 and 2025. We currently have it set to look at the entire year but that’s not accurate because it doesnt look back into Q4 of the previous year when a lot of our annual deals close.

unnamed.png
unnamed.png512×168 20.5 KB

4

Thanks for that additional context @ESvendsen!

At this time, that report would be limited to the pre-selected date ranges in the drop-down. That said, I’d like to invite some reporting experts to see if they can recommend a workaround.

Hey @johnelmer, @ArtyCele, @GCasali do y’all have any suggestions for reporting on Quota attainment over two calendar years? Thanks!

Best,
Kennedy

5

HI @ESvendsen, Quota attainment = closed-won (per rep, per period) ÷ that rep’s quota. The building blocks:

  1. Set goals per rep in HubSpot’s goals tool (revenue goals, by user, by period). This is the quota side.

  2. Goals reflect closed-won, so attainment reporting compares actuals to goal cleanly — the friction only appears when you try to blend in weighted/open pipeline (see the Goal vs Forecast answer).

  3. For a leaderboard-style view, a goal-based report grouped by owner gives you attainment per rep; add pipeline coverage next to it and you’ve got a genuinely useful weekly team view.

The gap people hit: mid-quarter, “attainment so far” doesn’t tell you if a rep will land the number — for that you need closed + weighted-open vs quota, which native goals won’t combine. Happy to share how I’d lay out the dashboard.