Search Console tells you what people search, never why. We classify every query — Informational, Commercial, Navigational, Transactional — with an LLM in your own warehouse, then report clicks, impressions, and CTR by intent instead of one row at a time.
A Search Console row is just a phrase with clicks and impressions. It can’t tell you whether the person was learning, comparing options, looking for you by name, or ready to buy — so demand that converts sits in the same list as demand that only researches, weighted identically.
Sort by clicks and the informational queries — the ones with the most volume — dominate the top, while the smaller commercial and transactional searches that actually drive revenue stay buried. Without the why, the report flatters the wrong queries.
Not a manual tagging pass you redo each quarter — an LLM labels every query where your data already lives, so the four intents read as cleanly as the head terms.
Each query Search Console reports is read by an LLM and assigned one of four intents — Informational, Commercial, Navigational, or Transactional — inside your own BigQuery. Phrasing and context decide the label, not a brittle keyword rule.
The intent sits next to the raw clicks, impressions, CTR, and position for every query — past the 1,000-row cap — so each metric carries the intent behind it. The mapping is yours, and fully reviewable.
Performance rolls up by intent across the reporting you already get — which intents earn the impressions, which earn the clicks, and where the CTR gap sits — with no pivoting by hand.
Each period your queries collect into four intents — and the clicks, impressions, and CTR for each tell you which demand is research and which is ready to act.
Example rollup. Your intents are classified by an LLM against your own Search Console queries.
Because the intent lives in your data layer, the split shows up everywhere your numbers do.
A high-impression, low-CTR query looks like a problem until you see it’s people learning, not buying. Reading clicks and CTR by intent tells you which demand is research and which is ready to act.
When commercial or transactional queries land on a page written to inform, CTR sags and the visit bounces. Performance per intent makes the mismatch obvious, so you can point the right page at the right intent.
If commercial and transactional intent is only a thin slice of your queries, the demand that turns into revenue is under-served. Sizing each intent shows where a new page is worth writing.
The LLM’s labels live in your own BigQuery next to the raw metrics — so you can review them, adjust the edge cases, and trust what rolls up. Not a black box inside someone else’s dashboard.
Every solution here runs on the same foundation: the full Search Console API, kept in your own warehouse — far more rows than the interface returns, and history that never expires.
Insightlytics taps into Google Search Console’s API to give you 50× more search data than GSC’s interface — 50,000 rows per query instead of 1,000. Get the complete picture of your site’s search performance, not just the tip of the iceberg.
Say goodbye to Google’s 16-month data limit. Insightlytics keeps an unlimited history of your Search Console data in your own warehouse — so you can identify long-term trends, measure algorithm impacts, and show clients real progress over time. Whether you’re tracking seasonal patterns or proving the value of your work, the historical depth is there when you need it, and crucial data never slips away.
You can tag intent yourself in a spreadsheet — until the row cap, the hours, and the inconsistency catch up. Here’s what changes when an LLM classifies it in your warehouse instead.
Still wondering about something? A discovery call clears it up fast.
Informational (learning something — “how to”, “what is”, guides), Commercial (comparing before deciding — “best”, “review”, “X vs Y”), Navigational (heading for a specific site or brand by name), and Transactional (ready to act — “buy”, “price”, “free trial”, “download”). Every query is sorted into one of the four.
Part of SEO solutions · Built on Google Search Console
All solutionsFree discovery call · No commitment
