Google is rolling out a characteristic over the following week that may mean you can automate a each day bulk export of your Search Console efficiency knowledge to BigQuery. It will mean you can run advanced queries over your knowledge to an exterior storage service, the place you are able to do deeper evaluation in a extra automated vogue, Google announced.
The export. Google mentioned you might configure an export in Google Search Console “to get a each day knowledge dump into your BigQuery venture.” This consists of all your Search Console efficiency knowledge however not the anonymized queries. The each day knowledge row restrict doesn’t affect this knowledge, so you may extract extra knowledge utilizing this technique.
The cool half is not only the discount of knowledge limits but in addition that that is an ongoing each day export that may be automated.
Who this helps. Google mentioned that is doubtless extra useful for bigger websites with bigger datasets. “This knowledge export may very well be notably useful for giant web sites with tens of 1000’s of pages, or these receiving site visitors from tens of 1000’s of queries a day (or each!),” Google wrote.
Methods to export. Google created a help document to stroll you thru tips on how to export your knowledge to BigQuery, it’s considerably technical, and chances are you’ll want help from a developer or programmer. The upper-level phases of this work as follows:
- Put together your Cloud venture (inside Google Cloud Console): this consists of enabling the BigQuery API on your venture and giving permission to your Search Console service account.
- Set export vacation spot (inside Search Console): this consists of offering your Google Cloud venture ID, and selecting a dataset location. Notice that solely property house owners can arrange a bulk knowledge export.
This export is each day, and the primary time it is going to begin inside 48 hours. If the export simulation fails, it is best to obtain a direct alert on the problem detected; right here’s a listing of possible export errors.
The information. Google supplied a fast description of the three tables that will likely be accessible to you:
searchdata_site_impression: This desk comprises knowledge aggregated by property, together with question, nation, sort, and machine.
searchdata_url_impression: This desk comprises knowledge aggregated by URL, which allows a extra detailed view of queries and wealthy outcomes.
ExportLog: This desk is a file of what knowledge was saved for that day. Failed exports are usually not recorded right here.
BigQuery. BigQuery is Google’s absolutely managed, serverless knowledge warehouse that allows scalable evaluation over petabytes of knowledge. It’s a service that helps querying utilizing ANSI SQL. It additionally has built-in machine studying capabilities.
Why we care. The extra knowledge you’ve got entry to in your personal platform, the extra you are able to do with evaluation of your search efficiency. Meaning you may slice and cube your knowledge in methods you most likely couldn’t prior. This could mean you can develop new concepts to enhance your web site and person expertise.
Additionally, third-party knowledge instruments might discover helpful methods to construct out new studies with this. Google mentioned, “We hope that by making extra Google Search knowledge accessible, web site house owners and SEOs will have the ability to discover extra content material alternatives by analyzing long-tail queries. It’ll additionally make it simpler to hitch page-level data from inside techniques to Search ends in a simpler and complete means.”