Make your Datastudio dashboards interactive<\/h2>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/Its-magic-300x237.jpg\")
<\/p>\n
End goal: a real-time report that is updating itself automatically, that allows interactivity and that can be shared in total transparency with the client. Bonus: you might even be able to use it for more than just one campaign or one client if you make it into a template.<\/p>\n
At CLICKTRUST, we\u2019re building all our reports through Google Data Studio. Let me quickly walk you through the main features we\u2019re using.<\/p>\n
Data connectors<\/h2>\n
Google Data Studio offers some direct data connectors.<\/p>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/4.png\")
<\/p>\n
But you can also use third-party connectors, which allow you to directly connect any type of data to your Google Data Studio report. No need for extracts and sheets anymore, everything is waiting for you in one and only place.<\/p>\n
Blended data<\/h2>\n
Getting your information from only one data source is usually not enough.<\/p>\n
Easy example: let\u2019s say you have multiple conversions in one search account but only want to provide the cost per one of the conversions. You can\u2019t filter cost per conversion based on conversion action (Google Ads doesn\u2019t allow you to filter cost based on conversion action). To be able to do so, you\u2019ll have to blend your data.<\/p>\n
There are 2 different ways to create blended data:<\/p>\n
- \n
- Select the 2 data you want to blend, click right and select \u201cblend data\u201d. This will open a new window where you can create your blended data.<\/li>\n
- Go to Resource > blended data > create new. From there, you\u2019ll be able to choose your data sources and create your blended data.<\/li>\n<\/ul>\n
In our example, we\u2019ll have to blend our Google Ads data source selecting cost with the same Google Ads data source selecting all conversions filtered on the conversion action name. Don\u2019t forget to rename your \u201call conversions\u201d metric with the name of the conversion you\u2019ve filtered.<\/p>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/3-2.png\")
<\/p>\nCustom fields<\/h2>\n
Custom fields let you use your own formula to calculate metrics. You can either use them as metrics or dimensions. In our previous example, we wanted to calculate the cost per test drive. To do so, we\u2019ve created a blended data that has both cost from the Google Ads account and all conversions filtered on Test Drive conversion action. Now that we have both data we need, we have to create a custom field to get the cost per test drive.<\/p>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/5-300x200-1.png\")
<\/p>\nCustom fields can also be used as dimensions. At Clicktrust, we are huge defenders of highly segmented campaigns. This means that we can end up with a lot of campaigns (French only targeting broad keywords, Dutch only targeting mobile devices, etc.) which makes the overview by campaign not really readable in a simplified dashboard. To fix this, we create custom fields using the CASE WHEN formula. That way, we can merge together the data from multiple campaigns under one single name.<\/p>\n
Need an example? Let\u2019s say that you\u2019ve split your campaigns targeting different devices, languages, and match types for optimization matters. You then end up with 8 campaigns :<\/p>\n
- \n
- BEFR_MOBILE_BROAD<\/li>\n
- BEFR_MOBILE_EXACT<\/li>\n
- BEFR_DESKTOP_BROAD<\/li>\n
- BEFR_DESKTOP_EXACT<\/li>\n
- BENL_MOBILE_BROAD<\/li>\n
- BENL_MOBILE_EXACT<\/li>\n
- BENL_DESKTOP_BROAD<\/li>\n
- BENL_DESKTOP_EXACT<\/li>\n<\/ul>\n
What if you only want to show how BEFR campaigns are performing compared to BENL ones. You just need to create a custom field inside your data source using the CASE WHEN formula (Resource > Data sources > Edit > Add a field). This will then become an available dimension and you\u2019ll be able to show metrics based on this new dimension.<\/p>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/10.png\")
<\/p>\nPut in a table, your new dimension will appear that way :<\/p>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/9-300x95-1.png\")
\nControls<\/h2>\nControls are filters that let you interact with your data. Would you only want to see the data for the last 30 days or only for mobile devices? Controls will let you filter this out. Time to really make things dynamic.<\/p>\n
Now that you know how to create blended data and custom fields, you can create blended data that are using custom fields as their join keys. Depending on what you need to show, your graphs can now be updated based on your custom fields by just adding a control next to it.<\/p>\n
Back to our example. Let\u2019s say you want to show how many test drives you received thanks to your campaign and the cost per test drive. But you also want to be able to show the split between the french and dutch campaigns. You\u2019ll have to follow these steps :<\/p>\n
- \n
- Create your dimension custom field using the CASE WHEN formula to merge data from your BEFR and BENL sub-campaigns.<\/li>\n
- Create your blended data to select cost on one side and all conversions filtered on test drive on the other side. Use your newly created custom field as the join key. This will allow you to use this same custom dimension as the control later on.<\/li>\n
- Add your scorecard (or any other graph) showing the test drive and cost per test drive.<\/li>\n
- Add a control on the dimension custom field (here language). In view mode, by selecting either french or dutch (or both) the reader will be able to compare the performance of both languages or have a view of everything together.<\/li>\n<\/ul>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/8.png\")
<\/p>\nGraphs interactions<\/h2>\n
Last but not least, make sure that your graphs will be sorted and can be used as filters themselves. To do so, open the graphs set up window, and check the last box : Interactions. There you can check \u201capply filter\u201d or \u201cenable sorting\u201d. Any graphs can then become a filter too.<\/p>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/7.png\")
<\/p>\nBack to our example, we\u2019re displaying test drive and cost per test drive and we have campaigns targeting mobile and desktop. By adding a small pie chart next to it, showing the number of test drives coming from mobile and desktop campaigns, you can also allow the data to be sorted by clicking one part of the graph. Do you only want to see the cost per test drive for the mobile campaigns? Click the mobile section of the pie chart in view mode and all data will update themselves.<\/p>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/6-1.png\")
<\/p>\nNow I guess you just need to figure out what you\u2019ll do with all this extra time.<\/p>\n
![\"\"](\"https:\/\/clicktrust.be\/wp-content\/uploads\/2022\/07\/giphy-1.gif\")
[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][nectar_global_section id=”31229″][\/vc_column][\/vc_row]\n","protected":false},"excerpt":{"rendered":"[vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” top_padding=”50″ text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” advanced_gradient_angle=”0″ overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none” gradient_type=”default” shape_type=””][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all”…<\/p>\n","protected":false},"author":25,"featured_media":43203,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"two_page_speed":[],"footnotes":""},"categories":[189],"tags":[252],"level":[199],"class_list":{"0":"post-38843","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-analytics","8":"tag-google-data-studio-fr","9":"level-channel-specialist-fr"},"acf":[],"yoast_head":"\n
Discover our Google Datastudio tips & tricks | CLICKTRUST<\/title>\n<meta name=\"description\" content=\"Learn how we're making reports become dynamic and win lots of time in the process. Discover our tips to rock Google Data Studio.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Discover our Google Datastudio tips & tricks | CLICKTRUST\" \/>\n<meta property=\"og:description\" content=\"Learn how we're making reports become dynamic and win lots of time in the process. Discover our tips to rock Google Data Studio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/\" \/>\n<meta property=\"og:site_name\" content=\"Clicktrust\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/clicktrustbrussels\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-02T11:55:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-26T13:48:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/clicktrust.be\/wp-content\/uploads\/2020\/09\/stephen-dawson-qwtCeJ5cLYs-unsplash-1-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1842\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Mathilde Duquenne\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mathilde Duquenne\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture est.\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Discover our Google Datastudio tips & tricks | CLICKTRUST","description":"Learn how we're making reports become dynamic and win lots of time in the process. Discover our tips to rock Google Data Studio.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/","og_locale":"fr_FR","og_type":"article","og_title":"Discover our Google Datastudio tips & tricks | CLICKTRUST","og_description":"Learn how we're making reports become dynamic and win lots of time in the process. Discover our tips to rock Google Data Studio.","og_url":"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/","og_site_name":"Clicktrust","article_publisher":"https:\/\/www.facebook.com\/clicktrustbrussels\/","article_published_time":"2020-09-02T11:55:22+00:00","article_modified_time":"2023-02-26T13:48:48+00:00","og_image":[{"width":2560,"height":1842,"url":"https:\/\/clicktrust.be\/wp-content\/uploads\/2020\/09\/stephen-dawson-qwtCeJ5cLYs-unsplash-1-scaled.jpg","type":"image\/jpeg"}],"author":"Mathilde Duquenne","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Mathilde Duquenne","Dur\u00e9e de lecture est.":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/#article","isPartOf":{"@id":"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/"},"author":{"name":"Mathilde Duquenne","@id":"https:\/\/clicktrust.be\/fr\/#\/schema\/person\/3eb7293741ee59a07efe3f2af395046e"},"headline":"Datastudio features to make your life easier","datePublished":"2020-09-02T11:55:22+00:00","dateModified":"2023-02-26T13:48:48+00:00","mainEntityOfPage":{"@id":"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/"},"wordCount":1476,"publisher":{"@id":"https:\/\/clicktrust.be\/fr\/#organization"},"keywords":["Google Data Studio"],"articleSection":["Analytics"],"inLanguage":"fr-BE"},{"@type":"WebPage","@id":"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/","url":"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/","name":"Discover our Google Datastudio tips & tricks | CLICKTRUST","isPartOf":{"@id":"https:\/\/clicktrust.be\/fr\/#website"},"datePublished":"2020-09-02T11:55:22+00:00","dateModified":"2023-02-26T13:48:48+00:00","description":"Learn how we're making reports become dynamic and win lots of time in the process. Discover our tips to rock Google Data Studio.","breadcrumb":{"@id":"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/#breadcrumb"},"inLanguage":"fr-BE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/clicktrust.be\/fr\/blog\/analytics\/datastudio-features-to-make-life-easier\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/clicktrust.be\/fr\/"},{"@type":"ListItem","position":2,"name":"Brainfood","item":"https:\/\/clicktrust.be\/blog\/"},{"@type":"ListItem","position":3,"name":"Analytics","item":"https:\/\/clicktrust.be\/fr\/category\/analytics\/"},{"@type":"ListItem","position":4,"name":"Datastudio features to make your life easier"}]},{"@type":"WebSite","@id":"https:\/\/clicktrust.be\/fr\/#website","url":"https:\/\/clicktrust.be\/fr\/","name":"Clicktrust","description":"We are CLICKTRUST. Full transparency","publisher":{"@id":"https:\/\/clicktrust.be\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/clicktrust.be\/fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-BE"},{"@type":"Organization","@id":"https:\/\/clicktrust.be\/fr\/#organization","name":"Clicktrust","url":"https:\/\/clicktrust.be\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-BE","@id":"https:\/\/clicktrust.be\/fr\/#\/schema\/logo\/image\/","url":"","contentUrl":"","caption":"Clicktrust"},"image":{"@id":"https:\/\/clicktrust.be\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/clicktrustbrussels\/","https:\/\/www.youtube.com\/channel\/UCKKPuTA6ssQo_w1Kzs9Ldwg","https:\/\/www.linkedin.com\/company\/clicktrust-marketing\/","https:\/\/instagram.com\/clicktrust?igshid=YmMyMTA2M2Y"]},{"@type":"Person","@id":"https:\/\/clicktrust.be\/fr\/#\/schema\/person\/3eb7293741ee59a07efe3f2af395046e","name":"Mathilde Duquenne","image":{"@type":"ImageObject","inLanguage":"fr-BE","@id":"https:\/\/clicktrust.be\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/524d9d4aceeb141882aebc4b7cfadfc2fb2d3dac5c166e762696da30d5c5415e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/524d9d4aceeb141882aebc4b7cfadfc2fb2d3dac5c166e762696da30d5c5415e?s=96&d=mm&r=g","caption":"Mathilde Duquenne"},"description":"Team lead & Digital Performance Analyst","url":"https:\/\/clicktrust.be\/fr\/author\/mathilde-duquenne\/"}]}},"_links":{"self":[{"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/posts\/38843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/comments?post=38843"}],"version-history":[{"count":0,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/posts\/38843\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/media\/43203"}],"wp:attachment":[{"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/media?parent=38843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/categories?post=38843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/tags?post=38843"},{"taxonomy":"level","embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/level?post=38843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}