How To Use Search Console Bulk Data Export


Google Search Advocate Daniel Waisberg just lately introduced an in-depth video on bulk information exports, a characteristic that permits you to export, retailer, and analyze Search Console information.

This novel answer surpasses capabilities and makes managing huge information volumes a breeze.

Right here’s how.

An Overview of Present Knowledge-Exporting Options

Earlier than introducing the majority information export characteristic, Waisberg recapped the present strategies to export Search Console information.

Essentially the most accessible means is thru the consumer interface. You may instantly export as much as 1,000 rows of information with a easy click on on the export button.

Looker Studio and the API present options for folks requiring bigger information volumes. Each channels will let you retrieve efficiency information, URL inspection information, sitemaps, and web site information, with an export restrict of as much as 50,000 rows.

Introducing Bulk Knowledge Export

The ultimate and most superior technique to export information from Search Console is bulk information export.

This distinctive characteristic permits you to extract huge quantities of information by way of Google BigQuery with out row limits. That is useful for giant web sites with quite a few pages or in depth visitors.

Waisberg states, “A bulk information export is a scheduled each day export of your Search Console efficiency information. It contains all the info utilized by Search Console to generate efficiency stories. Knowledge is exported to Google BigQuery, the place you possibly can run SQL queries for superior information evaluation and even export it to a different system.”

Setting Up Bulk Knowledge Export

Given its complexity and energy, Bulk Knowledge Export requires current data of the Google Cloud Platform, BigQuery, and Search Console.

Remember that leveraging this instrument may incur prices, so it’s essential to think about the potential fees earlier than establishing a brand new export.

Organising a bulk information export entails Google Cloud and Search Console.

Step One: Google Cloud

First, swap to the related venture in Google Cloud and make sure the BigQuery API is enabled.

  1. Open your Google Cloud Console and swap to the venture you’re exporting information to.
  2. Navigate to APIs & Companies > Enabled APIs & Companies, and allow BigQuery API if it isn’t.
  3. Navigate to IAM and Admin, click on + GRANT ACCESS, and paste in New Principals.
  4. Grant two roles to this account: BigQuery Job Consumer and BigQuery Knowledge Editor, then Save.

Step Two: Search Console

In Search Console, full the next steps:

  1. Navigate to Settings > Bulk information export.
  2. Enter your Google Cloud venture ID into the Cloud venture ID subject.
  3. Select a dataset title. The default is ‘searchconsole’.
  4. Choose a location on your dataset. This will’t be simply modified later.
  5. Click on Proceed to begin the exports. The primary export will occur as much as 48 hours after profitable configuration.
  6. After desk creation, set a partition expiration if wanted however keep away from schema alterations.
  7. For historic information previous the preliminary setup, use Search Console API or stories.

Monitoring & Managing Knowledge Exports

The brand new information export system has a built-in characteristic that allows you to monitor information exports utilizing BigQuery. For instance, you possibly can observe exports utilizing an export log desk.

Be aware that information will accumulate indefinitely except you set an expiration time. The export course of will proceed till manually deactivated or if Search Console faces points.

In case of any errors, Search Console will notify all property house owners.

In Abstract

In conclusion, the majority information export characteristic can improve the way you handle giant quantities of Search Console information.

Keep tuned for upcoming content material from Google that may delve deeper into processing information after establishing export and finest practices for extracting information from BigQuery.

Supply: YouTube

Featured picture generated by the writer utilizing Midjourney.


Scroll to Top