{"id":743,"date":"2023-05-01T14:25:59","date_gmt":"2023-05-01T14:25:59","guid":{"rendered":"http:\/\/frederickempaga.com\/shop\/the-ultimate-guide-to-google-data-studio-in-2020\/"},"modified":"2023-05-01T14:25:59","modified_gmt":"2023-05-01T14:25:59","slug":"the-ultimate-guide-to-google-data-studio-in-2020","status":"publish","type":"post","link":"https:\/\/frederickempaga.com\/shop\/the-ultimate-guide-to-google-data-studio-in-2020\/","title":{"rendered":"The Ultimate Guide to Google Data Studio in 2020"},"content":{"rendered":"<div class=\"hs-featured-image-wrapper\">\n <a href=\"https:\/\/blog.hubspot.com\/marketing\/google-data-studio\" title=\"\" class=\"hs-featured-image-link\"> <img decoding=\"async\" src=\"https:\/\/blog.hubspot.com\/hubfs\/Google%20Looker%20Studio%20%281%29.png\" alt=\"Google Data Studio abstract image featuring a man looking at a laptop screen\" class=\"hs-featured-image\" style=\"width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;\"> <\/a>\n<\/div>\n<p>Google Data Studio is now Google Looker Studio, and it&#8217;s making <a href=\"https:\/\/blog.hubspot.com\/marketing\/running-marketing-reports-ht\">data reporting<\/a> even more accessible, visual, and impactful than before. The new interface, features, and functionality have some serious advantages when it comes to visualizing competitive data insights.<\/p>\n<h3><\/h3>\n<p>Google Data Studio is now Google Looker Studio, and it&#8217;s making <a href=\"https:\/\/blog.hubspot.com\/marketing\/running-marketing-reports-ht\">data reporting<\/a> even more accessible, visual, and impactful than before. The new interface, features, and functionality have some serious advantages when it comes to visualizing competitive data insights.<\/p>\n<h3><\/h3>\n<p>In this guide, we&#8217;ll introduce some of the coolest, newest features of the platform to get you ramped up quickly. We&#8217;ll also walk you through the most notable changes between Google Data Studio and Google Looker Studio.<\/p>\n<p><a class=\"cta_button\" href=\"https:\/\/www.hubspot.com\/cs\/ci\/?pg=1d7211ac-7b1b-4405-b940-54b8acedb26e&amp;pid=53&amp;ecid=&amp;hseid=&amp;hsic=\"><img decoding=\"async\" class=\"hs-cta-img \" style=\"border-width: 0px; \/*hs-extra-styles*\/; margin: 0 auto; display: block; margin-top: 20px; margin-bottom: 20px\" alt=\"\u2192 Download Now: SEO Starter Pack [Free Kit]\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/53\/1d7211ac-7b1b-4405-b940-54b8acedb26e.png\" align=\"middle\"><\/a> <\/p>\n<p><strong><em>Pro Tip: <\/em><\/strong><em>Even with the major overhaul, Google Looker Studio is still entirely free and accessible to all (even if you don\u2019t have any data of your own!)\u2014 that means you can follow along with this tutorial <\/em><a href=\"https:\/\/lookerstudio.google.com\/\"><em>in real-time<\/em><\/a><em>. <\/em><\/p>\n<\/p>\n<p>With Looker Studio, you can create custom dashboards, reports, and visualizations to gain insights into your business operations. The platform offers a wide range of data connectors and report templates, allowing you to interpret data from various sources.<\/p>\n<\/p>\n<h3>1. Log into Looker Studio<\/h3>\n<p>To log in to <a href=\"http:\/\/datastudio.google.com\/\">Looker Studio<\/a>, you\u2019ll need a Google account \u2014 I recommend using the same one as your Analytics, Search Console, and\/or Google Ads account.<\/p>\n<p>After logging in, you\u2019ll land on a page displaying your most recent Looker Studio reports.<\/p>\n<h3>2. Explore the Looker Studio Dashboard<\/h3>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/GSYcUcuiYFyyiPFDjxlDa2-abwmksHfgiWnYCBqcTg8oOhJQ8gWWEPuvybuwgnqqSRIdZzPCAuXLe9TEHv306hYw7lD839bykmSf27Fddc0ER7vT-rjcrdEFh9pge9Zs3416XMlt4LA5TYH4NYYcvR4\" style=\"margin: auto; display: block; width: 650px;\" alt=\"How to Use Google Looker Studio: Explore the Looker Studio Dashboard\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>If you\u2019ve used Google Docs, Sheets, or Drive before, this dashboard should look pretty familiar. In the center, you have the option to start a blank report, start a tutorial, or see report templates. To the left, you&#8217;ll see a column that houses several tabs including Reports, Shared with me, Owned by me, Trash, and Templates. At the top, you&#8217;ll see three more tabs: Reports, Data sources and explorer.<\/p>\n<p>Let&#8217;s go over each of these tabs in detail.<\/p>\n<h4>Reports<\/h4>\n<p>Here\u2019s where you can access all of your reports (equivalent to a workbook in Tableau or Excel).<\/p>\n<p>To create a report in Google Looker Studio:<\/p>\n<ul>\n<li>Click the Create button.<\/li>\n<li>Choose Report.<\/li>\n<li>Add a data source.<\/li>\n<li>Customize your report.<\/li>\n<\/ul>\n<p>Once you&#8217;ve created your report, you can access it later in your dashboard. To soft through several reports, filter them by name, owner, or last opened date by using the dropdown filters.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/5OdRcg0ZxJlGY5A2y2N4C0JO6GIPzeBChxgT4xeAV2wlw1k86r9JnFd40Dj8XCiuEk-UnyiThhLcILAxg4kvmdhTxd6FSGS6iPxQoCOBdjjruy5eI7PwanpW54xH2vsjzvJmXSOq6igiKeqvfuWL9LU\" style=\"margin: auto; display: block; width: 650px;\" alt=\"How to Use Google Looker Studio: Reports\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h4>Data Sources<\/h4>\n<p>Data sources list all the connections you\u2019ve created between Looker Studio and your original data sources.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/bWivb80sLD7nqsziO5rknkGKGNkF7Tw2eJ4Vvjqd9-VzS_H3oyj27QbG7uzrjYdourUJ00OL8vGdj9f4x_wyS4nfRgJjzykzw14mmnAWP4-b5RK_lLYAgoGFwlZlhVe4_xZbFIn0IrhtzypX0OxSYN8\" style=\"margin: auto; display: block; width: 650px;\" alt=\"How to Use Google Looker Studio: Data sources\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>To create a data source in Google Looker Studio:<\/p>\n<ul>\n<li>Click the Create button.<\/li>\n<li>Choose Data source.<\/li>\n<li>Enter in your company information, click Continue.<\/li>\n<li>Set up email preferences.<\/li>\n<li>Select a Google Connector.<\/li>\n<li>Authorize the Google Connector using a Google Account.<\/li>\n<li>Choose the account and property you want to view.<\/li>\n<li>Click Create Report.<\/li>\n<\/ul>\n<p><strong><em>Pro Tip: <\/em><\/strong><em>If you\u2019re using Google Analytics and\/or Search Console (which I highly recommend), you\u2019ll need to individually connect each view and property, respectively. So if you have three GA views for three different subdomains, you\u2019ll need to set up three separate data sources.<\/em><\/p>\n<p>Looker Studio currently supports 760+ data sources. Below are the most popular sources:<\/p>\n<\/p>\n<h4>Explorer<\/h4>\n<p>Explorer is an experimental tool that lets you experiment or tweak a chart without modifying your report itself.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/alcn-ZBemOlSwVfvdRZ-n4IIL-ssD2QvbyoRZeMCFPL3nnjT3FApFuLzaReD-9g0zFnRk30MneSR8y80qYVfOOaYdR5ga4BuVeZyMwlR5VSr2y6RFvixDvLTi1cFJvfmJwQjCj9_QSdgnu6KLNrmR28\" style=\"margin: auto; display: block; width: 650px;\" alt=\"How to Use Google Looker Studio: Explorer\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>For instance, let\u2019s say you\u2019ve created a table in Looker Studio that shows the top landing pages by conversion rate. While looking at this table, you think, \u201cHuh, I wonder what I\u2019d find if I added average page load time.\u201d<\/p>\n<p>You don\u2019t want to edit the chart in the report, so you export it into Explorer \u2014 where you can tweak it to your heart\u2019s content. If you decide the new chart is valuable, it\u2019s easy to <a href=\"https:\/\/blog.hubspot.com\/marketing\/google-data-studio?hubs_content=blog.hubspot.com\/marketing\/google-data-studio&amp;hubs_content-cta=(Jump%20to%20the%20section%20where%20I%20explain%20how.)#Export\">export it back into the report<\/a>.<\/p>\n<h4>Template Gallery<\/h4>\n<p>The template gallery is a collection of templates and examples you can use depending on your business needs.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/VhDWcdu6zL4N6fcafuFnMLs4tSQxkpooqiPXcoJ9vVXkxKzd7YHZJjiZ-vl6pInJ_JMhiTaMAmNaQVCvBAaLy33Rylb7s_NlKI2Ey0cMnq5QRI9OSKqwIiEqgd7aXQQcYzrFj2-hrdCgWCp4D5C5nwo\" style=\"margin: auto; display: block; width: 650px;\" alt=\"How to Use Google Looker Studio: Template Gallery\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>For instance, if you run an ecommerce store, the <a href=\"https:\/\/datastudio.google.com\/open\/0dcc27d8-13a8-4025-b9dd-a09e1dd78bf1\">ecommerce revenue template<\/a> would be very useful.<\/p>\n<h2><strong>Google Looker Studio Tutorial<\/strong><\/h2>\n<h3>Connect Data Sources to Google Looker Studio<\/h3>\n<p>Here\u2019s a step-by-step guide on how to connect data sources to Google Looker Studio.<\/p>\n<h4>1. Create a data source.<\/h4>\n<p style=\"text-align: center;\">Click &#8220;Create&#8221; and choose &#8220;Data source&#8221;.<img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/25NSDu0GF6SN40EORAAXNtfZhc_hhvL1F7-10RbbOx-YAxkNqhHjLOagzeRS_vAQZ_hVHvkmhcvUNCYcLijjaXVr_EWiWRot9UIlwDj1258zWQMhmqQbkcDxSCrOV_BpdtMhatZqk70DMLzyZaGyMrM\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: Create a data source\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h4 style=\"text-align: left;\">2. Use Google Analytics.<img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/bsUp4-mQRXgEDx65l_GKmGZcv96ATrKP1sv8xhyfc4BIZYCNCf1HhbCtncO4E_eEnc5nv-hpj_f57_MM3ZqAXRpzv_cibKUz-Et4lTn5fIHJFzD4_kIZXRvxeGjKW-xteIQxa-EmLsKkPSnNSzFnjTg\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: Use google Analytics as the data source\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/h4>\n<p>The process is nearly identical for other sources.<\/p>\n<p>If you want to follow along exactly with what I\u2019m doing, connect the Google Analytics Demo Account for the Google Merchandise Store.<\/p>\n<h4>3. Authorize the connection and select an account.<\/h4>\n<p style=\"text-align: center;\">Next, you\u2019ll be prompted to authorize the connection. Once you\u2019ve done that, you\u2019ll need to select an account, property, and view.<img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/rb67v9Q53jzqlNXPEcJL3ZFNMrCNXFHFkP3C5unN1g4USpgFdfiUD13otP8Q9-Zi-jk1UWgjnoJrzMJQR6k6nzQbolrZvZQZT1lc7SjZ6C5uCP-OFk00XbfuxQp2Ak4my2DekUEPya4OHaeEg6MK_tw\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: Authorize the data source connection\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>You\u2019ll be presented with something like the view below: a list of every field in your Analytics account (both the standard ones and the ones you\u2019ve added).<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/cJl3yEJ41TPlHUKg9xbDzA1ix2CY9Efk34u0y9doyCgPPZ6On9Q8OqpdOYVp0CI3gVd1FkcDxCqOe7jtWuXcaUAPrQ_fNOmzZuzXwYpJIzqfAxH_Gw4pHy03_1ers_dhV0owXyp7e_75KOmHjK44oCk\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: data source connections to choose from\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Does this feel overwhelming? Yep, same here.<\/p>\n<p>We could do a lot in this step \u2014 add new fields, duplicate existing ones, turn them off, change field values, etc. But, of course, we could also do all those things in the report itself, and it\u2019s much easier there. So let\u2019s do that.<\/p>\n<h3>Create a Report in Google Looker Studio<\/h3>\n<h4>1. Click \u201cCreate Report\u201d in the upper right.<\/h4>\n<p style=\"text-align: center;\">Looker Studio will ask if you want to add a new data source to the report; yes, you do.<img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/yj99aKOhBeqYpkc-7iUAEfcbBGwlD9VD_x_L4HS5q35ATvB5UaLjocr9qi1JIQhFrqFkosWIW1JeXObiKwxXxzYR32t--RAbGfHuHWBFAGhJ98OrwWNLmNLi5P20MpqI6bQB9SeaPJhKEha0StbvJ1I\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: Create a report\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Here\u2019s what you\u2019ll see. It\u2019s pretty bare, but not for long!<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/K7Geikc4_RxWwXYu2Qz4o8cjq816_0WvTZYfeO6vL55DPNR1TMuvMTb0oy1QcvUSx90_xwen3Z0VXyF3jj1oJ96WWVpabl51c_pcTDPtlBcmBsAmR5JKUmp8uREhyQKep65mT4A6-8m72fTG2oAv6yM\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: reports\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h4>2. Click \u201cAdd a chart\u201d in the toolbar.<\/h4>\n<p>It\u2019s time to add your very first chart. The good news is that data Studio makes it easy to compare chart types with some handy illustrations.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/WzQ_iNvyNgODdo8rvf92ZmtcQY3KkTcRdPqRW7GGSeJBTYRJdXV8gqqxz1oI2_-fVW0KwbmV86yohVhhBaVxVvOaRAEFdhMD0k958e1vf9Xu3Cqb1BOsvqP_D55uhKfl7qFMNR3Pl8RoTszvDnaXc_0\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: add a chart\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h4>3. Choose the first option under \u201cTime series.\u201d<\/h4>\n<p style=\"text-align: center;\">For the purpose of this tutorial, we\u2019ll start with a \u201cTime series\u201d chart. This chart type shows change over time. <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/8pxuA_4zrWyYbXx3aHrXIPelh3aNoo7uMAWkid9hfhl0hBoVwhQq34WzOXelH9WRWglcpzqFOrJey3qbOmq6WN_ZKEfRTRLhMIe63cfb7eLB6pWmi8KhoZWRQrEkvzYsNGea81kTisIrvUar3RTbHjQ\" style=\"margin: auto; display: block; width: 556px; height: auto; max-width: 100%;\" alt=\"Google Looker Studio Tutorial: time series chart\" width=\"556\" height=\"450\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Once it appears on your report, the right-hand pane will change. Here\u2019s what you should see:<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/2phfukiKYeFlxQxepodfF-4VECXBcqtSC8lw06anUcfVcN9kUQxT4WsNp7qP9xzr3D5u3VOdIYgln0fO0XtjXDoRRwnWQg16ATOoEwz5f0WrAX8r-Qo5fblq-vBd-J-M1H6NqAoTnebpHaAb8-KimoQ\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: time series chart report\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>By default, the dimension is \u201cDate\u201d; you can change this to any of the time-based dimensions, including \u201cYear,\u201d \u201cHour,\u201d etc.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/rq1H86kx0sYzrPKUI5zgWhyZCCh7XUFfXrBIGbET3tBed68RLLOFixGKbyVxT0Dtmm8OOHlmSusfjBjChXwKTJB7omaAbEi-5-g8291uN4XMlwf2njlpKlI0H95qpFXtueKylP4pCAL94m5a4n76lDE\" style=\"margin: auto; display: block; width: 487px; height: auto; max-width: 100%;\" alt=\"Google Looker Studio Tutorial: change the date\" width=\"487\" height=\"450\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>I will stick with \u201cDate\u201d because the Demo Account doesn\u2019t have a lot of historical data.<\/p>\n<p>Looker Studio will automatically select a metric (i.e., what\u2019s displayed on the Y-axis) for you. Feel free to change this; for instance, it defaulted to \u201cPageviews\u201d for me, but I\u2019d rather see \u201cRevenue per user.\u201d<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/-d2FRZ0a0xSpv1PSBAciDuh7VnqmeBH8E_ux0y-7dA5dUDC-od0fi3V7kGyWljRcPhOcGps8-Vjgf8S0MUPK-6kq-PVrN4WCLQjHe7hShI8YoD_dy9Sk6UInfWSRFGbS1-Sr-Msi-5lphxWwxHUJ9h0\" style=\"margin: auto; display: block; width: 545px; height: auto; max-width: 100%;\" alt=\"Google Looker Studio Tutorial: chart with dates\" width=\"545\" height=\"450\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h4>4. Add another metric.<\/h4>\n<p>First, make sure you\u2019ve selected the chart, so you see the pane:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/3Dpzj9FoVKsRNf9c27eyzn5i-fMfDe5qOMOOL2GdMr1gLt1mA7na500qoiY3sGia36DFEKRTNfzZEbnl9JIyMn6CQuMfD9T-jtUptAIlZ8UZxPhmPQn1el5rylXbgoCvpgOf3UeuN9HHKPnaFJKe3BI\" style=\"margin: auto; display: block; width: 167px; height: auto; max-width: 100%;\" width=\"167\" height=\"450\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>You have two options for adding a metric (or dimension).<\/p>\n<p>You can click the blue plus-sign icon \u2014 which will bring up a search box so you can find the field you want \u2014 or you can drag a field from the right into the metric section.<\/p>\n<p>To delete a metric, simply hover over it with your mouse and click the white \u201cx\u201d that appears.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/ZbBGhyH5V0fwnSBIzdW5ggrkRHN_cbsjVj7RShkpU-zKfGm_TPZRYafU4ud-XqteCmxcaPVb2WowYdzF-tx8LRXSqqqqCvbdNU12S407zPPGunudLkBoNBKpYpc31zscbFcX4J6DS2I69pwcdpEmoVM\" style=\"margin: auto; display: block; width: 563px; height: auto; max-width: 100%;\" alt=\"Google Looker Studio Tutorial: delete a metric\" width=\"563\" height=\"300\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h4>5. To add a table, choose the third option under \u201cAdd a chart.\u201d<\/h4>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/s5BhXxWs6_e3LWIA8cpcVsj1Cr7A3wsSarPa-gvMHmxFZCD5Pv1xJOnW0Hb48ytsKRm9K12BIOao9g-ZcpvMEXMQGLyLYFkYAVTVzvaVKbp3CfSMyUlOnxzCXuzFUrHW3kjyuqEee4CYogWzNXWb04g\" style=\"margin: auto; display: block; width: 450px; height: auto; max-width: 100%;\" width=\"450\" height=\"450\" alt=\"Google Looker Studio Tutorial: add a chart\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>My chart defaults to Medium (for dimension) and Pageviews (for metric), so I change it to Product and Unique Purchases.<\/p>\n<p>And I think this table\u2019s formatting could use some work.<\/p>\n<p>Change the \u201cRows per page\u201d from 100 to 20 (much easier to read) and check the box for adding a Summary row.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/iJ3IVZIr7Wu87iWP114r2ewvv3--UJmr5H9bTClvTTyjU4NO-96N9osfFkuCvmyReFluyYVwjBjylrqr4H20A5WYrq27nu9UO0KH_ve_oGoelAuvUjDLG0qc2mN6QYOnsf-gdjwGC8H8ZfENNhutbOI\" style=\"margin: auto; display: block; width: 450px; height: auto; max-width: 100%;\" width=\"450\" height=\"450\" alt=\"Google Looker Studio Tutorial: change rows per page\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h4>6. Finally, click \u201cStyle\u201d to go to the style tab.<\/h4>\n<p>Scroll down and select \u201cAdd border shadow.\u201d This is one of my favorite ways to make a data visualization pop off the page.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/tH6UPysdrO-UVjWEtS2_tpJLU_yz2PsSposohfWxFVcL33kZO0BHSec2ZxUeq9_1ekAgwsIumeFlYcVWND-pGooq4fA81tJkFDrdUzvpC_JHCpMWTB8zHUzLaORjStn9omu-s4KYqkEQLu1FpzSxp-U\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: change the style of the table\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h4>7. To see the finished product, click \u201cView\u201d in the top corner.<\/h4>\n<p>This transitions you from Editor to Viewer mode.<\/p>\n<p>Voila!<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/M1tjflzN4rDQuYwAIV7JOuog6nciD1b4nz6iAZxdlZeupuhxR31C44UrByEtEre0hfxVgZlyZJ-fTDNx2a-Y5ziO3f68Gk0HpKqPFlNtgL7DvDpWmbzWEALLNtZomuN1wwcp9JuLTaYUr3VquIcbO4I\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: view final report\"><\/p>\n<h4>8. Click \u201cEdit\u201d to finish up and name the report.<\/h4>\n<p>Double-click the title (right now, it\u2019s \u201cUntitled Report\u201d) to change it.<img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/kvkpdFzLtuqVYJFCtgv7GulvrcOns9oH6_gL_Nrk0Z2AeJaHm_pIL3aOs_2kkLfLOl5SmTA3Uz8CTmDe4kSLi3uExl1OasLVUxXj0oQ7o1l3z6e-qj6SMz_LQIDYIi0a-Ls_aKIayRHbwgie_ltDNyU\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Google Looker Studio Tutorial: edit report name\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>And with that, your first Google Looker Studio report is complete. Click that familiar icon above the Chart Editor and add some email addresses to share your report.<\/p>\n<p>Okay, don\u2019t share the report just yet\u2014I\u2019m about to reveal the secrets that\u2019ll help you seriously upgrade it.<\/p>\n<h2><strong>Beginner Google Looker Studio Tips<\/strong><\/h2>\n<h3>1. Use templates.<\/h3>\n<p>There\u2019s no need to reinvent the wheel. If you\u2019re not sure where to start with Looker Studio, I recommend<a href=\"https:\/\/datastudio.google.com\/gallery?__hstc=20629287.d4f8faff60733b8f63875f668b0dab20.1623674559823.1643795543946.1644690650972.106&amp;__hssc=20629287.1.1644690650972&amp;__hsfp=1680013898\"> browsing through their templates<\/a> for inspiration.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/-k2fYhzrkGoGb62MGux_i0DboUxZl9sJ9U7bG1sWWWxXXYxsTCaKZKrkEsYTIRb7VhJyHD0yOVUkObRnNKPexTmQBv5pcTC1TKU_3YhAxYVUT7ga-YLK5dmZXLgk5c3_TURQKkLnCo3eZeOo9a5uvQM\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Beginner Google Looker Studio Tips: use templates\"><\/p>\n<p>Pay attention to the report\u2019s creator. Many templates were built by the Looker Studio team; you can find them all in the \u201cMarketing Templates\u201d section. But there are also 45+ user submissions located in the \u201cCommunity\u201d section. A few of my favorite templates:<\/p>\n<ul>\n<li>GA Behavior Overview: This dashboard pulls out the most relevant information from the Behavior section of Google Analytics<\/li>\n<li>Paid Channels Mix Report: Use this template to understand how your ads are performing on Facebook, Twitter, LinkedIn, search, and more.<\/li>\n<li>Website Technical Performance Indicators: Get a quick overview of how your site is performing in real-time, including JavaScript and 404 errors and page load times.<\/li>\n<\/ul>\n<p>There are also a bunch of fun, non-marketing templates in the gallery (found in the \u201cFeatured\u201d section), like <a href=\"https:\/\/datastudio.google.com\/u\/0\/reporting\/1kOunw0q0Dazkn42TjwE0V7b1wakEVbs4\/page\/VbVP?__hstc=20629287.d4f8faff60733b8f63875f668b0dab20.1623674559823.1643795543946.1644690650972.106&amp;__hssc=20629287.1.1644690650972&amp;__hsfp=1680013898\">F1: How Important Is the First Race?<\/a> and <a href=\"https:\/\/datastudio.google.com\/u\/0\/reporting\/1QXy-dp4EHsVDljoAeb7BE3PxW9MOPSLw?__hstc=20629287.d4f8faff60733b8f63875f668b0dab20.1623674559823.1643795543946.1644690650972.106&amp;__hssc=20629287.1.1644690650972&amp;__hsfp=1680013898\">Star Wars: Data from a galaxy far, far away<\/a>. Definitely take a look if you\u2019re curious to see the full potential of GSD unleashed.<\/p>\n<h3>2. Publish your report.<\/h3>\n<p>Want to show off your superior analytics and data visualization skills to the world? Submit your report to this gallery using <a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSfvfJh97GcpmJAXz6bIyzKGI_dwb9UapYbXYgyT6IODw6CkJw\/viewform?__hstc=20629287.d4f8faff60733b8f63875f668b0dab20.1623674559823.1643795543946.1644690650972.106&amp;__hssc=20629287.1.1644690650972&amp;__hsfp=1680013898\">this Google form<\/a>.<\/p>\n<p>Read over the <a href=\"https:\/\/support.google.com\/datastudio\/answer\/7540410?hl=en&amp;ref_topic=6291010&amp;__hstc=20629287.d4f8faff60733b8f63875f668b0dab20.1623674559823.1643795543946.1644690650972.106&amp;__hssc=20629287.1.1644690650972&amp;__hsfp=1680013898\">full instructions at this link<\/a>, but here\u2019s what I\u2019d keep in mind:<\/p>\n<ul>\n<li>Don\u2019t share sensitive information. I recommend creating a report with publicly accessible data, so there\u2019s absolutely no chance you get in trouble for sharing data you don\u2019t own. (Pro tip: recreate one of your existing company reports with dummy data from one of Google\u2019s sample data sets!)<\/li>\n<li>Make it awesome. The public reports are impressive, so don\u2019t hold back with design, features, and so on.<\/li>\n<li>Add context. Provide on-page explanations of what you\u2019re measuring or monitoring with captions, instructions, maybe even a video of you walking through the report.<\/li>\n<\/ul>\n<h3>3. Connect to 760+ data sources.<\/h3>\n<p>As I mentioned, you can bring data from Google-owned sources into Looker Studio, including Search Console, Google Ads, YouTube, and Campaign Manager.<\/p>\n<p>But that\u2019s just the tip of the iceberg. There are also more than 120 partner connectors \u2014 essentially, third-party bridges between Looker Studio and platforms like Adobe Analytics, AdRoll, Asana, Amazon Ads, and AdStage (and that\u2019s just the As).<\/p>\n<p>Check out <a href=\"https:\/\/datastudio.google.com\/data?__hstc=20629287.d4f8faff60733b8f63875f668b0dab20.1623674559823.1643795543946.1644690650972.106&amp;__hssc=20629287.1.1644690650972&amp;__hsfp=1680013898\">all the options here<\/a>.<img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/FHNeLSvNlptXbWLKlbvn5teuX234jYTtwMnfPYHGfvYqT7mzI3XlX8iV6PWw4faJUcPgh1JOZ67VEPlPNfGJJpPulL-vHQeQ-MqWW7BHwC1Pu-BUMM-_3n0HscfA6Eh1jqgu0A9wH68HxLAk-3_KjEw\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Beginner Google Looker Studio Tips: data sources\"><\/p>\n<h3>4. Create your own report theme.<\/h3>\n<p>Whether your report is meant for internal stakeholders, like the leadership team, or external ones, like clients, it\u2019ll be more effective if it looks good.<\/p>\n<p>To adjust the report\u2019s style and formatting, click the Layout and theme option in the toolbar.<\/p>\n<p>Any changes here will apply across the report\u2014meaning you only need to pick fonts, colors, etc., once versus every time, you add a new module to the report.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/VNOnc2xl-XCe-muouON0g7BtATh0htg1IpV8VdP1rUi2n4PK3bUlC1PvIaBrBPbM2UAdqtGFLCH9WoYwVaXCUP0unNNaQrjMBZuI1zbKJXzRynoNz_giN3GgGVbyZhyG9c2piex-C907pXv6RCtpxiU\" style=\"margin: auto; display: block; width: 650px;\"><\/p>\n<p>Looker Studio comes with two built-in themes: simple and simple dark. But it\u2019s easy to create your own \u2014 and the results are way more impressive.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/BOkyryqcovGA4Gzyf-fwQoITxPuD3wDWF7JPI9iW9wvp36NPGZcYP7CSy3yb1UAVe05yW7sbTSngw2rVXaMqud5n8XIJtiPmckrjoHuanHNe9GQMpaHtj8JwEyk8WGy7kyIjXL3x1s1V5ZUtirQDexg\" style=\"margin: auto; display: block; width: 254px; height: auto; max-width: 100%;\" width=\"254\" height=\"450\" alt=\"Beginner Google Looker Studio Tips: create your own report theme\"><\/p>\n<p>Click on \u201cCustomize.\u201d<\/p>\n<p>Use your brand style guide to choose primary and secondary colors, fonts, and text color. You might need to get creative here; HubSpot uses Avenir Next, which Looker Studio doesn\u2019t offer, so I went with its cousin Raleway.<\/p>\n<p>If you\u2019re creating a report for a client and don\u2019t know their hex codes, Seer Interactive\u2019s Michelle Noonan <a href=\"https:\/\/www.seerinteractive.com\/blog\/data-studio-tips-for-non-designers\/\">has an excellent tip<\/a>: use a free <a href=\"http:\/\/instant-eyedropper.com\/\">color picker tool<\/a> to identify what they\u2019re using on their website.<\/p>\n<p>You can also create a custom chart palette in this tab and edit the border and background settings.<\/p>\n<h3>5. Embed external content.<\/h3>\n<p>Just like you can bring your report to the wider world, you can also bring the wider world to your report.<\/p>\n<p>You can insert Google Docs, Google Sheets, YouTube videos, and even live webpages with the URL embed feature. Embedded content is interactive, so it\u2019s far more powerful than a screenshot.<\/p>\n<p>Click \u201cURL embed.\u201d in the navigation bar to add content.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/lr6OvK64uifknSEjv2VnZbl-VqCjrkczryqCdMJ5fB8FUbRd3MQszbiA36CDj69B6mDyEXuDj6ozgCB4nSccGGtRNTb0qg0UzMe1zE-DsGaJMBJ_i4EVkhOWQaF4-jByVPztxDkh4A8OwmKsJcfxDHw\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Beginner Google Looker Studio Tips: embed external content\"><\/p>\n<p>From there, simply paste the URL. Next, you may need to resize the box that appears to fit your content&#8217;s entire length and width.<\/p>\n<p>The options here are pretty endless. One of my favorite ways to use this feature is to embed a Google Form gauging how helpful the report was for my audience:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/jE3UgRFint07hL-FRbijT-tPQc4Gw6qbRl-HQj49HfKZql7x7dWmbAbN0cJ3M2EKp0XZXrF0PqstujXk2Tsm2VyBeMzMDkJkwWDpygQMxtYf7JrUL_XP_I2oAkdZyaxMZ22A3sWomJWLhydnrAhhBwI\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Beginner Google Looker Studio Tips: embed form\"><\/p>\n<p>If a section of the report needs extra context (or my viewers aren\u2019t that technical), I\u2019ll add a short video explaining what they\u2019re looking at and how to interpret the results.<\/p>\n<p>To personalize a report for a client, I\u2019ll add the URL of their website, blog, and\/or whatever pages they hired me to create or improve.<\/p>\n<p>And for the HubSpot blogging team, I\u2019ll add the latest version of the Search Insights Report so they can compare our progress to the results.<\/p>\n<h3>6. Send scheduled reports.<\/h3>\n<p>If you have a group of stakeholders that need to see your report regularly, consider using Looker Studio\u2019s \u201cscheduled report\u201d feature.<\/p>\n<p>Click on the drop-down menu beside the \u201cShare\u201d button and select \u201cSchedule email delivery.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/42GWJ0SaWKSuDBBdbnFim2CVPk-U4voX6bVb-7linyan7c4-iqviCWUvkeYGHpkwRuln_tLYP8m8pEzZZ-tAzdMGiwcnLzHDd86SMhuHlbNF9CkCXGBVJ3X6LYhOCTn6WtuiMCHgHz-7o7rqYCsYJOY\" style=\"margin: auto; display: block; width: 440px; height: auto; max-width: 100%;\" width=\"440\" height=\"450\" alt=\"Beginner Google Looker Studio Tips: send scheduled reports\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>First, enter your recipients\u2019 email addresses, then choose a schedule, whether daily, every Monday, or every month.<\/p>\n<p>This is particularly handy when working with customers, since you may not want to give them access to the live report.<\/p>\n<h3>7. Download the report as a PDF.<\/h3>\n<p>Alternatively, you can download your report as a PDF. This is helpful for one-off situations, like if your boss asks for a status report or your client wants to know how an ad has performed so far this month.<\/p>\n<p>To download the file, click \u201cdownload\u201d on the drop-down menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/0isiWtrwAUucK1D7scn5z_Bgb8aAsaA1Ihccl1ETJkFwA39c3bD1cbGnuPZ2zDzrr5-wQcpDW_M_-Gisva-A8_d7f_bHH0mxtvGuRYVXdv4kTQ2-_GF2wWzlZdRGFiTsEAow0pTevzIoPXpr8Ka1eC0\" style=\"margin: auto; display: block; width: 406px; height: auto; max-width: 100%;\" width=\"406\" height=\"450\" alt=\"Beginner Google Looker Studio Tips: download reports as pdfs\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Looker Studio gives the option of downloading your current page or the entire report. You can even add a link back to the report so your audience can dig in deeper if they\u2019d like and add password protection to ensure your data stays safe.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/eqb3R_9xzZ_2QULQS-xctONVSXa129d8W-1uY-k0CM_ZcRpvYkoUkCnmpVTqETXQsHG43JOBTYY6re2vLIJoS5q9sGH6ELyENyE03zc9bMXNNYHzaW7WO7aK_8zzGWsMnrZSlZ9gFHENabH3eZ_H6g\" style=\"margin: auto; display: block; width: 528px; height: auto; max-width: 100%;\" width=\"528\" height=\"400\" alt=\"Beginner Google Looker Studio Tips: download report as pdf\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h2><strong>Intermediate Google Looker Studio Tips<\/strong><\/h2>\n<h3>7. Add a date range.<\/h3>\n<p>Give your viewers more freedom by letting them select which dates they\u2019d like to see information for.<\/p>\n<p>For example, my reports always default to the last 30 days, but if one of HubSpot\u2019s blog editors wants to see how their property performed in the previous calendar month, the date range controls let them adjust the report.<\/p>\n<p>They can choose from predefined options, like \u201cyesterday,\u201d \u201clast seven days,\u201d \u201cyear to date,\u201d etc., or pick a custom period.<\/p>\n<p>To enable this, first navigate to the page you want to give users date control. Next, click on the drop-down menu by \u201cAdd a control.\u201d Next, click \u201cDate range\u201d from the toolbar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/ZED9BT46j-YZfVsYtkuSSgb9R7Zi_Led0fGsynsGO_yu92Ym6Ce9tvG1-nGKe9vZUHsQO-8aDBO1VYWgtmYzYtLWOIImgFHLxLgMPJPhRQiBP5ijpZFSTQUlU0mnLPasSBrZdybJeTpjsC82wpbYYQ\" style=\"margin: auto; display: block; width: 450px; height: auto; max-width: 100%;\" width=\"450\" height=\"450\" alt=\"Intermediate Google Looker Studio Tips: add a date range\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>A box will appear on your report. Drag it into the position you want \u2014 I recommend somewhere in the upper right or left corner, so your audience sees it first \u2014 and adjust the size if necessary.<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/yFJ2SfTs0IKmMF87GAziOQVf1Rkeif8PkC9p9oB7xduKBSXZ-fNZ0jW82MgaDyPegt4SqrGaVyfKmdP7edVZIMRoCLRSFl2Nilt_09fWxQKYI36r8BpUcle8JOq_QIqD0gNu1Rfl8RYeJ_oAA19S6EY\" style=\"margin: auto; display: block; width: 643px; height: auto; max-width: 100%;\" alt=\"Intermediate Google Looker Studio Tips: select a date range\" width=\"643\" height=\"450\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Clicking this module will bring up a panel on top of your report called Date Range Properties. Set the default date range to \u201cAuto date range,\u201d if it isn\u2019t already.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/HbrDAOIciQl9QQFw9TT7j_XXcu0GPr0qsYzuVW5LnaznBTTim6SAEJHX8K1MqcAugXa_EzKIpqmXX8mBFG_wp1j8vLPFx4VwCUGI8HIRoJT8v6Rc0S3aghwjQG_42vb-atbStzErZZR8e8OFbB-VY40\" style=\"margin: auto; display: block; width: 500px; height: auto; max-width: 100%;\" alt=\"Intermediate Google Looker Studio Tips: auto date range\" width=\"500\" height=\"450\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>If your viewers select a date range using the date range widget, every report on the page will automatically update to that period.<\/p>\n<p>There are two ways to override this:<\/p>\n<ul>\n<li>Set a time period within a specific chart. That time period will always supersede the date range control.<\/li>\n<li>Group the charts you want to be affected by the date range control with the module. Select the chart(s) and the box, then choose Arrange &gt; Group.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/XWIDeYC9M21Aml2BFjn6DHViSSKVggQgJQdpV9OB32TGi40RMLLQg4nFghFWyLtjEIwYbYzK-TC_SQRTVyIFzsDtpOKbzmdhUSNmchU5vdXK8A2DKSFatEi7FSFHo8twlByT7CKAr20o-7IeAtWu51U\" style=\"margin: auto; display: block; width: 500px; height: auto; max-width: 100%;\" width=\"500\" height=\"450\" alt=\"Intermediate Google Looker Studio Tips: group charts\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Now, only the chart(s) in this group will update when someone adjusts the date range.<\/p>\n<p>Make sure this setting is clear to your viewers \u2014 otherwise, they\u2019ll probably assume all the charts they\u2019re looking at on their current page are using the same time period.<\/p>\n<h3>8. Create interactive chart filters.<\/h3>\n<p>Want to make it even easier for your audience to filter the charts in your report? Create responsive chart filters.<\/p>\n<p>This sounds fancy, but it simply means selecting a dimension in a chart will filter all the charts on that page for that dimension.<\/p>\n<p>For instance, if you click on \u201corganic\u201d in this chart, the other charts on the page will update to show data for organic traffic only \u2014 just like you\u2019d applied a traditional filter control.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/6eWu5VdYU103DdO5Ceu6Ihr4VC5MbVsAmiVR3g0X1aGHu9DymcpUnq1T-NiHIfSZpx0n1-4nR1e8NP28x1IEfwOB6BSnhNWjNSqC9mSL16B8ABN_CZGuR5lMVjS4exTMFM8sS6kIL3EQSiMWRCIEnw\" style=\"margin: auto; display: block; width: 409px; height: auto; max-width: 100%;\" width=\"409\" height=\"350\" alt=\"Intermediate Google Looker Studio Tips: create interactive chart filters\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>You can also create chart controls for time, line, and area charts. For example, if a user highlights say, January through March on a time chart, the other charts on the page will show data for January through March as well \u2014 just like date range control.<\/p>\n<p>And also, just like filter controls, you can group chart controls.<\/p>\n<p>To enable chart control, select the appropriate chart. In the right-hand panel, scroll to the bottom and check the box labeled \u201cApply filter.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/hwZRTggd9n4NQ2-s851bjVJKpKPuBJ1csLFus0u51CaaPolz9gdToumrx5KJZmr0nsikIXj0n-DLX8QKqySpwppb14lPzPNAAJi3CKDxMfFcRRuCl0ZxmcVh6JLXqU7XBlMddF5ElIxtvy-QvrLrlA\" style=\"margin: auto; display: block; width: 224px; height: auto; max-width: 100%;\" width=\"224\" height=\"450\" alt=\"Intermediate Google Looker Studio Tips: apply filter\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Add a caption next to charts that support interactive filtering, so your viewers know it\u2019s an option:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/d84VEai9RLLKWoUauf_4JpqeGBvdYFcNX0MC3KsEVAFs2b75BzzB2vWltmxs43-VWnNDuk6HO1LBqE_6o7bjU8b3VdU8zjrVPFgQZn2HjopCjVoIJPE44ViW3XkU2jQ_3SPI28DduHPlDdrP2K8KEA\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Intermediate Google Looker Studio Tips: add a caption to the chart\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h3>9. Add a data control.<\/h3>\n<p>Data controls may just be one of the coolest Looker Studio features, full-stop. Place one of these bad boys on your report, and you\u2019ll give viewers the ability to choose the source of the data being piped into your charts.<\/p>\n<p>This is a game-changer for anyone managing a complex property or working with multiple stakeholders.<\/p>\n<p>For instance, imagine you\u2019re the admin of HubSpot\u2019s Google Analytics account. You create a Looker Studio report monitoring key website performance indicators, like average page speed, number of non-200 response codes, number of redirect chains, and so on.<\/p>\n<p>You share this report with the blogging team, who has access to the Google Analytics view for blog.hubspot.com. (Need a refresher on how views and permissions work? Check out our <a href=\"https:\/\/blog.hubspot.com\/marketing\/google-analytics?_ga=2.87921816.1838187926.1557323413-644648569.1551722047&amp;hubs_content=blog.hubspot.com\/marketing\/google-data-studio&amp;hubs_content-cta=ultimate%20guide%20to%20Google%20Analytics\">ultimate guide to Google Analytics<\/a>.)<\/p>\n<p>You also share the report with the Academy team, who has access to the GA view for academy.hubspot.com, and the Leads Optimization team, who has access to offers.hubspot.com.<\/p>\n<p>To see this report populated with the relevant data, these teams simply need to select their view from the \u201cdata source\u201d drop-down, and voila \u2014 all the charts will update automatically.<\/p>\n<p>Pretty nifty, right?<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/ZmxfwCbnWbjzHnVCSGzsRFoVwwZ06cfYAwpm7fDKiyFylZGMo0mUJ8A8g7JMGM8zZUrNK7CLcbUKy1i26F2uMud0jrJBzpQCedhvROkUPnfkc2qaIInwAv_L7zS0_YEFGH01BCWOOqsWoQGjslToUQ\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Intermediate Google Looker Studio Tips: add data controls\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Not only does this save you from rebuilding the same report for different groups, but it also means you don\u2019t need to worry about accidentally sharing sensitive or confidential information. Each viewer can only select data sources they\u2019ve been granted access to.<\/p>\n<p>You can include multiple data controls in a single report.<\/p>\n<p>Add the data control widget to your report by clicking this icon:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/5kT7v_B83WgFHo4TfaUu7SDgwEaSLMHymCjmXWQd7YCZUcD-2vfBgL0r3FjSzZ3rv6x9MNXzeKl_mqqoIkRx9jIp6MAGNfgZgOKXD3NjYoZg_5Xr7BdRHAjUjJySSTye5BCfRqP1k4D-SAEJ-CKOxQ\" style=\"margin: auto; display: block; width: 650px;\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a>Then choose which primary source you\u2019d like viewers to pull from:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/d-hlDP8eYhgB6UVB4qRMLbgp-GgCp7o7gBEme3DWaXXBemMfj31L0I_fdNcodaMyJ9eHp5KzYJ8optj19hbBZpZ_cBddlRUARtxchFEdl7TYQ4i2Q50hP7drhOr38YaMu6QGC5HE2Sw2KT4XUwkI7Q\" style=\"margin: auto; display: block; width: 230px; height: auto; max-width: 100%;\" width=\"230\" height=\"450\" alt=\"Intermediate Google Looker Studio Tips: choose a primary source\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h3>10. Add a dimension breakdown.<\/h3>\n<p>Instead of telling you what a dimension breakdown is, it\u2019s easier to show you how it works.<\/p>\n<p>Suppose we want to see users by source. To find out, we create a simple bar chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/HdPKWhjjR9BVeb5I-bE0j5oyrMHzIqxiaPkBsBR-xC3vUpx_tIWDHvfrhyVWSacxXeHYm6mFjZ3H2_jwwErL0ZG4YwcQIIhOFN0saIiLnyRGIZwNVp5HdmSNKV-ayl9EmeKulUpIVzNYRrIQhNRyCw\" style=\"margin: auto; display: block; width: 518px; height: auto; max-width: 100%;\" width=\"518\" height=\"450\" alt=\"Intermediate Google Looker Studio Tips:  add a dimension breakdown\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>This is interesting \u2014 yet there\u2019s some context missing. For example, is all of that organic traffic coming from Google? (Since this is U.S. data, probably, but imagine creating the same chart for China or Japan, where Baidu and Yahoo have a far greater presence.)<\/p>\n<p>What about referral traffic? Clearly, we\u2019re getting a significant number of users from referral links; is a single source driving most of them, or is it distributed fairly equally across a wide variety of sources?<\/p>\n<p>We could create separate bar charts for each source \u2014 first filtering by medium and then making the dimension \u201cSource\u201d and the metric \u201cUsers.\u201d<\/p>\n<p>Or we could click a single button and have Looker Studio do it for us.<\/p>\n<p>Under Breakdown Dimension, click \u201cAdd dimension.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/aLThBJbejNVM7v4OHU0VW6WaQ-NqzzRhq_8gsZVOSUy0-nd77TsJDOgizRVlQaEmAudF84a-G1QdQwdoqw547uL9nhsKTQa4FgHalgW9lCvMpwhgbW1Gpiphi1MWgP9UWIFW44S1iN62MoD1lX1q_w\" style=\"margin: auto; display: block; width: 224px; height: auto; max-width: 100%;\" width=\"224\" height=\"450\" alt=\"Intermediate Google Looker Studio Tips: add a dimension\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Add \u201cSource.\u201d<\/p>\n<p>Here\u2019s what you should see:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/WGb8ySUrSVRbFRqQMxBIByZf2Yq873YPqo0nxcHAUvbnKqFuRSsQUNznRbInG5G3iKXJ5PGm4OYKbDafN7uBJzkZ0txEatQFXyg8qaTPJZO5cXMA1OdkUW_v056eQd5nDgrkvU30OZvqJNGcmoz8Lg\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Intermediate Google Looker Studio Tips: add source\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Pretty sure my former Data Analytics professor would cry if he saw this. But don\u2019t worry, we\u2019re not done yet.<\/p>\n<p>Jump over to the \u201cStyle\u201d tab and check the box \u201cStacked bars\u201d to turn your regular bar chart into a stacked bar chart (you should see the chart type update accordingly).<\/p>\n<p>Looker Studio will automatically make your bar charts \u201c100% stacking,\u201d meaning that every bar will go to the top of the chart. However, this style is misleading \u2014 for example, here, it suggests every medium drove the same number of users.<\/p>\n<p>Uncheck this box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/xbg0d9NTOxH7LsYmgoNwqXpXZNHvIco2bLZEdvUJK5OMsKYRpVzL62HSigVhKJ1pL_o1UwFmAN-I4ivM22uOfFEWczAHwpt0kAStI18k9R4Fsoes5RGtc5kI3osHVWLjOH4LjdzqmD3ec29k7S634Q\" style=\"margin: auto; display: block; width: 216px; height: auto; max-width: 100%;\" width=\"216\" height=\"450\" alt=\"Intermediate Google Looker Studio Tips: uncheck stacking for the bar chart\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Now check it out:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/2hsv6Iur_L4Ib8JgAoZgmIgkrVYFDvFo_3SRqGsVm7_1v3GTSckI2_1oWj0yH7OV0YEcy0s7C9oWPrFZA18Q76LTSjsFJlkOS3l2HxqzAUJe_GTis5BAKDVeynZ4YQlYTgnCbClXXmVQfvWam4TMVg\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Intermediate Google Looker Studio Tips: bar chart final result\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h3>11. Use Looker Studio Explorer.<\/h3>\n<p>To bring any chart into Explorer, mouse over the space next to its top-right corner. You\u2019ll see three vertically-stacked dots appear; click them.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/FRWd1JeWdD3f79U7MqCuG_0AUL-74DcJHt3LHigf64c2wryy0CLHRj9p8AA2ADRnhhFKILuViinStX0pUbEL_j_okv9R1O5p6aqLEPsUnV46inJT-1iAJ881Jh7KLyJ1ePF4bJGmOxj8DgVCKju43w\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Intermediate Google Looker Studio Tips: use looker studio explorer\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Select \u201cExplore.\u201d<\/p>\n<p>You\u2019ll see something like this:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/LvZRnafF5TdBuyF2i552WXNKlIMqwx0fylqUapOddxDOUzkKARjhf-6aN6qvM9EWi4m9EW1n2SOARtC_Gu1CfIUVBG85PN5TVT4nI474MqWGHKos9PleOIh_GqC6JrqXYFem3Xgy9D--VZowOUnfIQ\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Intermediate Google Looker Studio Tips: explorer\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>You can toggle between different visualizations; add and remove dimensions and metrics; change the date range, and apply segments.<\/p>\n<p>Note: Unlike every other Google tool out there, Explorer does not automatically save your work.<\/p>\n<p>To preserve your chart, click the \u201cSave\u201d button on the top nav bar (to the left of your profile icon). Once you do that, your Explorer \u201creport\u201d will be saved in the Explorer section of your dashboard. In addition, every change you make will be saved by default.<\/p>\n<p>Speaking of that dashboard, if you prefer, you can also start with Explorer (rather than a Looker Studio report). Go to your <a href=\"https:\/\/datastudio.google.com\/u\/0\/navigation\/reporting?__hstc=20629287.d4f8faff60733b8f63875f668b0dab20.1623674559823.1643795543946.1644690650972.106&amp;__hssc=20629287.1.1644690650972&amp;__hsfp=1680013898\">Looker Studio dashboard<\/a> and select \u201cExplorer\u201d in the top menu.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/blog.hubspot.com\/hubfs\/studio%20explorer-png.png\"><br \/><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Create a new Explorer view by clicking the &#8220;Create&#8221; button on the left side..<\/p>\n<p>At first, Explorer confused me. It feels very similar to the core Looker Studio \u2014 what was the point of having both?<\/p>\n<p>However, after spending some time in Explorer, I\u2019ve come to appreciate its unique value.<\/p>\n<p>Unlike Looker Studio, any modifications you make to a chart in Explorer are temporary. That means it\u2019s a great place to dig into your data and try out different ways of visualizing it without making any permanent changes. Then, once you\u2019re happy with your chart, simply export it back into Looker Studio.<\/p>\n<p>To do this, click the small sharing icon in the top navigation bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/t5Q_8MosH7aPkh5YWnY7ehK1ewEBPP_mA6UrqQNLg1lKQtsNMH1W1jRGhd50NzRmslnQXik8XuMIkXuJzX9ihtSzqeKAHkmExdLt5lfkcRzK4Nxm3xi7QtSi1EtVDvKYiBV3qqdv4bOGSMQI4QEBeQ\" style=\"margin: auto; display: block; width: 187px; height: auto; max-width: 100%;\" width=\"187\" height=\"450\" alt=\"Intermediate Google Looker Studio Tips: share the explorer view of the report\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Then choose whether to add your Explorer work on a new or existing Looker Studio report.<\/p>\n<h2><strong>Advanced Google Looker Studio Tips<\/strong><\/h2>\n<h3>12. Create report-level filters.<\/h3>\n<p>By default, a filter applies to every chart on that page. But what if the viewer goes to the next page? The filter won\u2019t go with them.<\/p>\n<p>This is confusing for non-technical folks and inconvenient for data-savvy ones. To bring a filter up from page-level to report-level, simply right-click on it and select \u201cMake report-level.\u201d<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/y59rRPqOoTv6uCh1yhRQTw4Fsp10gRBRvh6luPvxrb8Lt30cE8qBG-75Qj6D--66lTlqM_OxaZAdT8UYc1Io_SpChIYzzR5c9wKlNL1RaI4dD2NJEGq0SsOUdcjt-Fx9xwdR29UQwnNYNj1dZBrUsT4\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: create report level filters\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<h3>13. Create blended fields.<\/h3>\n<p>Looker Studio is powerful because you can bring in 760+ sources of data into a single report. But, thanks to a new feature, blended sources, it just got even mightier.<\/p>\n<p>Heads up: this will get a little technical. Stay with me, and I promise it\u2019ll be worth it.<\/p>\n<p>If you\u2019re familiar with JOIN clauses in SQL, you\u2019ll understand data blending right away. No idea what SQL is? Not a problem.<\/p>\n<p>The best way to think about blending data is with a Venn Diagram. You have two data sets. Each data set has unique information \u2014 e.g., such as the data living in the green and blue areas.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/j23zJcaZbk6TSvCVQgH4Ax-CJR32oQXvp_V10qRcH3gfgWNN6dcJXATK__An6QZldEjXtTHq1CH90EQv2QKbJ-0iXNRZgbmMUikWK10kcqVeW9_zCKSXcUvbW9z-UCDo6ZwokkknQH4G3BoK75-xwQ\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: create blended fields\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>But they have (at least) one data point in common: the information in the blue-green overlap section.<\/p>\n<p>This shared data point is known as a key. If your data sets do not have a key, they\u2019re not blendable.<\/p>\n<p>For example, suppose you want to compare how users behave on your website versus your app. The key is the user ID, a custom dimension you\u2019ve created in Google Analytics that your app analytics software also uses. (Note: The key doesn\u2019t need to have the same name in both data sources; it just needs to have identical values.)<\/p>\n<p>You blend your website behavior report from GA with your app usage report. This gives you all the records from the first report along with any matching ones from the second; in other words, if a user has visited the site and used the app, they\u2019ll be included.<\/p>\n<p>However, if they only used the app but didn\u2019t visit the site, they will not be included in the new blended data.<\/p>\n<p>This is known as a LEFT OUTER JOIN. (To learn more, check out <a href=\"https:\/\/www.w3schools.com\/sql\/sql_join_left.asp\">this W3Schools primer<\/a>.) Why do you care? Because the order of your data sources matters.<\/p>\n<p>Put your primary data source first \u2014 e.g., the one where you want all the values, regardless of whether there\u2019s a match in your second source.<\/p>\n<p>Now that we\u2019ve gotten all that out of the way, let\u2019s set up a blended field.<\/p>\n<p>First, add a chart to your report, then click on \u201cBlend Data.\u201d<img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/aq25hENZ8MNk5YWYa3YE2Qx_UkXEuvaDBnDy4wP96NrA-v5i3VgNDyNK9_L3GEAi1ejGfi2yq4eSATvg-QNVw72K0fcWFjYxdS6BP3TV-HXQ7ARfNEWOMOYOrwnlrGQC2QtaxOHQtg5TSRnv8e4_XBs\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: blend data\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>This panel will pop up:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/NZfd1vw3iT5Dc3sN6zmVyjgY-3d3vZ8gY4sQVkdER83je1_Ue_7VENK3Iy115YbM6k1bDLsqsOl0XOZlE4NUD3QujezplOwL-ikelssc3J5L3tDQ5PyK3FDP2h9FRtEcep3Jxwd27QyVh1yD2HRWaA\" style=\"margin: auto; display: block; width: 650px;\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Select your first data source on the left. Remember, this is the primary data source. Then add your second data source. Looker Studio lets you add up to five data sources in a chart, but let\u2019s stick to two for now.<\/p>\n<p>Now pick your join key(s). If the field exists in both sources, it will turn green. If it doesn\u2019t exist, you\u2019ll see this:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/BNDLg_7Pe9bTvEgf097ZA6MH3QR81XECVkKqWg-XashSwh1s6Wxv2H-euKnDtEaBEcnqlJmAiZTPLrO93WTcSDxf_tOgVVTjMFDcVHSsyH983mP-LGLGX45aS6sf8dgkUDQGBXh0xroSDErIeBYUQA\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: establish keys\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Remember that the key acts as a filter for the second data source. So in this example, only records that match the landing page from the GA view for hubspot.com will be pulled from Google Search Console.<\/p>\n<p>Choosing multiple keys will further limit the number of records pulled from the second data source.<\/p>\n<p>Once you\u2019ve picked your join key(s), pick the dimensions and metrics you want to see for your first data source. Then do the same for your second.<\/p>\n<p>You can also limit the results by adding a filter or date range (or for GA sources, segments). Filters, date ranges, and segments applied to the left-most data source will carry over to the other data sources.<\/p>\n<p>Once you\u2019ve finished customizing the report, click \u201cSave.\u201d Congrats: you just created your first blended data chart!<\/p>\n<p>If you find it easier to create two separate charts and then combine them, Looker Studio offers a great shortcut.<\/p>\n<p>Just select both charts, right-click, and choose \u201cBlend data.\u201d<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/pZZjXt0n8dpCi8RtMV97ER-gclzcv6fuzMbAzSHZLpsDwPziUxlI0a4oWXAkDg4eCZXliSm-dakPCFb-F58PTljSKx1D7miRTM3JLqB_l5j3sFGYZaFE4zRHwapUhKDIz-qb8w4pchXmtksk07zggQ\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: create and combine two separate charts\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a>Unfortunately, Looker Studio can get confused pretty quickly, so I\u2019d still make an effort to learn how to blend data using the right-hand pane.<\/p>\n<h3>14. Blend your data source with itself.<\/h3>\n<p>Try this workaround if you\u2019re bumping into limitations with your data source connectors: blend a data source with itself.<\/p>\n<p>To give you an idea, the GA data connector only lets you add one \u201cactive user\u201d metric to a chart, so there\u2019s no way to see 1 Day Active Users, 7 Day Active Users, and 28 Day Active Users on the same chart\u2026 unless you blend your Google Analytics data source with itself.<\/p>\n<p>Follow the same instructions as above, but instead of picking a new source for your second data source, just select the first one again.<\/p>\n<p>And since all of the fields are identical, you can pick whichever join key you\u2019d like.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/_T0inC96jkay62A6jne4ShWEPlMtAxb_X5hIFZavR0gm_l6YGXwLOhYUpwOw6J1KON3_TAGLezCKn1xOb0A9Pb44AfZnWgPaA3aGuFgxYKKV0E1gHBEetJ54hI3JtGK-EocnW8_KYmLLOHPSJNAfVw\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: blend data source with itself\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>This option is also perfect when comparing trends across two-plus subdomains or segments.<\/p>\n<p>For instance, I wanted to look at organic users for the HubSpot Blog (blog.hubspot.com) and primary site (www.hubspot.com) at the same time.<\/p>\n<p>This helps me figure out if we\u2019re growing search traffic across the board. It\u2019s also helpful when traffic decreases \u2014 have rankings dropped site-wide, or just for the blog (or the site)?<\/p>\n<p>However, you can\u2019t add two separate \u201cuser\u201d metrics to a chart at once\u2026 unless, of course, you\u2019re blending data.<\/p>\n<p>Create a new blended data source (following the same process as above) to set this up.<\/p>\n<p>Add your first view to the left-most column, your second view to the following column, and so on.<\/p>\n<p>Note: Make sure you\u2019re choosing views with mutually exclusive data. In other words, I wouldn\u2019t want to use \u201cblog.hubspot.com\u201d as my first source and \u201cblog.hubspot.com\/marketing\u201d as my second source because all the data for the blog.hubspot.com\/marketing view is included in the blog.hubspot.com one.<\/p>\n<p>Because of that overlap, we wouldn\u2019t be able to spot trends clearly.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/nlCXDghcyRR2gwlwCxd1q5kxj0_2Q1QBx88DoSad-ekeCUUgDgKnpZaFuV6HUx0zKUCp_BOTUnClUl6Su56p1PTm0_P6bfrQ8v_5HyvZcVdKLXvfRR-ItvLZXdk0AON_ssW0L9MtBbVzq08P1Hf-Gw\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: spot trends in blended data\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a>Use \u201cDate\u201d as the join key.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/JWWUEbCaMH15KOiXuQTlGRYSCKhX9YgOEZCiccFb_Z27jVNCLx-vHmFC7UBrAqGT5bCZF5oUrQ-0PIIqwlICfxLJ1QvYTakBlpTDiOFGlqRpVmCOQD6kdDcPMsMTzaed-BTJOqp-oFmAxmMOqULW7Q\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: use date as the join key\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>I added the organic traffic segment to both sources, but you can choose whichever segment you\u2019re interested in (paid traffic, social traffic, etc.) Or leave it off entirely! Tons of possibilities here.<\/p>\n<p>In fact, here are some additional ideas for blending a source with itself:<\/p>\n<ul>\n<li>Compare two-plus custom segments<\/li>\n<li>Compare two-plus landing pages<\/li>\n<li>Compare two-plus goal completions<\/li>\n<\/ul>\n<h3>15. Create a basic calculated field.<\/h3>\n<p>When your existing data doesn\u2019t give you enough information, it\u2019s time to create a calculated field.<\/p>\n<p>Calculated fields take your data and, as their name suggests, and make calculations.<\/p>\n<p>It\u2019s probably easiest to explain with an example.<\/p>\n<p>Let\u2019s say you want to look at the average number of transactions per user. You can create a calculated field that takes the metric \u201cTransactions\u201d and divides it by the metric \u201cUsers.\u201d<\/p>\n<p>Once this field has been created, it\u2019ll be updated automatically \u2014 so you can change the chart\u2019s time range, dimensions, etc., and the average transactions per user data will update accordingly.<\/p>\n<p>There are two ways to create a calculated field.<\/p>\n<h4>Create a data-source calculated field<\/h4>\n<p>This option makes the field available in any report that uses that data source.<\/p>\n<p>It\u2019ll also be available as a filter control or in new calculated fields (like calculated field inception).<\/p>\n<p>Obviously, this is a good option if you plan on using this custom metric more than once. The only caveat \u2014 you must have edit rights to the original data source. You also can\u2019t use a data source calculated field with blended data.<\/p>\n<p>To create a data-source calculated field, add a chart to your Looker Studio dashboard, then choose the data source you want to derive your new field from.<\/p>\n<p>Click \u201cAdd a new field\u201d in the lower left-hand corner.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/RoHuNvrTyfp-rx3REfIPBpb7Z7iEQYDeqSANG6tiZRiOXPV_0yivfkUkvEdhZjBxHUBWPoDyLOIY0pikRLD2lmSmB9z8oW_lyWSk2VEes1vOXACIQrztelZ5m7XXY-3RnJXshglV7HtgRzujKl2xyw\" style=\"margin: auto; display: block; width: 229px; height: auto; max-width: 100%;\" width=\"229\" height=\"450\" alt=\"Advanced Google Looker Studio Tips: create a data source calculated field\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>(You can also do this by clicking the pencil next to the data source and then selecting \u201cAdd a field\u201d in the upper right corner of your field menu.)<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/RVhCxUe-euAFsSZHWxFQKBYk7-Dkfqu782aRQ-xWVVC8NSG6oekMupq20s0F99b_FxNvrq-dAnd8bqqsA_JsxxO8YPUvokaRf0TQ4hY1gMuHLsLxnIufrHY7nc7_Kn2g3Z14ibBdhQGXFUYFa59B2w\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: add a field\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Use the left menu to search for the metrics you need; click one to add it to the formula.<\/p>\n<p>If the formula has an error, a notification will appear in red underneath the editor explaining where you went wrong.<\/p>\n<p>If your formula works, you\u2019ll get a green checkmark.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/rtT15avUUz_T-Zx6cbdkrks-pD9vnNrxGgv3hm0GwLT7cy8fCn_N3RZICIENuCEJzpwT5YhwH5war-EpzYjLIx2DPLxVoRAbfk5JOHXq29B_0O3JXN--uEoLM6N8PDURZH4yPi2P9_6wRCuv78V-DA\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: formula works correctly with green checkmark\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Click \u201cSave\u201d to add your new field to the data source.<\/p>\n<p>And don\u2019t forget to name yours \u2014 which I forgot to do. \ud83d\ude42<\/p>\n<p>Now you can add this calculated field to any chart just like a regular field.<\/p>\n<h4>Create a chart-level calculated field<\/h4>\n<p>For this option, you\u2019ll only be able to use the field for that specific report.<\/p>\n<p>This option is a little easier because all the limitations of the other type are reversed.<\/p>\n<p>While you can\u2019t use a chart-level calculated field in another chart, filter control, or additional calculated field, you don\u2019t need edit rights to the original data.<\/p>\n<p>You can also use a chart-specific calculated field for data blending, which we\u2019ll cover in the next step.<\/p>\n<p>To create a chart-level calculated field, simply click \u201cAdd a field\u201d underneath the existing dimension(s) and metric(s) you\u2019ve selected.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/sgPwd7bs75xd5hdkqZfsITHN3A7xUxp-zsf-_bk7hdbTss4UDWckQTX_m7CnX2Rxr52lIYC3_DmnMe0vwW5xxHuLadPJNgMGIANH-tkpeO7osgVnGomV6HH5BGkfki8-zOO0aJKwvAKPX6_IbvSuwQ\" style=\"margin: auto; display: block; width: 219px; height: auto; max-width: 100%;\" width=\"219\" height=\"450\" alt=\"Advanced Google Looker Studio Tips: create a chart level calculated field\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a>When you choose to add a new field, this pane will pop up:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/OPtLbaS29j0MywkvLqE9tZvHEw7sCxPx4YgmWAKFmdjul16x6MQU1bD1FpEZeyObmgtp7AdXen83ZLMVykzIwsZleIOSHHuniBvMz6pSNfpeRy6DM1SBy3GSRCtbfardepTHB8s4cgUsg2eUWY4ymQ\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: total portals\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>From here, enter the formula for your new field \u2014 simply typing in the name of your desired metric will trigger a menu of options \u2014 and click \u201cApply.\u201d<\/p>\n<p>Your new field will be added to the chart.<\/p>\n<p>Loves Data\u2019s Benjamin Mangold has an excellent <a href=\"https:\/\/www.lovesdata.com\/blog\/calculated-metrics\">round-up of sample calculated metrics<\/a>, including:<\/p>\n<ul>\n<li>Average goal completions per user<\/li>\n<li>Non-bounce rate<\/li>\n<li>Pageviews per transaction<\/li>\n<li>Value per session<\/li>\n<\/ul>\n<p>You can check it out for inspiration.<\/p>\n<p>If you want a little practice before you start going to town on your own data, Google offers a handy <a href=\"https:\/\/support.google.com\/datastudio\/answer\/7569890?hl=en&amp;ref_topic=7570421&amp;__hstc=20629287.d4f8faff60733b8f63875f668b0dab20.1623674559823.1643795543946.1644690650972.106&amp;__hssc=20629287.1.1644690650972&amp;__hsfp=1680013898\">sample exercise<\/a>.<\/p>\n<h3>16. Create an advanced calculated field.<\/h3>\n<p>Okay, so there\u2019s a lot you can do with simple algebraic calculated fields. But there\u2019s even more you can do once you introduce functions and RegEx.<\/p>\n<p>Don\u2019t be scared off! We\u2019ll walk through these step-by-step.<\/p>\n<p>If you\u2019re comfortable with Google Sheets and\/or Excel functions, you already know how to use functions in Looker Studio.<\/p>\n<p>For instance, let\u2019s say that you majored in English, and it\u2019s always bothered you that \u201cSource\u201d in Google Analytics is lower-case.<\/p>\n<p>You can use the UPPER function to transform Source into all upper-case.<\/p>\n<p>Simply click \u201cAdd dimension\u201d &gt; \u201cCreate new field.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/5TOraEy8cJW6hXPAdVQT3d1zLsqvu_LS9H8tB6EyTo262fZyDOwfpJveXLGUrwtHMOoKlnZLAAamFUD55jebLmH9PJy-6teiuAIC7DR53FmdM6H772PnbLh-W5D8XeGKloYRUwu1agVLY9sk2YK7-g\" style=\"margin: auto; display: block; width: 273px; height: auto; max-width: 100%;\" width=\"273\" height=\"450\" alt=\"Advanced Google Looker Studio Tips: create an advanced calculated field\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a>Then enter the UPPER formula:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/9dORNTbXdhpjAAYWSz55kSuhmOvF9vQInopE0ZX4OaGtbjze0YOFlZ9GEuhjOFgb3-hdEohw85YaJs4bj1DK17Ji1c8cExyj9CmhHOEC0y9chs9l4Pd5FBOK8vZoJ22No_zGZmEmH_bHqSOemAqyxg\" style=\"margin: auto; display: block; width: 404px; height: auto; max-width: 100%;\" width=\"404\" height=\"450\" alt=\"Advanced Google Looker Studio Tips: use the UPPER formula\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>As <a href=\"https:\/\/www.benlcollins.com\/dashboard\/google-data-studio-tips\/\">Google Sheets expert Ben Collins points out<\/a>, this trick will also standardize any custom naming; for example, if some people on your team used \u201cchat\u201d for a campaign, and others used \u201cChat,\u201d the UPPER function will aggregate both together.<\/p>\n<p>Perhaps you want to create a new field for city and country.<\/p>\n<p>Just click \u201cAdd dimension\u201d (since city and state are categorical, not quantitative, variables) &gt; \u201cCreate field.\u201d<\/p>\n<p>Then use the CONCATENATE function to smush together the City and Country fields.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/oCp7CGosO4Dc-EwDglwmUEQdsjdqVPiNYvOv0f-IfYOgjGL_1Eqjmxoi5aH-9WvX2EsNDTZ3g78O_cSRc_6w-LJ0C1BOH8EQ1gCDzju-5Lh2SRt3lKs5Cb1MUTALfGxNpm0mElz43yJ3pvC_3ul6xw\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: create field\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Check out the <a href=\"https:\/\/support.google.com\/datastudio\/table\/6379764?hl=en&amp;ref_topic=7570421&amp;__hstc=20629287.d4f8faff60733b8f63875f668b0dab20.1623674559823.1643795543946.1644690650972.106&amp;__hssc=20629287.1.1644690650972&amp;__hsfp=1680013898\">complete list of functions Looker Studio supports<\/a>.<\/p>\n<p>One of the niftiest is CASE. If you\u2019re unfamiliar, it\u2019s essentially an IF\/THEN statement. This function lets you create custom groupings.<\/p>\n<p>For example, let\u2019s say you\u2019re looking at the table we created in the last step:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/2vNt48On7dqTkeQTZVJLgih_QZfoq0SWg31zZl9-AbVSj-Xr8uTtm9lOQEcV6vn3luZ4HGwW3mfpoilYQKFTGHximWNvuuvA9BapKboo83F240oghOyqzZ0bUwejrV3Dy180XlBZdTFqwSCH3_ClwQ\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: example table\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Here, Looker Studio is treating Facebook mobile traffic (m.facebook.com) and desktop traffic (Facebook) as two different sources. There\u2019s also l.facebook.com \u2014 desktop traffic coming via a <a href=\"https:\/\/www.indulgemedia.com\/blog\/mysterious-lfacebookcom-referral\">link shim<\/a>, which Facebook implemented in 2008 to protect users from potential spam. What if you want to combine all Facebook traffic into a single source?<\/p>\n<p>A CASE formula solves this issue neatly. Here\u2019s the formula:<\/p>\n<p><em>CASE<\/em><\/p>\n<p><em>WHEN condition THEN result<\/em><\/p>\n<p><em>WHEN condition THEN result<\/em><\/p>\n<p><em>ELSE result<\/em><\/p>\n<p><em>END<\/em><\/p>\n<p>You can have one condition (like the example below) or several. The ELSE argument is optional, so feel free to leave it out if you don\u2019t need it.<\/p>\n<p>Here\u2019s the formula we\u2019ll use to group Facebook traffic:<\/p>\n<p>CASE<\/p>\n<p>WHEN REGEXP_MATCH(Source,&#8221;^(l.facebook.com|m.facebook.com|facebook.com)$&#8221;) THEN &#8220;Facebook&#8221;<\/p>\n<p>END<\/p>\n<p>This formula tells Looker Studio, \u201cIf the source matches l.facebook.com, m.facebook.com, or facebook.com, call it \u2018Facebook.\u2019\u201d<\/p>\n<p>To add a CASE formula, you must be able to edit the data source.<\/p>\n<p>Click the pencil icon next to your source to bring up the data field editor.<\/p>\n<p>Then click \u201cAdd a new field\u201d in the upper right corner.<\/p>\n<p>Enter your formula.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/mDGqG3RYgyC0kZanteU5C9KpI6mejkSBvXMtpNZrY4s7LpbfmIhU-iXJ7PKoy8DuAjcO7aHdPjd16bttf4OR4EMuT4Mt9eYWNMmbUEZyFJYD8kfjpgFfblr1rjMPjzk-RhKcfWNqcuOjwA5nLaX33A\" style=\"margin: auto; display: block; width: 650px;\" alt=\" Advanced Google Looker Studio Tips: enter the formula\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>If the formula works, you\u2019ll see a green checkmark. Give your new field a name and click \u201cSave.\u201d Now you can add this field to any chart or data viz that uses this data source.<\/p>\n<p>You might be thinking, \u201cOkay, great, but was that formula written in Klingon? How do I come up with my own?\u201d<\/p>\n<p>Don\u2019t know RegEx? No problem! This blog post has <a href=\"https:\/\/www.clickinsight.ca\/blog\/5-calculated-fields-google-data-studio\">five formulas to get you started<\/a>.<\/p>\n<h3>17. Create a calculated blended field.<\/h3>\n<p>This is the pinnacle of Looker Studio mastery, requiring all the skills you\u2019ve already learned and a hefty dose of luck \u2014 just kidding, it\u2019s super easy.<\/p>\n<p>Create a blended data source per usual.<\/p>\n<p>In this example, I blended together the GA views for <a href=\"https:\/\/www.hubspot.com\/?_ga=2.51369385.1838187926.1557323413-644648569.1551722047&amp;hubs_post=blog.hubspot.com\/marketing\/google-data-studio&amp;hubs_post-cta=www.hubspot.com\">www.hubspot.com<\/a> and blog.hubspot.com.<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/UWXU6MB44hblTE44hihfooSOO3U98mlV77PdfmigqWSuLnu5fcGVJ-YVmtV2EuSM6kuZ9Ei1UUoNmOo2qH9jW98oSfiu7W4xEtM580jl3ZReo89gQQn4LoMI0uV3RVVikzC8iVIcaU4rI-gNk8ZEHA\" style=\"margin: auto; display: block; width: 212px; height: auto; max-width: 100%;\" width=\"212\" height=\"450\" alt=\"Advanced Google Looker Studio Tips: create a calculated blended field\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Then click \u201cAdd metric\u201d &gt; \u201cCreate Field\u201d as you would to create a normal calculated field.<\/p>\n<p>Enter your formula.<\/p>\n<p>I wanted to see \u201cTotal Users\u201d (i.e., users from <a href=\"https:\/\/www.hubspot.com\/?_ga=2.51369385.1838187926.1557323413-644648569.1551722047&amp;hubs_post=blog.hubspot.com\/marketing\/google-data-studio&amp;hubs_post-cta=www.hubspot.com\">www.hubspot.com<\/a> plus users from blog.hubspot.com), which is a simple calculation:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/r6HHpJUHwmS1NEWofquXpmeLYB_6sDHI6RC6t8dVy6SyN0Cto0bSgvUniDtuqnFObpBW9RE5T7hiLuir2hleZJ4Ar7fkVEQ4w6smzulAarazrtiGbhOkHoGbhQUoegpt5iri9WflaQufcmN7iD52ng\" style=\"margin: auto; display: block; width: 263px; height: auto; max-width: 100%;\" width=\"263\" height=\"450\" alt=\"Advanced Google Looker Studio Tips: total users\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Note: It can get a bit hairy here if you\u2019re using two different fields with the same name, as I\u2019m doing here. Sometimes Looker Studio is smart enough to recognize the difference, and sometimes it\u2019s not.<\/p>\n<p>If you run into issues, I recommend editing the name of one or both fields in the original data source(s), which you can do at any time by clicking the pencil next to the blended data source.<\/p>\n<p>Then click the pencil next to the field name you want to change.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/FyCGWTqHv_7i9TyxkNKAJabi3tdCPZ3DWvSEfmyluo_tPrltZEkqplEYKl3i-bNDhYsZ1g54k2wKtDpbqqHCot-pykg7Pgs5x5Vd83TGanZIV0CJlfAJPpkDsIXA-3F6Utn4qE-UPEepbf2rs98JqQ\" style=\"margin: auto; display: block; width: 650px;\" alt=\"Advanced Google Looker Studio Tips: change field name\"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a>This pane will appear; edit the title accordingly.<a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Then click \u201cSave\u201d and go back to your calculated field to update the formula:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/_ZX8KsFaJIpp5dGO7HUUV-kK7hlzTcEMMp2VzE64bDHNN3oR11ZGEuRC6qt7XLeejobuc3wVrJNq3tN55vLRo02mDLl1kjF9BNIIIQztpCCYwoUd4_zLdW05vMzR0LueRLyiBCr7drNiHAPuFrozkg\" style=\"margin: auto; display: block; width: 258px; height: auto; max-width: 100%;\" width=\"258\" height=\"450\" alt=\"Advanced Google Looker Studio Tips: save the field \"><a href=\"https:\/\/blog.hubspot.com\/marketing\/add%20Url\" style=\"font-size: 12px;\"><\/a><\/p>\n<p>Done! I can now see both in my report.<\/p>\n<h2><strong>Google Looker Studio is the Best Way to Visualize Your Data<\/strong><\/h2>\n<p>Now that you know Looker Studio inside and out, you\u2019re well-prepared to create stunning interactive reports for your coworkers, clients, and executives. Use the tips I shared above to make the most of it and successfully show the ROI of your marketing efforts.<\/p>\n<p><em>Editor&#8217;s note: This post was originally published in October 2018 and has been updated for comprehensiveness.<\/em><\/p>\n<p><a class=\"cta_button\" href=\"https:\/\/www.hubspot.com\/cs\/ci\/?pg=8835eaa3-be7b-4697-81d2-488e03708d34&amp;pid=53&amp;ecid=&amp;hseid=&amp;hsic=\"><img decoding=\"async\" class=\"hs-cta-img \" style=\"border-width: 0px; \/*hs-extra-styles*\/; \" alt=\"SEO Starter Pack\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/53\/8835eaa3-be7b-4697-81d2-488e03708d34.png\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/track.hubspot.com\/__ptq.gif?a=53&amp;k=14&amp;r=https%3A%2F%2Fblog.hubspot.com%2Fmarketing%2Fgoogle-data-studio&amp;bu=https%253A%252F%252Fblog.hubspot.com%252Fmarketing&amp;bvt=rss\" alt=\"\" width=\"1\" height=\"1\" style=\"min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; \"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Data Studio is now Google Looker Studio, and it&#8217;s making data reporting even more accessible, visual, and impactful than before. The new interface, features,&hellip;<\/p>\n","protected":false},"author":1,"featured_media":742,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[19],"tags":[],"class_list":["post-743","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-socialmarketing"],"_links":{"self":[{"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/posts\/743"}],"collection":[{"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/comments?post=743"}],"version-history":[{"count":0,"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/posts\/743\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/media\/742"}],"wp:attachment":[{"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/media?parent=743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/categories?post=743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frederickempaga.com\/shop\/wp-json\/wp\/v2\/tags?post=743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}