{"id":7598,"date":"2023-03-05T12:25:43","date_gmt":"2023-03-05T12:25:43","guid":{"rendered":"https:\/\/www.searchviu.com\/?p=7598"},"modified":"2025-09-10T10:58:45","modified_gmt":"2025-09-10T10:58:45","slug":"google-search-console-export-data-to-bigquery","status":"publish","type":"post","link":"https:\/\/www.searchviu.com\/en\/google-search-console-export-data-to-bigquery\/","title":{"rendered":"Get more detailed Google Search Console data using the new BigQuery export"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Google introduced a game-changing feature for Google Search Console in 2023: the ability to export data directly to BigQuery. When we activated the export feature, we uncovered a wealth of additional URL and keyword data that was previously unavailable in standard Search Console reports. With this BigQuery export feature, you can dig deeper into your website\u2019s performance and gain insights that may have been missed before.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2330% more different keywords in BigQuery export<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">We analysed the data from two websites \u2013 one small and one large. We observed a significant difference in the count of different URLs and keywords for the large website, with in default 5.000 over the api and 160.515 different keywords in the BigQuery export.<br>We\u2019ve compared only one day in order to have comparable data for a day by day export.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><\/th><th>Search Console Frontend export*<\/th><th>Search Console API*<\/th><th>BigQuery Export<\/th><\/tr><\/thead><tbody><tr><td>Count of different URLs: Small website<\/td><td>119<\/td><td>119<\/td><td>119<\/td><\/tr><tr><td>Count of different URLs: Large website<\/td><td>1000<\/td><td>5000<\/td><td><strong>19.212<\/strong><\/td><\/tr><tr><td>Count of different Keywords: Small website<\/td><td>1000<\/td><td>1437<\/td><td>1437<\/td><\/tr><tr><td>Count of different Keywords: Large Website<\/td><td>1000<\/td><td>5000<\/td><td><strong>160.515<\/strong><\/td><\/tr><tr><td>Count of different Keywords containig word X: Small website<\/td><td>203<\/td><td>203<\/td><td>203<\/td><\/tr><tr><td>Count of different Keywords containig word X: Large website<\/td><td>13<\/td><td>13<\/td><td><strong>661<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As you can see in the table above, big sites get much more data from Google. But also small websites with more than 5k different keywords can benefit from the advantages with the export.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Especialy the fact that the count of unique keywords containing a special word is much higher for the large website shows that in GSC the amount of data what is saved is limited compared to the export.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>*By filtering data, creating more properties etc. it is possible to get more rows, but it needs to be set up and you can\u2019t ever be sure to get all the data out.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Many One impression keywords (on that day)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">88% of the keywords for the large website had only one impression, and only 7% had one or more clicks that day. However, we expect to see more keywords with clicks and impressions over a more extended period.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Daily data export<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">It\u2019s important to note that the data export process starts on the day of activation and begins exporting data day by day, with no backfill of the data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Data fields in the exported data<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The exported data contains fields such as date, country, search type, etc., similar to the query fields in the Google Search Console, including all filters to filter by search appearance. The data tables are created in the BigQuery data set, and having the data in a table format combined with each other makes it easier to analyze the data with charts, pivot tables, etc.<br><a href=\"https:\/\/support.google.com\/webmasters\/answer\/12917991\">You can find the complete table references here.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Getting started with exporting data to BigQuery<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A few words before we begin: Before diving into exporting Google Search Console data through BigQuery, it is important to note that data storage and query costs in Google Cloud Platform can accumulate over time. To avoid unexpected charges, it is recommended to have a basic understanding of the Google Cloud Platform pricing model and to regularly review your usage and costs. It is also helpful to have a general overview of the Google Cloud Platform before starting.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For each property you export to BigQuery, you should think about creating a designated project in Google Cloud Platform. It\u2019s not possible to change the assigned dataset name and exporting two GSC Properties into the same project, meaning writing data from these properties in the same table. It can make sense to grant the same access to both properties, but if you want more granular access control we suggest you create two projects.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With that in mind, let\u2019s begin the step-by-step guide to exporting your Search Console data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>1.<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Enable BigQuery in your Google Cloud project<\/strong><br>Navigate to APIs &amp; Services &gt; Enabled APIs &amp; Services in the sidebar of Google Cloud Console. If BigQuery is not enabled, click + ENABLE APIS AND SERVICES to enable the BigQuery API.&nbsp;<a href=\"https:\/\/console.cloud.google.com\/apis\/library\/bigquery.googleapis.com\">Or just click here.<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/seoviu_wordpress\/blog\/2023\/03\/c3caf07d-bildschirmfoto-2023-03-06-um-00.19.23.png\" alt=\"\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2.<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Grant Search Console access to your Google Cloud project<\/strong><br>Navigate to IAM and Admin in the sidebar of Google Cloud Console.&nbsp;<a href=\"https:\/\/console.cloud.google.com\/iam-admin\/iam\">Or click here.<\/a><br>Click + GRANT ACCESS to open a side panel that says Add principals. In New Principals, paste the following service account name:<br>search-console-data-export@system.gserviceaccount.com<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Grant it two roles: BigQuery Job User &amp; BigQuery Data Editor<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/seoviu_wordpress\/blog\/2023\/03\/b86bb213-bildschirmfoto-2023-03-06-um-00.22.49.png\" alt=\"\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3.<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Set up your Google Cloud project in Search Console<br><\/strong>Go to Settings &gt;&nbsp;<a href=\"https:\/\/search.google.com\/search-console\/settings\/bulk-data-export\">Bulk data export<\/a>&nbsp;for your property in Search Console. Copy the project ID (the name of the Google Cloud project you\u2019ve created) into the Cloud project ID field.<br>Select a location for your dataset from the list and click continue.<br>After that it takes a day or two until the first data arrives in BigQuery.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/seoviu_wordpress\/blog\/2023\/03\/2e4078c6-bildschirmfoto-2023-03-06-um-00.26.44.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">By following these steps, you can export Google Search Console data to BigQuery through daily bulk exports.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can find more information about the setup of the export in these articles from Google:<br><a href=\"https:\/\/support.google.com\/webmasters\/answer\/12917675\">https:\/\/support.google.com\/webmasters\/answer\/12917675<\/a><br><a href=\"https:\/\/developers.google.com\/search\/blog\/2023\/02\/bulk-data-export\">https:\/\/developers.google.com\/search\/blog\/2023\/02\/bulk-data-export<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Accessing the data<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After the first data has been imported to BigQuery you can create some SQL statements to explore the data. But it\u2019s much easier to explore the data directly with Google Looker Studio.<br>To do so, navigate to Google Cloud Plattform -&gt; BigQuery and select the dataset and a table.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/seoviu_wordpress\/blog\/2023\/03\/b5c688e3-bildschirmfoto-2023-03-06-um-00.32.42-500x196.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click on Query and change the query to:<br>SELECT * FROM `{yourproject}.searchconsole.searchdata_url_impression`<br>(this queries all columns from the table over the complete timeframe)<br>Run the query.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/seoviu_wordpress\/blog\/2023\/03\/dacb40a4-bildschirmfoto-2023-03-06-um-00.36.49.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click on Explore Data -&gt; Explore with Looker Studio.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here you can explore the data without writing any additional SQL Query.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/seoviu_wordpress\/blog\/2023\/03\/c07caed0-bildschirmfoto-2023-03-06-um-00.40.14.png\" alt=\"\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Summary<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The extended export of GSC data to BigQuery gives much more insights. But also a higher amount of data to manage and analyze. Because of the daily export we recommend to start soon \u2013 because you are losing data every day it is not activated.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019re interested in a Data Warehouse Service that takes care of all the export hassles, get in touch with us.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google introduced a game-changing feature for Google Search Console in 2023: the ability to export data directly to BigQuery. When we activated the export feature, we uncovered a wealth of additional URL and keyword data that was previously unavailable in standard Search Console reports. With this BigQuery export feature, you can dig deeper into your [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7600,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[36],"tags":[30],"class_list":["post-7598","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-seo-data","tag-english"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Get more detailed Google Search Console data using the new BigQuery export - SEO Data Warehouse And Monitoring<\/title>\n<meta name=\"description\" content=\"Discover how Google Search Console\u2019s BigQuery export unlocks thousands of additional keywords and URLs for deeper SEO insights. Learn how to set up daily data exports and analyze your site\u2019s performance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.searchviu.com\/en\/google-search-console-export-data-to-bigquery\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get more detailed Google Search Console data using the new BigQuery export - SEO Data Warehouse And Monitoring\" \/>\n<meta property=\"og:description\" content=\"Discover how Google Search Console\u2019s BigQuery export unlocks thousands of additional keywords and URLs for deeper SEO insights. Learn how to set up daily data exports and analyze your site\u2019s performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.searchviu.com\/en\/google-search-console-export-data-to-bigquery\/\" \/>\n<meta property=\"og:site_name\" content=\"SEO Data Warehouse And Monitoring\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-05T12:25:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-10T10:58:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.searchviu.com\/wp-content\/uploads\/2025\/08\/pexels-ghida-basma-196023-609749.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2048\" \/>\n\t<meta property=\"og:image:height\" content=\"1365\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michael\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@searchviu\" \/>\n<meta name=\"twitter:site\" content=\"@searchviu\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/\"},\"author\":{\"name\":\"Michael\",\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/#\\\/schema\\\/person\\\/047e04e169af50cb1ca9d948557fa1c2\"},\"headline\":\"Get more detailed Google Search Console data using the new BigQuery export\",\"datePublished\":\"2023-03-05T12:25:43+00:00\",\"dateModified\":\"2025-09-10T10:58:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/\"},\"wordCount\":1022,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.searchviu.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/pexels-ghida-basma-196023-609749.jpg\",\"keywords\":[\"english\"],\"articleSection\":[\"SEO data\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/\",\"url\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/\",\"name\":\"Get more detailed Google Search Console data using the new BigQuery export - SEO Data Warehouse And Monitoring\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.searchviu.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/pexels-ghida-basma-196023-609749.jpg\",\"datePublished\":\"2023-03-05T12:25:43+00:00\",\"dateModified\":\"2025-09-10T10:58:45+00:00\",\"description\":\"Discover how Google Search Console\u2019s BigQuery export unlocks thousands of additional keywords and URLs for deeper SEO insights. Learn how to set up daily data exports and analyze your site\u2019s performance.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.searchviu.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/pexels-ghida-basma-196023-609749.jpg\",\"contentUrl\":\"https:\\\/\\\/www.searchviu.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/pexels-ghida-basma-196023-609749.jpg\",\"width\":2048,\"height\":1365},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/google-search-console-export-data-to-bigquery\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.searchviu.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get more detailed Google Search Console data using the new BigQuery export\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/#website\",\"url\":\"https:\\\/\\\/www.searchviu.com\\\/\",\"name\":\"SEO Data Warehouse And Monitoring\",\"description\":\"SEO Solutions For Teams And Agencies\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.searchviu.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/#organization\",\"name\":\"searchVIU\",\"url\":\"https:\\\/\\\/www.searchviu.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.searchviu.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/d3babe41-searchviu-logo2x.png\",\"contentUrl\":\"https:\\\/\\\/www.searchviu.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/d3babe41-searchviu-logo2x.png\",\"width\":340,\"height\":340,\"caption\":\"searchVIU\"},\"image\":{\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/searchviu\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/searchviu\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.searchviu.com\\\/#\\\/schema\\\/person\\\/047e04e169af50cb1ca9d948557fa1c2\",\"name\":\"Michael\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e383ecb4d55e87b2093a198ac18315bff59afd030de65ea2c5b9172bb951d89?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e383ecb4d55e87b2093a198ac18315bff59afd030de65ea2c5b9172bb951d89?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e383ecb4d55e87b2093a198ac18315bff59afd030de65ea2c5b9172bb951d89?s=96&d=mm&r=g\",\"caption\":\"Michael\"},\"sameAs\":[\"https:\\\/\\\/www.searchviu.com\"],\"url\":\"https:\\\/\\\/www.searchviu.com\\\/en\\\/author\\\/michaelsearchviu-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Get more detailed Google Search Console data using the new BigQuery export - SEO Data Warehouse And Monitoring","description":"Discover how Google Search Console\u2019s BigQuery export unlocks thousands of additional keywords and URLs for deeper SEO insights. Learn how to set up daily data exports and analyze your site\u2019s performance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.searchviu.com\/en\/google-search-console-export-data-to-bigquery\/","og_locale":"en_US","og_type":"article","og_title":"Get more detailed Google Search Console data using the new BigQuery export - SEO Data Warehouse And Monitoring","og_description":"Discover how Google Search Console\u2019s BigQuery export unlocks thousands of additional keywords and URLs for deeper SEO insights. Learn how to set up daily data exports and analyze your site\u2019s performance.","og_url":"https:\/\/www.searchviu.com\/en\/google-search-console-export-data-to-bigquery\/","og_site_name":"SEO Data Warehouse And Monitoring","article_published_time":"2023-03-05T12:25:43+00:00","article_modified_time":"2025-09-10T10:58:45+00:00","og_image":[{"width":2048,"height":1365,"url":"https:\/\/www.searchviu.com\/wp-content\/uploads\/2025\/08\/pexels-ghida-basma-196023-609749.jpg","type":"image\/jpeg"}],"author":"Michael","twitter_card":"summary_large_image","twitter_creator":"@searchviu","twitter_site":"@searchviu","twitter_misc":{"Written by":"Michael","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/#article","isPartOf":{"@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/"},"author":{"name":"Michael","@id":"https:\/\/www.searchviu.com\/#\/schema\/person\/047e04e169af50cb1ca9d948557fa1c2"},"headline":"Get more detailed Google Search Console data using the new BigQuery export","datePublished":"2023-03-05T12:25:43+00:00","dateModified":"2025-09-10T10:58:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/"},"wordCount":1022,"commentCount":0,"publisher":{"@id":"https:\/\/www.searchviu.com\/#organization"},"image":{"@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/#primaryimage"},"thumbnailUrl":"https:\/\/www.searchviu.com\/wp-content\/uploads\/2025\/08\/pexels-ghida-basma-196023-609749.jpg","keywords":["english"],"articleSection":["SEO data"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/","url":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/","name":"Get more detailed Google Search Console data using the new BigQuery export - SEO Data Warehouse And Monitoring","isPartOf":{"@id":"https:\/\/www.searchviu.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/#primaryimage"},"image":{"@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/#primaryimage"},"thumbnailUrl":"https:\/\/www.searchviu.com\/wp-content\/uploads\/2025\/08\/pexels-ghida-basma-196023-609749.jpg","datePublished":"2023-03-05T12:25:43+00:00","dateModified":"2025-09-10T10:58:45+00:00","description":"Discover how Google Search Console\u2019s BigQuery export unlocks thousands of additional keywords and URLs for deeper SEO insights. Learn how to set up daily data exports and analyze your site\u2019s performance.","breadcrumb":{"@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/#primaryimage","url":"https:\/\/www.searchviu.com\/wp-content\/uploads\/2025\/08\/pexels-ghida-basma-196023-609749.jpg","contentUrl":"https:\/\/www.searchviu.com\/wp-content\/uploads\/2025\/08\/pexels-ghida-basma-196023-609749.jpg","width":2048,"height":1365},{"@type":"BreadcrumbList","@id":"https:\/\/www.searchviu.com\/google-search-console-export-data-to-bigquery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.searchviu.com\/en\/"},{"@type":"ListItem","position":2,"name":"Get more detailed Google Search Console data using the new BigQuery export"}]},{"@type":"WebSite","@id":"https:\/\/www.searchviu.com\/#website","url":"https:\/\/www.searchviu.com\/","name":"SEO Data Warehouse And Monitoring","description":"SEO Solutions For Teams And Agencies","publisher":{"@id":"https:\/\/www.searchviu.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.searchviu.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.searchviu.com\/#organization","name":"searchVIU","url":"https:\/\/www.searchviu.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.searchviu.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.searchviu.com\/wp-content\/uploads\/2023\/02\/d3babe41-searchviu-logo2x.png","contentUrl":"https:\/\/www.searchviu.com\/wp-content\/uploads\/2023\/02\/d3babe41-searchviu-logo2x.png","width":340,"height":340,"caption":"searchVIU"},"image":{"@id":"https:\/\/www.searchviu.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/searchviu","https:\/\/www.linkedin.com\/company\/searchviu\/"]},{"@type":"Person","@id":"https:\/\/www.searchviu.com\/#\/schema\/person\/047e04e169af50cb1ca9d948557fa1c2","name":"Michael","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0e383ecb4d55e87b2093a198ac18315bff59afd030de65ea2c5b9172bb951d89?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0e383ecb4d55e87b2093a198ac18315bff59afd030de65ea2c5b9172bb951d89?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0e383ecb4d55e87b2093a198ac18315bff59afd030de65ea2c5b9172bb951d89?s=96&d=mm&r=g","caption":"Michael"},"sameAs":["https:\/\/www.searchviu.com"],"url":"https:\/\/www.searchviu.com\/en\/author\/michaelsearchviu-com\/"}]}},"modified_by":"Katja","_links":{"self":[{"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/posts\/7598","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/comments?post=7598"}],"version-history":[{"count":3,"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/posts\/7598\/revisions"}],"predecessor-version":[{"id":7603,"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/posts\/7598\/revisions\/7603"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/media\/7600"}],"wp:attachment":[{"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/media?parent=7598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/categories?post=7598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.searchviu.com\/en\/wp-json\/wp\/v2\/tags?post=7598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}