Google is rolling out a function over the subsequent week that can let you automate a day by day bulk export of your Search Console efficiency knowledge to BigQuery. It will let you run complicated 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 stated you possibly can configure an export in Google Search Console “to get a day by day knowledge dump into your BigQuery mission.” This consists of your whole Search Console efficiency knowledge however not the anonymized queries. The day by day knowledge row restrict doesn’t influence this knowledge, so you may extract extra knowledge utilizing this methodology.
The cool half isn’t just the discount of knowledge limits but in addition that that is an ongoing day by day export that may be automated.
Who does this assist. Google stated that is seemingly extra useful for bigger websites with bigger datasets. “This knowledge export could possibly be significantly useful for big web sites with tens of hundreds of pages, or these receiving visitors from tens of hundreds of queries a day (or each!),” Google wrote.
How one can export. Google created a help document to stroll you thru find out 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 mission (inside Google Cloud Console): this consists of enabling the BigQuery API to your mission and giving permission to your Search Console service account.
- Set export vacation spot (inside Search Console): this consists of offering your Google Cloud mission ID, and selecting a dataset location. Word that solely property homeowners can arrange a bulk knowledge export.
This export is day by day, and the primary time it’s going to begin inside 48 hours. If the export simulation fails, it’s best to obtain a right away alert on the difficulty detected; right here’s a listing of possible export errors.
The information. Google offered a fast description of the three tables that will likely be obtainable to you:
searchdata_site_impression: This desk accommodates knowledge aggregated by property, together with question, nation, sort, and gadget.
searchdata_url_impression: This desk accommodates knowledge aggregated by URL, which allows a extra detailed view of queries and wealthy outcomes.
ExportLog: This desk is a document of what knowledge was saved for that day. Failed exports are usually not recorded right here.
Why we care. The extra knowledge you have got entry to in your personal platform, the extra you are able to do with evaluation of your search efficiency. Which means you may slice and cube your knowledge in methods you most likely couldn’t prior. This could let you develop new concepts to enhance your web site and person expertise.
Additionally, third-party knowledge instruments could discover helpful methods to construct out new reviews with this. Google stated, “We hope that by making extra Google Search knowledge obtainable, web site homeowners and SEOs will be capable to discover extra content material alternatives by analyzing long-tail queries. It’ll additionally make it simpler to hitch page-level info from inner methods to Search leads to a simpler and complete method.”