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.
“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/