Keyword Research Beyond Google Planner: What Clickstream Data Actually Changes
Planner rounds volumes into buckets. Clickstream data gives you real numbers, real CTR, and zero-click rates. Here's what changes when you combine both.
What we learn from pulling fresh SERP, keyword, and AI visibility data every day.
Planner rounds volumes into buckets. Clickstream data gives you real numbers, real CTR, and zero-click rates. Here's what changes when you combine both.
Position tracking gives you a number. A SERP report maps the entire page — snippets, PAA, ads, local pack — and shows who actually owns it.
People ask AI before they Google. This report counts your brand mentions, maps citations, and tracks volume across AI answer engines.
What belongs inside a client-ready audit, how the pricing tiers work, and why stale data quietly destroys retainer credibility.
For a long time, Google Keyword Planner was the entire keyword research process on most projects I touched. Export, sort by volume, pick the winners, hand over the spreadsheet. Worked fine until a client asked why the keyword they'd been chasing for four months — the one that Planner said had "10K–100K" searches — was getting zero impressions at position #2.
Turned out the keyword had about 1,400 real monthly searches. Bottom end of that range. And roughly 60% of those searches produced a featured snippet that absorbed most of the clicks. Position #2 was invisible. That one conversation made us rethink the entire approach.
Keyword Planner exists to help advertisers buy ads. The search volume data is a side effect — useful, but deliberately vague. Volumes come in ranges. There's no click-through rate. No sense of whether users actually click organic results or just read the answer in the SERP and move on.
Most SEO workflows still treat Planner exports as ground truth, rank by volume, call it research. The problem isn't that the data is wrong — it's that it only shows half the picture.
Clickstream panels track anonymized browsing behavior from large pools of real users. Not what Google estimates people might search — what they actually type, click, and visit. The things that change when you layer this on top of Planner:
We don't throw away Planner data. We layer clickstream on top. Planner gives us the keyword list, CPC estimates, competition scores, seasonal trends — the baseline. Clickstream is the correction layer.
The interesting part is the discrepancies. When Planner says "10K–100K" and clickstream says "14,000 with a 70% zero-click rate," that keyword drops from priority to skip. When Planner says "1K–10K" and clickstream shows "9,200 with 85% organic CTR," you've found a winner that most people would ignore.
Those disagreements between data sources are usually where the best opportunities hide.
A keyword report from LuneBiSEO covers 100 to 500 terms. Each one gets blended volume (unrounded), CPC and competition, keyword difficulty, estimated organic CTR and traffic ceiling, zero-click percentage, SERP feature map, and a search intent tag.
The intent tag matters more than people expect. A keyword with 50K volume and informational intent is a blog post. Same volume with transactional intent is a money page. Treating them the same way in a content plan is common — and shows up when traffic grows but conversions don't.
One data source gives you a keyword list. Two give you a content strategy with traffic ceilings attached.
If you're reselling keyword research to clients, the depth of your data is your credibility. A Planner export with rounded ranges is a commodity. A blended report with zero-click analysis and SERP-aware prioritization is something a client can't replicate with a Google Ads login.
A conversation that happens on nearly every retainer call: "We're #4 for [important keyword], how do we get to #1?" The honest answer almost never involves on-page tweaks or more backlinks. It involves looking at what the rest of the page looks like.
If position #1 is a featured snippet from a DA-90 site, #2 and #3 are review aggregators, and a local pack is pushing everything below the fold — the path from #4 to real visibility isn't about "ranking higher." It's about understanding the board.
A rank tracker gives you keyword + position + change. Useful for monitoring, poor for strategy. A full SERP report maps everything a user sees on page one:
Ranking #3 on a clean SERP with no ads is a different animal from ranking #3 on a SERP with four ads, a snippet, and a video carousel sitting above you.
The part that changes client conversations: for each keyword, we lay your position next to your primary competitor's. Not just "they're #2, you're #7." We map which SERP features each of you own.
You see that they own the featured snippet for your most valuable commercial query. Or that they appear in PAA answers for 12 out of 20 target keywords while you show up in none. Or that neither of you ranks for a cluster — gap for both.
When a client sees this, the conversation shifts from "rank higher" to "here's where they're winning and here's the specific content that would take those positions." Immediate action items, not vague targets.
We assign each keyword a visibility score that accounts for position (with diminishing returns after #3), SERP feature ownership, ad density above organic, and above-the-fold presence. Rolled up, you get a single SERP Visibility Index — not "we rank for X terms" but "we own Y% of visible SERP real estate." That goes on page one of every report.
White-label-ready PDF with five sections: executive summary (score, top wins, biggest gaps), SERP landscape table (keyword-by-keyword with feature ownership), feature breakdown (snippets, PAA, local), competitor comparison (side-by-side visibility), and an opportunity matrix ranked by impact vs. effort.
A rank tracker tells you a number. A SERP report shows you who owns the page.
If your client's keywords have busy SERPs — ads, snippets, carousels — a rank report misses most of the picture. The SERP report fills it in. It also tends to justify scope expansion: once a client sees that their competitor owns 15 featured snippets they don't, the content budget conversation gets easier.
Something shifted over the past year and a half. A real chunk of product research — the "which one should I pick" searches — moved from Google to AI. People ask ChatGPT to compare CRM tools. They ask Perplexity to recommend hosting providers. They skim Google AI Overviews before scrolling to organic results.
For most businesses, the answer to "does your brand show up when someone asks AI about your category?" is "we have no idea." We built a report that replaces the guessing with numbers.
We run your target keywords — the same set you'd track in Google — through ChatGPT, Perplexity, and Google AI Overviews. For each query, we check whether your brand name appears in the response text. Not as a link. Not as a footnote. As an actual recommendation or reference.
If someone asks "best project management tool for remote teams" and the AI lists six tools and yours isn't there, that's a visibility gap. Backlinks and keyword optimization can't directly fix it. Your content structure, entity clarity, and how the broader web discusses your brand — that's what drives AI inclusion.
We run 20 to 50 queries per report and benchmark you against your top competitors. The output is specific: you're mentioned in 6 out of 30 relevant queries. Competitor A shows up in 18. Competitor B in 14.
When an AI mentions your brand, where does it pull information from? This tells you whether you control your own narrative or someone else does.
Citation analysis shows whether your content strategy feeds AI models or whether your AI narrative is written by other people.
Where historical data exists, we track mention frequency over 30, 60, 90 days. Published a comparison guide last month? If AI mentions went up, it worked. If not, the content isn't structured in a way LLMs pick up.
Trend data also catches competitor moves. If a competitor's AI visibility spiked in the last 30 days, something changed — new content, new PR, a restructured product page. Better to know before your next content cycle than after.
AI visibility doesn't correlate neatly with Google rankings. We've seen brands ranking #1 in Google that don't appear in ChatGPT's answer for the same query. And brands with average Google positions but strong AI presence because their content is structured the way LLMs prefer — clear entity definitions, unambiguous descriptions, comparison-friendly formats.
Different surfaces, different ranking factors, different optimization. That's why it's a standalone product.
If you're not tracking your brand in AI answers, you're ignoring where a growing share of your audience forms their first impression.
A pattern I keep seeing in conversations with agency owners: they charge $1,500/month for SEO. They spend 6 hours pulling data from three different tools, formatting a PDF, writing commentary, sending it off. The client glances at it for 90 seconds on a call.
The economics are backwards. Reporting — which should be the cheapest part — eats the most labor. Strategy — which is what the client actually pays for — gets whatever time is left.
You purchase a report built on live data for $67 to $99. You deliver it under your brand as part of a retainer that runs $300 to $1,500 depending on scope. The report takes 20 minutes to review and annotate instead of 6 hours to build.
Your effective rate shifts from $50/hour building reports to $300+/hour reviewing and adding strategic notes. The leverage isn't in the report — it's in the five hours you didn't spend creating it. Those hours go to strategy, client calls, implementation, upselling.
A white-label SEO report is not a data dump. Clients don't want 47 spreadsheet tabs. They want to understand three things:
Every section maps to one of those questions. If a chart doesn't serve any of them, cut it. Clients feel padding even when they can't name what's wrong. A 12-page report that clearly answers those questions is worth more than a 50-page deck that buries them.
Commentary matters more than data. Raw numbers are free. The interpretation — "this means you're losing ground on commercial keywords because a competitor published three comparison guides last month, and here's how to respond" — is what the retainer buys.
Fastest way to lose trust: deliver a report with outdated numbers. If your report says the client ranks #3 for their main keyword and they check Google and see #7, everything in that document is now suspect. Not just that data point — all of it.
This happens more often than anyone admits. Most white-label providers pull from cached databases. The ranking in the report might be a week old. Accurate when scraped — stale by the time the client reads it.
We pull data at the time of each order. The numbers in the PDF match what the client sees in Google the day they receive it. Sounds small, but it's the foundation of month-over-month trust.
The model scales because the input is standardized: domain, competitors, country, keyword focus. Adding a client means filling out a form and placing an order. Report production is handled. Your job is interpretation and delivery.
Ten clients on a monthly bundle costs roughly $4K/month. Revenue at $1,000/client average is $10K/month. That's 60% gross margin on reporting alone — before strategy, implementation, and add-ons.
Agencies that scale aren't the ones that build everything in-house. They're the ones that know what to build and what to buy.