Written by: Aaron Rovner, Founder, Saas Hero | Last updated: July 15, 2026

What You Will Get From This GTM Dashboard Framework

  • Most B2B SaaS teams cannot connect paid media spend to closed-won Net New ARR because ad platforms and CRMs remain disconnected.
  • A six-step framework creates the infrastructure needed to trace every Net New ARR dollar back to specific campaigns, ad groups, and keywords.
  • Defining a locked ARR waterfall with exact formulas and 2026 benchmarks eliminates reporting discrepancies between finance and marketing teams.
  • Technical tracking steps, including GCLID capture, standardized UTM taxonomy, and offline conversion uploads, enable value-based bidding on actual revenue rather than form fills.
  • SaaSHero implements this framework on a month-to-month retainer; schedule a call to map the framework to your GTM motion.

Step 1: Lock Your ARR Waterfall Formulas and 2026 Benchmarks

Purpose: Establish a single, agreed-upon definition of Net New ARR before any dashboard is built. Without this, finance and marketing report different numbers to the same board.

Actions: Instrument every booked opportunity in the CRM with a type field, labeled new, expansion, renewal, contraction, or churn, so component rollups stay consistent. Without these type fields, the formulas below cannot separate New ARR from Expansion ARR, and your waterfall collapses into a single undifferentiated number. Once the type fields exist, apply the following formulas.

The core Net New ARR formula is:

Net New ARR = New ARR + Expansion ARR − Churned ARR − Contraction ARR

The full ARR bridge equation that reconciles period-over-period is:

Beginning ARR + New ARR + Expansion ARR + Reactivation ARR − Contraction ARR − Churned ARR = Ending ARR

Component definitions:

  • New ARR: Revenue from net-new logos only, owned by new business sales.
  • Expansion ARR: Only the incremental amount above a customer's prior ARR. A customer upgrading from $100K to $150K contributes $50K, not $150K.
  • Reactivation ARR: Revenue from previously churned customers who return. This revenue must not be counted as New ARR.
  • Contraction ARR: Downgrades and seat reductions. Treat this as an early churn signal and never net it against expansion.
  • Churned ARR: Full cancellations.

2026 Benchmarks: 30–40% year-over-year Net New ARR growth is considered healthy for $50M–$150M ARR companies. Healthy Gross Revenue Retention sits at 85–90%, with 90%+ best-in-class; Net Revenue Retention of 100–110% is healthy and 120%+ is best-in-class.

Validation check: Reconcile the waterfall to the billing system monthly. If booked ARR and billed ARR diverge, identify which convention the CRM uses and document it.

Common mistake: Counting the full new ACV as Expansion ARR instead of only the incremental delta above the prior contract value.

Step 2: Turn the ARR Waterfall Into a Board-Ready KPI Table

Purpose: Translate the ARR waterfall into a structured KPI set that covers three domains, Revenue/ARR, Pipeline, and Efficiency, so every dashboard metric maps to a board-level question.

Actions: Assign an owner, a target, and a 2026 benchmark to each KPI before building any visualization.

Revenue/ARR KPIs measure whether the company is growing at a rate that justifies continued investment and whether retention mechanics are strong enough to compound that growth:

Pipeline KPIs show whether enough qualified opportunities exist to hit the ARR plan at current win rates and deal sizes:

Efficiency KPIs indicate how quickly the company recovers acquisition spend and how effectively it turns GTM dollars into durable ARR:

Validation check: Every KPI must have a single CRM or billing-system field as its source. If two team members pull the same metric and get different numbers, the definition is not yet locked.

Common mistake: Including activity metrics, such as calls made, emails sent, and impressions, alongside outcome KPIs. Dashboards with more than 12 metrics get reviewed half as often as those with 6–8 metrics.

Once you have defined which KPIs matter, the next step is ensuring you can actually measure them. That requires technical infrastructure that connects ad spend to closed-won revenue.

Step 3: Connect Ad Spend to CRM With End-to-End Tracking

Purpose: Create an unbroken data chain from the first ad click to the closed-won field in the CRM so every Net New ARR dollar can be traced to a campaign, ad group, and keyword.

Actions: Complete these five tracking tasks in sequence because each one builds on the previous step.

  • GCLID capture: Add a hidden form field named gclid to every landing page form. Map it to a custom contact field in HubSpot or Salesforce so it persists through the lead lifecycle. This field forms the foundation; without GCLID, later steps cannot tie ad clicks to CRM records.
  • UTM taxonomy: Define a standardized UTM structure, including utm_source (platform name), utm_medium (channel type), and utm_campaign (type, audience, date), and apply it consistently to every paid touchpoint. Write the UTM values to CRM contact and deal records at conversion so campaign-level detail sits beside revenue.
  • Offline conversion uploads: Set up offline conversion imports from the CRM to Google Ads and LinkedIn for key milestones such as SQL qualification, Demo Completed, and Closed Won with associated revenue value. This configuration enables value-based bidding on actual revenue signals rather than form fills.
  • Server-side tracking: Implement server-side conversion tracking using Google Enhanced Conversions and Meta's Conversion API to recover events lost to ad blockers and Safari's Intelligent Tracking Prevention.
  • Negative-keyword hygiene: Exclude competitor brand names used alone, which signal navigational intent, and retain only modifier-qualified terms such as pricing, alternatives, and vs to filter out users seeking a competitor's login page rather than evaluating alternatives.

Inputs: Ad platform accounts, CRM field schema, landing page forms. Outputs: A CRM deal record that carries UTM source, medium, campaign, GCLID, and closed-won ARR value in a single row.

Validation check: Join three datasets monthly, ad spend by platform and campaign, originating UTM values stored on CRM records, and deal value at closed-won, and confirm the row counts reconcile. Ad platforms overcount conversions by 2–4× when stacked without reconciliation.

Common mistake: Relying on last-click attribution as the sole model. Last-touch attribution systematically undervalues upper-funnel platforms such as LinkedIn because it assigns 100% credit to the final touchpoint, often a branded search ad, even when earlier touchpoints created the opportunity.

Get the GTM Dashboard Template used to generate $504K in Net New ARR for TripMaster and see how it maps to your tracking architecture.

Step 4: Build a Four-Quadrant Executive Scorecard

Purpose: Consolidate the KPI table from Step 2 into a single-page executive view that a board member can scan in under 60 seconds and that a revenue leader can use to run a weekly Monday review.

Actions: Build in Looker Studio, which is free and connects to Google Ads, Google Sheets, and BigQuery, or in HubSpot's custom report builder, which uses native CRM data and requires no ETL. Structure the scorecard in four quadrants that answer the four questions every board asks: Are we growing fast enough? Are we keeping customers? Are we spending efficiently? Can we see what is coming? Each quadrant mirrors one KPI category.

  • Growth: Net New ARR vs. plan, ARR Growth Rate, Pipeline Coverage Ratio
  • Retention: NRR, GRR, Logo Churn Rate
  • Efficiency: CAC Payback Period, Magic Number, Pipe-to-Spend Ratio
  • Forward Visibility: Pipeline Velocity, Marketing-Sourced Pipeline %, Forecast Accuracy

Each metric card displays the current value, comparison to prior period with an arrow and percentage, a color indicator vs. target using green, yellow, or red, and the named owner responsible for movement.

Validation check: A board-ready GTM dashboard must be reconciled to a single source of truth, CRM plus billing system plus finance or ERP, with written metric definitions agreed upon by GTM and finance teams to prevent discrepancies that erode board trust.

Common mistake: Building separate dashboards for marketing, sales, and finance that use different ARR definitions. One scorecard, one source of truth, and one set of definitions.

Step 5: Use Segment Data to Focus First-Year Geography and Vertical

Purpose: Concentrate ad spend and pipeline capacity on the segment where CAC payback is fastest and win rates are highest, rather than spreading budget across every geography and vertical simultaneously.

Actions: Pull closed-won data from the CRM and segment it by vertical, geography, and ACV band. Calculate CAC payback and win rate for each segment using the formula CAC Payback (months) = Sales & Marketing expense (prior period) ÷ (New ARR added × Gross margin %) × 12. Then answer these prioritization questions.

  • Which vertical has the shortest sales cycle relative to ACV? Prioritize that segment for paid search.
  • Which geography has the highest inbound win rate? Inbound sales convert at 14.6% vs. 1.7% for outbound in 2026.
  • Which segment produces the highest NRR? Prioritize that segment for expansion ARR modeling.
  • Where does pipeline coverage fall below 3×? Flag that segment as a demand generation gap.

Inputs: CRM closed-won data segmented by vertical, region, and ACV. Outputs: A ranked segment matrix with CAC payback, win rate, and pipeline coverage per segment.

Validation check: Confirm that the chosen focus segment has sufficient total addressable market to support the Net New ARR target from Step 1. A segment with a 10-day payback and 50 total prospects is not a scalable focus.

Common mistake: Selecting the segment with the largest deal size rather than the fastest payback. Median sales cycles for $100K–$200K ACV enterprise deals run 90–180 days, while $80K mid-market deals typically close in 30–90 days, which delays ARR recognition and strains cash flow for growth-stage companies.

Step 6: Run a Monthly Executive Review That Reallocates Budget

Purpose: Turn the dashboard into a decision engine by running a structured monthly review that produces explicit budget reallocation decisions.

Actions: Schedule a 60-minute monthly review with the CMO, Head of Sales, and CFO. Use a four-part agenda where each step informs the next.

  1. Scorecard review (15 min): Walk each quadrant and flag any metric outside the target range. Name the owner and the corrective action so accountability stays clear.
  2. Pipeline coverage audit (15 min): Review coverage by segment and ACV band. Pipeline coverage below 3× at the start of a quarter correlates with forecast miss probability above 40%. Use these findings to identify which channels generate qualified pipeline and which generate volume without conversion.
  3. CAC payback by channel (15 min): Compare CAC payback across paid search, paid social, and content. Channel-level CAC payback benchmarks include 11 months for paid search and 13 months for outbound SDR. Use this comparison to determine which channels deserve more budget.
  4. Budget reallocation decision (15 min): Document the reallocation in writing with the dollar amount moved, the channel it came from, the channel it goes to, and the expected impact on pipeline coverage and CAC payback within 60 days.

Validation check: Companies that track pipeline velocity weekly often achieve higher forecast accuracy than teams that track irregularly. The monthly review must be a standing calendar event, not an ad hoc meeting.

Common mistake: Reallocating budget based on platform-reported ROAS rather than CRM-confirmed closed-won ARR. Recall the 2–4× overcount issue from Step 3, which explains why platform-reported ROAS cannot drive budget decisions without CRM reconciliation.

Advanced Variations: Scaling Channels and Tightening Sales Alignment

Once the six-step framework is stable and producing consistent closed-won attribution, two extensions increase its leverage.

Multi-channel scaling: Add Microsoft Ads for LinkedIn-adjacent B2B audiences and Capterra or G2 intent campaigns for in-market buyers. Review site sources, such as G2 intent, can be high-efficiency additions once the tracking infrastructure from Step 3 is in place. Apply the same UTM taxonomy and offline conversion upload process to each new channel before scaling spend.

Sales-alignment extensions: Feed the pipeline coverage audit output directly into the SDR and AE weekly standup. When coverage drops below 3× in a specific segment, the SDR team receives a targeted outbound sequence for that segment within 48 hours. This process closes the loop between the marketing dashboard and sales execution and compresses the lag between a coverage gap and a corrective action.

Checklist Recap and Next Steps by Team Maturity

The six-step checklist:

  1. Define the ARR waterfall with locked component formulas and CRM type fields.
  2. Build the categorized KPI table across Revenue or ARR, Pipeline, and Efficiency domains.
  3. Set up GCLID capture, UTM taxonomy, offline conversion uploads, and negative-keyword hygiene.
  4. Create the executive scorecard in Looker Studio or HubSpot with 8–10 KPIs in four quadrants.
  5. Segment closed-won data by vertical and geography and select the highest-payback focus segment.
  6. Run the monthly executive review with a documented budget reallocation output.

By team maturity:

  • Founder-led teams ($0–$2M ARR): Start with Steps 1, 3, and 6. A minimal ARR waterfall, basic UTM tracking, and a monthly budget review produce more signal than a full dashboard with incomplete data.
  • VP-led teams ($2M–$15M ARR): Implement all six steps. Prioritize Step 4, the executive scorecard, to give the board a consistent view and Step 5, segment focus, to concentrate limited budget on the fastest-payback vertical.
  • Scale-up teams ($15M+ ARR): Add the multi-channel scaling and sales-alignment extensions. Introduce stage-weighted pipeline coverage, healthy SaaS teams target 2.0× weighted coverage entering the quarter, even when raw coverage reaches 4–5×, and segment CAC payback by channel and ACV band.

FAQ: Implementing and Maintaining Your GTM Dashboard

How long does setup typically take?

A complete implementation of all six steps takes four to eight weeks for most B2B SaaS companies. The longest phase is Step 3, technical tracking setup, which requires CRM field mapping, form modifications, and offline conversion upload configuration across each ad platform. Teams with a clean CRM schema and an existing UTM convention can compress this to two to three weeks. Teams starting from scratch with inconsistent historical data should budget six to eight weeks and plan for a data-cleaning sprint before the dashboard goes live.

Which roles are required to implement this framework?

A minimum viable implementation requires four roles. A marketing operations or RevOps lead owns CRM field mapping and UTM governance. A paid media manager configures GCLID capture and offline conversion uploads. A data analyst or BI developer builds the Looker Studio or HubSpot scorecard. A revenue leader, such as a CMO, VP Marketing, or founder, owns the monthly executive review and budget reallocation decisions. SaaSHero's senior-led retainer model covers all four functions without requiring internal hires, which is why growth-stage companies use it to activate the framework faster than building an in-house team.

How does the framework adapt for smaller versus larger teams?

Smaller teams, especially founder-led teams below $2M ARR, should implement a simplified three-step version. Lock the ARR waterfall definition, set up UTM tracking and GCLID capture, and run a monthly review against two or three KPIs, specifically Net New ARR, CAC Payback, and Pipeline Coverage. Larger teams above $15M ARR should add stage-weighted pipeline coverage, channel-level CAC payback segmentation, and the sales-alignment extension that feeds coverage gaps directly into SDR sequencing. The core framework stays consistent, while the depth of segmentation and the number of KPIs tracked scale with team capacity and data maturity.

What are the most common attribution gaps?

Four attribution gaps appear consistently across B2B SaaS GTM audits. First, GCLID values are not captured in hidden form fields, which breaks the link between the ad click and the CRM lead record. Second, UTM parameters are applied inconsistently, such as utm_source=google in some campaigns and utm_source=Google-Ads in others, which creates fragmented source data that cannot be aggregated. Third, offline conversion uploads are never configured, so ad platforms optimize on form fills rather than closed-won revenue signals. Fourth, platform-reported conversion data is used directly in budget decisions without reconciling against CRM closed-won records, which causes teams to scale spend on campaigns that generate leads but not revenue.

How often should the dashboard be revisited?

The executive scorecard should be reviewed weekly at the operator level for pipeline coverage, new ARR vs. plan, and stuck deals, and monthly at the executive level for full KPI review, budget reallocation, and segment performance. The underlying metric definitions and KPI targets should be audited quarterly to confirm they still reflect the company's current ARR stage and GTM motion. Annual benchmarking against published SaaS industry data, including CAC payback, NRR, and pipeline coverage, keeps targets calibrated to market conditions rather than internal historical baselines that may no longer be relevant.

Conclusion: Turn Ad Spend Into Board-Ready Net New ARR

The six-step framework, ARR waterfall definition, categorized KPI table, technical tracking setup, executive scorecard, segment focus, and monthly review, converts a disconnected stack of ad platforms and CRM records into a single, board-ready view of Net New ARR. Each step builds on the previous one, and the output of Step 6 feeds back into Step 5, which creates a self-correcting system that reallocates budget toward the highest-payback channels every 30 days.

Traditional agencies do not build this system because their billing model does not require it. SaaSHero builds it because the month-to-month retainer structure means the framework must produce measurable closed-won ARR to retain the engagement. That accountability produced $504,758 in Net New ARR for TripMaster, an 80-day CAC payback period for TestGorilla, and a 10× reduction in cost per lead for Playvox.

TripMaster adds $504,758 in Net New ARR in One Year
TripMaster adds $504,758 in Net New ARR in One Year

Senior-led execution, flat-fee pricing, and no long-term contracts keep incentives aligned from day one. The dashboard is not a deliverable; it functions as the operating system for capital-efficient growth.

Walk through the six-step implementation against your current ad spend, CRM setup, and ARR targets.