Tables without hyperlinks can be very annoying for viewers of your Google Data Studio dashboards. Most people would like to have the option to click on a hyperlink, in that way they can match the data with the right page. In this blog we will show you how to create a table with hyperlinks in Google Data Studio.
A table in Google Data Studio with hyperlinks.
Create a new field in your Google Data Studio source
The first thing you need to do is to edit your data source, in this example we’re going to edit a Google Analytics source. Other sources, like Google Ads and YouTube, will also work perfectly fine with this method. Click on ‘Add a field’ at the right top corner to create the desired ‘hyperlink dimension’ field.
Select ‘Add a field’ when you’re in the source you want to edit.
Start with typing the name of the new field you’re creating, in this example we’re calling it: ‘Pages (with hyperlink)’. In the formula section we’re going to paste the following formula: HYPERLINK(CONCAT(‘https://shop.googlemerchandisestore.com‘,Page path),Page path)
You need to edit the bold elements to your own situation. Change the url ‘https://shop.googlemerchandisestore.com‘ to your own domain name. Then choose a dimension which shows the slug of your pages, for example: Page, Landing page, Page path etcetera, depending on the data source you’re working with. Change both ‘Page path’ dimensions to your own situation.
A calculated field with the formula for creating hyperlinks in tables.
Using new hyperlink dimension in Google Data Studio
You can save your formula once it’s set up correctly. Then start creating a table with the new dimension to check if everything works fine. To be certain of everything: just click on one hyperlink!
Use your new field in a Google Data Studio table.
Explanation of the CONCAT formula:
The formula combines multiple string fields to one string field. In our example we are combining our domain name with the slug. In this way (with the help of the hyperlink function) we’re creating a new field with the whole permalink. But instead of showing the whole URL in the table (which normally takes a lot of space) it only shows the slug of the permalink. For that reason we’re using the second ‘Page path’.