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.

👉 https://myriamjessier.com/en
👉 https://www.neurospicy.agency/

👉 Follow Olga Zarr X (https://x.com/olgazarr)
👉 Follow Olga Zarr on LinkedIn (https://www.linkedin.com/in/olgazarr/)
👉 SEO newsletter (https://seosly.io/)
👉 SEO podcast (https://seosly.com/podcast/)
👉 SEO consultant Olga Zarr (https://seosly.com/seo-consultant/)
👉 The best SEO course (https://seosly.com/seo-course/)

In this episode, I interview David from SEO Crawl about recent updates to their SEO tool. We explore how SEO Crawl can help SEO workflows and provide more accurate data compared to some other popular tools in the market.

Key points discussed:

• SEO Crawl's ability to access 100% of Search Console data, offering more comprehensive insights
• Automated brand vs non-brand keyword tracking setup, which significantly reduces manual work
• Custom annotations feature for tracking the impact of SEO changes over time

Upcoming features, including automated search intent classification and improved reporting capabilities The conversation highlights how SEO Crawl can potentially consolidate multiple tools into one platform, offering both data analysis and actionable insights.

This episode offers valuable insights for SEO professionals at all levels, from beginners to experienced practitioners. It provides a comprehensive overview of SEO Crawl's capabilities and its potential to improve SEO workflows. David also mentions an upcoming book on SEO reporting, which may be of interest to those looking to enhance their reporting processes.

Check SEOcrawl: https://seosly.com/seocrawl

👉 Follow Olga Zarr X (https://x.com/olgazarr)
👉 Follow Olga Zarr on LinkedIn (https://www.linkedin.com/in/olgazarr/)
👉 SEO newsletter (https://seosly.io/)
👉 SEO podcast (https://seosly.com/podcast/)
👉 SEO consultant Olga Zarr (https://seosly.com/seo-consultant/)
👉 The best SEO course (https://seosly.com/seo-course/)

In this episode, I explain how to analyze and diagnose website traffic and ranking drops. I walk you through the most common causes, such as Google core updates, failed website migrations, and site redesigns. I show you how to differentiate between traffic and ranking drops and why it’s important to understand the difference. You learn step-by-step how to pinpoint what’s affecting your website’s performance, whether it’s an algorithm change, a technical SEO issue, or something else.

The Cora SEO Tool that I mention in the video:

🔥 Get Cora 25% OFF (the tool that changed my SEO): https://seosly.com/cora

Don't miss these related resources:

🔥 The written guide: https://seosly.com/blog/website-rankings-drop-audit/
🔥 My article on migrations: https://seosly.com/blog/how-to-migrate-without-losing-traffic-seo/
🔥 Website migration checklist: https://seosly.com/blog/seo-migration-checklist/

👉 Follow Olga Zarr X (https://x.com/olgazarr)
👉 Follow Olga Zarr on LinkedIn (https://www.linkedin.com/in/olgazarr/)
👉 SEO newsletter (https://seosly.io/)
👉 SEO podcast (https://seosly.com/podcast/)
👉 SEO consultant Olga Zarr (https://seosly.com/seo-consultant/)
👉 The best SEO course (https://seosly.com/seo-course/)