{"id":6572,"date":"2024-05-05T18:42:47","date_gmt":"2024-05-05T16:42:47","guid":{"rendered":"https:\/\/chartud.io\/blog\/how-to-separate-brand-queries-in-looker-studio-with-data-from-google-search-console\/"},"modified":"2025-09-16T16:47:47","modified_gmt":"2025-09-16T14:47:47","slug":"separar-queries-marca","status":"publish","type":"post","link":"https:\/\/chartud.io\/en\/blog\/separar-queries-marca\/","title":{"rendered":"How to Separate Brand Queries in Looker Studio with Data from Google Search Console?"},"content":{"rendered":"\n

When we analyze data from Google Search Console<\/a>, queries are fundamental. Clicks, impressions, average position, CTR… And there is something that is often not done: separating branding terms from non-branding terms in the analyses. <\/p>\n\n\n\n

In this brief tutorial, I am going to explain how you can do it in several ways<\/strong> in Looker Studio.<\/p>\n\n\n\n

    \n
  1. Creating a custom dimension<\/li>\n\n\n\n
  2. Creating predefined boolean filters<\/a> in buttons<\/li>\n\n\n\n
  3. With filters directly in graphs<\/li>\n<\/ol>\n\n\n\n

    And also at the end of the post I leave you a video so you can see how it’s done.<\/p>\n\n\n\n

    \ud83d\udc49Check out our selection of Looker Studio templates<\/strong><\/a><\/p>\n\n\n\n

    Separate Branding Queries with a Custom Dimension or Field.<\/h2>\n\n\n\n

    If what we want is to visualize the data related to brand keywords<\/strong> from those that are not, in table, circular, bar type graphs… Clearly seeing the data of the metric we want (clicks, impressions, ctr, average position) for each type of queries, this is the best way. <\/p>\n\n\n\n

    Creating a custom field<\/strong> will give you more versatility when creating graphs using this comparison. <\/p>\n\n\n\n

    Also, keep in mind that once you create the custom field you can use it whenever you want in that report<\/strong>, like any other dimension.<\/p>\n\n\n\n

    In this image we see 2 tables. In the first one we are seeing separately the clicks on terms that are not brand (non-brand) and those of brand (brand). <\/p>\n\n\n\n

    In the second table<\/strong> we see the queries but also using a second dimension, which is the custom field that we are going to create.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    In both tables the new dimension comes into play.<\/p>\n\n\n\n

    Steps to create this custom field:<\/strong><\/p>\n\n\n\n

      \n
    1. In the Data section, click on \u201cAdd a field\u201d<\/strong> > Add calculated field<\/strong><\/li>\n\n\n\n
    2. Put the name of the field. For example \u201cBrand vs non-brand\u201d<\/strong> <\/li>\n\n\n\n
    3. In the formula, enter the formula that you will see a couple of lines below.<\/li>\n\n\n\n
    4. Enter in the formula the different variants of your brand name. I recommend that you check in Search Console how they search for your brand (sometimes you are surprised). <\/li>\n\n\n\n
    5. Click on Save<\/li>\n\n\n\n
    6. Select the custom dimension in the graph you want.<\/li>\n<\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      This is the formula you can use:<\/p>\n\n\n\n

      CASE
       WHEN REGEXP_MATCH(Query, \u201c.*brand name.*|.*brandname.com.*|.*variation.*|.*variation2.*\u201d) THEN \u201cBrand\u201d
       ELSE \u201cNon-Brand\u201d
      END<\/pre>\n\n\n\n
      Note that in this case the formula contains \u201cRegexp_match\u201d, that is, we ask it to match those variants.<\/p>\n\n\n\n
      Another way to do it is with regexp_contains. In this way we tell it to contain what we indicate. For example:  <\/p>\n\n\n\n
      CASE
       WHEN REGEXP_CONTAINS(Query, \u201cchartud\u201d) THEN \u201cBrand\u201d
       ELSE \u201cNon-Brand\u201d
      END<\/pre>\n\n\n\n
      This way we get that if someone searches for \u201cchartudio\u201d or \u201cchartud.io\u201d it also includes it.<\/p>\n\n\n\n
      <\/p>\n\n\n\n
      Creating Predefined Boolean Filters in Buttons<\/h2>\n\n\n\n
      This way of doing it is especially good when we have a series of data represented in different graphs and we want to filter them at a certain moment.<\/p>\n\n\n\n
      For example, in this set I want to filter at a given moment by brand queries, or on the contrary only by queries that are not brand. In addition, being able to activate and deactivate that \u201cfilter\u201d when I want. <\/p>\n\n\n\n
      We are going to do it by means of a button, which we can find in the upper bar > Add a control<\/strong>.<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      In this button we are going to create a custom field as a \u201ccontrol field\u201d.<\/p>\n\n\n\n
      It must be of type \u201cboolean\u201d<\/a> so first we are going to create a button for brand queries<\/strong> and another for those that are not.<\/strong><\/p>\n\n\n\n
        \n
      1. Enter the name.<\/li>\n\n\n\n
      2. In the formula use the formula that I leave you below and put the name of your brand.<\/li>\n\n\n\n
      3. Click on Apply.<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Formula:<\/p>\n\n\n\n
        REGEXP_CONTAINS(Query, \u201cchartud\u201d)<\/pre>\n\n\n\n
        Remember that as before, you can use regexp_contains or regexp_match depending on what you need. <\/p>\n\n\n\n
        My advice?<\/strong> Analyze how they search for you and do tests.<\/p>\n\n\n\n
        I leave you this article where you have regular expressions that you can use in Looker Studio.<\/a><\/p>\n\n\n\n
        Another aspect to take into account when creating these buttons are the groups.<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        The groups serve to be able to use buttons that filter within the same scope correctly. <\/p>\n\n\n\n
        For example, if I want to see first the data filtered by brand keywords and then the opposite, if I group the two buttons in group 1, for example, when I activate one, the other will be deactivated.<\/p>\n\n\n\n
        This will allow you to filter saving clicks and without giving you errors. <\/p>\n\n\n\n
        Now you will have to repeat the same process. Create a new button and this time enter the formula: <\/p>\n\n\n\n
        NOT REGEXP_CONTAINS(Query, \u201cchartud\u201d)<\/pre>\n\n\n\n
        Or the own one but with regexp_match.<\/p>\n\n\n\n
        Now you will have the two buttons ready to separate your brand keywords from those that are not.<\/p>\n\n\n\n
        With filters directly in graphs<\/h2>\n\n\n\n
        This way is simpler than the previous two. <\/p>\n\n\n\n
        I’m not going to tell you about it here. You can see it in the video where I show you the 3 different ways to do it: <\/p>\n\n\n\n
        \n