{"id":4867,"date":"2021-02-16T10:00:00","date_gmt":"2021-02-16T07:00:00","guid":{"rendered":"https:\/\/trackingchef.com\/?p=4867"},"modified":"2021-02-15T17:39:47","modified_gmt":"2021-02-15T14:39:47","slug":"5-more-tips-to-levl-up-your-data-studio-game","status":"publish","type":"post","link":"https:\/\/trackingchef.com\/blog\/5-more-tips-to-levl-up-your-data-studio-game\/","title":{"rendered":"5 More Tips to Level Up Your Data Studio Game"},"content":{"rendered":"\n

Back by popular demand, after the roaring success of my previous post <\/a>I\u2019ve decided to share some more tips and tricks I use when working with Data Studio (Number 3 will shock you! Well, not really).<\/p>\n\n\n\n

So without further ado here are 5 more tips to level up your Data Studio game!<\/p>\n\n\n\n

Trick #1: The Index is Dead, Long Live the New Index<\/strong><\/h2>\n\n\n\n

Remember when I\u2019ve told you to create an index for all your dashboards<\/a>, since Google has done a half baked job with the admin panel of Data Studio? That was fun, but we can do better. The previous index was hard coded manually, meaning I\u2019ve literally added a hyperlink to each text\/dashboard name, which is laborious and not really scalable – It\u2019s time to level up.<\/p>\n\n\n\n

There are 2 solutions I\u2019ve thought of, choose the one that fits your case, they both make use of the hyperlink() function<\/a> in Data Studio. <\/p>\n\n\n\n

  1. The Google Analytics Way<\/strong><\/li><\/ol>\n\n\n\n

    If we wish to create a list of names with links why not use the data that\u2019s in GA already?<\/p>\n\n\n\n

    Since I\u2019m tracking all my dashboards with a designated Google Analytics  property, then the values of \u201cpage title\u201d are my dashboard titles and \u201cpage\u201d is their URL address. Now you need to create a new calculated field<\/a> with this formula:<\/p>\n\n\n\n

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

    Now you can create a table with the field you created, and presto! All your dashboards are here and hyperlinked. The best part? new dashboards you\u2019ll create will be added automatically to the table with their respective link (bye bye manual labor).<\/p>\n\n\n\n

    \"\"<\/figure><\/div>\n\n\n\n
    1. The Google Sheets Way<\/strong><\/li><\/ol>\n\n\n\n

      The previous way is good but not always enough. Since you can\u2019t add any custom dimension or metadata to this analytics property (if you found a way please let me know), then you’re kinda stuck when you want to classify your dashboards into types or groups. Now, while you can create a calculated field with a case that will act as a custom\/grouping dimension, it requires constant case maintenance. A better way would be to use the Google Sheets Analytics Add On<\/a>. Using this method you can create the following table:<\/p>\n\n\n\n

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

      You\u2019ll need to create an automated report that pulls the \u201cHostname\u201d, \u201cPage\u201d and \u201cPage Title\u201d fields, build rule-based classifications or groups, and then create a new tab with the above table. This requires more back-end building in Google Sheets, but with a bit of know-how and creative thinking you can set up a back-end solution for all your dashboards, that\u2019s easier to maintain (arguably) than a case inside Data Studio.<\/p>\n\n\n\n

      Trick #2: Data Sources and Filters Levels<\/strong><\/h2>\n\n\n\n

      When you first open a new Data Studio report, it asks you to connect to your data source of choice, be it Google Analytics, Excel, BigQuery, or whatnot, and then DS automatically creates the first visual in the form of a table. Since this is the default method of Data Studio we often just carry along and continue to add elements and visuals, manually connecting each one to our data source. HOLD ON! Manually connect each one? What am I? A peasant?! Stop this nonsense and start working with report level<\/a> or page level data source. By setting your data source to report level, all elements and visuals in that report are controlled from a single location, which makes life a lot easier for you.<\/p>\n\n\n\n

      When in \u201cEdit\u201d mode go to \u201cFile\u201d->\u201dReport Setting\u201d, then a panel will open on the right with a field for your \u201cData Source\u201d, simply select one and there you have it.<\/p>\n\n\n\n

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

      If you have many pages and you want to choose a different source to each one, then go to \u201cPage\u201d->\u201dPage Setting\u201d and choose a source for each page.<\/p>\n\n\n\n

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

      The same is true for filters – If you have a master filter that\u2019s applicable to the entire report or page, simply apply it via the same functions in the admin (it just below the data source sections).\u00a0<\/p>\n\n\n\n

      BUT WAIT!<\/strong> What if I have 5 elements with data source A and 2 elements with data source B? Or if I need to apply a specific filter to my graph that doesn\u2019t match the one I\u2019ve set to the entire report? Don\u2019t worry, Data Studio have you covered. In this case set source A on a page or report level, and then go to the specific element(s) you need and manually change the data source in there. In the case of filters, when choosing the element you want, and the \u201cdata\u201d tab, scroll way down to the filters section and deactivate the \u201cinherit filters\u201d and then add the filter you need.<\/p>\n\n\n\n

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

      Trick #3: The Correct Place for Your Case<\/strong><\/h2>\n\n\n\n

      One of the most useful functions there is, creating a CASE helps us when trying to bridge between the raw data and what we need to display in our dashboards. Like all things data (Shout out to Shuki Mann<\/a>), where you write your case is as important as how. While technically you can create a calculated field and CASE<\/a> on a specific visual, it\u2019s not really best practice. What happens when you need to use that case in a different visual? Copy\/Past? Not smart, instead, better add this CASE as part of your data source. In \u201cEdit\u201d mode go to \u201cResource\u201d -> \u201dManage added data sources\u201d<\/p>\n\n\n\n

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

      This is true both when you use a \u201cregular\u201d data source or (god knows why) a blended one.<\/p>\n\n\n\n

      Trick #4: Manage Your Filters<\/strong><\/h2>\n\n\n\n

      Let\u2019s be honest, we copy existing dashboards and modify them way more than creating new ones from scratch, it\u2019s easier this way than having to create all the visuals again. The problem starts when we modify the data and forget to manage our filters, and what you end up with is something like this:<\/p>\n\n\n\n

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

      A bunch of unused filters, possibly some duplicated ones, and gods knows what else. While this may not impact the dashboard itself, I always prefer a clean workspace to a messy one. All you need to before publishing your dashboard, do a bit of cleaning up. When in \u201cEdit\u201d mode go to \u201cResource\u201d -> \u201cManage filters\u201d and there you\u2019ll find a list of filters you need to keep or delete.<\/p>\n\n\n\n

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

      Trick #5: Number Your Versions<\/strong><\/h2>\n\n\n\n

      Like all developers you should number your dashboards with version numbers. I like adding version numbers visible to all for 2 reasons:<\/p>\n\n\n\n

      1. It\u2019s a way to communicate to the user that what you see can and will improve, that the current dashboard is not a final product and he should expect more features and data in the next version.<\/li><\/ol>\n\n\n\n
        \"\"<\/figure><\/div>\n\n\n\n
        1. It\u2019s a way for you to keep track of dashboards development, and create a sense of order and power up the \u201csee historical version\u201d feature in Data Studio. If you add a version number, then the \u201cversion history\u201d basically becomes a log of all changes you made throughout the different versions.<\/li><\/ol>\n\n\n\n
          \"\"<\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"

          Back by popular demand, after the roaring success of my previous post I\u2019ve decided to share some more tips and tricks I use when working with Data Studio (Number 3 will shock you! Well, not really). So without further ado here are 5 more tips to level up your Data Studio game! Trick #1: The […]<\/p>\n","protected":false},"author":6,"featured_media":4880,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,46],"tags":[],"class_list":["post-4867","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-google-data-studio"],"_links":{"self":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/comments?post=4867"}],"version-history":[{"count":2,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4867\/revisions"}],"predecessor-version":[{"id":4882,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/posts\/4867\/revisions\/4882"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/media\/4880"}],"wp:attachment":[{"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/media?parent=4867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/categories?post=4867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trackingchef.com\/wp-json\/wp\/v2\/tags?post=4867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}