Bulk data exports: Tables and tips - Google Search Console Training

preview_player
Показать описание
In this episode of Search Console Training, Daniel Waisberg shares what data is available in Google BigQuery after you successfully set up a bulk data export. Learn about the table schema, SQL tips, and best practices when querying the data.

Resources:

Chapters:
00:00 - Introduction
1:17 - Table guidelines and reference
3:54 - Query guidelines and sample queries

#Search #SearchConsole #BigQuery #data
Рекомендации по теме
Комментарии
Автор

In the end of the video, you mention that bulk exports can be utilized for machine learning, clustering, statistical modeling, etc. Would be very interesting to see a video from you with (detailed) examples of this type of advanced usage of GSC data.

danielaarupkristensen
Автор

Does anyone know how to resolve this:
Oops! Something went wrong We had a problem submitting your indexing request. Please try again later

noorshaikh
Автор

The query example at 4:10 really should have a DESC in the ORDER BY clause, else its just 100 zeros with the LIMIT 100.

FelixHenriksen