How to Automate Branded Search Reporting in Data Studio

With Google Data Studio and the Google Search Console connector you can segment queries between brand vs. non-brand.

It’s great for general reporting, opportunity spotting & PPC/SEO testing if bidding on branded terms.

To do this just create a custom field and add this formula:

CASE
WHEN REGEXP_CONTAINS (Query, "Brand") THEN 'Branded'
ELSE "Non-branded"
END

You’ll want to test at first then refine to make sure you’re capturing all relevant queries i.e. spelling errors.

Using this logic and basic regex you can further segment for elements like intent, categorisation and more. 

You can also supercharge this to make your dashboards quicker & dynamic with linking this up with BigQuery. 

Here’s some similar resources on how to segment queries and use Google Data Studio:

Feel free to share in the comment how you report on branded search