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/)

In this episode, I talk with my friend Adrijana, an SEO mindset coach who recently made the bold decision to leave her dream job and pursue coaching full-time.

We dive into:

✅ Adrijana's journey from stressed SEO consultant to mindset coach
✅ How she overcame fears and cultural expectations to quit her job
✅ The importance of aligning work with personal values like freedom and family
✅ Practical strategies for managing stress and improving work-life balance in SEO
✅ Why mindset coaching is particularly valuable for SEO professionals
✅ Tips for those considering leaving their jobs to start their own business
✅ The misconceptions about money and job security

As someone who made a similar leap, I relate deeply to Adrijana's experience. Whether you're considering a career change or simply want to improve your work-life balance, this conversation offers valuable insights for SEOs at all stages.

• https://www.linkedin.com/in/adrijana-vujadin/
• https://www.youtube.com/@coaching_for_SEO_professionals

I will be happy if you check the below resources about me and my sponsors:

• My SEO newsletter: https://seosly.io/
• My SEO course: https://seosly.com/seo-course/
• Cora SEO tool (25% OFF): https://seosly.com/cora

👉 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 John Wright, a professional in the iGaming industry. John shares his unconventional journey from engineering to professional gambling, and eventually to SEO consulting for online casinos and gambling affiliates. The conversation delves into the complexities of SEO in the iGaming space, including data-driven decision making, the impact of Google's algorithm updates, and innovative strategies for building authoritative content. John also discusses his current venture, Stats Drone, a comprehensive software solution tailored for gambling affiliates, and touches upon responsible gambling initiatives.

👉 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/)

Watch the video version: https://youtu.be/j9LMpZesI1o

In this video, I dive into the details of Google’s core algorithm updates, with a specific focus on the August 2024 core update. I explain what these updates are, how they impact your website's traffic, and why they should not be seen as penalties but rather as algorithmic adjustments. I share insights into the changes Google is making, including their emphasis on content that is genuinely useful to users. I also offer practical advice on how to approach these updates, what to avoid, and the importance of waiting until the update fully rolls out before making any drastic changes to your SEO strategy. If you're navigating the complexities of Google's updates and looking for ways to optimize your site in light of these changes, this video is for you.

My SEO newsletter: https://seosly.io/

My SEO course: https://seosly.com/seo-course/

Cora SEO tool (25% OFF): https://seosly.com/cora

👉 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 dive deep into the importance of proper heading structure on the example of lawyer websites. I'll review random pages that show up in Google search results and analyze their headings. You will learn about common mistakes, best practices, and why headings matter for SEO. I'll also share some practical tips using tools like the Cora SEO tool to help you optimize your headings effectively.

• Check my full lawyer SEO guide: https://seosly.com/blog/lawyer-seo/
• 25% OFF Cora: https://seosly.com/cora
• Introduction to Cora SEO tool: https://seosly.com/blog/cora-seo-tool/

👉 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 video, I dive deep into the importance of internal linking for lawyer websites and other local businesses. As an SEO expert with over 12 years of experience, including a significant focus on the legal industry, I've seen firsthand how proper internal linking can dramatically impact a website's SEO performance.

You'll learn why using keyword-rich anchor text is crucial, how to avoid the common pitfalls of "read more" links, and why alt text for image links is a must. I'll also share insights on how to use tools like Cora to refine your internal linking strategy and boost your site's rankings.

If you're looking to improve your site's SEO, this video is a must-watch! Want to take your SEO skills to the next level? Check out my SEO Audit Mastery Course, where I share my entire SEO audit methodology, refined over 12+ years in the industry.

The course covers everything from the basics of SEO audits to advanced tactics that can help you charge $5K+ for an audit. You’ll get lifetime access, regular updates, and direct access to me through live Q&A sessions and community discussions.

Sign up today and transform your SEO career!

👉 Enroll in SEO Audit Mastery: https://seosly.com/seo-course/

👉 Subscribe to my SEO newsletter: https://seosly.io

Watch the video version of this podcast: https://youtu.be/t5CQzXUCGYw

Don't forget to subscribe to my channel and hit the notification bell so you never miss an update!

👉 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/)