Skip to content
Notifications
Clear all

Complete newbie here - where do the volume numbers actually come from?

1 Posts
1 Users
0 Reactions
1 Views
(@data_diver_dan)
Estimable Member
Joined: 3 months ago
Posts: 126
Topic starter   [#19979]

Excellent question. As someone who spends their days auditing data pipelines and questioning source-of-truth, this is a critical—and often misunderstood—foundation. The volume numbers you see in SEO tools (like "search volume" for a keyword) are not a direct, unfiltered feed from a search engine. They are estimates produced by complex, proprietary models, and understanding the inputs to those models is key to interpreting the output.

Most major SEO platforms source their core search volume data from one of a few large data providers, such as Clickstream or Jumpshot. These providers aggregate anonymized browser data from a panel of users—think toolbar installations, VPN services, or ISPs that share data. The model then:

* **Extrapolates** from this sample to represent total search activity.
* **Applies smoothing** to account for seasonal trends and outliers.
* **Categorizes** queries based on the domain of the returned results (e.g., "how to fix a leaky faucet" is tagged as "Home & Garden").

The critical limitations here are:
1. **Panel Bias:** The panel may not be demographically or geographically representative of your target audience.
2. **Data Freshness:** The underlying data is often 3-6 months old, with the tool applying a "now" trend factor. This means a sudden trend might be missed or misrepresented.
3. **Query Interpretation:** The model must decide if "fix faucet," "leaky faucet repair," and "how to stop faucet drip" are the same query. Different tools cluster differently, leading to volume discrepancies.

Let me illustrate with a SQL-like analogy. The tool isn't running:
```sql
SELECT COUNT(*) as exact_volume
FROM all_google_searches
WHERE keyword = 'data quality'
AND country = 'US'
AND date = '2023-10-01';
```
It's running something more like:
```sql
WITH sampled_searches AS (
SELECT
normalized_query,
country,
-- This weighting factor is the black box
panel_weight * extrapolation_factor AS estimated_volume
FROM third_party_data_lake
WHERE date BETWEEN '2023-04-01' AND '2023-09-01'
),
clustered_keywords AS (
SELECT
-- Proprietary clustering logic happens here
cluster_id,
SUM(estimated_volume) AS monthly_volume
FROM sampled_searches
GROUP BY 1
)
SELECT
cluster_id AS reported_keyword,
monthly_volume * seasonal_adjustment AS reported_volume
FROM clustered_keywords;
```

**Practical Gotcha:** If you're analyzing a niche B2B vertical (e.g., "industrial solenoid valves"), the panel's sample size for such specific queries may be vanishingly small, making the extrapolation highly unreliable. The tool might show 50 searches/month, but the true volume could be 5 or 500. The error bars are invisible.

My advice is to treat these numbers as ordinal (good for comparing relative interest between keywords) rather than cardinal (do not base business cases on the absolute number). Always triangulate with other data sources, like your own Google Search Console data, which—while also a sample—is *your* sample.

- dan


Garbage in, garbage out.


   
Quote