{"id":6121,"date":"2020-05-20T09:02:48","date_gmt":"2020-05-20T09:02:48","guid":{"rendered":"https:\/\/docs_v3.dataforseo.com\/v3\/?page_id=6121"},"modified":"2023-05-02T09:33:34","modified_gmt":"2023-05-02T09:33:34","slug":"databases-keywords","status":"publish","type":"page","link":"https:\/\/docs.dataforseo.com\/v3\/databases-keywords\/","title":{"rendered":"databases\/keywords"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]<\/p>\n

Keyword Database<\/h2>\n

\u200c\u200c <\/p>\n

This<\/strong> is a legacy version page. See the updated documentation here<\/a>.<\/h3>\n

 
\nKeyword Database encompassed over 3 billion search terms enriched with related data: search volume trends, cpc, competition, impressions, and more.<\/p>\n

This database is available in both JSON and CSV formats.<\/p>\n

\t

\n\t\t
\n\t\t\t
\n\t\t\t\t\n\t\t\t\t\t<\/use>\n\t\t\t\t<\/svg>\n\t\t\t<\/div>\n\t\t\t
Pricing<\/div>\n\t\t<\/header>\n\t\t
\n\t\t\t

The cost depends on the size and location parameters of the specific database.
\nThe cost can be found on the Keyword Database<\/a> pricing page.<\/p>\n\t\t<\/div>\n\t<\/article>\n\t[vc_column_text]<\/p>\n

Description of the fields in the Keyword Database:<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field name<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
keyword<\/code><\/td>\nstring<\/td>\nkeyword<\/em>
\nUTF-8 encoding applies\n<\/td>\n<\/tr>\n
location<\/code><\/td>\ninteger<\/td>\nlocation code<\/em>
\nunique identifier of the corresponding location
\nyou can receive the list of available locations with their location_code<\/code> by making a separate request to the
\nhttps:\/\/api.dataforseo.com\/v3\/dataforseo_labs\/locations_and_languages<\/code>
\nexample:
\n2840<\/code> corresponds to the United States<\/code><\/td>\n<\/tr>\n
language<\/code><\/td>\nstring<\/td>\nlanguage code<\/em>
\nunique identifier of the language available for the corresponding location
\nyou can receive the list of available locations with their language_code<\/code> by making a separate request to the
\nhttps:\/\/api.dataforseo.com\/v3\/dataforseo_labs\/locations_and_languages<\/code>
\nexample:
\nen<\/code> corresponds to English<\/code><\/td>\n<\/tr>\n
spell<\/code><\/td>\nstring<\/td>\nautocorrection of the search engine<\/em>
\nif the search engine provided results for a keyword that was corrected, we will provide the keyword corrected by the search engine and the type of autocorrection\n<\/td>\n<\/tr>\n
spell_type<\/code><\/td>\nstring<\/td>\ntype of autocorrection<\/em>
\npossible values:
\ndid_you_mean<\/code>, showing_results_for<\/code>, no_results_found_for<\/code>\n<\/td>\n<\/tr>\n
keyword_info<\/strong><\/code><\/td>\narray<\/td>\nkeyword data for the returned keyword<\/em><\/td>\n<\/tr>\n
\u00a0 \u00a0 search_volume<\/code><\/td>\ninteger<\/td>\naverage monthly search volume rate<\/em>
\nrepresents either the approximate number of searches for the given keyword idea on google.com or google.com and partners, depending on the user\u2019s targeting<\/td>\n<\/tr>\n
\u00a0 \u00a0 cpc<\/code><\/td>\nfloat<\/td>\ncost-per-click<\/em>
\nrepresents the average cost per click (USD) historically paid for the keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 competition<\/code><\/td>\nfloat<\/td>\ncompetition<\/em>
\nrepresents the relative amount of competition associated with the given keyword;
\nthe value is based on Google Ads data and can be between 0 and 1 (inclusive)<\/td>\n<\/tr>\n
\u00a0 \u00a0 time_update<\/code><\/td>\nstring<\/td>\ndate and time when keyword data was last updated<\/em>
\nin the format: \u201cmonth\/date\/year hours:minutes:seconds UTC\u201d
\nexample:
\n05\/08\/2020 09:47:05<\/code><\/td>\n<\/tr>\n
\u00a0 \u00a0 categories<\/code><\/td>\narray<\/td>\nproduct and service categories<\/em>
\nyou can download the full list of possible categories<\/a><\/td>\n<\/tr>\n
\u00a0 \u00a0 history<\/code><\/td>\narray<\/td>\nmonthly searches<\/em>
\nrepresents the (approximate) number of searches on the returned keyword in the given location\n<\/td>\n<\/tr>\n
impressions_info<\/strong><\/code><\/td>\narray<\/td>\nimpressions data for the returned keyword<\/em>
\nlearn more about impressions in this help center article<\/a><\/td>\n<\/tr>\n
\u00a0 \u00a0 ad_position_average<\/code><\/td>\nfloat<\/td>\nthe average ad position<\/em>
\nrepresents the average position of the paid result in Google SERP for the returned keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 ad_position_min<\/code><\/td>\nfloat<\/td>\nthe minimum ad position<\/em>
\nrepresents the minimum position of the paid result in Google SERP for the returned keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 ad_position_max<\/code><\/td>\nfloat<\/td>\nthe maximum ad position<\/em>
\nrepresents the maximum position of the paid result in Google SERP for returned keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 cpc_avg<\/code><\/td>\nfloat<\/td>\nthe average value of cost-per-click<\/em>
\nrepresents the average cost-per-click (USD) historically paid for the keyword in Google Ads<\/td>\n<\/tr>\n
\u00a0 \u00a0 cpc_min<\/code><\/td>\nfloat<\/td>\nthe minimum value of cost-per-click<\/em>
\nrepresents the minimum cost-per-click (USD) historically paid for the keyword in Google Ads<\/td>\n<\/tr>\n
\u00a0 \u00a0 cpc_max<\/code><\/td>\nfloat<\/td>\nthe maximum value of cost-per-click<\/em>
\nrepresents the maximum cost-per-click (USD) historically paid for the keyword in Google Ads<\/td>\n<\/tr>\n
\u00a0 \u00a0 daily_impressions_avg<\/code><\/td>\nfloat<\/td>\nthe average value of daily impressions<\/em>
\nrepresents the average number of daily impressions of the paid result in Google SERP for the returned keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 daily_impressions_min<\/code><\/td>\nfloat<\/td>\nthe minimum value of daily impressions<\/em>
\nrepresents the minimum number of daily impressions of the paid result in Google SERP for the returned keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 daily_impressions_max<\/code><\/td>\nfloat<\/td>\nthe maximum value of daily impressions<\/em>
\nrepresents the maximum number of daily impressions of the paid result in Google SERP for the returned keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 daily_clicks_avg<\/code><\/td>\nfloat<\/td>\nthe average value of daily clicks<\/em>
\nrepresents the average number of daily clicks on the paid result in Google SERP for the returned keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 daily_clicks_min<\/code><\/td>\nfloat<\/td>\nthe minimum value of daily clicks<\/em>
\nrepresents the minimum number of daily clicks on the paid result in Google SERP for the returned keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 daily_clicks_max<\/code><\/td>\nfloat<\/td>\nthe maximum value of daily clicks<\/em>
\nrepresents the maximum number of daily clicks on the paid result in Google SERP for the returned keyword<\/td>\n<\/tr>\n
\u00a0 \u00a0 bid<\/code><\/td>\ninteger<\/td>\nthe maximum bid<\/em>
\nwe return the results for the 999<\/code> bid value to provide the most relevant impressions data<\/td>\n<\/tr>\n
\u00a0 \u00a0 daily_cost_avg<\/code><\/td>\nfloat<\/td>\nthe average daily cost<\/em>
\nrepresents the average daily cost of running ads for the returned keyword in Google Ads<\/td>\n<\/tr>\n
\u00a0 \u00a0 daily_cost_min<\/code><\/td>\nfloat<\/td>\nthe minimum daily cost<\/em>
\nrepresents the minimum daily cost of running ads for the returned keyword in Google Ads<\/td>\n<\/tr>\n
\u00a0 \u00a0 daily_cost_max<\/code><\/td>\nfloat<\/td>\nthe maximum daily charge value<\/em>
\nrepresents the maximum daily cost of running ads for the returned keyword in Google Ads<\/td>\n<\/tr>\n
\u00a0 \u00a0 time_update<\/code><\/td>\nstring<\/td>\ndate and time when keyword data was last updated<\/em>
\nin the format: \u201cmonth\/date\/year hours:minutes:seconds UTC\u201d
\nexample:
\n05\/08\/2020 09:47:05<\/code><\/td>\n<\/tr>\n
bing_keyword_info<\/strong><\/code><\/td>\narray<\/td>\nkeyword data based on bing ads<\/em>
\nnote:<\/strong> bing data is available for a limited number of locations and languages<\/a><\/td>\n<\/tr>\n
\u00a0 \u00a0 search_volume<\/code><\/td>\ninteger<\/td>\nmonthly number of searches on bing<\/em>
\nrepresents the number of searches for the given keyword idea on bing.com for the past month<\/td>\n<\/tr>\n
\u00a0 \u00a0 time_update<\/code><\/td>\nstring<\/td>\ndate and time when keyword data was last updated<\/em>
\nin the ISO 8601<\/a> format: \u201cYYYY-MM-DDThh:mm:ss.sssssssZ\u201d
\nexample:
\n2020-09-12T00:07:43.0733218Z<\/code><\/td>\n<\/tr>\n
\u00a0 \u00a0 history<\/code><\/td>\narray<\/td>\nmonthly searches<\/em>
\nrepresents the number of monthly Bing searches on the returned keyword in the given location<\/td>\n<\/tr>\n
extra<\/strong><\/code><\/td>\narray<\/td>\nadditional information about the keyword<\/em><\/td>\n<\/tr>\n
\u00a0 \u00a0 core_keyword<\/code><\/td>\nstring<\/td>\nmain keyword in a group<\/em>
\ncontains the main keyword in a group of keywords that share similarities across the keyword_info<\/code> parameters
\nif the value is null<\/code>, our database does not contain any keywords that match these criteria<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u200c\u200c[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n

The database in JSON contains data structured like in the example below:<\/p><\/blockquote>

{\r\n  "keyword": "\u0627\u0644\u0631\u0633\u0645 \u062b\u0644\u0627\u062b\u064a \u0627\u0644\u0627\u0628\u0639\u0627\u062f",\r\n  "location": 2818,\r\n  "language": "ar",\r\n  "spell": null,\r\n  "spell_type": null,\r\n  "keyword_info": {\r\n    "search_volume": 720,\r\n    "cpc": 0.015523,\r\n    "competition": 0.019329507701600728,\r\n    "time_update": "2021-03-24T04:01:47.4351095Z",\r\n    "categories": [\r\n      10013,\r\n      10108,\r\n      13388,\r\n      13595,\r\n      13691,\r\n      13692\r\n    ],\r\n    "history": {\r\n      "202003": 1000,\r\n      "202004": 1000,\r\n      "202005": 880,\r\n      "202006": 1000,\r\n      "202007": 720,\r\n      "202008": 590,\r\n      "202009": 480,\r\n      "202010": 480,\r\n      "202011": 480,\r\n      "202012": 590,\r\n      "202101": 590,\r\n      "202102": 480\r\n    }\r\n  },\r\n  "impressions_info": {\r\n    "ad_position_avg": null,\r\n    "ad_position_min": null,\r\n    "ad_position_max": null,\r\n    "cpc_avg": null,\r\n    "cpc_min": null,\r\n    "cpc_max": null,\r\n    "daily_impressions_avg": 0,\r\n    "daily_impressions_min": 0,\r\n    "daily_impressions_max": 0,\r\n    "daily_clicks_avg": 0,\r\n    "daily_clicks_min": 0,\r\n    "daily_clicks_max": 0,\r\n    "bid": 999,\r\n    "daily_cost_avg": 0,\r\n    "daily_cost_min": 0,\r\n    "daily_cost_max": 0,\r\n    "time_update": "2021-03-19T14:07:03.9208731Z"\r\n  },\r\n  "bing_keyword_info": null,\r\n  "extra": {\r\n    "core_keyword": "\u0631\u0633\u0648\u0645\u0627\u062a \u062b\u0644\u0627\u062b\u064a\u0629 \u0627\u0644\u0627\u0628\u0639\u0627\u062f"\r\n  }\r\n},\r\n{\r\n  "keyword": "\u0627\u0644\u0627\u0645\u064a\u0631\u0629 \u0647\u064a\u0627",\r\n  "location": 2818,\r\n  "language": "ar",\r\n  "spell": null,\r\n  "spell_type": null,\r\n  "keyword_info": {\r\n    "search_volume": 720,\r\n    "cpc": 0.009519,\r\n    "competition": 0.0033973161202649907,\r\n    "time_update": "2021-03-31T21:57:05.1516650Z",\r\n    "categories": [\r\n      10013,\r\n      10018,\r\n      10108,\r\n      10584,\r\n      13414,\r\n      13444\r\n    ],\r\n    "history": {\r\n      "202003": 2900,\r\n      "202004": 880,\r\n      "202005": 590,\r\n      "202006": 590,\r\n      "202007": 720,\r\n      "202008": 590,\r\n      "202009": 480,\r\n      "202010": 390,\r\n      "202011": 390,\r\n      "202012": 390,\r\n      "202101": 390,\r\n      "202102": 880\r\n    }\r\n  },\r\n  "impressions_info": {\r\n    "ad_position_avg": null,\r\n    "ad_position_min": null,\r\n    "ad_position_max": null,\r\n    "cpc_avg": null,\r\n    "cpc_min": null,\r\n    "cpc_max": null,\r\n    "daily_impressions_avg": 0,\r\n    "daily_impressions_min": 0,\r\n    "daily_impressions_max": 0,\r\n    "daily_clicks_avg": 0,\r\n    "daily_clicks_min": 0,\r\n    "daily_clicks_max": 0,\r\n    "bid": 999,\r\n    "daily_cost_avg": 0,\r\n    "daily_cost_min": 0,\r\n    "daily_cost_max": 0,\r\n    "time_update": "2021-03-28T14:05:34.4503662Z"\r\n  },\r\n  "bing_keyword_info": null,\r\n  "extra": {\r\n    "core_keyword": null\r\n  }\r\n}<\/code><\/pre><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"
[vc_row][vc_column][vc_column_text] Keyword Database \u200c\u200c  This is a legacy version page. See the updated documentation here.   Keyword Database encompassed over 3 billion search terms enriched with related data: search volume trends, cpc, competition, impressions, and more. This database is available in both JSON and CSV formats. Pricing The cost depends on the size and location […]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template.php","meta":{"apibase_doc_request_yaml":"","apibase_doc_request_additional_yaml":"","apibase_doc_response_yaml":"","footnotes":""},"class_list":["post-6121","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/docs.dataforseo.com\/v3\/wp-json\/wp\/v2\/pages\/6121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.dataforseo.com\/v3\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.dataforseo.com\/v3\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.dataforseo.com\/v3\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.dataforseo.com\/v3\/wp-json\/wp\/v2\/comments?post=6121"}],"version-history":[{"count":29,"href":"https:\/\/docs.dataforseo.com\/v3\/wp-json\/wp\/v2\/pages\/6121\/revisions"}],"predecessor-version":[{"id":16926,"href":"https:\/\/docs.dataforseo.com\/v3\/wp-json\/wp\/v2\/pages\/6121\/revisions\/16926"}],"wp:attachment":[{"href":"https:\/\/docs.dataforseo.com\/v3\/wp-json\/wp\/v2\/media?parent=6121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}