This page is about my talks at BrightonSEO, sorted by the most recent first.
Log Data + GSC + Big Query
The idea of this talk is to use the BigQuery 101 talk as a base and build on it to merge Log Files and GSC data together.
Below you’ll find auxiliary links. Her I leave all the reference links I have, in case you land on this page and are interested in knowing more 🙂 (how helpful is that content… I wonder if search engines like helpful content these days)
More links:
- BigQuery Cost -> https://www.linkedin.com/posts/analyticsnerd_bigquery-ga4-activity-7074703772538527744-Vd_n/
- Saji Linkedin -> https://www.linkedin.com/in/sajjad-azizzadeh-fahimi/?originalSubdomain=de
- Log Files via SFTP -> https://support.cloudways.com/en/articles/5124068-how-to-view-application-logs-via-ssh-sftp​
- Robots.txt with 5xx errors -> https://www.seroundtable.com/500-code-robots-google-34567.html
- My Linkedin post about Screaming Frog Segments -> https://www.linkedin.com/posts/activity-7161297356410208256-SA1t
Also, take a look at the links from the other talk, as they might be relevant to this topic.
Video:
BigQuery 101 for SEOs to use Google Search Console (September 2023).
The idea of the talk is to share some of my learnings in the past year since I started stumbling around to get all the insights I needed.
I’m not a BigQuery expert, but if you have questions, please send me a LinkedIn message :).
More links:
- BigQuery Cost -> https://www.linkedin.com/posts/analyticsnerd_bigquery-ga4-activity-7074703772538527744-Vd_n/
- BigQuery Efficiency -> https://developers.google.com/search/blog/2023/06/bigquery-efficiency-tips
- Bulk Data Export for GSC -> https://www.shtros.com/google-search-consoles-bulk-data-export-for-bigquery/
- SQL for SEO Automation -> https://codingisforlosers.com/why-learn-sql-for-seo/
- How to use BigQuery for SEO -> https://gofishdigital.com/blog/how-to-use-bigquery-with-google-search-console/
- More detailed data from GSC -> https://www.searchviu.com/en/google-search-console-export-data-to-bigquery/
Video: https://www.youtube.com/watch?v=PNtKbGz_HVs&t=4s