BigQuery + SEO: A Data-Driven Duo (With Myriam Jessier)
In this episode of SEO Cash Flow, it’s me, Olga Zarr, teaming up with Myriam Jessier to tackle BigQuery for SEOs.
We’re diving into how you can pull more insights out of Google Search Console data without turning into a data scientist. Myriam’s going all-in on learning BigQuery, while I’m sticking to my minimalist, ADHD-friendly approach—keeping it simple, powerful, and quick.
We chat about why BigQuery isn’t as scary as it seems and how it can give you way more control over your data, letting you see past the usual Google limits.
This is for SEOs who want that edge without a ton of fuss or coding. If you’ve been wanting to get into BigQuery but didn’t know where to start, this episode is your roadmap.
The tool I use for BigQuery access: https://seosly.com/seo-crawl
Follow Myriam Jessier:
https://myriamjessier.com/en
https://www.neurospicy.agency/
I will be happy if you check the below resources about me and my sponsors:
🔥 Join my SEO newsletter: https://seosly.io/
🔥 Check Cora (25% OFF): https://seosly.com/cora
Follow Olga Zarr or hire Olga to help you with SEO
👉 Follow me on X: https://x.com/olgazarr
👉 Follow me on LinkedIn: / olgazarr
👉 My SEO Podcast: https://seosly.com/podcast/
👉 You can hire me: https://seosly.com/hire-me/
👉 Want to learn more about me? Check this: https://seosly.com/seo-consultant/
👉 Want to contact me? Feel free to reach out at [email protected]
00:00 Introduction and Setting the Scene
00:40 Challenges in Selling SEO Services
01:18 Exploring BigQuery: Public vs. Private Learning
01:38 Minimalist Approach to BigQuery
03:24 Tool Features and Benefits
04:16 Setting Up and Using the Tool
05:22 Advanced Data Analysis with BigQuery
07:32 Skills and Value in SEO
09:52 Integrating Multiple Data Sources
11:42 Balancing Technical and Creative SEO
16:34 Deciding Your Focus in SEO
17:54 The Barbecue Analogy: Starting with BigQuery
18:26 Mastering SQL for BigQuery
19:03 Understanding Data Architecture
19:50 Integrating Data Sources and Tools
20:21 Data Privacy and Compliance
21:10 Deciding Your Level of Involvement
22:24 Real-Life Example: Real Estate Client
24:58 Using Data to Improve Business Metrics
26:44 Spotify's Data-Driven Genre Classification
31:52 Delivering Actionable Recommendations
32:49 Final Thoughts and Resources