Organic Traffic
Organic Traffic: Visitors from unpaid search.
Formula
Organic Traffic = Visitors where source = organic search Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
sum(field.unique_visitors where field.traffic_source = 'organic_search') Unit: count
Data requirements
Grain: Daily aggregate · Frequency: Daily · Aggregation: aggregate (day) · Staged: no · Main source: Web Analytics.
| Field | Dataset | Type |
|---|---|---|
period_start | web_traffic | date |
traffic_source | web_traffic | string |
unique_visitors | web_traffic | integer |
Example SQL (Postgres)
SELECT (SELECT COALESCE(SUM(unique_visitors), 0) FROM web_traffic WHERE period_start >= :period_start AND period_start <= :period_end AND traffic_source = 'organic_search') AS organic_traffic From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Organic Traffic" }) or generate_query({ "metric": "Organic Traffic", "adapter": "<your adapter JSON>" }).
What It Tells You
SEO effectiveness and brand awareness.