I can do this in two layers: 1. **Right now:** I’ll give you a **comprehensive AI-ready strategic insight report (framework + analysis logic + tables)** you can paste into a doc and fill automatically once data is provided. 2. **Once you upload your exports here:** I’ll **populate this report with your actual findings** (no guesswork). Below is the report structure **built specifically for Google Analytics + CRM exports** and optimized for **B2B SaaS customer acquisition efficiency**. --- ## 0) Data Inputs Required (So the report is evidence-based) ### Google Analytics export (GA4 recommended) Minimum fields (daily or weekly grain): * Date * Source / Medium * Default channel group * Campaign (UTM campaign) * Landing page (or page path + query) * Sessions / Users * Engaged sessions + Engagement rate * Key events (your conversion events) * Conversion count (trial, demo request, lead form, signup—whatever you use) * Revenue (if tracked) or proxy value event ### CRM export (leads + lifecycle) Minimum fields: * Lead/Account ID * Created date * Lead source / UTM fields (utm_source, utm_medium, utm_campaign, utm_content, utm_term) * Stage timestamps (Lead → MQL → SQL → Opp → Closed Won/Lost) * Deal amount (ARR/MRR/TCV) if applicable * Owner (optional) * Industry / company size / persona (if available) * Outcome reasons (lost reason, disqual reason) **Critical join key:** UTM + timestamp alignment OR a shared ID (best). If you don’t have a join key, we can still do a “probabilistic alignment” by date + channel + campaign—but we’ll label it as a limitation. --- ## Executive Summary (Objective Alignment) **Objective:** Improve **Customer Acquisition Efficiency** for B2B SaaS by identifying where cost, time, and effort produce the highest-quality pipeline and closed revenue—then eliminating leakage and reallocating resources. ### What “Acquisition Efficiency” will be measured as (choose what you have) * **Primary efficiency metric (recommended):** **CAC (blended) = Total acquisition spend / # New customers** * **Pipeline efficiency (if spend or CAC not available):** **Cost per SQL**, **Cost per Opp**, **Cost per Closed Won** * **Funnel efficiency (if spend not available):** **Sessions → Lead → MQL → SQL → Opp → Won conversion rates** + **cycle time** + **win rate** * **Revenue efficiency (ideal):** **LTV:CAC**, **CAC payback months**, **ARR per lead**, **ARR per SQL** ### Executive conclusions (to be populated from your data) * **Where efficiency is highest:** [Channel/Campaign/Segment] driving [SQL/Won] at [lowest cost or highest yield]. * **Where leakage is highest:** [Funnel stage] for [Segment/Channel], implying [quality/fit/messaging/sales handoff] issue. * **What to do first:** [Top 3 moves] likely to improve efficiency with lowest operational risk. --- ## Core Data Patterns ### 1) Acquisition Funnel Shape (GA → CRM) Populate this table: | Stage | Volume | Conv. Rate from prior | Median Time-in-Stage | Notes | | ------------- | -----: | --------------------: | -------------------: | ----- | | Sessions (GA) | | | | | | Leads (CRM) | | | | | | MQL | | | | | | SQL | | | | | | Opp | | | | | | Closed Won | | | | | **Pattern flags to detect** * **Top-heavy traffic, weak lead conversion:** landing pages, intent mismatch, form friction. * **Strong leads, weak MQL/SQL:** targeting/ICP mismatch, lead scoring, unclear qualification, nurture gaps. * **SQL but low Opp/Win:** sales process, pricing, competition, product gaps, slow follow-up. * **Long cycle time spikes:** segment complexity, security review, procurement, poor enablement. --- ### 2) Channel & Campaign Efficiency (Quality-weighted, not volume-weighted) Create a “quality ladder” score per channel: **Quality ladder (example weighting):** * Lead = 1 * MQL = 3 * SQL = 8 * Opp = 15 * Won = 40 Then rank: | Source/Medium | Sessions | Leads | SQL | Won | Quality Score | SQL Rate | Win Rate | Notes | | ------------- | -------: | ----: | --: | --: | ------------: | -------: | -------: | ----- | | | | | | | | | | | **Strategic interpretation rules** * High sessions + low SQL = awareness channel (good for retargeting/nurture, not direct ROI). * Low volume + high win rate = “quiet winner” worth scaling carefully. * High lead volume + low SQL = lead quality problem or wrong offer. --- ### 3) Landing Page Contribution (intent alignment) Rank landing pages by **SQL/Won per 1,000 sessions** (or per 100 leads). | Landing Page | Sessions | Leads | SQL | Won | SQL/1k Sessions | Key Hypothesis | | ------------ | -------: | ----: | --: | --: | --------------: | -------------- | | | | | | | | | **What this reveals** * Underleveraged pages with strong downstream conversion → scale traffic + replicate message. * High traffic pages with weak downstream → reposition CTA, tighten ICP framing, improve proof. --- ### 4) Time-Series Trend Signals (efficiency drift) Track weekly/monthly: * Lead → SQL rate trend * SQL → Won trend * Median cycle time trend * Segment mix shift (ICP vs non-ICP) * Channel mix shift (paid vs organic vs referral) **Interpretation** * Efficiency dropping while volume rises = you’re buying growth at the expense of quality. * Efficiency rising with flat volume = scaling constraint (distribution, budget ceiling, narrow ICP reach). --- ## Audience / Segment Insights ### Segment axes to use (depending on what exists) * **Firmographics:** industry, company size, region * **Persona:** founder, marketing lead, sales leader, ops, compliance, etc. * **Intent proxy:** visited pricing, demo page, integration docs, comparison pages * **Acquisition origin:** paid search, outbound, partner, organic, community * **Use case / product tier** (if captured in forms) ### Segment scorecard (populate) | Segment | Leads | SQL | Won | Win Rate | Cycle Time | ARR per SQL | Primary Bottleneck | | ------- | ----: | --: | --: | -------: | ---------: | ----------: | ------------------ | | | | | | | | | | **Strategic insight to extract** * Your “efficiency ICP” is **not** the biggest segment—it’s the segment with: **high SQL rate + high win rate + short cycle time + strong ARR per opp**. --- ## Strategic Implications ### 1) Where efficiency is being won (or lost) Classify each channel/segment into one of these buckets: * **Scale Winners:** high quality score + stable win rate + acceptable cycle time * **Fix Before Scaling:** high volume but poor down-funnel (leakage) * **Harvest Only:** low effort maintenance, steady small wins * **Stop / Constrain:** consumes resources but yields low SQL/Won ### 2) Causal indicators (treated carefully) We will **not claim causality** without experiments, but we *can* identify: * **Leading indicators:** pricing page visits, demo page depth, repeat visits, high-intent event completion * **Lagging indicators:** SQLs, opps, wins, ARR If leading indicators rise but SQLs don’t: attribution or routing/scoring issue. If SQLs rise but wins don’t: sales readiness/pricing/competition mismatch. --- ## Opportunity Matrix (Impact vs Effort) Use this to prioritize actions: ### High Impact / Low Effort (quick wins) * Reallocate budget from low-quality channels to “quiet winners” * Improve lead routing speed (time-to-first-touch) * Tighten landing page to ICP message + proof + CTA clarity * Fix UTM hygiene & attribution mapping (big insight unlock) ### High Impact / High Effort (strategic bets) * Build/scale partner channel * Create ICP-specific offers and landing pages * Revamp lead scoring + lifecycle automation * Implement multi-touch attribution or MMM-lite ### Low Impact / Low Effort (maintenance) * Basic CRO hygiene * Weekly performance dashboarding ### Low Impact / High Effort (avoid) * Broad awareness expansions with no evidence of downstream quality * Complex automation without clean data foundations (Once data is in, I’ll fill this matrix with your exact opportunities.) --- ## Risk Signals & Constraints ### Common risk signals to scan in your exports * **Attribution decay:** “Direct / none” rising, UTMs missing → you can’t trust channel ROI * **Lead quality dilution:** leads up, SQL flat/down * **Sales capacity constraint:** SQL up, opp/wins flat, cycle time increases * **Segment drift:** more non-ICP traffic/leads from broad campaigns * **Single-channel dependency:** one source drives most pipeline (fragility risk) --- ## Assumptions & Data Gaps (explicitly stated) We will tag each insight as: * **High confidence:** directly measured in dataset * **Medium confidence:** strong pattern but partial fields * **Low confidence:** inferred, needs validation Common gaps to call out if present: * Missing spend data → cannot compute CAC * No consistent UTMs → channel conclusions limited * No stage timestamps → cannot compute cycle time bottlenecks * No lost reasons → cannot diagnose win-rate drag --- ## Recommended Action Roadmap ### Short-term (7–14 days): “Stop leakage + unlock visibility” 1. **Attribution & tracking cleanup** * Enforce UTMs, normalize naming, map GA events to CRM stages 2. **Quality-weighted channel ranking** * Shift attention from CPL to **Cost per SQL / Opp / Won** 3. **Speed-to-lead** * Reduce time-to-first-touch; monitor impact on SQL rate **Success metrics:** SQL rate, time-to-first-touch, MQL→SQL conversion, pipeline per channel. --- ### Mid-term (15–45 days): “Improve conversion per unit effort” 1. **ICP segmentation** * Identify top 1–2 segments by efficiency; tailor landing pages/offers 2. **Landing page optimization** * Prioritize pages with high intent but low form completion 3. **Lead scoring + routing** * Align scoring with observed win patterns (not gut feel) **Success metrics:** Win rate, cycle time, opp creation rate, ARR per SQL. --- ### Long-term (46–120 days): “Build compounding acquisition systems” 1. **Scale what produces revenue, not traffic** * Expand the top-performing segment/channel combinations 2. **Durable channel creation** * Partner, ecosystem, SEO around high-intent use cases 3. **Experimentation system** * Run structured tests (offer, audience, page, sales motion) with clean measurement **Success metrics:** CAC payback, LTV:CAC, pipeline efficiency, revenue per channel mix. --- # Next step (so I can generate the *actual* report from your exports) Upload either: * A CSV export from GA4 + a CSV export from your CRM (HubSpot/Salesforce/Pipedrive/etc.), **or** * One combined spreadsheet And I’ll return this same report fully populated with: * your top/bottom channels by efficiency * your biggest funnel bottleneck with evidence * your highest-leverage segment(s) * a ranked opportunity matrix with quantified upside where possible If you want, include your **monthly acquisition spend** (even rough by channel). That’s what turns “efficiency” into true CAC decisions.