How to Query Google Search Console Data in BigQuery?

Updated: June 11th, 2025 Google Search Console is one of the go-to tools for figuring out what content to create next. However, one major limitation is that the interface only displays the top 1,000 search queries, which can be quite restrictive when trying to get a comprehensive view of your site’s performance. One workaround is […]
Julius Fedorovicius
In BigQuery

BigQuery shows more purchases than Google Analytics 4

If you have linked your Google Analytics 4 property to BigQuery, you might notice discrepancies between the data you see in the GA4 UI and what is available in BigQuery. This includes e-commerce data, where you may see a higher number of purchases in BigQuery compared to GA4. Weird, right? So, if you are wondering […]
Julius Fedorovicius
In BigQuery Google Analytics Tips