A copy-paste prompt that reconstructs every touchpoint a contact had before converting — impression → click → anonymous visit → form → contact → MQL → SQL → opportunity → closed-won. Reads across Google Ads, LinkedIn Ads, and HubSpot in a single conversation through the free Growthspree MCP.
HubSpot logs the deal as "Paid Search." But that contact saw 14 LinkedIn Sponsored Content impressions over 60 days, read three blog posts, watched a webinar, then finally Googled your brand name and clicked a paid search ad. Google gets the credit. LinkedIn, content, and webinar marketing get nothing.
The fix is simple in concept: reconstruct the full journey using data from every touchpoint system. In practice, it has meant 4–6 hours per deal of CSV exports, pivot tables, and guesswork. Most teams stopped trying years ago.
This workflow makes that reconstruction a 90-second Claude query. One prompt reads across Google Ads, LinkedIn Ads, and HubSpot in parallel, matches touchpoints by contact ID, cookie, and click ID, and returns the complete journey — plus five attribution models side-by-side so you can see where the models disagree. The disagreement is where your budget decisions sit.
Change the gold variables based on what you want to analyze — a single deal ID, a cohort, or a blanket 90-day view. Everything else stays as-is.
Sample single-deal output from a mid-market B2B SaaS account. Real structure, illustrative numbers. Notice how different attribution models tell different stories for the same deal.
Pulling touchpoints from all three platforms. Running in parallel.
Reconstructing journey for Deal #47829 — Acme Corp · $42,000 · Closed-Won. Contact: VP RevOps. 6 touchpoints across 67 days.
Attribution models side-by-side:
First-time setup only. Every subsequent run takes 3–5 minutes because Claude runs the three platform queries in parallel.
Head to growthspreeofficial.com/mcp. Click install and authorize the OAuth flow. One flow grants Claude read access to Google Ads, LinkedIn Ads, and HubSpot — the three you need for this workflow.
Open Claude Desktop. Click the tools icon. You should see growthspree-mcp with google_ads, linkedin_ads, and hubspot all showing green. If any of the three shows red, re-run the OAuth flow for that specific platform.
Copy the prompt from section 02. Replace [ACCOUNT_NAME]. Choose your scope: a single deal ID for one story, a cohort for a pattern, or all_closed_won_last_90_days for a full view. Extend the window to 180 days if your sales cycle runs enterprise.
Claude returns the chronological journey, the 5-model attribution comparison, and one concrete budget recommendation in 90–120 seconds. Save the output as markdown for your next CFO conversation. Re-run monthly to track how the journey pattern evolves — the first-touch-to-close lag is the best forward indicator of sales cycle health.
Same underlying prompt, different angle. Useful for win stories, loss post-mortems, and segment-level strategy.
Pipe the same prompt against closed-lost deals. Surface the channel mix that's bringing in deals that won't close — usually a sign the ICP filter or messaging is off somewhere in the journey.
all_closed_lost_last_90_days. Add: "Compare channel mix of closed-lost deals vs closed-won. Flag overrepresented channels."
For each closed-won deal, have Claude write a narrative paragraph — useful for sales all-hands, QBR decks, or case study raw material. Turns a data dump into a story.
Different ICP segments have radically different journey shapes. Enterprise buyers take 8 touchpoints. Mid-market takes 4. SMB takes 2. Have Claude cohort the analysis by segment.
Install the free Growthspree MCP, paste the prompt, reconstruct a deal journey in under 20 minutes. Or have senior GrowthSpree operators implement and run it monthly as part of your RevOps cadence.