A copy-paste Claude prompt that connects Google Ads, LinkedIn, HubSpot, GA4, and GSC into one unified monthly health scorecard. Surfaces month-over-month deltas across pipeline metrics, channel mix, signal quality, and AEO visibility — with the top 3 regressions, top 3 wins, and the single highest-leverage next action. Twenty-five minutes once a month replaces three hours of dashboard switching.
"How is pipeline this month?" The answer requires Google Ads (cost per SQL by campaign), LinkedIn Ads (matched-audience reach + influenced pipeline), HubSpot (lifecycle conversion rates + closed-won), GA4 (channel mix + AI referral traffic), and Search Console (branded search trend + AEO visibility). Five tabs. Three hours of cross-referencing. By the time the answer is assembled, half the leadership meeting has passed.
The deeper problem isn't the time — it's that cross-platform patterns are invisible inside any single dashboard. Cost per SQL on Google Ads spiked. LinkedIn-influenced pipeline dropped 22%. Branded search lift slowed. Are these unrelated, or is there one upstream cause? You can't see it from inside any single tool. The diagnostic happens in the head of whoever has spent the last 3 hours looking at all five.
This workflow runs the diagnostic for you. Once a month, on the 1st. Claude pulls data across all five connectors in parallel, computes month-over-month deltas, flags each of 5 health rows as HEALTHY / WATCH / DEGRADING, surfaces the top 3 regressions and top 3 wins, and identifies the single highest-leverage next action. The output is what a senior CMO would write at the top of the monthly business review — not a status report, a decision brief.
The gold variables — your brand, target ACV, monthly SQL goal, and prior-month context — are the parts you edit. Save the prompt as a markdown file you reuse on the 1st of every month.
google_ads, linkedin_ads, hubspot, ga4, and search_console via the free Growthspree MCP. Partial setups produce a partial scorecard — Claude flags which rows are degraded by missing connectors. Most B2B SaaS teams running ads at $5K+/month have 4 of the 5 already.Sample output for a hypothetical mid-market B2B SaaS account targeting $400K monthly pipeline. Three rows healthy, one watch, one degrading. The pattern below — channel mix degrading because of one specific failure point — is the most common monthly diagnostic.
Running the monthly health check across all 5 connectors now.
Health verdict: MIXED — pipeline volume is on track but channel mix is degrading. The single most important sentence: LinkedIn cost per SQL spiked 41% MoM because the matched-audience refresh stalled, and three planned audience updates didn't ship.
11.2 months. Pipeline volume is on plan — no concern.$1,420, +3% MoM). LinkedIn CPL spiked 41% from $2,480 to $3,500. Organic SQLs +14% MoM. The LinkedIn jump is the dominant signal — overall blended CPL up 18% despite Google and organic improving.8 days (vs 7). Marginal slowdown but inside noise.The cadence is the point. Block 25 minutes on the 1st of every month as a recurring calendar event — owned by the CMO or RevOps lead.
Head to growthspreeofficial.com/mcp. Authorize Google Ads, LinkedIn Ads, HubSpot, GA4, and Google Search Console through the OAuth flow. All read-only. The 8-minute setup is one-time — every subsequent month's run takes 25 minutes total.
Calendar block: "Pipeline Health Check" on the 1st at 9 AM. Recurring. Whoever owns blended pipeline performance is the runner — typically the CMO at Series B+, head of marketing at Series A, founder/CEO at seed. The discipline of the cadence matters more than the runner's title — monthly noise overwhelms quarterly signal in B2B SaaS.
Copy the prompt from section 02. Edit the gold variables — your brand, target ACV, monthly SQL goal, monthly pipeline target, average sales cycle, and last month's known issues. Save as health_check_template.md. Reuse every month with only the "last month's known issues" field updated based on prior month's output.
Claude returns the scorecard in 90-120 seconds. Read the headline and priority action first — that's usually the only part that drives a decision. The rest of the scorecard is reference. Queue the recommended workflow into the appropriate owner's calendar before closing the file. The most common failure mode is reading the scorecard but not queuing the action — which converts the workflow from a decision tool into a status report.
Same 5-row foundation, different audience or scope. Pick the one that matches your reporting context.
Reframes the output for board consumption — quarterly view rolled up from 3 monthly health checks, with year-over-year context, narrative around channel investments, and a forward-looking next-quarter focus. Same data foundation, different writing register.
Tighter scope — runs weekly instead of monthly, focused on Rows 03 (funnel velocity) and 04 (signal quality) which are the rows where weekly cadence is meaningful. Skips Pipeline volume and AEO rows which need monthly windows.
Used at the start of each quarter to set a clean baseline. Same 5 rows but compared against quarter-start (instead of prior month) for the next 3 monthly runs. Surfaces drift across an entire quarter rather than just the most recent month.
Install the free Growthspree MCP, authorize the five connectors, save the prompt as a markdown template, and block 25 minutes on the 1st as a recurring calendar event. The monthly cadence is what compounds — single runs are useful, recurring runs are transformational. Or have senior GrowthSpree operators run the monthly health check across your stack and orchestrate every priority action — the same operating system used across 300+ B2B SaaS accounts.