Systems Audit & Diagnostic Presentation

Celigo Revenue Operations Transformation

A unified narrative synthesizing HubSpot and Salesforce findings into a comprehensive transformation roadmap.

WebRenew Logo
Client:

The Story We're Telling

Narrative Arc

Act 1

The Situation

Celigo's revenue operations infrastructure has accumulated years of technical debt. What began as tactical workarounds has calcified into structural constraints that now actively block revenue recovery.

Act 2

The Diagnosis

Two parallel audits—HubSpot and Salesforce—reveal the same root cause: the organization has been using vendors and custom objects to compensate for avoiding standard lifecycle architecture.

Act 3

The Path Forward

The fix is not more tooling. The fix is restoring native lifecycle discipline, letting tools do their intended jobs, and augmenting human capacity with AI where it creates the most leverage.

Part 1

Context & Engagement Overview

Engagement Summary

Client
Celigo
Primary Contact
Nicole Penland (Sr. Director, Revenue Marketing)
Engagement Start
October 2025
Duration
6 months (through May 2026)

SOW Deliverables

  • Full diagnostic report with system architecture map
  • Critical issues briefing (top 7 gaps)
  • Tool consolidation roadmap
  • Campaign to BDR flow recommendations
  • BDR team composition recommendations
  • Six-month AI transition plan
  • Prioritized implementation roadmap

Discovery

Stakeholder Interviews

Brian Knaupe

Key decision maker

VP, GTM Operations

Sales Ops, Partner Ops, Overall GTM Systems

Dean Davis

NEW ROLE

Head of Marketing Ops

HubSpot, Salesforce (Marketing side), Lead Scoring

Jerry Patterson

9.5 years

System Operations Analyst

Gong (Admin), Chili Piper (Admin)

Aaron Young

6 years

Sr. Sales Operations Analyst

Lead processes, routing oversight

Karen Lacambra

4 years

Sales Operations Analyst

Territory routing, lead routing

Cody Loyer

6 months

Sr. Marketing Ops Manager

HubSpot configuration

Part 2

Executive Diagnosis

HubSpot Assessment

HubSpot is not merely misconfigured — it is structurally constrained by prior architectural decisions that now block revenue recovery, break lead recycling, undermine attribution investments, and force manual sales workarounds.

This is no longer a marketing ops problem. It is a revenue system integrity issue.

Salesforce Assessment

Salesforce is experiencing compounding technical debt and integration failures that block accurate pipeline reporting, force manual workarounds, create data trust issues, and risk critical knowledge loss during team transitions.

This is no longer a data hygiene problem. It is an operational reliability issue.

The Cascade Effect

1
HubSpot: Custom funnel stages instead of native lifecycle
2
Leads cannot re-qualify (hardcoded 'ever been MQL' blocks)
3
2,400+ leads rot with zero activity
4
Nurture automation breaks (6 months broken)
5
SDRs working blind (notifications broken ~2 months)
6
Manual workarounds proliferate (Google Sheets)
7
Report trust collapses
8
Attribution fails (>50% misattributed)
9
Executive visibility compromised

Current vs. Target Metrics

MQL to Opportunity Conversion

Current

~6.3%

Target

10%

Speed to Lead

Current

Unknown

Target

Under 5 minutes

SDR SLA Adherence

Current

~60-75%

Target

Over 90%

Attribution Accuracy

Current

~50%

Target

Over 95%

AI Handling (Month 6)

Current

0%

Target

70%

Stakeholder Data Trust

Current

Low

Target

Over 80%

Part 3

System Architecture — Current State

Part 3.4

Tool Consolidation Roadmap

Consolidation Targets

ZoomInfo + Lusha + CognismMonth 1-2
ZoomInfo primary; Lusha EMEA only
Traction Complete + Chili PiperMonth 2-3
Single routing solution
ThoughtSpot + SigmaIn progress
Sigma only
Manual spreadsheets + SFDCMonth 3-6
SFDC dashboards only

Already Deprecated

Cognism
CanceledMid-year contract termination
RollWorks
CanceledMarketing decision
ThoughtSpot
ReplacingSigma taking over

Sunset Candidates

Traction Complete

Brian's team evaluating alternatives

Replace
Chili Piper

Over 50% attribution errors, 'Suggested AE' field ignored, reps manually routing

Consolidate
LiveChat

Candidate for consolidation — Qualified can replace

Consolidate

Consolidation Opportunity: Qualified

The audit identified two tools with overlapping functionality and significant issues:

  • Chili Piper — Over 50% attribution errors, "Suggested AE" field ignored, reps manually routing
  • LiveChat — Separate vendor, no attribution tie-in

Qualified (qualified.com) could consolidate both into a single platform with:

Native Salesforce integration with attribution preservation
AI-powered chat + visitor de-anonymization
Meeting scheduling with proper routing logic
1,200+ G2 reviews, Forrester #1 rated

Recommendation

Schedule a 30-minute demo for Brian Knaupe to evaluate as part of the routing tool decision. This is complementary to Unify (which handles email sequences), not a replacement.

Note: This aligns with Brian's stated priority — "Routing is the biggest one [change]."

Part 4

Critical Findings — HubSpot

H1

Custom Funnel Stages Are the Root Cause

CRITICAL

HubSpot uses custom 'Marketing Funnel Stage' instead of native Lifecycle Stage. Funnel stamps are irreversible, re-qualification is impossible, and leads rot permanently.

Impact: Leads that re-engage can NEVER become MQLs again. Database full of stale records. Completely breaks lead recycling motion.

Recommendation: Use HubSpot lifecycle stages as designed. Allow lifecycle regression and progression.

H2

Re-Qualification Failure Is Self-Inflicted

CRITICAL

Hard 'has ever been MQL' conditions block re-entry. No lifecycle clearing mechanism exists.

Impact: Re-engaged prospects never convert. Nurture is meaningless. Marketing ROI suppressed.

Recommendation: Remove 'ever been MQL' hard blocks. Enable lifecycle-based re-qualification. Use engagement + fit to re-trigger MQL.

H3

Workflow Volume Is a Symptom

HIGH

~1,200-1,300 workflows in HubSpot. Built on 'quicksand' with no strong foundations.

Impact: Duplicate properties, complex dependencies, hard-coded values causing campaign association problems.

Recommendation: Lifecycle-first triggers replace hundreds of workflows. Campaign logic simplified. Brand logic enforced upstream.

H4

Two Brands, One Instance — No Guardrails

HIGH

Celigo Core + CloudExtend share infrastructure with no guaranteed exclusion logic. No inclusion list is being used in HubSpot to connect SFDC.

Impact: Cross-brand contamination, mis-attribution, incorrect nurture, undetected reporting errors.

Recommendation: Introduce explicit brand enforcement with hard exclusions, brand-aware workflows, and brand-locked nurture.

H5

Routing & Notification Failures

HIGH

Email notifications broken for ~2 months. SDRs polling list views all day.

Impact: SLA breaches, lost high-intent leads, territory leakage, shadow IT proliferation.

Recommendation: HubSpot must act as routing safety net providing redundant alerting, SLA monitoring flags, and exception queues.

Part 5

Critical Findings — Salesforce

S1

Email Notification Failure — SDRs Working Blind

CRITICAL

Email notifications for new lead assignments broken for approximately 2 months. SDRs manually refreshing list views.

Impact: SLA breaches on high-intent leads, manual polling gaps, 15-25% of inbound leads not contacted within SLA.

We're literally using a Google Sheet to track meetings because we can't trust the Salesforce numbers.Aaron Young

S2

Attribution Failure in Chili Piper Integration

CRITICAL

More than 50% of leads have attribution errors (per Brian). 'Suggested AE' field untrustworthy. 3 US states stuck in routing round robin.

Impact: Marketing ROI reporting compromised, compensation disputes, forecasting accuracy degraded.

We can't tell which marketing channel actually drove the meeting because the attribution gets overwritten.Karen Lacambra
The Suggested AE field is basically useless at this point — reps just manually route.Jerry Patterson
Three states have been stuck in our round robin for months while we wait on hiring.Aaron Young

S3

Gong Sync Failures — Meeting Overreporting

HIGH

Rescheduled meetings counted multiple times. Manual spreadsheet tracking used as workaround.

Impact: SDR performance metrics unreliable, trust in Salesforce numbers collapsed.

I booked 4 meetings the week of 11/24, but the report only showed 1.Cece (SDR)

Strong Recommendation

We advise against creating custom event objects. This is exactly the pattern that created the current technical debt — building new custom objects instead of fixing existing configuration issues.

If You Insist

If client proceeds with custom event object anyway, we will support implementation but flag that we are not responsible for downstream integration issues this may create.

S4

Data Hygiene Crisis

HIGH

No systematic lead cleanup. Kaitlyn: ~1,100 leads with zero activity. Meredith: ~1,300 leads. Total: ~2,400 leads in limbo.

Impact: Reporting accuracy compromised, operational inefficiency, cost waste, lost nurture opportunities.

S5

Automation Technical Debt

HIGH

534 active flows with significant overlap. 69 workflow rules must migrate to flows (Salesforce platform sunset deadline has passed—URGENT).

Impact: Operational risk, performance degradation, error propagation, compliance risk from deprecated workflow rules.

S6

No Accurate Lifecycle Stage Tracking

MEDIUM-HIGH

No lifecycle stage tracking in Salesforce. Marketing cannot report on full lifecycle conversions in SFDC.

Impact: Strategic reporting impossible, cross-team misalignment, forecasting accuracy degraded.

Critical Context

The organization is currently using Full Circle as a vendor-driven, campaign-based attribution bypass instead of native lifecycle logic. This means the company is paying a vendor to compensate for foundational system misalignment. Full Circle should enhance attribution — not replace lifecycle logic, not dictate system architecture. Implementing proper lifecycle tracking does not break Full Circle's plans; it improves them by giving Full Circle cleaner, more truthful data to work with. We are strongly recommending against Full Circle as a path forward.

Part 6

Where the Audits Converge

Part 6.2

Campaign to BDR Flow Recommendations

Current State (Broken)

CampaignForm FillHubSpot
??? (attribution lost)
SFDC??? (notifications broken)SDR

- Broken notifications

- Attribution overwrites

- No SLA enforcement

Target State (Fixed)

CampaignHubSpot: Score + Brand-Tag
Lifecycle Stage: MQL

High Intent

Route to AE

If no action 4hr: escalate

Low Intent

Route to SDR

If no action 2hr: AI SDR

Key Recommendations

1

Define Intent Tiers

High → AE, Low → SDR

2

Implement SLA Enforcement

4hr AE, 2hr SDR escalation

3

Brand-Lock Campaigns

Celigo vs CloudExtend separation

4

Restore Attribution Chain

Lock fields, prevent overwrites

5

AI SDR Safety Net

Catches all missed SLAs

Part 7

BDR/SDR Team Assessment

RepLocationH2 MeetingsBook RateShow RateCVRNotes
Kaitlyn Scott
US14614.6%84%9.2%Top performer
Meredith Kimball
US13113.1%88%7.6%Top performer
Claire Philippe
EMEA10310.3%63%3.8%EMEA specialist
Cece Capistrano
APAC10210.2%69%4.7%APAC coverage
TEAM AVERAGE10.7%77%6.3%

Recent Changes

Jhelly Dela TorreOffboarded January 2026
Jay LopezOffboarded January 2026

Q1 2026 Gap Analysis

Human SDR Baseline139 opps
Gap to 200-61 opps
AI SDR Contribution+55 opps
Paid Media Lift+15 opps
Projected Total209 opps (104%)

Month 6 End State: 2 Humans + AI

Kaitlyn Scott
US + overflow
Meredith Kimball
US + overflow
Unify
All regions

Claire and CeCe transition out as AI assumes EMEA/APAC coverage

Team Transformation Timeline

Month 1-2

4humans

AI: 0% → 30%

Month 3-4

4humans

AI: 30% → 50%

Month 5-6

2humans

AI: 70%

Part 8

AI SDR Transition Framework

Selected Vendor: Unify

unifygtm.com

Approved

Approved January 20, 2026 — Awaiting Signature

Capability

AI reengagement campaigns

Capability

Speed-to-lead (<5 min first touch)

Capability

Automatic multithreading to buying committees

Human Benchmarks (AI Must Match)

These are the current human SDR metrics that AI must match or exceed to justify transition

SDRBook RateShow RateCVR
Kaitlyn ScottTop14.6%84%9.2%
Meredith KimballTop13.1%88%7.6%
Claire Philippe (EMEA)10.3%63%3.8%
Cece Capistrano (APAC)10.2%69%4.7%
TEAM AVERAGE10.7%77%6.3%

AI SDR must achieve ≥6% CVR on re-engagement to be considered successful in Phase 1

Phased Rollout Plan

Phase 1Week 4

Re-Engagement

~7,500 stale leads

Projected: +10-15 opps

Phase 2Week 5-6

Speed-to-Lead

~40% of real-time MQLs

Projected: +15-20 opps

Phase 3Week 7+

Multi-Threading

All MQLs

Projected: +10-15 opps

Phase 4Month 4+

Full-Funnel (Optional)

Any list, any segment

Implementation Timeline

Vendor Selected

Unify approved

Contract

Awaiting signature

Setup + Warmup

Weeks 1-3

Phase 1 Launch

Week 4

Phase 2

Week 5-6

Full Deploy

Week 7+

Deploy Timing Impact

Mid-Feb deploy (7 wks)

~195

Early Feb deploy (9 wks)

~205

Full quarter (13 wks)

~209

Every week of delay = ~5-8 fewer opps

How AI SDR Closes the Gap

Use CaseMechanismImpactAdditional Opps
Speed-to-leadFirst touch <5 min on all MQLs+2-3% on low intent+15-20
Re-engagement7,500 stale leads @ 2% bookAdditive pool+10-15
Instant demo follow-upWhen AEs don't respond in SLACaptures leakage+5-10
Total AI SDR Contribution+30-45

Implementation Questions Answered

Lead selection criteria

Phase 1: 7,500 stale leads. Phase 2: real-time MQLs. Phase 3: multi-threading on all inbound.

Human-in-the-loop process

Humans control messaging templates, can review before send, handle all responses. Autonomy increases as performance validates.

Leading indicators

Response rate, positive reply rate, book rate, show rate, time to first touch, contacts per account.

Benchmarking

H2 2025 data by rep provides baseline. Weekly AI vs human comparison planned.

Meeting booking

Chili Piper remains scheduling tool. AI proposes correct AE calendar based on territory/account mapping.

Timeline

Weeks 1-3: Setup + warmup. Week 4: Phase 1. Week 5-6: Phase 2. Week 7+: Full deploy.

Identity

TBD — options: individual domain (jack@celigo.com) or general (sales@celigo.com).

Part 9

Unified Transformation Roadmap

Phase 1: Emergency Stabilization

Month 1

Phase 2: Architecture Correction

Month 2-3

Phase 3: Operational Cleanup

Month 3-5

Phase 4: Attribution & Trust Rebuild

Month 5-6

Part 10

Success Metrics & Exit Criteria

Note: Exit criteria, definition targets, and owners are pending final review from Cole and Tess.

MetricCurrentMonth 3Month 6
MQL → Opp Conversion6.3%8%10%
Speed to LeadUnknownUnder 2 hoursUnder 5 minutes
AI Handling0%30%70%
Human SDRs442
Regional CoverageUS onlyAll regionsAll (AI primary EMEA/APAC)

Immediate

Month 1-2

Medium-term

Month 3-4

Long-term

Month 5-6

Appendix

Key Stakeholder Quotes

Fact-Check

Evidence Strength

AreaConfidenceNotes
Tech stack inventorystrongMultiple corroborating sources
SFDC critical issuesstrongConfirmed by stakeholders + system audit
HubSpot technical debtstrongDean confirmed, Cody quantified
Q1 targets and mathstrongConfirmed 12/19 call with Nicole
AI SDR vendorstrongUnify approved Jan 20, awaiting signature
Attribution error rate (>50%)mediumStakeholder-reported by Brian; not system-verified
Routing replacementmediumBrian evaluating options — in flux

Document prepared by The Matchbox | Celigo Systems Audit & Diagnostic | January 2026