A copy-paste Claude prompt that reveals how much pipeline LinkedIn actually sourced — including the 60–80% typically misattributed to organic or direct traffic. Runs on the free Growthspree MCP. No GAQL, no CSV exports, no BI tool.
A VP of Engineering sees your LinkedIn ad on Monday. Three weeks later, she Googles your company name, visits your site directly, books a demo, and closes in July. LinkedIn's 7-day click window expired months ago. Your CRM logs her as "organic search." LinkedIn gets zero credit.
Across 300+ B2B SaaS accounts, 60–80% of LinkedIn's actual revenue contribution is misattributed to other channels. This workflow fixes that. It uses the free Growthspree MCP to match LinkedIn impression data to HubSpot contacts in a 90-day window — surfacing the dark-funnel revenue that LinkedIn's native reporting misses entirely.
The prompt below reads across LinkedIn Ads and HubSpot in a single Claude conversation. No manual exports. No SQL. The first run takes 15 minutes. Every run after that takes under 2.
Paste it as-is. The two variables in gold — account name and date range — are the only things you typically change between runs.
A sample run from a mid-market B2B SaaS account. Real structure, illustrative numbers. The dark-funnel gap is typically the most important number Claude returns.
Running the attribution analysis. I'll query LinkedIn first, then HubSpot, then match.
Matched 3,847 LinkedIn-exposed contacts against 1,204 HubSpot records. Here's the breakdown.
Top 5 campaigns contributing the dark-funnel gap:
First run only. After this, every subsequent run takes under two minutes.
Head to growthspreeofficial.com/mcp. Click install and authorize the OAuth flow. This grants Claude read access to LinkedIn Ads, HubSpot, Google Ads, GA4, and Search Console in one step.
Open Claude Desktop. Click the tools icon in the input bar. You should see growthspree-mcp listed with all five connectors showing green. If LinkedIn Ads or HubSpot show red, re-run the OAuth flow for that specific account.
Copy the prompt from section 02 above. Paste it into Claude. Replace [ACCOUNT_NAME] with your company name. Adjust the 90-day window if your sales cycle runs materially longer or shorter.
Claude returns the four-metric breakdown in 60–90 seconds. Save the output as a markdown file or share directly with your CFO. Re-run monthly to track the dark-funnel trend over time. Typical result: LinkedIn's true revenue is 2–3x what Campaign Manager reports.
Same foundation, different lens. Pick the variation that matches your next question — or chain them together in one Claude session.
Long-cycle deals often break the 90-day window entirely. Expand the match window and add a pipeline-stage filter to surface influence on deals still in-flight.
90 days to 180 days. Add: "Include deals in stages 3+ even if not yet closed-won."
Useful before budget planning. Separate ABM, awareness, retargeting, and lead gen to see which campaign types drive the most dark-funnel revenue.
Skip the manual rewrite. Have Claude produce a plain-English summary in the exact format your CFO reads — pipeline contribution, cost per dollar of pipeline, trend vs last quarter.
Install the free Growthspree MCP, paste the prompt, see your LinkedIn dark-funnel revenue in under 15 minutes. Or have senior GrowthSpree operators implement and run it across your entire stack.