From $297k Spend to $3.9M in Generated Pipeline

+77%

Increase in landing page conversion rate

2.6×

ROI on marketing
spend

130%

Revenue growth in 2024 projection

A Deep-Dive Paid Media Influence Audit for $10M+ ARR B2B SaaS

For a sales-led B2B SaaS company with complex, multiple stakeholder sales cycles averaging 3-12 months, understanding the true ROI of paid media requires more than surface level metrics. This audit examined two years of paid media performance and sales funnel data, revealing how $297k in marketing spend generated $3.9M in qualified pipeline and drove 66% of new business revenue, while uncovering critical conversion bottlenecks that, once addressed, could dramatically improve performance.

Company profile

  • Sales-led B2B SaaS company that is doing $10M+ in ARR
  • Long cycles (3-12 months) with multiple decision makers
  • Marketing Mix: Investment in content, podcasts, videos, ABM, and paid media
  • Tech Stack: HubSpot CRM, Clearbit, 6Sense for ABM and revenue intelligence

Core Challenges

Leadership team needed clarity on three critical subjects:

  1. What is the actual revenue influence of paid media investment?
  2. Where they losing potential deals in the funnel, and why?
  3. What realistic targets should we set for next year that align spend with revenue goals?

Data Analysis Framework

I conducted a comprehensive 2 year trend analysis examining:

TOFU performance - Traffic, CPC benchmarks, HMQLs, and early-stage conversions

MOFU performance - MQL to SQL conversion rates, qualification criteria, and velocity metrics

Pipeline data - PSQO/SQO generation, win/loss analysis, and channel attribution

Financial performance - Spend efficiency, CPA, ACV, CAC payback periods, and ROI calculations

Key Discoveries

1. The Quality vs. Quantity

Key finding: While traffic dropped 28% YoY (458k → 328k sessions), conversion quality improved significantly.

Metric 2022 2023 Change Impact
Sessions 458,114 327,783 -28% Less traffic
Session→HMLQ 0.05% 0.15% +40% CRO influence
SQL Win Rate 12% 21% +75% Higher quality
Average Deal Size $40,313 $40,313 Stable Maintained ACV

Insight: The decline in lead volume was offset by a marked improvement in lead quality. This indicates that tighter targeting, increased investment in remarketing, and stronger qualification processes were working.

2. The MOFU Bottleneck

Key finding: MQL to SQL conversion plummeted from 30% to 15% YoY, but this revealed a critical process improvement.

The investigation uncovered that:

Stricter qualification criteria were implemented mid-2023

SQLs were redefined to only count after scoping calls (PSQO stage)

Many leads were stuck in "Sales Lead" status without proper nurturing

Impact: While conversion rates appeared worse, the SQL win rate nearly doubled 12% → 21%, proving that quality trumped quantity.

3. Pipeline Creation vs. Pipeline Conversion

Key finding: Despite generating substantial pipeline, conversion to closed deals remained challenging.

Pipeline Stage 2022 2023
PSQO Generated $4.16M $3.89M
SQO Generated $2.90M $2.24M
Pipeline Lost $3.85M $3.42M
Closed Won $1.06M $784k

Insight: Paid media was generating pipeline but company struggled with mid-funnel engagement and closing, particularly in Q4 2023.

4. Channel Performance Deep Dive

Finding: Inbound marketing drove the majority of business success.

🔄 Deal Attribution

Inbound → 22 customers (69% of volume), $784k revenue (66% of total)

Outbound → 6 customers (19% of volume), $167k revenue (14% of total)

Referral network → 3 customers (9% of volume), $176k revenue (15% of total)

Customer success → 1 customer (3% of volume), $55k revenue (5% of total)

📊 Channel Performance Breakdown

  • Google ads → 13 customers, $345k ARR (CPA: $3,778)
  • Paid social (Remarketing) → 4 customers, $149k ARR (CPA: $6,612)
  • Paid social (Demand creation) → 2 customers, $32k ARR (CPA: $32,018)
  • Direct (uncovered traffic) → 3 customers, $258k ARR (CPA: $11,213)

Insight: While paid social had the highest CPA, it played an important role in demand creation and assisted conversions not captured in last-touch and linear attribution.

5. Tier Analysis Reveals Opportunity

Key finding: Tier 1 accounts showed significant improvement potential.

Tier Performance Volume Revenue ACV Win Rate
Tier 1 7 deals $132k $18,920 25%
Tier 2 6 deals $351k $58,466 14%
Tier 3 9 deals $301k $33,413 26%

Insight: Despite lower volume, Tier 1 accounts needed focused attention to improve ACV and win rates.

Strategic Recommendations & 2024 Plan

Based on the analysis, I developed realistic 2024 targets that balanced growth ambitions with demonstrated conversion rates.

📈 Volume Targets

  • Sessions: 425,000 (+30% YoY)
  • HMQLs: 340 (+72% YoY)
  • MQLs: 1,160 (+65% YoY)
  • SQLs: 143 (+36% YoY)
  • Won Deals: 31 (+41% YoY)

Note: In addition to setting targets, we established benchmarks for MQL cost by channel and location but for highly relevant keyword sets and audience types. These benchmarks were defined specifically to make unit economics works and ensure campaigns remained profitable.

💵 Financial Targets

  • ARR Goal: €1.8M
  • Marketing Budget: €305k
  • ROI Target: €785k (excluding team costs)
  • Target CPA: €9,838 (improvement from €14,006)

Strategic Initiatives

1. Fix the MOFU Bottleneck

Action: Develop targeted mid-funnel content (case studies, ROI calculators, industry benchmarks)

Expected Impact: Improve MQL→SQL from 15% to 25%

Measurement: Weekly MOFU conversion tracking

2. Implement Multi-Touch Attribution

Action: Introduce "inbound-influenced" attribution model alongside last-touch

Expected Impact: Better visibility into paid media's true influence

Measurement: Quarterly attribution analysis

3. Tier 1 Account Focus Program

Action: Deploy ABM strategies using 6Sense data for tier 1 targets

Expected Impact: Increase tier 1 SQL percentage from 27% to 35%

Measurement: Monthly tier mix analysis

4. Sales-Marketing Alignment

Action: Redefine "Sales Leads" stage with clear SLA for follow-up

Expected Impact: Reduce leads stuck in limbo by 50%

Measurement: Lead velocity and aging reports

5. Channel Optimization

Action: Reallocate budget based on assisted conversion analysis

Budget Reallocation:

  • Paid Search: 35% → 25% (focus on high-intent keywords only)
  • Organic/Content: 20% → 30% (proven lower CPA)
  • LinkedIn: 25% → 30% (demand creation for enterprise)
  • Events/Partners: 20% → 15% (maintain but optimize)

Implementation Roadmap

Q1 and Q2 2024: Foundation & Optimization

  • Implement new attribution model
  • Launch MOFU content series
  • Establish sales lead SLAs
  • Deploy ABM program for TIER 1 targeted accounts
  • A/B test paid search strategies in combination with paid social

Q3 2024: Scale

  • Expand successful channel strategies across Google ads and LinkedIn
  • Introduce sales-marketing workshops
  • Launch partner co-marketing initiatives to support paid media

Q4 2024: Accelerate

  • Focus on pipeline acceleration
  • Implement end-of-year campaigns
  • Prepare 2025 strategy based on results

Results and Outcomes of Post Implementation

✅ SQL quality score increased by 35%

✅ Pipeline velocity reduced by 12 days on average

✅ Marketing influenced revenue trackable at 70% (vs. 66% last-touch only)

Expected 2024 Outcomes

  • Revenue Impact: €1.8M ARR (130% growth)
  • Efficiency Gain: CPA reduction of 30%
  • Win Rate: Improve from 21% to 26%
  • ROI: 2.6x marketing spend (up from 2.4x)

Key Learnings

1. Quality Beats Quantity in B2B SaaS

By reducing SQL volume while improving paid traffic quality and lead qualification criteria, win rates improved by 75%. This underscores why you must track performance and model your unit economics across the entire funnel, from first session to closed-won.

2. Attribution Models Matter

Single-touch attribution significantly undervalued paid media's contribution. Multi-touch revealed paid search and paid social influenced 45% of all closed deals despite showing only 2 direct attributions.

3. MOFU is the Profit Center

Companies often focus on top of funnel growth or bottom of funnel sales enablement, but the middle of the funnel where consideration happens determined success.

4. Tier Strategy Requires Patience

Tier 1 accounts had lower initial conversion rates but represented the highest growth potential. Strategic patience and targeted nurturing were essential.

5. Process Changes Beat Budget Increases

Improving the SQL definition and qualification process delivered more impact than the previous year's 29% budget increase.

Tools & Technologies Used

  • Analysis Tools: Advanced excel modeling, SQL queries via HubSpot API
  • Attribution Modeling: Custom multi-touch attribution using UTM parameters and 6Sense intent data
  • Visualization: Hubspot for executive dashboards

Conclusion

This audit transformed how the company evaluates their paid media investment. By moving beyond surface level metrics to understand the full customer journey, we found the real opportunity wasn’t in generating more traffic or endlessly introducing new tactics. Key success for every PPC strategy is to understand funnel performance, focus on the right data, uncover high-leverage insights, and build paid media strategy around profitable unit economics.

The shift from volume focused to quality focused targeting, combined with tighter sales → marketing alignment and improved attribution modeling, positioned the company to achieve 130% revenue growth with only a modest increase in marketing spend.

Most importantly, this analysis established a framework for continuous improvement, with monthly tracking against targets and quarterly strategy adjustments based on performance data.

Interested in uncovering similar insights for your B2B SaaS company?

 Let's discuss how data-driven paid media optimization can accelerate your growth.

Get a PPC Audit
“After an extended period of poor results, we were finally able to generate relevant sales leads and recover revenue from the paid marketing channels.”
Philippa Pollock
Demand generation director