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 Lo...
You can learn more about Nico using the links below.
Website: twooctobers.com/nico-brooks/
RU-vid: / @twooctobers
LinkedIn: / nicobrx
Apprenticeship at TwoOctobers: twooctobers.com/digital-marke...
Thanks for watching.
Any ad revenue from this video is being donated to support apprenticeship programs. www.jff.org/
Root and Branch offers free digital marketing training and tips focused on Google Analytics, Google Ads, Google Tag Manager, and SEO.