How to add a dynamic title in Looker Studio?


There is nothing more upsetting than setting up a fully automated Google Looker Studio report (formerly known as Data Studio), to eventually having to change the title every now and then.

In this article, we'll review how you can add a dynamic title to your pages (but really, it could be any piece of text anywhere in your dashboard) so you reach the 100% automation you've always dreamt of!

In order to achieve this, any data source will do the trick, but please try to use one that grinds few data. Maybe you can even create a dummy one for the sake of it (a Google Sheet tab with one column two rows, dummy in A1 and 1 in A2; a SELECT 1 AS dummy SQL statement in a Big Query custom query, ...). If you want your title to depend on a given dimension / metric / filter, please use the associated data source.


Need help ? We offer Looker Studio Support for companies.

Looking for a connector ? Check Supermetrics.


Creating a simple table data visualization

First of, please create a new table by clicking on Add a chart -> Table in the top ribbon:

Looker Studio Dynamic Title Add Table

Now, select your dummy Data Source, and set-up as follow in the setup ribbon on the right:

  • Metric: delete anything there, should be empty
  • Rows per page: 1
  • Cross-filtering: untick


Next, moving on to the style ribbon right next to it, please do as follow:

  • Show header: untick
  • Row numbers: untick
  • Show pagination: untick
  • Table colors - Cell border color: transparent
  • Dimension alignement: Center
  • Chart header: do not show


If you followed carefully these steps, you should have something like that, a table with actually only one number (in my case, I left the dummy in Dimension):

Looker Studio Dynamic Title Dummy Table

A formula (or calculated field) as the only metric

Now, this is where the magic happens. Replace the current dimension by clicking on it in the setup ribbon, and then Create field.

We're going to start easy with the date, by giving a Name to our newly created dimension (any name can work as it won't be displayed), and then using the CURRENT_DATE() formula, and please Apply.

Quick note here: you need to first apply once to save the dimension, before coming back and changing its format (here, Looker Studio understands it's a date so it's changing it automatically, but be careful, it might not always be what you want).

Looker Studio Dynamic Title Create Field

What if we wanted to change the Formatting of the display?

Well, just click the small calendar icon next to the name of your Dimension to change it, and under Format, choose Date & Time, Year Month. You should now see the current Month and Year.

Looker Studio Date Format

At this stage, I think you've got the point. By using a formula as a dimension in a single row table with no grid & no metric, you'll give your users the sensation that they are really dealing with a dynamic title (which is indeed the case, but in a tortuous way).


Don't forget to format

As usual, once your formula is working and showing what you want it to and when you want it to, you need to proceed to the style ribbon to make some formatting so your dynamic title looks good.

Please remember that we're using a dimension here, so you need to update the settings accordingly to see the changes applied on your page.

Last but not least, try to put your title to the very top of your page, as in the "table box" must touch the top border, so users can't click on the table nor see the options when hovering the mouse.

And eventually, an example of the powerful things you can do with using formulas like CONCAT( YEAR(CURRENT_DATE()) , ' - Week ' , WEEK(CURRENT_DATE()) , ' to date'). This title is fully dynamic and gets updated...well, every week, you damn right!

Looker Studio Dynamic Title Example

And that's it. Here we've played with dates, but obviously, you could make your title depend on any dimension / metric / control that is in the data source you're using, it's all about the formula you'll build. Sky is the limit.

PROBLEM SOLVED !


Previous article: How to split Analytics conversion by Search Console keywords in Looker Studio?

Next article: How to build a control that filters across several data sources in Looker Studio?

Looking for something else? All our articles can be found on our blog page