Blog post
Looker Studio
Looker Studio (formerly Google Data Studio) can be a complex tool, but with all those tips, you might become an expert soon !
Renaming a data source is essential when you need to work with Google Data Studio. It’s the only way to find and re-use a data source. You can rename a data source in 2 different ways :
When you are in a report :
Step by step :
If your data source is reusable, you can find it on the data source list, where you can also rename it :
Step by step :
when you create a report, the first thing you have to do is to create a data source. This data source will be embedded in the report, and you won’t be able to use it elsewhere.
You can transform this data source to make it reusable :
Step by step :
Once a data source is reusable, you can share it and every user can add it to a new report.
There is a way to check every report it is used and remove it :
Step by step :
An extract data source can be a great way to speed your report. Thanks to this, you create a database in Google Data Studio, that will be refreshed at the rate you decide.
Here is how to do it :
Step by step :
The first extract will be done when you saved the data source.
Every metric and dimensions can be set up, for example to indicate a currency, a percent… in the data source. Once done every time you will use that field, it will be with the set-up :
Step by step :
And here is the complete list of type fir fields :
• Numeric
• Text
• Date and time
• Boolean
• Geo
• Currency
• URL
I advise taking the time when you first create a data source to type all the fields you will always use. This is a great time savior tips because you can indicate the type of the component in a report. But this will only be applied to this component and you will have to do it again the next time you recreate it.
You can choose to export only the data from a table. Every filter used in the current page will be applied to the data :
Step by step :
When you want to combine data, you can create blended data sources that will allow you to combine any metrics you want. But this can be hard to configure. There is a simple way to combine 2 metrics quickly :
Step by step :
A new card appears with the combination of the 2 you selected. The first one you selected will be the numerator, the second one, the denominator.
A new blended data source is created containing only the 2 metrics you used.
You can make every link clickable by giving it the type URL -> URL :
Step by step :
Any URL of images can be displayed as an image in a table :
Step by step :
You can place a component in a page, and add it to all the other pages, at the same place in 2 clicks. This can be great to keep a design between multiple pages. Place a header, a control field and duplicate them for all the pages :
Step by step :
The image, fields, control… you place at report levels will be available for every page. If you move it on one page, it will move on every page.
You can activate the cross-filtering options on components. It will allow you to click on data to filter the entire page. For example, you can select a row in a table, and the page will filter by it :
Step by step :
Use this when you wants to allow your viewer to filter a page using tables.
Once a filter is created in the Resource -> Manage Filter menu, you can apply it to each component. But you can also choose to add it to a page and it will be applied to every component you add on the page :
Step by step :
It will automatically be applied to every component, old, or added to the page.
A filter can also be applied to a report level. To do so, check on the menu File -> Report settings.
If your report may be consulted while you modify it, you may want to activate the Manual publication settings. It creates a draft version of your report, only visible in edition mode and you can choose when to publish it so viewers can see it :
Step by step :
You can consult and restore the previous version of your report. You can even work on a version and decide not to publish it now and get back on it later.
Step by step :
This can only restore a version of your report. Any change made in the data source won’t be restored.
Each report can be tagged with a Google Analytics measurement Ids (G-XXXXXXXXXX or UA-XXXXXXXX-Y). You can then follow your report consulting a view in Google Analytics :
Step by step :
For this need, I advise creating a new view of Google Analytics so you can check on your report in one place with no other information.
Received an email with your report and a download PDF version when you want. You can choose the frequency and day you report will be sent. And you can share it with every Google or Gmail account in a few clicks :
Step by step :
If you have special need, for example to send your report every 2nd Tuesday of the month, check on the Custom option of the frequency.
If you do not want viewers to download data from components or copy your report, you can prevent that in the share settings :
Step by step :
The saving configuration might not appear, just close the share pop-up and open it again.
You can assign a data source for every component in a page. Already created components with no data source will take the default configuration, newly created will also take the default configuration :
Step by step :
Displaying trends for a metric can give you great insight over time. Is it good ? Is it growing ? You can do that in Google Data Studio with the charts type Time series :
Step by step :
You can change the color of the line thanks to the button above :
In order to filter your report, you may use the advanced filter. It allows you to filter dimensions using search types such as Equals, Contains, Start With… By default this search box will display Equals, but the most use is Contains. You can change this default configuration :
Step by step :
Tables can display variation compared to the previous period. By default, the variation is displayed for all columns, but you can choose which one will display it and which one won’t :
Step by step :
By default, the variation is displayed in percent. But you can also get the absolute change :
Step by step :
Tables can be frustrating, you always try to resize the column for the best readability. Add a comparison to the previous period and you just double the number of columns and nothing is readable anymore. You can easily resize on 2 clicks :
Step by step :
Sometimes data exceeds the size of a card. You can always choose to resize the card or lower the font size, but this modifies the style of your report. A simple trick to gain a few pixels and get data into cards are to change the padding from the left side of the card :
Step by step :
Modifying the style of a component can be tedious, doing it for all components can be painful… But you can re-use most of the style with a simple copy paste :
Step by step :
You can select multiple components to paste style only ! Hold Ctrl or Cmd and click to select multiple components, then right click and Paste Style Only
Google Data Studio made a simple way to generate a thumbnail of your report. You can use this on social media, presentations, quick view…
Use this URL and you always get a thumbnail up to date with your report !
Metrics names can be very long, and often, exceed the width of the panel, making it unreadable. With a recent update, Google Data Studio allow you to extend this panel for comfortable viewing :
Google created an issue tracker where you can report bugs and ask for evolution or new features for all their tools. Each demand get upvote by the community depending on their needs.
Here is the link for the Google Data Studio issue tracker : https://issuetracker.google.com/savedsearches/5492224?pli=1