{"id":1887,"date":"2025-01-21T20:59:13","date_gmt":"2025-01-21T19:59:13","guid":{"rendered":"https:\/\/webmasterei-prange.de\/set-up-google-search-console-bigquery-export\/"},"modified":"2025-09-23T22:16:12","modified_gmt":"2025-09-23T20:16:12","slug":"set-up-google-search-console-bigquery-export","status":"publish","type":"post","link":"https:\/\/webmasterei-prange.de\/en\/set-up-google-search-console-bigquery-export\/","title":{"rendered":"Set up Google Search Console BigQuery Export"},"content":{"rendered":"\n<p>Google Search Console offers a powerful Bulk Data Export feature that allows website operators to store and analyze extensive search data in Google BigQuery. In this blog post, you&#8217;ll learn how to set up and optimally use the Bulk Data Export in Google Search Console. <\/p>\n\n<h3 class=\"wp-block-heading\" id=\"toc_Warum_Bulk_Data_Export_nutzen\"><strong>Why use Bulk Data Export?<\/strong><\/h3>\n\n<p>Bulk Data Export enables:<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>In-depth analyses<\/strong> through more comprehensive data than in standard reports.<\/li>\n\n\n\n<li><strong>Automation of reports<\/strong> through direct integration with Google BigQuery.<\/li>\n\n\n\n<li><strong>Long-term data storage<\/strong>, which is otherwise only available in Search Console for a limited time.<\/li>\n<\/ul>\n\n<h3 class=\"wp-block-heading\" id=\"toc_SchrittfurSchrittAnleitung_zur_Einrichtung_des_Search_Console_BigQuery_Export\"><strong>Step-by-step guide to setting up the Search Console BigQuery Export<\/strong><\/h3>\n\n<p><strong>This guide has been derived from the <a href=\"https:\/\/support.google.com\/webmasters\/answer\/12917675?hl=en&amp;ref_topic=12917674&amp;sjid=10640303135094517858-EU\" target=\"_blank\" rel=\"noreferrer noopener\">official instructions<\/a>.<\/strong><\/p>\n\n<h4 class=\"wp-block-heading has-theme-palette-5-color has-text-color has-link-color wp-elements-8bf018d8c6fe5c3c50275b02494a7520\" id=\"toc_1_Google_CloudProjekt_einrichten\"><strong>1. Set up Google Cloud Project<\/strong><\/h4>\n\n<p>Before you can use Bulk Data Export, you need a <a href=\"https:\/\/developers.google.com\/workspace\/guides\/create-project?hl=de\" target=\"_blank\" rel=\"noreferrer noopener\">Google Cloud Project<\/a>:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Log in to the <a>Google Cloud Console<\/a>.<\/li>\n\n\n\n<li>Create a new project or use an existing one.<\/li>\n\n\n\n<li>Ensure that BigQuery is enabled, as the data will be stored there.<\/li>\n<\/ul>\n\n<h4 class=\"wp-block-heading has-theme-palette-5-color has-text-color has-link-color wp-elements-e650736e4c38c699a8b55d91da98199b\" id=\"toc_2_Bulk_Data_Export_in_Search_Console_aktivieren\"><strong>2. Activate Bulk Data Export in Search Console<\/strong><\/h4>\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Log in to Google Search Console:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Go to <a>Google Search Console<\/a>.<\/li>\n\n\n\n<li>Select the appropriate property.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Navigate to settings:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Click on <strong>Settings<\/strong> in the left menu bar.<\/li>\n\n\n\n<li>Scroll down and select <strong>Bulk Data Export<\/strong>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Connect Google Cloud Project:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Copy the <strong>Project ID<\/strong> (not the project number!) from the Google Cloud Console.<\/li>\n\n\n\n<li>Paste the ID into the <strong>Cloud Project ID<\/strong> field.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Choose Dataset name:<\/strong>\n<ul class=\"wp-block-list\">\n<li>By default, the name is <strong>searchconsole<\/strong>.<\/li>\n\n\n\n<li>If you&#8217;re exporting data from multiple properties, use individual names (e.g. <code>searchconsole_mywebsite_com<\/code>). <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Choose storage location for the Dataset:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Select a storage location from the list.<\/li>\n\n\n\n<li>Please note that the save location cannot be easily changed once the export has begun. For users from the EU, this should also be &#8220;EU.&#8221; <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Confirmation and start of export:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Click on <strong>Continue<\/strong> to complete the configuration.<\/li>\n\n\n\n<li>If there&#8217;s a problem (e.g., missing permissions), an error message will be displayed.<\/li>\n\n\n\n<li>The first export will occur within <strong>48 hours<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"849\" height=\"666\" src=\"https:\/\/webmasterei-prange.de\/wp-content\/uploads\/2025\/09\/google-searc-console-bigquery-export.png.webp\" alt=\"Google searc console bigquery export.png\" class=\"wp-image-1222\"\/><\/figure>\n\n<h5 class=\"wp-block-heading has-theme-palette-5-color has-text-color has-link-color wp-elements-2bccbea0d1bfae7deba7a9fe1aa5b3d6\">Search Console BigQuery Export<\/h5>\n\n<h3 class=\"wp-block-heading\" id=\"toc_Was_passiert_nach_der_Einrichtung\"><strong>What happens after setup?<\/strong><\/h3>\n\n<ul class=\"wp-block-list\">\n<li><strong>Daily export:<\/strong> Search Console automatically exports the data every day.<\/li>\n\n\n\n<li><strong>Error handling:<\/strong> If there&#8217;s a non-critical error, the export will be attempted again the next day.<\/li>\n\n\n\n<li><strong>Data structure:<\/strong> After the first export, table partitions can be adjusted. Changes to the schema (e.g., adding new columns) should be avoided as this can interrupt the export. <\/li>\n\n\n\n<li><strong>Historical data:<\/strong> For older data from before setup, the Search Console API or standard reports must be used.<\/li>\n<\/ul>\n\n<h3 class=\"wp-block-heading\" id=\"toc_Fazit\"><strong>Conclusion<\/strong><\/h3>\n\n<p>The Google Search Console Bulk Data Export is a valuable feature for SEO professionals and data analysts who want to gain comprehensive insights into their website&#8217;s search performance. With this guide, you can quickly and efficiently set up the export and thus utilize valuable data for your analyses in the long term. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Search Console offers a powerful Bulk Data Export feature that allows website operators to store and analyze extensive search data in Google BigQuery. In this blog post, you&#8217;ll learn how to set up and optimally use the Bulk Data Export in Google Search Console. Why use Bulk Data Export?&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","slim_seo":{"title":"Set up Google Search Console BigQuery Export - Webmasterei Prange","description":"Google Search Console offers a powerful Bulk Data Export feature that allows website operators to store and analyze extensive search data in Google BigQuery. In"},"footnotes":""},"categories":[28,26],"tags":[],"class_list":["post-1887","post","type-post","status-publish","format-standard","hentry","category-big-query","category-data-management"],"taxonomy_info":{"category":[{"value":28,"label":"Big Query"},{"value":26,"label":"Data management"}]},"featured_image_src_large":false,"author_info":{"display_name":"admin","author_link":"https:\/\/webmasterei-prange.de\/en\/author\/admin\/"},"comment_info":0,"category_info":[{"term_id":28,"name":"Big Query","slug":"big-query","term_group":0,"term_taxonomy_id":28,"taxonomy":"category","description":"","parent":0,"count":12,"filter":"raw","cat_ID":28,"category_count":12,"category_description":"","cat_name":"Big Query","category_nicename":"big-query","category_parent":0},{"term_id":26,"name":"Data management","slug":"data-management","term_group":0,"term_taxonomy_id":26,"taxonomy":"category","description":"","parent":0,"count":3,"filter":"raw","cat_ID":26,"category_count":3,"category_description":"","cat_name":"Data management","category_nicename":"data-management","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/posts\/1887","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/comments?post=1887"}],"version-history":[{"count":1,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/posts\/1887\/revisions"}],"predecessor-version":[{"id":1888,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/posts\/1887\/revisions\/1888"}],"wp:attachment":[{"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/media?parent=1887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/categories?post=1887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webmasterei-prange.de\/en\/wp-json\/wp\/v2\/tags?post=1887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}