How to Use Case Statements in Looker Studio for SEO Reporting (Part 1)

In this video you’ll learn what a case statement is and how to use it in Looker Studio to create a report separating your brand and non-brand organic search data from Search Console. You’ll see how to connect your Search Console data to Looker and you’ll also learn how to add a calculated field to your report.

Our guest instructor is Nico Brooks. Nico is the Co-CEO and Head of Analytics at Two Octobers, a Certified B Corporation based in Denver Colorado that focuses on analytics, SEO, and media. In addition to loving case statements, Nico is passionate about apprenticeship as a means for providing good jobs for good people.

Here's the link to Part 2 of the SEO Reporting series in Looker:    • How to use Regex in Looker Studio for...  

You can learn more about Nico using the links below.

Website: https://twooctobers.com/nico-brooks/
YouTube:    / @twooctobers  
LinkedIn:   / nicobrx  
Apprenticeship at TwoOctobers: https://twooctobers.com/digital-marke...

Thanks for watching.

Any ad revenue from this video is being donated to support apprenticeship programs. https://www.jff.org/


Root and Branch offers free digital marketing training and tips focused on Google Analytics, Google Ads, Google Tag Manager, and SEO.