Google Ads Keyword Planner fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Google Ads Keyword Planner data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

Early Access5 metrics27 dimensions

ACCOUNT

account_name
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_level
Field label Account level
Description The level of the account
Field type dimension
Data type string.text.value
account_timezone
Field label Account timezone
Description The timezone of the account
Field type dimension
Data type string.time.timezone
account_currency_code
Field label Account currency code
Description The currency code of the account
Field type dimension
Data type string.currency.code

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

KEYWORD

keyword
Field label Keyword
Description Keyword name
Field type dimension
Data type string.text.value
competition
Field label Competition
Description Competition shows how competitive ad placement is for a keyword, specific to the location and Search Network targeting options that you've selected. If we don't have enough data, you'll see a dash (-)
Field type dimension
Data type string.text.value
competition_index
Field label Competition index
Description The competition index for the keyword in the range [0, 100]. Shows how competitive ad placement is for a keyword. The level of competition from 0-100 is determined by the number of ad slots filled divided by the total number of ad slots available. If not enough data is available, null is returned
Field type dimension
Data type string.text.value
keyword_close_variants
Field label Keyword close variants
Description The list of close variants from the requested keywords
Field type dimension
Data type string.text.value
keyword_country
Field label Keyword country
Description Country of the keyword
Field type dimension
Data type string.geo.country
keyword_language
Field label Keyword language
Description Language of the keyword
Field type dimension
Data type string.language.value

MANAGER ACCOUNT (MMC)

manager_account_name
Field label Manager account name
Description The name of the manager account
Field type dimension
Data type string.text.value
manager_account_id
Field label Manager account ID
Description The ID of the manager account
Field type dimension
Data type string.text.value

PERFORMANCE

monthly_searches
Field label Monthly searches
Description Approximate number of searches on this keyword for the past twelve months
Field type metric
Data type int.number.value
avg_monthly_searches
Field label Average monthly searches
Description The average number of times people search for a keyword and similar terms based on the month range, the location and your Search Network settings. Averaged for the past 12 months
Field type metric
Data type int.number.value
top_of_page_bids_low_range
Field label Top of page bids (low range)
Description Shows the lower range of what advertisers have historically paid for a keyword’s top of page bid, based on your location and Search Network settings
Field type metric
Data type float.currency.value
top_of_page_bids_high_range
Field label Top of page bids (high range)
Description Shows the higher range of what advertisers have historically paid for a keyword’s top of page bid, based on your location and Search Network settings
Field type metric
Data type float.currency.value
average_cpc_micros
Field label Average CPC
Description Average cost per click for the keyword
Field type metric
Data type float.currency.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Description Year
Field type dimension
Data type string.time.year
month
Field label Month
Description Month
Field type dimension
Data type string.time.month