![\"\"](\"https:\/\/www.pandraus.com\/wp-content\/uploads\/2024\/02\/image-5-1024x585.png\" "\\"\\"")
<\/figure>\n\n\n\nBelow 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 \ud83d\ude42 (how helpful is that content… I wonder if search engines like helpful content these days)<\/p>\n\n\n\n
More links: <\/p>\n\n\n\n
- \n
- BigQuery Cost -> https:\/\/www.linkedin.com\/posts\/analyticsnerd_bigquery-ga4-activity-7074703772538527744-Vd_n\/<\/a><\/li>\n\n\n\n
- Saji Linkedin -> https:\/\/www.linkedin.com\/in\/sajjad-azizzadeh-fahimi\/?originalSubdomain=de<\/a><\/li>\n\n\n\n
- Log Files via SFTP -> https:\/\/support.cloudways.com\/en\/articles\/5124068-how-to-view-application-logs-via-ssh-sftp\u200b<\/a><\/li>\n\n\n\n
- Robots.txt with 5xx errors -> https:\/\/www.seroundtable.com\/500-code-robots-google-34567.html<\/a><\/li>\n\n\n\n
- My Linkedin post about Screaming Frog Segments -> https:\/\/www.linkedin.com\/posts\/activity-7161297356410208256-SA1t<\/a><\/li>\n<\/ul>\n\n\n\n
Also, take a look at the links from the other talk, as they might be relevant to this topic. <\/p>\n\n\n\n
“BigQuery 101 for SEOs to use Google Search Console” (September 2023). <\/h2>\n\n\n\n
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. <\/p>\n\n\n\n
\nSlides link<\/a><\/div>\n\n\n\nSpreadsheet link<\/a><\/div>\n\n\n\nLinkedin<\/a><\/div>\n\n\n\nBQ Group<\/a><\/div>\n\n\n<\/div>\n\n\n\n![\"\"](\"https:\/\/www.pandraus.com\/wp-content\/uploads\/2023\/07\/image-1024x582.png\" "\\"\\"")
<\/figure>\n\n\n\nI’m not a BigQuery expert, but if you have questions, please send me a LinkedIn message :).<\/p>\n\n\n\n
More links: <\/p>\n\n\n\n
- \n
- BigQuery Cost -> https:\/\/www.linkedin.com\/posts\/analyticsnerd_bigquery-ga4-activity-7074703772538527744-Vd_n\/<\/a><\/li>\n\n\n\n
- BigQuery Efficiency -> https:\/\/developers.google.com\/search\/blog\/2023\/06\/bigquery-efficiency-tips<\/a><\/li>\n\n\n\n
- Bulk Data Export for GSC -> https:\/\/www.shtros.com\/google-search-consoles-bulk-data-export-for-bigquery\/<\/a><\/li>\n\n\n\n
- SQL for SEO Automation -> https:\/\/codingisforlosers.com\/why-learn-sql-for-seo\/<\/a><\/li>\n\n\n\n
- How to use BigQuery for SEO -> https:\/\/gofishdigital.com\/blog\/how-to-use-bigquery-with-google-search-console\/<\/a><\/li>\n\n\n\n
- More detailed data from GSC -> https:\/\/www.searchviu.com\/en\/google-search-console-export-data-to-bigquery\/<\/a><\/li>\n<\/ul>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
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…<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"disable","_kad_post_title":"show","_kad_post_layout":"default","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"default","_kad_post_feature_position":"behind","_kad_post_header":true,"_kad_post_footer":false,"footnotes":""},"_links":{"self":[{"href":"https:\/\/www.pandraus.com\/wp-json\/wp\/v2\/pages\/230207"}],"collection":[{"href":"https:\/\/www.pandraus.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.pandraus.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.pandraus.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pandraus.com\/wp-json\/wp\/v2\/comments?post=230207"}],"version-history":[{"count":15,"href":"https:\/\/www.pandraus.com\/wp-json\/wp\/v2\/pages\/230207\/revisions"}],"predecessor-version":[{"id":230319,"href":"https:\/\/www.pandraus.com\/wp-json\/wp\/v2\/pages\/230207\/revisions\/230319"}],"wp:attachment":[{"href":"https:\/\/www.pandraus.com\/wp-json\/wp\/v2\/media?parent=230207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- BigQuery Efficiency -> https:\/\/developers.google.com\/search\/blog\/2023\/06\/bigquery-efficiency-tips<\/a><\/li>\n\n\n\n
- Saji Linkedin -> https:\/\/www.linkedin.com\/in\/sajjad-azizzadeh-fahimi\/?originalSubdomain=de<\/a><\/li>\n\n\n\n