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/
UA-cam: / @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.

[@user-gp7hr1li2v]

Good guest thanks

[@rooted-digital]

Thanks for the feedback. Nico is a really smart (and good) guy. Hope to have him back sharing some more Looker stuff before too long.

[@andrzejandrzejos6674]

Great one! Would like to see more of content like this. What about landing page dashboard? I mean measuring clicks, video views, engagement, lead form openen, lead form sent

[@rooted-digital]

Glad you liked it. Nico will be back and teaching some more on a similar subject before too long.
You might find this video helpful on creating an events dashboard. If you follow the instructions here - and also filter to your landing page - you should be able to get what you're looking for. ua-cam.com/video/9G6MJ0t8cRI/v-deo.html Best of luck to you.