Regular Google SERP Database
Regular Google SERP Database encompasses millions of Google results pages with standard organic and paid search results and featured snippets. Besides structured data on these SERP elements, you will also get accurate keyword metrics for relevant search terms.
This database is available in both JSON and CSV formats.
Click here to download a database sample for the US location, English language.
You can also download the full list of supported locations and languages in the CSV format (last updated 2023-08-30).
The database in JSON contains data structured like in the example below:
{
"keyword": "mountain painting",
"location": 2528,
"language": "nl",
"spell": null,
"spell_type": null,
"keyword_info": {
"search_volume": 260,
"cpc": null,
"competition": 0.99,
"competition_level": "HIGH",
"low_top_of_page_bid": null,
"high_top_of_page_bid": null,
"time_update": "2023-03-14T07:02:10.0979701Z",
"categories": [
10013,
13388,
13595,
10014
],
"history": {
"202203": 320,
"202204": 210,
"202205": 260,
"202206": 320,
"202207": 210,
"202208": 260,
"202209": 260,
"202210": 260,
"202211": 320,
"202212": 210,
"202301": 390,
"202302": 320
}
},
"serp_info": {
"check_url": "https://www.google.nl/search?q=mountain%20painting&num=100&hl=nl&gl=NL&gws_rd=cr&ie=UTF-8&oe=UTF-8&uule=w+CAIQIFISCbvkh9vDCcZHEZ8Kvf_OdaGz",
"items_count": 102,
"keyword_difficulty": 20,
"se_results_count": 455000000,
"time_update": "2023-03-12T22:20:17.3263383Z",
"serp": [
{
"rank_group": 1,
"rank_absolute": 2,
"type": "organic",
"domain": "www.pinterest.com",
"url": "https://www.pinterest.com/hbauch64/mountain-paintings/",
"title": "790 Best mountain paintings ideas in 2023 - Pinterest",
"description": "See more ideas about mountain paintings, landscape paintings, ... Mountain Paintings, Scape, Kyle, Acrylic Painting, Art, Art Background, Kunst ...",
"breadcrumb": "https://www.pinterest.com › mount...",
"etv": 79.03999999999999,
"impressions_etv": 0,
"traffic_cost": 0
},
{
"rank_group": 2,
"rank_absolute": 3,
"type": "organic",
"domain": "fineartamerica.com",
"url": "https://fineartamerica.com/art/paintings/mountain",
"title": "Mountain Paintings - Fine Art America",
"description": "Choose your favorite mountain paintings from 162298 available designs. All mountain paintings ship within 48 hours and include a 30-day money-back ...",
"breadcrumb": "https://fineartamerica.com › art",
"etv": 42.120000000000005,
"impressions_etv": 0,
"traffic_cost": 0
},
{
"rank_group": 3,
"rank_absolute": 4,
"type": "organic",
"domain": "www.etsy.com",
"url": "https://www.etsy.com/market/mountain_painting",
"title": "Mountain Painting - Etsy",
"description": "Check out our mountain painting selection for the very best in unique or custom, handmade pieces from our oil shops.",
"breadcrumb": "https://www.etsy.com › market",
"etv": 25.298,
"impressions_etv": 0,
"traffic_cost": 0
},
{
"rank_group": 4,
"rank_absolute": 5,
"type": "organic",
"domain": "www.saatchiart.com",
"url": "https://www.saatchiart.com/paintings/mountain-landscape-painting/feature",
"title": "Mountain Landscape Painting Paintings | Saatchi Art",
"description": "Results for \"Mountain Landscape Painting\" Paintings. Discover 14 Paintings by top emerging artists from around the world, including Nino Ponditerra, ...",
"breadcrumb": "https://www.saatchiart.com › feature",
"etv": 17.134,
"impressions_etv": 0,
"traffic_cost": 0
},
{
"rank_group": 5,
"rank_absolute": 6,
"type": "organic",
"domain": "www.amazon.com",
"url": "https://www.amazon.com/Mountain-Paintings/s?k=Mountain+Paintings",
"title": "Mountain Paintings - Amazon.com",
"description": "Amazon.com: Mountain Paintings. ... Untitled Mountain line art wall print Abstract wall art painting Abstract canvas print Extra large wall.",
"breadcrumb": "https://www.amazon.com › Mount...",
"etv": 12.193999999999999,
"impressions_etv": 0,
"traffic_cost": 0
},
{
"rank_group": 6,
"rank_absolute": 7,
"type": "organic",
"domain": "www.freepik.com",
"url": "https://www.freepik.com/free-photos-vectors/mountain-painting",
"title": "Mountain Painting Images - Free Download on Freepik",
"description": "Find & Download Free Graphic Resources for Mountain Painting. 90000+ Vectors, Stock Photos & PSD files. ✓ Free for commercial use ✓ High Quality Images.",
"breadcrumb": "https://www.freepik.com › mounta...",
"etv": 8.787999999999998,
"impressions_etv": 0,
"traffic_cost": 0
},
{
"rank_group": 7,
"rank_absolute": 8,
"type": "organic",
"domain": "unsplash.com",
"url": "https://unsplash.com/s/photos/mountain-painting",
"title": "Mountain Painting Pictures | Download Free Images on ...",
"description": "Download the perfect mountain painting pictures. Find over 100+ of the best free mountain painting images. Free for commercial use ✓ No attribution ...",
"breadcrumb": "https://unsplash.com › photos › m...",
"etv": 6.656000000000001,
"impressions_etv": 0,
"traffic_cost": 0
},
{
"rank_group": 8,
"rank_absolute": 9,
"type": "organic",
"domain": "luxianwall.com",
"url": "https://luxianwall.com/product/mountain-painting/",
"title": "Mountain – Painting Canvas - Luxian Wall",
"description": "Mountain – Painting Canvas · 40x30 cm · 60x40 cm · 100x70 cm · 120x80 cm.",
"breadcrumb": "https://luxianwall.com › product › mountain-painting",
"etv": 5.122,
"impressions_etv": 0,
"traffic_cost": 0
},
{
"rank_group": 9,
"rank_absolute": 10,
"type": "organic",
"domain": "marjoleinbos.nl",
"url": "http://marjoleinbos.nl/artwork/mountain-painting",
"title": "Mountain Painting - Marjolein Bos",
"description": "In 2009 Marjolein founded Galerie Maste 4 in Saas-Fee, 2565 m above sea level. The interest shown in her mountain series prompted her to send paintings to the",
"breadcrumb": "http://marjoleinbos.nl › artwork",
"etv": 3.9,
"impressions_etv": 0,
"traffic_cost": 0
},
{
"rank_group": 10,
"rank_absolute": 12,
"type": "organic",
"domain": "www.handmadepiece.com",
"url": "https://www.handmadepiece.com/oil-painting-collection/famous-mountain-paintings.html",
"title": "Famous Mountain Paintings - Oil Painting Reproductions",
"description": "Welcome to the collection of famou Mountain Paintings. Mountains are the artworks created by nature. People often marvel at their beauty ...",
"breadcrumb": "https://www.handmadepiece.com › ...",
"etv": 2.9379999999999997,
"impressions_etv": 0,
"traffic_cost": 0
}
]
},
"extra": {
"core_keyword": null,
"detected_language": "en",
"keyword_difficulty": 20
},
"search_intent_info": {
"main_intent": "commercial",
"foreign_intent": [
"transactional"
],
"last_updated_time": "2023-03-03T13:08:27.4586525Z"
}
}
Description of the fields in the database:
| Field name | Type | Description |
|---|---|---|
keyword |
string | keyword UTF-8 encoding applies |
location |
integer | location code unique identifier of the corresponding location you can receive the list of available locations with their location_code by making an API request tohttps://api.dataforseo.com/v3/dataforseo_labs/locations_and_languagesexample: 2840 corresponds to the United States |
language |
string | language code unique identifier of the language available for the corresponding location you can receive the list of available locations with their language_code by making an API request tohttps://api.dataforseo.com/v3/dataforseo_labs/locations_and_languagesexample: en corresponds to English |
spell |
string | autocorrection of the search engine if 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 |
spell_type |
string | type of autocorrection possible values: did_you_mean, showing_results_for, no_results_found_for, including_results_for
|
keyword_info |
object | keyword data for the returned keyword |
search_volume |
integer | average monthly search volume rate represents the approximate number of searches for the given keyword on google.com |
cpc |
float | cost-per-click represents the average cost per click (USD) historically paid for the keyword note that Google Ads does not provide separate CPC data; this field returns values based on data from high_top_of_page_bid supplied in Google Ads |
competition |
float | competition represents the relative amount of competition associated with the given keyword; the value is based on Google Ads data and can be between 0 and 1 (inclusive) |
competition_level |
string | competition level represents the relative level of competition associated with the given keyword in paid SERP only; possible values: LOW, MEDIUM, HIGHif competition level is unknown, the value is null;learn more about the metric in this help center article |
low_top_of_page_bid |
float | minimum bid for the ad to be displayed at the top of the first page indicates the value greater than about 20% of the lowest bids for which ads were displayed (based on Google Ads statistics for advertisers) the value may differ depending on the location |
high_top_of_page_bid |
float | maximum bid for the ad to be displayed at the top of the first page indicates the value greater than about 80% of the lowest bids for which ads were displayed (based on Google Ads statistics for advertisers) the value may differ depending on the location |
time_update |
string | date and time when keyword data was last updated in the ISO 8601 format: “YYYY-MM-DDThh:mm:ss.sssssssZ” example: 2020-09-12T00:07:43.0733218Z |
categories |
array | product and service categories you can download the full list of possible categories |
history |
object | monthly searches represents the (approximate) number of searches on the returned keyword in the given location |
serp_info |
object | SERP data available for the returned keyword |
check_url |
string | direct URL to search engine results you can use it to make sure that we provided exact results |
items_count |
integer | the number of results returned in the serp array |
keyword_difficulty |
integer | difficulty of ranking in the first top-10 organic results for a keyword indicates the chance of getting in top-10 organic results for a keyword on a logarithmic scale from 0 to 100; calculated by analysing, among other parameters, link profiles of the first 10 pages in SERP; learn more about the metric in this help center guide |
se_results_count |
integer | total number of results in SERP |
time_update |
string | date and time when SERP data was last updated in the ISO 8601 format: “YYYY-MM-DDThh:mm:ss.sssssssZ” example: 2020-09-12T00:07:43.0733218Z |
serp |
array | contains data on the SERP elements found for the returned keyword |
rank_group |
integer | group rank in SERP position within a group of elements with identical type valuespositions of elements with different type values are omitted from rank_group |
rank_absolute |
integer | absolute rank in SERP absolute position among all the elements found in SERP; note: values are returned in the ascending order, with values corresponding to advanced SERP features omitted from the results to get all items (including advanced SERP features and rich snippets) with their positions, please refer to the Advanced SERP Database |
type |
string | type of element possible types: organic, paid, featured_snippet |
domain |
string | domain in SERP |
url |
string | relevant URL |
title |
string | title of the result in SERP |
description |
string | description of the results element in SERP |
breadcrumb |
string | breadcrumb in SERP |
etv |
float | estimated traffic volume estimated organic monthly traffic to the domain; calculated as the product of CTR (click-through-rate) and search volume values of the keyword a given URL ranks for |
impressions_etv |
float | estimated traffic volume based on impressions estimated organic monthly traffic to the domain; calculated as the product of CTR (click-through-rate) and impressions values of the keyword a given URL ranks for |
traffic_cost |
float | estimated cost of converting organic search traffic into paid represents the estimated monthly cost of running ads for the keyword that a given URL ranks for; the metric is calculated as the product of organic etv and paid cpc values and indicates the cost of driving the estimated volume of monthly organic traffic through PPC advertising in Google Search |
extra |
array | additional information about the keyword |
core_keyword |
string | main keyword in a group contains the main keyword in a group of keywords that share similarities across the keyword_info parametersif the value is null, our database does not contain any keywords that match these criteria |
detected_language |
string | detected language of the keyword indicates the language of the keyword as identified by our system |
keyword_difficulty |
integer | difficulty of ranking in the first top-10 organic results for a keyword indicates the chance of getting in top-10 organic results for a keyword on a logarithmic scale from 0 to 100; calculated by analysing, among other parameters, link profiles of the first 10 pages in SERP; learn more about the metric in this help center guide |
search_intent_info |
object | search intent info for the returned keyword learn about search intent in this help center article |
main_intent |
string | main search intent possible values: informational, navigational, commercial, transactional
|
foreign_intent |
array | supplementary search intents possible values: informational, navigational, commercial, transactional
|
last_updated_time |
string | date and time when search intent data was last updated in the ISO 8601 format: “YYYY-MM-DDThh:mm:ss.sssssssZ” example: 2022-09-12T00:07:43.0733218Z |