The Keywords table aggregates performance data on paid-search keywords, including spend, impressions, clicks, and conversions, along with keyword attributes such as match type, quality score, and status. By querying this table, users can evaluate the effectiveness of their search advertising keywords, optimize bidding strategies, and improve campaign targeting to maximize return on ad spend.

📘
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 keyword triggered an ad. Based on the time zone of the shop at the moment of publishing.
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`.
Ad Account ID	`account_id`	string	The unique ID for the ad account associated with the ad. Assigned by the ad platform. Example values: `act_2168791943307744`, `18ce55770zl`, `1986494684391480`
Ad Account Name	`account_name`	string	The name of the advertiser’s account as defined in the ad platform. Example values: `Example Shop`, `example_shop`, `ES - International`
Ad Set ID	`adset_id`	string	The unique ID for the ad set associated with the ad click. Assigned by the ad platform. Example value: `120210439890740003`
Ad Set Name	`adset_name`	string	The name of the ad set within a campaign. Example values: `Broad Audience`, `Bracelets`, `Wellness`
Campaign ID	`campaign_id`	string	The unique ID for the marketing campaign associated with the ad. Assigned by the ad platform. Example values: `23852438666180053`, `531011533`, `20620285829`
Campaign Name	`campaign_name`	string	The name of the marketing campaign associated with the ad. Example values: `Catalog Retargeting`, `US Generic Search`, `Breakfast of Champions Campaign`
Channel	`channel`	string	The platform through which the ad was delivered. Example value: `google-ads`
Currency	`currency`	string	The currency used in the ad platform. Example values: `USD`, `GBP`, `EUR`
Keyword ID	`keyword_id`	string	The unique ID assigned to the keyword by the ad platform. Example values: `40127221`, `196746895709`
Keyword Status	`keyword_status`	string	The status of the keyword. Example values: `ENABLED`, `PAUSED`, `REMOVED`
Keyword Text	`keyword_text`	string	The text of the keyword as entered in the ad platform. Example values: `running shoes`, `cheap flights`, `best coffee`
Match Type	`match_type`	string	How closely a user’s search query must match the keyword in order to trigger an ad. Example values: `EXACT`, `PHRASE`, `BROAD`
System Serving Status	`system_serving_status`	string	Indicates whether the keyword is currently eligible to serve ads. Example values: `ELIGIBLE`, `RARELY_SERVED`

Measures

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

Title	ID	Type	Description
All Conversion Value	`all_conversion_value`	numeric	Revenue generated from channel-reported conversions of all types (e.g. purchases, registrations, add-to-carts).
All Conversions	`all_conversions`	numeric	The total number of channel-reported conversions of all types (e.g. purchases, registrations, add-to-carts).
Clicks	`clicks`	numeric	Number of channel-reported clicks.
Channel-Reported Conversion Value	`conversion_value`	numeric	Revenue generated from channel-reported conversions (purchases).
CPC Bid	`cpc_bid`	numeric	The bid amount set for the keyword (cost-per-click). By default shown in the shop's currency.
Effective CPC Bid	`effective_cpc_bid`	numeric	The effective CPC bid after platform bid adjustments are applied. By default shown in the shop's currency.
Impressions	`impressions`	numeric	Number of channel-reported impressions.
Quality Score	`quality_score`	numeric	The quality score assigned to the keyword by the ad platform (0 – 10, higher is better).
Search Absolute Top Impression Share	`search_absolute_top_impression_share`	numeric	The percentage of search impressions that were shown to users in the absolute top position.
Search Budget Lost Absolute Top Impression Share	`search_budget_lost_absolute_top_impression_share`	numeric	The percentage of search impressions that were shown to users in the absolute top position, but not clicked.
Search Budget Lost Top Impression Share	`search_budget_lost_top_impression_share`	numeric	The percentage of search impressions that were shown to users in the top position, but not clicked.
Search Impression Share	`search_impression_share`	numeric	The percentage of search impressions that were shown to users.
Search Rank Lost Impression Share	`search_rank_lost_impression_share`	numeric	The percentage of search impressions that were shown to users in the top position, but not clicked.
Search Rank Lost Top Impression Share	`search_rank_lost_top_impression_share`	numeric	The percentage of search impressions that were shown to users in the top position, but not clicked.
Search Top Impression Share	`search_top_impression_share`	numeric	The percentage of search impressions that were shown to users in the top position.
Ad Spend	`spend`	numeric	Channel-reported ad spend, excluding any custom expenses marked as ad spend.

Keywords Table

📘
Note

Dimensions

Measures

📘Note

Dimensions

Measures

📘
Note