How to Map 6sense Keyword Research to Your Full Buyer Journey

George Samaras

Hi everyone, this is my first post on RevCity, so go easy on me. I lead marketing operations at Ataccama, and I wanted to share something my team has been experimenting with, purely from a knowledge-sharing perspective. I would love to hear how others in this community are approaching the same questions.

You're already tracking which keywords your target accounts research. But have you ever mapped that research to where those accounts actually sit in your pipeline, including the 12 months before the deal even exists? We did. Here's how, step by step, and what it revealed.

Why bother?

Most of us use 6sense keyword data for intent signals and segment activation. That's table stakes. But keyword data has a timestamp, and your CRM has stage transition dates. Join those two together, extend the lookback to capture pre-opportunity research, and you get a continuous map of what buyers research from 12 months before the deal opens through close: how research accelerates toward deal creation, where competitive pressure peaks, and what buyers keep researching after they sign.

We ran this across all of our Closed Won new logo deals: nearly 180,000 keyword searches across 100+ unique keywords, with over 42,000 in the pre-opportunity window alone.

Step 1: Pull your keyword data from 6sense

You need account-level keyword research with three fields: account/opportunity identifier, keyword, and date. Heads-up: this level of fidelity isn't available out of the box in the 6sense UI. Ask your 6sense CS team for the export, and if your instance is connected to your CRM, ask them to include the Opportunity ID. It makes the join in Step 3 much easier.

Step 2: Pull your opportunity report from Salesforce

Export Closed Won deals with stage transition dates (Stage Date: Qualify, Build Value, Negotiate, and so on), not just the current stage. The fields that matter: Opportunity ID and every stage-date column your pipeline tracks.

Step 3: Join on Opportunity ID and assign the full journey

Merge the two datasets on Opportunity ID. For searches that happened before the deal existed, assign them to time buckets relative to the Qualify date (we used 12-9, 9-6, 6-3, and 3-0 months before Qualify). For searches after Qualify, assign each to the latest stage whose date it falls on or after. Cap the lookback at 12 months to cut noise, and if a deal skips a stage, skip it too.

Step 4: See the full journey in one view

You now have a single continuous view, 11 columns spanning the whole journey. The pre-opportunity window was about a quarter of all volume, and velocity nearly doubled in the final 3 months before deal creation. The mid-pipeline evaluation stage was the largest by volume, but post-close was second. Buyers don't stop researching when they sign

Pre-Opportunity Research Acceleration: 12-Month Lookback

Step 5: Categorize your keywords

Group keywords into categories (capabilities, competitor/vendor, compliance, integration, and so on) and build a heatmap of categories by stage. Platform and cloud terms dominated everywhere; security and compliance surged pre-opp and stayed elevated through close; competitor names spiked in the final pre-opp quarter and again at Negotiate.

Category Intensity Across the Full Buyer Journey

Step 6: Isolate branded keywords

Flag every vendor or competitor name and rerun the analysis on just that subset. Branded terms were a small share of volume but told a different timing story: comparison starts late in the pre-opp window, direct competitors had low raw volume but dominated the late pipeline, and nearly half of branded research surfaced post-close.

Step 7: Look at the surge keywords

Find which keywords ramp the most between 12-9 months out and the final quarter before Qualify. A security term surged 11x, a deduplication term 9x, a legacy vendor 7.5x. These aren't the highest-volume keywords; they're the fastest-accelerating, which makes them a strong early-warning signal for your segments.

Keyword Surge: What Accelerates Before Deals Open

Step 8: Act on it

The full-journey view changed what we do:

• Research sprints in the final 3 months before a deal opens (over 40% of pre-opp volume). We treat that acceleration, especially around security and competitor terms, as a trigger to activate outbound.
• Pre-opp research is problem-first, not vendor-first. We shifted top-of-funnel content toward problem definition and away from product messaging.
• The busiest research stage (mid-pipeline) is throughput, not decision. We make sure earlier and later-stage content is deep enough to survive it, rather than building stage-specific content.
• Competitor research starts late pre-opp and ends at Negotiate. We surface battlecards proactively at Negotiate, prioritized by where each competitor's research lands.
• A large share of keywords end at Closed Won. We treat post-close themes as expansion signal for customer marketing and onboarding.
• Security is the persistent through-line. Security messaging is now always-on across content and campaigns, not seasonal.

What you need

The whole recipe: 6sense keyword data with timestamps, a CRM opportunity report with stage dates for Closed Won deals, a join on Opportunity ID, a 12-month lookback sliced into quarterly pre-opp buckets, standard stage assignment in-pipeline, and keyword categorization. If you run 6sense alongside a CRM with stage history, you have everything you need. The 12-month lookback is what turns a basic keyword-by-stage chart into a full buyer journey map.

What's next for us

We're extending this to Closed Lost deals. If keyword patterns diverge between Won and Lost, that becomes a predictive signal. We're also looking at layering in page-level engagement data, to go from what keywords buyers research to what content they actually consume at each stage. If you've run something similar, I'd love to compare notes.

Jana_Marketing_Maven

This is amazing and clearly a lot of work went into it. I don't know that we have the data capabilities to do this but I like the ideas behind it and it has definitely given me some food for thought.