Iconiq - GMT Reporting
Iconiq - GMT Reporting
Reporting Guide
Key metrics and frameworks for GTM organizations to track
and leverage, including templates for best-in-class reporting
Go-to-Market Series
December 2023
UNLESS OTHERWISE INDICATED, THE VIEWS EXPRESSED IN THIS PRESENTATION ARE THOSE OF ICONIQ GROWTH ("ICONIQ" OR
THE "FIRM"), ARE THE RESULT OF PROPRIETARY RESEARCH, MAY BE SUBJECTIVE, AND MAY NOT BE RELIED UPON IN MAKING
AN INVESTMENT DECISION. INFORMATION USED IN THIS PRESENTATION WAS OBTAINED FROM NUMEROUS SOURCES.
CERTAIN OF THESE COMPANIES ARE PORTFOLIO COMPANIES OF ICONIQ GROWTH. ICONIQ GROWTH DOES NOT MAKE ANY
REPRESENTATIONS OR WARRANTIES AS TO THE ACCURACY OF THE INFORMATION OBTAINED FROM THESE SOURCES.
THIS PRESENTATION IS FOR EDUCATIONAL PURPOSES ONLY AND DOES NOT CONSTITUTE INVESTMENT ADVICE OR AN
OFFER TO SELL OR A SOLICITATION OF AN OFFER TO BUY ANY SECURITIES WHICH WILL ONLY BE MADE PURSUANT TO
DEFINITIVE OFFERING DOCUMENTS AND SUBSCRIPTION AGREEMENTS, INCLUDING, WITHOUT LIMITATION, ANY
INVESTMENT FUND OR INVESTMENT PRODUCT REFERENCED HEREIN.
ANY REPRODUCTION OR DISTRIBUTION OF THIS PRESENTATION IN WHOLE OR IN PART, OR THE DISCLOSURE OF ANY OF ITS
CONTENTS, WITHOUT THEPRIOR CONSENT OF ICONIQ, IS PROHIBITED.
THIS PRESENTATION MAY CONTAIN FORWARD-LOOKING STATEMENTS BASED ON CURRENT PLANS, ESTIMATES AND
PROJECTIONS. THE RECIPIENT OF THIS PRESENTATION ("YOU") ARE CAUTIONED THAT A NUMBER OF IMPORTANT FACTORS
COULD CAUSE ACTUAL RESULTS OR OUTCOMES TO DIFFER MATERIALLY FROM THOSE EXPRESSED IN, OR IMPLIED BY, THE
FORWARD-LOOKING STATEMENTS. THE NUMBERS, FIGURES AND CASE STUDIES INCLUDED IN THIS PRESENTATION HAVE
BEEN INCLUDED FOR PURPOSES OF ILLUSTRATION ONLY, AND NO ASSURANCE CAN BE GIVEN THAT THE ACTUAL RESULTS OF
ICONIQ OR ANY OF ITS PARTNERS AND AFFILIATES WILL CORRESPOND WITH THE RESULTS CONTEMPLATED IN THE
PRESENTATION. NO INFORMATION IS CONTAINED HEREIN WITH RESPECT TO CONFLICTS OF INTEREST, WHICH MAY BE
SIGNIFICANT. THE PORTFOLIO COMPANIES AND OTHER PARTIES MENTIONED HEREIN MAY REFLECT A SELECTIVE LIST OF THE
PRIOR INVESTMENTS MADE BY ICONIQ.
CERTAIN OF THE ECONOMIC AND MARKET INFORMATION CONTAINED HEREIN MAY HAVE BEEN OBTAINED FROM
PUBLISHED SOURCES AND/OR PREPAREDBYOTHER PARTIES. WHILE SUCH SOURCES ARE BELIEVED TO BE RELIABLE, NONE
OF ICONIQ OR ANY OF ITS AFFILIATES AND PARTNERS, EMPLOYEES AND REPRESENTATIVES ASSUME ANY RESPONSIBILITY
FOR THE ACCURACY OF SUCH INFORMATION.
ALL OF THE INFORMATION IN THE PRESENTATION IS PRESENTED AS OF THE DATE MADE AVAILABLE TO YOU (EXCEPT AS
OTHERWISE SPECIFIED),AND IS SUBJECT TO CHANGE WITHOUT NOTICE, AND MAY NOT BE CURRENT OR MAY HAVE
CHANGED (POSSIBLY MATERIALLY) BETWEEN THE DATE MADE AVAILABLE TO YOU AND THE DATE ACTUALLYRECEIVED OR
REVIEWED BY YOU. ICONIQ ASSUMES NO OBLIGATION TO UPDATE OR OTHERWISE REVISE ANY INFORMATION,
PROJECTIONS, FORECASTS OR ESTIMATES CONTAINED IN THE PRESENTATION, INCLUDING ANY REVISIONS TO REFLECT
CHANGES IN ECONOMIC OR MARKET CONDITIONS OR OTHER CIRCUMSTANCES ARISING AFTER THE DATE THE ITEMS WERE
MADE AVAILABLE TO YOU OR TO REFLECT THE OCCURRENCE OF UNANTICIPATED EVENTS. NUMBERS OR AMOUNTS
HEREIN MAY INCREASE OR DECREASE AS A RESULT OF CURRENCY FLUCTUATIONS.
FOR AVOIDANCE OF DOUBT, ICONIQ IS NOT ACTING AS AN ADVISER OR FIDUCIARY IN ANY RESPECT IN CONNECTION
WITH PROVIDING THIS PRESENTATION AND NO RELATIONSHIP SHALL ARISE BETWEEN YOU AND ICONIQ AS A RESULT OF
THIS PRESENTATION BEING MADE AVAILABLE TO YOU.
ICONIQ IS A DIVERSIFIED FINANCIAL SERVICES FIRM AND HAS DIRECT CLIENT RELATIONSHIPS WITH PERSONS THAT MAY
BECOME LIMITED PARTNERS OF ICONIQ FUNDS. NOTWITHSTANDING THAT A PERSON MAY BE REFERRED TO HEREIN AS A
"CLIENT" OF THE FIRM, NO LIMITED PARTNER OF ANY FUND WILL, IN ITS CAPACITY AS SUCH, BE A CLIENT OF ICONIQ. THERE
CAN BE NO ASSURANCE THAT THE INVESTMENTS MADE BY ANY ICONIQ FUND WILL BE PROFITABLE OR WILL EQUAL THE
PERFORMANCE OF PRIOR INVESTMENTS MADE BY PERSONS DESCRIBED IN THIS PRESENTATION.
THESE MATERIALS ARE PROVIDED FOR GENERAL INFORMATION AND DISCUSSION PURPOSES ONLY AND MAY NOT BE RELIED
UPON.
THIS MATERIAL MAY BE DISTRIBUTED TO, OR DIRECTED AT, ONLY THE FOLLOWING PERSONS: (I) PERSONS WHO HAVE
PROFESSIONAL EXPERIENCE IN MATTERS RELATING TO INVESTMENTS FALLING WITHIN ARTICLE 19(5) OF THE FINANCIAL
SERVICES AND MARKETS ACT 2000 (FINANCIAL PROMOTION) ORDER 2005 (THE “FP ORDER”), (II) HIGH-NET-WORTH ENTITIES
FALLING WITHIN ARTICLE 49(2) OF THE FP ORDER, AND (III) ANY OTHER PERSONS TO WHOM IT MAY OTHERWISE LAWFULLY BE
COMMUNICATED (ALL SUCH PERSONS TOGETHER BEING REFERRED TO AS “FPO RELEVANT PERSONS”). PERSONS WHO ARE
NOT FPO RELEVANT PERSONS MUST NOT ACT ON OR RELY ON THIS MATERIAL OR ANY OF ITS CONTENTS. ANY INVESTMENT
OR INVESTMENT ACTIVITY TO WHICH THIS MATERIAL RELATES IS AVAILABLE ONLY TO FPO RELEVANT PERSONS AND WILL BE
ENGAGED IN ONLY WITH FPO RELEVANT PERSONS. RECIPIENTS MUST NOT DISTRIBUTE, PUBLISH, REPRODUCE, OR DISCLOSE
THIS MATERIAL, IN WHOLE OR IN PART, TO ANY OTHER PERSON.
2
The Authors
Seeking to empower our portfolio with proprietary analytics,
insights, and advisory across business operations and strategy
3
Introduction
About The Research
ICONIQ Growth has invested in more than 100 SaaS, fintech, and consumer tech
companies. We believe a persistent theme across many successful technology
companies is that a holistic and well-executed go-to-market strategy is one of the
key pillars that drives sustainable, long-term growth.
4
What’s included?
Part I: GTM Reporting Best Practices
Best practices for designing and operationalizing a B2B SaaS GTM reporting engine based on
learnings and perspectives from the ICONIQ Growth portfolio and network.1
Companion templates
ICONIQ Growth templates that can be leveraged to track and report on these metrics, and
illustrative examples of best-in-class reporting:
ARR & Logo Funnel ARR and logo funnel templates and charts
Pipeline, Leads & Top of Funnel Pipeline outlook and coverage by segment
1 See more about these perspectives on the following page. For a complete list of ICONIQ Growth portfolio companies,
please see the appendix 5
Industry perspectives
Throughout this guide, we also weave in perspectives, insights, and best practices
from go-to-market executives in the ICONIQ Growth B2B SaaS portfolio and
network. All industry perspectives have been anonymized to protect company-level
information.
Trademarks are the property of their respective owners. None of the companies illustrated have endorsed or recommended the services of ICONIQ. Not all
companies on this page are ICONIQ Growth portfolio companies. For a complete list of ICONIQ Growth portfolio companies, please see the appendix. Insights
from some but not all ICONIQ Growth portfolio companies as well as companies not part of ICONIQ Growth’s portfolio. 6
Related materials
This guide is one in a series of ICONIQ Growth go-to-market reports.
Benchmarks for many of the KPIs and metrics included in this guide are displayed
in these materials and other ICONIQ Growth content, which will be linked
throughout this report whenever relevant.
Operationalizing Go-to-Market
Templates:
Blog Post
Blog Post
Segmenting the
Marketing budgets
sales org
7
PART 1
1 See SaaS key metrics disclosed upon IPO and ongoing after IPO in the ICONIQ Analytics Path to IPO report 9
GTM Reporting Best Practices
Displaying Longitudinal Data
Many of the benchmarks linked and referenced in this guide are presented as
median, average, or top quartile by ARR scale or sector. We share these to
demonstrate how performance evolves as companies grow and how goals may differ
by stage and business model.
However, for internal reporting purposes, we believe the best practice is to analyze
and share most of this data in a longitudinal manner (weekly, monthly, or quarterly
based on the reporting cycle) to identify and understand trends over time.
variables (1 to 3) or $65M
number of longitudinal
variables (3+) such as a
complete ARR funnel,
headcount breakdown,
or pipeline integrity
analysis
All data shown is illustrative and randomized (not a benchmark for best in class) 10
GTM Reporting Best Practices
Reporting Should Reflect Scale
We believe investing in the operational infrastructure to support reporting rigor is
important at all stages. However, companies face different challenges as they scale,
and reporting should reflect this by placing emphasis on different types of key
questions and corresponding metrics at different stages of growth.
Below summarizes guidance for the types of key questions we typically emphasize
at different stages of growth. While all these questions and metrics are important
throughout the company lifecycle, some may deserve particular focus at a certain
scale:
Expansion velocity
Customer concentration
11
GTM Reporting Best Practices
Essential GTM Board Slides
Regardless of scale, there are some updates and metrics that we believe should
typically be included in the go-to-market section of a board deck, if relevant to a
company’s business model.
Early-stage
Sales rep capacity &
New Logo New logo velocity vs. Sales Capacity
productivity vs. targets,
Velocity goal as a signal of & Attainment ramp and attainment
product market fit
GTM Reporting Best Practices
Sales Early-stage
Net and gross revenue
Revenue & Longitudinal view of
retention and logo Productivity
Logo Retention retention by segment
individual productivity,
Ramp attainment, and ramp
This template is a resource to guide users’ reporting. The template and/or portions thereof may not be relevant for all companies 12
GTM Reporting Best Practices
The ICONIQ Growth GTM Scorecard
There are seemingly endless metrics to track in a go-to-market organization and
unlimited ways to cut this data. However, we believe a critical signal of best-in-class
reporting is a company’s ability to identify top key performance indicators, set goals
against these KPIs, and regularly share progress against these goals.
In $M unless otherwise specified ACTUAL PLAN DELTA ACTUAL PLAN DELTA FCAST PLAN DELTA FCAST PLAN DELTA
Ending ARR 10.5 10.3 2% 14.1 15.0 (6%) 18.9 $20.0 (6%) 18.9 $20.0 (6%)
BOP ARR + net new ARR
Net New ARR 2.2 2.0 10% 3.6 4.7 (23%) 4.8 5.0 (4%) 11.0 $12.1 (9%)
Gross New ARR - Churned ARR
Net Dollar Retention 120% 115% 5 ppts 120% 115% 5 ppts 115% 115% O ppts 119% 115% 4 ppts
[(Qtr expansion ARR - qtr churned
ARR(*4]/average(BOP ARR + EOP ARR) + 1
Net Magic Number 0.5x 0.8x (38%) 0.4x 0.9x (56%) 0.8x 1.0x (20%) 0.6x 1.0x (40%)
Qtr net new ARR / prior quarter S&M OpEx
$125K $140K (11%) $135K $150K (10%) $150K $155K (3%) $140K $151K (7%)
S&M FTE
Annualized net new ARR / average S&M FTEs
LTV:CAC Ratio 2.9x 3.5x (17%) 3.1x 4.0x (23%) 3.5x 4.5x (22%) 3.2x 4.1x (22%)
LTV / CAC
1 The GTM scorecard is illustrative and not a proxy for independent management decisions (not a benchmark for best in class) 13
PART 2
The GTM Metrics Guide
01 Growth Drivers 04 Efficiency & Economics
Revenue recognition Gross margins
The ARR funnel Gross & net magic number
Growth Rate Customer acquisition cost (CAC)
New logo velocity Customer lifetime value (LTV)
Expansion velocity Payback period
Net new velocity
Revenue recognition FAQs
05
06 Click here to return to Part 1: GTM Reporting Best Practices
14
01 Growth Drivers
Key Questions + Metrics
Example: A contract with a 3-year term where $600K is due year one (including an implementation fee of
$100K), $1.2M is due year two, and $1.2M is due year three. Contract is signed on January 1, with a term
start date of March 1. Customer will be invoiced annually with payment due upfront.
See the ICONIQ Growth SaaS Glossary for more information All examples are illustrative and may not be relevant for all companies. 16
What does my recurring revenue funnel look like?
The Recurring Revenue Funnel
While the key revenue metric differs across businesses, we focus on recurring
revenue in this guide as it tends to be the “north star” revenue metric for B2B SaaS
companies.1 Understanding all components of the recurring revenue funnel is
critical to understanding the health of the overall business:
Term Formula
Beginning ARR Existing ARR at the beginning of a period (BOP)
BOP ARR
Input ARR, MRR, or CARR values and funnel metrics will be calculated
for automatically:
This template is a resource to guide users’ reporting. The template and/or portions thereof may not be relevant for all companies 18
What does my revenue cycle look like?
Revenue Recognition FAQs
ICONIQ Growth best practices
a customer and churned. We believe win-backs should be counted as new logos, as they should
have been booked as churned previously.
Velocity
𝐿𝐿𝐿𝐿𝐿𝐿 𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁 𝐴𝐴𝐴𝐴𝐴𝐴
new, new logo, and expansion velocity to (
𝐿𝐿𝐿𝐿𝐿𝐿−1 𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁
-1 ) * 100
understand where growth is coming from.
Net new velocity measures how well
companies are able to grow net new ARR
QoQ:
over time, which includes customer (
𝑇𝑇𝑇𝑇𝑇𝑇𝑇 𝑄𝑄𝑄𝑄𝑄𝑄 𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁
-1 ) * 100
expansion and churned ARR. 𝐿𝐿𝐿𝐿𝐿𝐿𝐿𝐿 𝑄𝑄𝑄𝑄𝑄𝑄 𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁
1 Based on multi-variable analysis on the correlation between revenue growth and public SaaS NYM forward revenue multiples (includes all software companies
with an IPO date in 2013 or later)
2 “LTM” = last twelve months. “LTM-1” is the 12-month period prior to the last twelve months. These formulas give annual velocity. 20
What’s driving this growth?
Composition of Revenue
To understand growth velocity, we believe companies must also understand what
exactly is driving this growth by looking at the composition of revenue across various
factors. Best practice is to track revenue by type, with multiple levels of granularity
across products, services, channels, geographies, and more:
Recommended metrics:
• % of ending ARR by customer size (e.g., SMB vs. Mid-Market vs. Enterprise)
• % of ending ARR by geo (e.g., AMER, EMEA, APAC, ROW)
1 ICONIQ Growth Proprietary Survey of GTM Leaders (Mar 2023). See more information about this data source in Building GTM Teams p8 21
02 Sales Funnel
Key Questions + Metrics
06
22
What’s my top of funnel volume?
Stages of the Sales Cycle
There are many ways to design a sales cycle, or “go-to-market funnel”, and many
different naming conventions for funnel stages and sub-stages. This is an archetype
of the key funnel stages that we commonly see across sales-led B2B SaaS.
SAL SALs are leads that meet a set of criteria but have not
yet engaged in the buying cycle. SAL criteria should
The lead meets acceptance criteria
and is moved to SQL
Sales Accepted be specific to the ideal customer profile – this The lead is returned to Marketing for
Lead
Sales Funnel | Sales Cycle Stages
The sales cycle shown is primarily relevant for sales-led or sales-involved growth companies. This is an illustrative archetype; not all sales-led B2B SaaS
companies will have the stages shown here and some may benefit from different stages than those shown here. 23
What does pipeline look like?
Sales Cycle: Opportunity Stages
When opportunity criteria are met, a deal is created with ~5 or so sub-stages that
align to the buyer’s decision-making process. Opportunity stages can differ
drastically, particularly for companies targeting SMB vs. enterprise customers.
For us, selling mostly to SMB customers, the first interaction should be the best interaction.
We do everything possible to close the deal in that first initial call – we do demos, share
pricing details, implementation timelines, product roadmap, and onboarding
details, all in the very first meeting.1
Revenue Leader | Late-Stage Vertical SaaS
1 Paraphrased statement from a leader in the ICONIQ Growth portfolio and network. For a complete list of ICONIQ Growth portfolio companies, see the appendix
The sales cycle shown is primarily relevant for sales-led or sales-involved growth companies. This is an illustrative archetype; not all sales-led B2B SaaS companies will
have the stages shown here and some may benefit from different stages than those shown here. 24
Do I have enough pipeline to meet sales targets? (1 of 3)
Pipeline KPIs
In addition to understanding how many leads and deals are in each stage of the sales
cycle, these KPIs can help companies understand what that pipeline means in the
context of sales targets, which can help forecast more effectively based on pipeline
health:
Pipeline $ Pipeline measures the value of all opportunities that qualify as pipeline per a
company’s sales cycle
Pipeline $
Sum of the value of all opportunities set to close in a period (e.g., this quarter, all-
time)
𝑆𝑆𝑆𝑆m (value for all opportunities set to close in period)
Weighted Pipeline $
The pipeline $ likely to be closed won in a period, based on probably of conversion
𝑆𝑆𝑆𝑆m (value for all opportunities set to close in period) * conversion rate %
Pipeline Coverage
𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃 $ 𝑡𝑡𝑡𝑡 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐 𝑖𝑖𝑖𝑖 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝
Unweighted pipeline $ set to close
𝑆𝑆𝑆𝑆𝑆𝑆𝑆𝑆𝑆𝑆 𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡 𝑓𝑓𝑓𝑓𝑓𝑓 𝑡𝑡𝑡𝑡𝑡 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝
Vs. the sales target for a period
Weighted Pipeline Coverage 𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃𝑃 $ 𝑡𝑡𝑡𝑡 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐 𝑖𝑖𝑖𝑖 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝 ∗ 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐 𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟 %
Pipeline forecasted to convert
𝑆𝑆𝑆𝑆𝑆𝑆𝑆𝑆𝑆𝑆 𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡𝑡 𝑓𝑓𝑓𝑓𝑓𝑓 𝑡𝑡𝑡𝑡𝑡 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝
vs. the sales target for a period
Sales Funnel | Pipeline KPIs
Cycle Time Duration of time a lead or deal is in a certain stage of the sales cycle. For SMB-
focused companies, cycle time is measured in days or weeks, whereas it is typically
measured in weeks or months for enterprise-focused companies. Sales cycle time is
calculated as the amount of time from pipeline (usually opportunity stage 1) to closed
won and should be calculated separately for each of a company’s market segments:
25
Do I have enough pipeline to meet sales targets? (2 of 3)
Pipeline KPIs
In addition to understanding how many leads and deals are in each stage of the sales
cycle, these KPIs can help companies understand what that pipeline means in the
context of sales targets, which can help forecast more effectively based on pipeline
health:
Conversion The percent of leads or deals that get from one stage to another in the sales cycle.
Key examples:
Rates
Win Rate
𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁 𝑜𝑜𝑜𝑜 𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜 𝑤𝑤𝑤𝑤𝑤𝑤
The % of opptys that get from
pipeline to closed won 𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁𝑁 𝑜𝑜𝑜𝑜 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐 𝑤𝑤𝑤𝑤𝑤𝑤 + 𝑙𝑙𝑙𝑙𝑙𝑙𝑙𝑙
Deal Size Total Avg Deal Size 𝐸𝐸𝐸𝐸𝐸𝐸 𝑜𝑜𝑜𝑜 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝 𝐴𝐴𝐴𝐴𝐴𝐴
I.e., Average Sales Total Pipeline $ set to close 𝑇𝑇𝑇𝑇𝑇𝑇𝑇𝑇𝑇𝑇 # 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐 𝑎𝑎𝑎𝑎 𝑒𝑒𝑒𝑒𝑒𝑒 𝑜𝑜𝑜𝑜 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝
Price (ASP)
Sales Funnel | Pipeline KPIs
26
Do I have enough pipeline to meet sales targets? (3 of 3)
Pipeline KPIs
In addition to understanding how many leads and deals are in each stage of the sales
cycle, these KPIs can help companies understand what that pipeline means in the
context of sales targets, which can help forecast more effectively based on pipeline
health:
Forecast vs. With a robust forecasting methodology, metrics that measure forecast vs. goal will
perhaps be the best way to understand whether a company has enough pipeline to
goal meet sales targets.
These are two of the most common ways to calculate forecast vs. goal, and it is
recommended to track both to understand how sales capacity is tracking against
sales target. In both cases, any revenue metric can be utilized (e.g., net new ARR or
gross new ARR)
Forecast as % of Capacity1
Compares the pipeline forecast $ to
the capacity, or the maximum amount 𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹 $ 𝑓𝑓𝑓𝑓𝑓𝑓 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝 𝑋𝑋
of ARR that could be generated by 𝑆𝑆𝑆𝑆𝑆𝑆𝑆𝑆𝑆𝑆 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐 𝑓𝑓𝑓𝑓𝑓𝑓 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝 𝑋𝑋
quota-carrying reps (QCRs), for a
period
Origin source
Refers to where the lead or opportunity originated in terms of ongoing go-to-market efforts:
A lead that opted into contact with the organization in some way, such as by signing up for a
Inbound mailing list, filling out a web form, downloads content, etc. In terms of attribution, inbound
leads are often attributed to marketing efforts.
A lead that is specifically targeted by outreach by the organization, such as via direct
Outbound outbound emails, cold calls, or mail.
A lead that has been referred to the organization by a third party that is not a partner (as
Referral partner-sourced leads should be tracked separately). These kinds of referrals often come from
existing customer or investor.
Partner A lead that is brought to the organization by a partner such as a referral partner or reseller
Sales Funnel | Lead & Opportunity Source
Direct traffic Online Direct to the website (no other channels utilized)
Email Marketing Online Via an email marketing campaign such as a newsletter or blog
Paid Search Online Via a search engine because of a paid advertising campaign
Other offline Offline Via media and grassroots marketing efforts, television, sponsorship, etc.
1 Not exhaustive – marketing channel sources may differ in breadth and granularity by company 28
Sales Funnel
Pipeline FAQs
Industry Perspectives
Identify which use cases have the best conversion rates and most efficient cycle times –
that will be your best way to your foot in the door with enterprise customers. You can
start small, and once you’re in you’ll have massive upsell opportunity.
Sales Funnel | Pipeline
As an SMB business, time is the most important factor in our deals. Our goal is to get
the customer from A to B in the fastest way possible, so we look at cycle time for each
stage and the percent of initial meetings that convert to closed deals.
Sales Leader | Late-Stage Vertical SaaS1
1 Paraphrased statement from a leader in the ICONIQ Growth portfolio and network. For a complete list of ICONIQ Growth portfolio companies, see the appendix. 29
Do I have enough pipeline and top of funnel to meet targets?
Pipeline & Leads Template
Leverage this template to create automated outputs for weighted and unweighted
pipeline, pipeline vs. bookings, lead conversion rates, and more that can be used in
top-of-funnel reporting.
Input ARR, MRR, or CARR values and funnel metrics will be calculated
for automatically:
This template is a resource to guide users’ reporting. The template and/or portions thereof may not be relevant for all companies 30
03 Retention
Key Questions + Metrics
Why are customer churning and Churn & lost reasons p33
how is this changing over time? Won / lost analysis
02
03
04
05
06
31
How are we retaining and expanding existing customers?
Retention Metrics
Retention – both revenue and logo – signals the efficiency of a company’s growth by
measuring its ability to retain and expand existing customers. We believe this makes
retention one of the most important gauges of business health, as it is correlated
with everything from product market fit to customer health.
ICONIQ Growth Annual (LTM) NDR % 𝐿𝐿𝐿𝐿𝐿𝐿 𝑛𝑛𝑛𝑛𝑛𝑛 𝑛𝑛𝑛𝑛𝑛𝑛 𝐴𝐴𝐴𝐴𝐴𝐴 − 𝐿𝐿𝐿𝐿𝐿𝐿 𝑛𝑛𝑛𝑛𝑛𝑛 𝑙𝑙𝑙𝑙𝑙𝑙𝑙𝑙 𝐴𝐴𝐴𝐴𝐴𝐴
benchmarks available Looks at total NDR for the 1+
(p24) 𝑎𝑎𝑎𝑎𝑎𝑎(𝐵𝐵𝐵𝐵𝐵𝐵 𝐴𝐴𝐴𝐴𝐴𝐴 + 𝐸𝐸𝐸𝐸𝐸𝐸 𝐴𝐴𝐴𝐴𝐴𝐴)
last twelve months
Cohort NDR %
Looks at annual (LTM) NDR for the specific cohorts of companies (e.g., all companies
that signed within a given quarter). This helps businesses better understand what’s
driving changes in retention over time
BOQ = Beginning of quarter; EOQ = end of quarter; BOP = beginning of period; EOP = end of period
It is recommended to average BOP and EOP ARR in the denominator to adjust for quarter over quarter ARR growth. Alternatively, BOP ARR can be used. 32
Why are customer churning and how is this changing?
Churn & Lost Reasons
Companies should assign a primary reason for every lost opportunity or customer
churn / downsell. While multiple reasons often apply, tracking primary lost reasons
can help diagnose important sales process or product gaps that can be filled.
While churn & lost reasons should be catered to a company’s market and buyers,
the important thing is that each option reflects a root cause. For example, we often
see a “Timing” category, but this category can often be better categorized into one
of the options below:
No Decision For use when a prospect or customer is unresponsive or not ready to buy
Lack of sponsor For use when a deal was lost due to lack of executive sponsor / buyer
For use when the customer goes through a major change that inhibits a deal.
Business Change Significant business changes include company acquisitions, restructurings, and
liquidations
Unlike budget, the price category should be used when the budget exists, but the
Price customer can’t justify the quoted price. This can suggest a price-value-mismatch
Prospect or customer requires features or product functionality that is not available or
Functionality does not meet current needs or expectations. Also track: Feature request(s) and/or
product feedback
For use when the root cause of a churn or downsell is implementation related (e.g.,
Implementation time to value, delayed or unfulfilled implementations)
For use when the product or service was delivered to a customer, but lack of adoption
Lack of Adoption led to churn
For use when the team “dropped the ball” on an opportunity by lack of coverage or
Dropped Ball follow-up (most often, when a sales rep leaves and account transitions are mis-
managed). This should only be used when the options above are not relevant
For use when after additional discovery, this company does not meet the ideal
customer profile and should not have been qualified. Opportunities lost due to bad fit
Bad Fit* should not be included in lost count but should be reviewed regularly and used to
refine ICP and qualification criteria.
Active User Measures the proportion of users that are active users (hit a minimum activation
threshold on a daily, weekly, or monthly basis) out of the total user pool of a specific
Rate customer:
Adoption Rate Measures the portion of users that have adopted a new feature or product. This
metric is most useful in the first ~12 months after releasing a new product (or
activating a new product / feature for a specific customer)
Stickiness Rate (%) Measures how well the 𝐷𝐷𝐷𝐷𝐷𝐷𝐷𝐷𝐷𝐷 𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎 𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢 𝑓𝑓𝑓𝑓𝑓𝑓 𝑋𝑋 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐
∗ 100
product is retaining active users 𝑀𝑀𝑀𝑀𝑀𝑀𝑀𝑀𝑀𝑀𝑀𝑀𝑀 𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎 𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢 𝑓𝑓𝑓𝑓𝑓𝑓 𝑋𝑋 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐
Gross user 1+
𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶 𝑋𝑋 𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢 𝑎𝑎𝑎𝑎 𝐸𝐸𝐸𝐸𝐸𝐸 − 𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢 𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜𝑜 𝑖𝑖𝑖𝑖 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝
∗ 100
Retention % 𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶 𝑋𝑋 𝑛𝑛𝑛𝑛𝑛𝑛𝑛𝑛𝑛𝑛𝑛𝑛 𝑜𝑜𝑜𝑜 𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢𝑢 𝑎𝑎𝑎𝑎 𝐵𝐵𝐵𝐵𝐵𝐵
Net Promoter Measures the likelihood of a user to recommend the product to another potential
user
Score % of promoters at company X - % of detractors at company X
NPS
00
01
02
03
04
05
06
36
Is our go-to-market motion scaling efficiently? (1 of 2)
GTM Efficiency Metrics
Go-to-market is often the largest investment a B2B SaaS company makes in terms of
both people and programs spend.1 As such, we believe it’s imperative to track and
understand go-to-market efficiency as a company scales. The following metrics focus
on how efficiently a company is operating on a per-unit basis:
Magic Magic number measures the amount of ARR or revenue gained for every dollar
spent to acquire it, making it a robust signal of GTM efficiency and unit
Number economics.
A magic number calculation should depend on a company’s sales cycle, and
ICONIQ Growth different magic number calculations can be used if sales cycles differ across
benchmarks available segments. The formula included here shows a one-quarter offset such that we are
(p46)
measuring new ARR this quarter relative to spend last quarter to reflect a median
~60-90-day sales cycle. For those with a much shorter or longer sales cycle, that
period offset can be adjusted.
Magic number can also be multiplied by a company’s gross margin to account for
the payback required to fully break even and normalize comparisons across
companies.
Customer CAC measures the $ cost of acquiring one new logo via a few primary methods:
Cost (CAC) S&M OpEx per new logo 𝐺𝐺𝐺𝐺𝐺𝐺𝐺𝐺𝐺𝐺 𝑛𝑛𝑛𝑛𝑛𝑛 𝑙𝑙𝑙𝑙𝑙𝑙𝑙𝑙 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐
Customer LTV measures the profit acquired over a single customer’s lifetime, with the idea
that the LTV of a customer is greater than the cost to acquire that customer:
Lifetime
Simple LTV1
Value (LTV) Profit on average ARR per
𝐴𝐴𝐴𝐴𝐴𝐴 𝑝𝑝𝑝𝑝𝑝𝑝 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐 ∗ 𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔 𝑚𝑚𝑚𝑚𝑚𝑚𝑚𝑚𝑚𝑚
𝐿𝐿𝐿𝐿𝐿𝐿𝐿𝐿 𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐𝑐 𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟
Retained customer
Cohort LTV
Looks at LTV for a specific cohorts of companies (e.g., all companies that signed
within a given quarter). This helps businesses better understand what’s driving
changes in LTV over time
LTV/CAC
The LTV to CAC ratio measures the value
ICONIQ Growth 𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶𝐶 𝐿𝐿𝐿𝐿𝐿𝐿
of each customer relative to the cost to
Efficiency & Economics
Is the go-to-market team Net new ARR per S&M FTE p41-42
scaling productively? Sales capacity
Sales productivity
Quota attainment
Ramp rate
00
01
02
03
04
05
06
39
Is the GTM team scaling efficiently?
Headcount Efficiency
The following metrics help companies understand headcount efficiency and
productivity in the go-to-market organization, which is an important component to
team planning and hiring, as well as understanding performance vs. goal.
S&M OpEx
Measures go-to-market headcount
per S&M FTE efficiency by looking at average S&M 𝑄𝑄𝑄𝑄𝑄𝑄 𝑆𝑆&𝑀𝑀 𝑂𝑂𝑂𝑂𝑂𝑂𝑂𝑂 ∗ 4
on a per-S&M-employee basis 𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴 𝑆𝑆&𝑀𝑀 𝐹𝐹𝐹𝐹𝐹𝐹𝐹𝐹 𝑖𝑖𝑖𝑖 𝑞𝑞𝑞𝑞𝑞𝑞
Annualized formula shown
ICONIQ Growth
benchmarks available
(p53)
Headcount Headcount ratios between key go-to-market roles are a great way to measure
whether the team is growing in a scalable manner. As account executives (AEs)
Ratios typically make up the largest portion of any go-to-market organization, headcount
is usually compared between AEs and other key roles such as CSMs and managers.
Companies should track this over time with the goal to increase leverage as a
company scales, allowing for AE headcount ratios to increase:
Employee Employee attrition, both voluntary and involuntary, is typically highest in a SaaS
company’s go-to-market organization (sales in particular). In the case of quota-
Attrition carrying teams, attrition can have a major impact on sales capacity, a primary
driver of overall attainment. It’s important to track and forecast attrition effectively
to better forecast hiring needs relative to goals.
40
Is the GTM team scaling productively? (1 of 2)
Headcount Productivity
The following metrics help companies understand headcount efficiency and
productivity in the go-to-market organization, which is an important component to
team planning and hiring, as well as understanding performance vs. goal.
Sales Measures the maximum amount of ARR that could be generated by quota-carrying
reps (QCRs) in a given time period, while taking into account ramp, attainment, and
Capacity attrition. This can be measured on a monthly, quarterly, or annual basis, and be
looked at on a total or per rep basis:
Total Sales Capacity1 Allocated quota in qtr * % quota attainment * QCR retention rate
Sales Rep Measures the amount of actual ARR generated per quota-carrying rep, which can
also be measured on a monthly, quarterly, or annual basis. Net productivity is
Productivity preferred as it takes into account churn (regardless of whether sales owns
renewal and expansion)
1 Allocated quota in qtr is the sum of all individual contributor quotas for a given quarter less quotas unallocated due to ramp 41
Is the GTM team scaling productively? (2 of 2)
Headcount Productivity
The following metrics help companies understand headcount efficiency and
productivity in the go-to-market organization, which is an important component to
team planning and hiring, as well as understanding performance vs. goal.
Quota While a couple ways to calculate quota attainment are included here, the best
practice is to look at the distribution of quota attainment over time, either in a 100%-
Attainment stacked-bar-chart format or in a histogram format. See an example displayed in our
GTM board deck template:
Ramp Rate Ramp rate measures a company’s ability to onboard new sales reps effectively, a
critical component of scaling any go-to-market team.
Team & Productivity | Headcount Productivity
Ramp Rate # 𝑄𝑄𝑄𝑄𝑄𝑄𝑄𝑄 𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎𝑎 𝑞𝑞𝑞𝑞𝑞𝑞𝑞𝑞𝑞𝑞 𝑖𝑖𝑖𝑖 𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝 𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓 𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟
% of reps achieving quota 𝑇𝑇𝑇𝑇𝑇𝑇𝑇𝑇𝑇𝑇 𝑄𝑄𝑄𝑄𝑄𝑄𝑄𝑄 𝑖𝑖𝑖𝑖 𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝 𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓𝑓 𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟𝑟
in first period after fully ramped
42
06 Fiscal Maturity
Key Questions + Metrics
00
01
02
03
04
05
06
43
How are we getting from pipeline to forecasts? (1 of 2)
Pipeline Forecasts
There are many forecasting methodologies, each with pros and cons depending on
a company’s go-to-market motion and sales cycle.
The simple forecasting methodologies included here are often used in the early
stages of company growth. As companies scale and approach revenue predictability,
more complex methodologies are developed, and many companies invest in tooling
to build robust statistical forecasting models.
Assessment forecast
An assessment forecast, also known as an “intuitive forecast”, relies on human assessment of the likelihood
that an opportunity will be won. Sales reps, sales managers, and sales leadership assign one of the following
assessment categories to each opportunity, as well as a probability (%) that the opportunity will be won. The
assessment category can have a fixed % probability associated with it, or the % probability can be chosen
from a range within that assessment category:
1 % probability values shown here are examples. Companies should use their own probability allocations based on their sales cycle and historical actuals
2 Pipeline forecast does not include churn 44
How are we getting from pipeline to forecasts? (2 of 2)
Pipeline Forecasts
There are many forecasting methodologies, each with pros and cons depending on
a company’s go-to-market motion and sales cycle.
The simple forecasting methodologies included here are often used in the early
stages of company growth. As companies scale and approach revenue predictability,
more complex methodologies are developed, and many companies invest in tooling
to build robust statistical forecasting models.
Stage forecast
A stage forecast is considered slightly more robust than an assessment forecast. Stage forecasts use historical
conversion rates from one stage to the next to predict the likelihood of an opportunity to be closed won. For
example:
decreases the likelihood an opportunity will be won vs. historical conversion rates. For example, if many
deals have historically been closed lost due to lack of feature functionality, and a feature is being released
to solve for this, win rate may be expected to increase proportionally.
We prefer the stage forecast method. It’s more accurate than assessment
forecasts, and these are often an ineffective use of time for your sales team. We
want our reps to be focused on execution.3
Finance Leader | Later-Stage Infrastructure SaaS
1 Win rate values shown here are illustrative examples (not a benchmark for best in class). Companies should use their own historical conversion rates
2 Pipeline forecast does not include churn
3 Paraphrased statement from a leader in the ICONIQ Growth portfolio and network. For a complete list of ICONIQ Growth portfolio companies, see the appendix 45
Are we achieving revenue predictability & repeatability? (1 of 2)
Signals of Fiscal Maturity
As companies scale, we believe it should be a priority to approach revenue
predictability and repeatability – and many of the metrics included in this guide
help companies achieve this.
This responsibility should not only reside with the finance team. The go-to-market
teams play a critical role in setting goals and bear the responsibility of providing
accurate forecasts based on high fidelity pipeline and top of funnel projections. The
following metrics can be used to measure progress towards revenue predictability
as an organization scales:
ARR is used as the primary revenue metric in these top-line calculations but can be substituted for CARR or
run-rate bookings where relevant. Similarly, FCF is used as the bottom-line metric, but can be substituted for
operating income or EBITDA.
YoY ARR Growth attainment 𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴𝐴 𝑌𝑌𝑌𝑌𝑌𝑌 𝐴𝐴𝐴𝐴𝐴𝐴 𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔 𝑖𝑖𝑖𝑖 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝
Attainment vs. budget for year 𝑌𝑌𝑌𝑌𝑌𝑌 𝐴𝐴𝐴𝐴𝐴𝐴 𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔𝑔 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝 𝑖𝑖𝑖𝑖 𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝𝑝
over year ARR growth
This is particularly important for companies to develop prior to entering the public markets. A company’s
ability to meet and beat quarterly guidance estimates signals visibility into future performance, strong growth
prospects, and the internal financial and operational rigor to accurately forecast and meet market demand. A
company’s ability to beat and raise is strongly correlated with public market performance.
While beating expectations is important, excessive sandbagging can also be detrimental to market
performance. It is recommended that companies start thinking like a public company about ~2 years prior to
IPO, which includes building “beat and raise” into the forecasting motion.
We implemented a beat and raise motion 1.5 years before IPO. Every quarter,
we generated a conservative number based on our sales forecast for each
subsequent quarter, and we use that to guide how we set our targets.1
Finance Leader | Later-Stage Infrastructure SaaS
1 Paraphrased statement from a leader in the ICONIQ Growth portfolio and network. For a complete list of ICONIQ Growth portfolio companies, see the appendix
Learn more about the “beat and raise” motion and IPO readiness in ICONIQ Analytics Path to IPO report 47
Entrepreneurs Backing Entrepreneurs
48
ICONIQ Growth | A global portfolio of
category-defining businesses
Appendix
These companies represent the full list of companies that ICONIQ Growth has invested in since inception through ICONIQ Strategic Partners funds as of the
date these materials were published (except those subject to confidentiality obligations). Trademarks are the property of their respective owners. None of the
companies illustrated have endorsed or recommended the services of ICONIQ. 49
San Francisco | Palo Alto | New York | London
50