{"id":46596,"date":"2025-05-12T12:31:46","date_gmt":"2025-05-12T10:31:46","guid":{"rendered":"https:\/\/clicktrust.be\/?p=46596"},"modified":"2025-05-12T12:33:45","modified_gmt":"2025-05-12T10:33:45","slug":"how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try","status":"publish","type":"post","link":"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/","title":{"rendered":"How to create better, cleaner, and more dynamic Google Looker Studio dashboards \u2013 3 cool tricks you need to try"},"content":{"rendered":"\n<p>Better dashboards simplify your data workflow, making it easier to analyze insights quickly and clearly communicate findings to stakeholders. By making good design choices and utilizing advanced functionalities, you&#8217;ll be able to create dashboards that impress clients, managers, and teammates with streamlined, easy-to-understand visuals.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"3 Google looker studio tricks you did not know about\" width=\"1080\" height=\"810\" src=\"https:\/\/www.youtube.com\/embed\/JJiYkqspens?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>So, let&#8217;s dive into our three cool, actionable tricks right away!<\/p>\n\n\n\n<p><strong>Trick #1: Easily Display Both Period-on-Period (PoP) and Year-on-Year (YoY) Comparisons Together<\/strong><\/p>\n\n\n\n<p>Currently, by default, Google Looker Studio only easily lets you compare one type of period (e.g., either period-on-period or year-on-year) in each widget. But what if you want to analyze both comparisons side-by-side for better context? There&#8217;s an easy workaround. Here&#8217;s how:<\/p>\n\n\n\n<p>Step-by-step:<\/p>\n\n\n\n<p>1. First, select your metric (such as conversions, revenue, cost, or clicks).<br>2. Duplicate the current metric <br>3. Select your newly duplicated widget. Adjust the comparison to be the other type you haven&#8217;t used yet. For example, if your first widget is comparing year-on-year, make your second widget compare previous period (period-on-period).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"448\" height=\"341\" src=\"https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.27.02.png\" alt=\"\" class=\"wp-image-46603\" srcset=\"https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.27.02.png 448w, https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.27.02-300x228.png 300w\" sizes=\"(max-width: 448px) 100vw, 448px\" \/><\/figure>\n\n\n\n<p>4. Ensure your design is neat by placing the two widgets next to or closely below one another. You will need to click &#8220;Send to back&#8221; on one to keep your alignment neat.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"304\" height=\"474\" src=\"https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.25.41.png\" alt=\"\" class=\"wp-image-46597\" style=\"width:246px;height:auto\" srcset=\"https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.25.41.png 304w, https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.25.41-192x300.png 192w\" sizes=\"(max-width: 304px) 100vw, 304px\" \/><\/figure>\n\n\n\n<p><br>5. Carefully label your widgets: insert clear text boxes indicating &#8220;Year-on-Year&#8221; vs &#8220;Previous Period&#8221;. This helps highlight exactly which comparison is displayed where.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"184\" height=\"135\" src=\"https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.26.19.png\" alt=\"\" class=\"wp-image-46600\"\/><\/figure>\n\n\n\n<p>Tip: Make sure you use clean text labels and consistent design, which will greatly improve clarity for anyone viewing your dashboard.<\/p>\n\n\n\n<p>And just like that, you now have a single-page dashboard with metrics easily compared for period-on-period versus year-on-year:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Trick #2: Enable Cross-Filtering Graphs for More Interactivity<\/strong><\/p>\n\n\n\n<p>Interactive dashboards are impactful dashboards. Did you know there&#8217;s a powerful built-in functionality called cross-filtering in Google Looker Studio? Cross-filtering allows you to filter dashboard-wide data dynamically by clicking directly onto chart elements.<\/p>\n\n\n\n<p>Here\u2019s how to activate cross-filtering on graphs quickly:<\/p>\n\n\n\n<p>1. In edit mode, select your existing chart or graph.<br>2. Head over to the &#8220;Setup&#8221; panel (on your right-hand side).<br>3. Scroll down until you find the &#8220;Cross-filtering&#8221; toggle and enable it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"158\" height=\"156\" src=\"https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.27.30.png\" alt=\"\" class=\"wp-image-46606\" srcset=\"https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.27.30.png 158w, https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.27.30-100x100.png 100w\" sizes=\"(max-width: 158px) 100vw, 158px\" \/><\/figure>\n\n\n\n<p><br>4. Switch to &#8220;View mode&#8221; to see it in action! Clicking on a certain date or data point within your chart will now dynamically filter all associated widgets on your page.<\/p>\n\n\n\n<p>Example of Cross-filtering Use:<br>Suppose you click and select a range or a certain specific point on your line chart showing your costs or conversions over time. Instantly, tables, scorecards, or other visuals tied to that data will update dynamically to reflect the selected range only.<\/p>\n\n\n\n<p><strong>Trick #3: Make Better Comparisons Using Your Naming Conventions and Custom Dimensions<\/strong><\/p>\n\n\n\n<p>If you&#8217;re running ads, campaigns, or even website content with clear naming conventions (e.g., video ads versus static ads, winter versus summer promotion, brand-related vs non-brand campaigns, and so on), here&#8217;s a clever trick to dynamically leverage it inside Looker Studio:<\/p>\n\n\n\n<p>Step-by-step:<\/p>\n\n\n\n<p>1. Always ensure your ad or campaign names clearly reflect categories you can segment by (for example, &#8220;Static_AD1&#8221;, &#8220;Video_AD2,&#8221; etc.). Good naming convention is crucial here!<br>2. Select the widget you want to use to display the comparison (such as a table or pie chart).<br>3. Create a new calculated dimension with a &#8220;CASE WHEN&#8221; statement, using REGEX to identify your categories.<\/p>\n\n\n\n<p>Example CASE statement for video\/static differentiation might look like this:<\/p>\n\n\n\n<p>CASE<br>WHEN REGEXP_CONTAINS(Ad Name, &#8220;Static&#8221;) THEN &#8220;Static&#8221;<br>WHEN REGEXP_CONTAINS(Ad Name, &#8220;Video&#8221;) THEN &#8220;Video&#8221;<br>ELSE &#8220;Other&#8221;<br>END<\/p>\n\n\n\n<p>4. Use your newly-created dimension as a dimension in your table or graph to immediately compare performance between categories, clearly displayed and easily understood.<\/p>\n\n\n\n<p>Tip: Set clear naming conventions ahead of time and keep them consistent. This method can also help compare campaign promotions, offer types, content themes, and more.<\/p>\n\n\n\n<p>This visibility is powerful, especially for quick insights and easy storytelling.<\/p>\n\n\n\n<p>Great dashboards aren&#8217;t just good to look at\u2014they tell impactful data stories that empower smarter business decisions. With these three easy-to-implement yet powerful Google Looker Studio dashboard tips, you&#8217;ll craft clearer comparisons, interactive visualizations, and dashboards that anyone can quickly understand and use effectively.<\/p>\n\n\n\n<p>If you need help to build your dashboard do not hesitate to get in contact or check out <a href=\"https:\/\/clicktrust.be\/clicktrust-academy-digital-marketing-training-brussels\/looker-studio-dashboarding-training-brussels\/\">here<\/a> our upcoming training on Dashboarding<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Better dashboards simplify your data workflow, making it easier to analyze insights quickly and clearly communicate findings to stakeholders. By making good design choices and&#8230;<\/p>\n","protected":false},"author":31,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"two_page_speed":[],"footnotes":""},"categories":[426],"tags":[],"level":[],"class_list":{"0":"post-46596","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-dashboarding"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to create better, cleaner, and more dynamic Google Looker Studio dashboards \u2013 3 cool tricks you need to try - Clicktrust<\/title>\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\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to create better, cleaner, and more dynamic Google Looker Studio dashboards \u2013 3 cool tricks you need to try - Clicktrust\" \/>\n<meta property=\"og:description\" content=\"Better dashboards simplify your data workflow, making it easier to analyze insights quickly and clearly communicate findings to stakeholders. By making good design choices and...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/\" \/>\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=\"2025-05-12T10:31:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-12T10:33:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.27.02.png\" \/>\n<meta name=\"author\" content=\"Enrico Cadei\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Enrico Cadei\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture est.\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to create better, cleaner, and more dynamic Google Looker Studio dashboards \u2013 3 cool tricks you need to try - Clicktrust","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\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/","og_locale":"fr_FR","og_type":"article","og_title":"How to create better, cleaner, and more dynamic Google Looker Studio dashboards \u2013 3 cool tricks you need to try - Clicktrust","og_description":"Better dashboards simplify your data workflow, making it easier to analyze insights quickly and clearly communicate findings to stakeholders. By making good design choices and...","og_url":"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/","og_site_name":"Clicktrust","article_publisher":"https:\/\/www.facebook.com\/clicktrustbrussels\/","article_published_time":"2025-05-12T10:31:46+00:00","article_modified_time":"2025-05-12T10:33:45+00:00","og_image":[{"url":"https:\/\/clicktrust.be\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-12-at-12.27.02.png"}],"author":"Enrico Cadei","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Enrico Cadei","Dur\u00e9e de lecture est.":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/#article","isPartOf":{"@id":"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/"},"author":{"name":"Enrico Cadei","@id":"https:\/\/clicktrust.be\/fr\/#\/schema\/person\/bf07ac7f91b34c401b5f168b492b2f52"},"headline":"How to create better, cleaner, and more dynamic Google Looker Studio dashboards \u2013 3 cool tricks you need to try","datePublished":"2025-05-12T10:31:46+00:00","dateModified":"2025-05-12T10:33:45+00:00","mainEntityOfPage":{"@id":"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/"},"wordCount":703,"publisher":{"@id":"https:\/\/clicktrust.be\/fr\/#organization"},"articleSection":["Dashboarding"],"inLanguage":"fr-BE"},{"@type":"WebPage","@id":"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/","url":"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/","name":"How to create better, cleaner, and more dynamic Google Looker Studio dashboards \u2013 3 cool tricks you need to try - Clicktrust","isPartOf":{"@id":"https:\/\/clicktrust.be\/fr\/#website"},"datePublished":"2025-05-12T10:31:46+00:00","dateModified":"2025-05-12T10:33:45+00:00","breadcrumb":{"@id":"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/#breadcrumb"},"inLanguage":"fr-BE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/clicktrust.be\/fr\/blog\/dashboarding\/how-to-create-better-cleaner-and-more-dynamic-google-looker-studio-dashboards-3-cool-tricks-you-need-to-try\/#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":"Dashboarding","item":"https:\/\/clicktrust.be\/category\/dashboarding\/"},{"@type":"ListItem","position":4,"name":"How to create better, cleaner, and more dynamic Google Looker Studio dashboards \u2013 3 cool tricks you need to try"}]},{"@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\/bf07ac7f91b34c401b5f168b492b2f52","name":"Enrico Cadei","image":{"@type":"ImageObject","inLanguage":"fr-BE","@id":"https:\/\/clicktrust.be\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2d2b4074a32e00487db8bac9ac404127860162ef7fe5675afa0b327ad69502ec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2d2b4074a32e00487db8bac9ac404127860162ef7fe5675afa0b327ad69502ec?s=96&d=mm&r=g","caption":"Enrico Cadei"},"description":"Digital Performance Analyst","url":"https:\/\/clicktrust.be\/fr\/author\/enrico-cadei\/"}]}},"_links":{"self":[{"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/posts\/46596","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\/31"}],"replies":[{"embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/comments?post=46596"}],"version-history":[{"count":0,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/posts\/46596\/revisions"}],"wp:attachment":[{"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/media?parent=46596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/categories?post=46596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/tags?post=46596"},{"taxonomy":"level","embeddable":true,"href":"https:\/\/clicktrust.be\/fr\/wp-json\/wp\/v2\/level?post=46596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}