Search Terms

search_terms_table

The Search Terms table provides performance data for organic search queries, including impressions, clicks, and search result position. By querying this table, users can analyze how users discover their site through search engines, identify high-performing search queries, and refine SEO strategies to improve visibility and traffic.

📘

Note

event_date is a required field for queries on this table.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title

ID

Type

Description

Event Date

event_date

date

The date the search query occurred, in Pacific Time Zone (PT).

Event Day

event_date.day

date

The day on which the event occurred. Derived from event_date.

Event Week

event_date.week

date

The Sunday of the week during which the event occurred. Derived from event_date.

Event Month

event_date.month

date

The month during which the event occurred. Derived from event_date.

Event Quarter

event_date.quarter

date

The first month of the quarter during which the event occurred. Derived from event_date.

Event Year

event_date.year

date

The year during which the event occurred. Derived from event_date.

Account ID

account_id

string

The unique ID of the connected search source, such as a verified domain in Search Console.

Example value: sc-domain:myshop.com

Channel

channel

string

The platform where the search query occurred.

Example value:google

Search Query

query

string

The exact search term entered by the user that surfaced the site’s content in search results.

Example values: nike running shoes, best camping gear

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

TitleIDTypeDescription
ClicksclicksnumericNumber of times users clicked on the site in the search results.
ImpressionsimpressionsnumericNumber of times the site appeared in search results for a query.
PositionpositionnumericThe average position where the site appeared in search results for the query.