[Looker Studio] How to Use the HYPERLINK Function and Practical Examples | Calculated Fields

In this article, we will explain how to use the HYPERLINK function in Looker Studio and provide specific examples of its application. By utilizing the functions available in Looker Studio, you can process and visualize your data.

The HYPERLINK function allows you to create links within your Looker Studio reports, enhancing the convenience of your reports. We also introduce usage examples with GA4 (Google Analytics 4) data and Search Console, so please make use of them.

What are Calculated Fields in Looker Studio?

Calculated Fields in Looker Studio are a handy feature that allows you to create custom fields by using operators (such as addition, subtraction, multiplication, division), functions, and regular expressions based on existing items for use in reports.

Also, for basic usage of Looker Studio, please refer to the "How to Use Looker Studio" guide. Looker Studio is a very convenient tool that is free to use and allows for the creation of easy-to-understand reports by connecting to various data sources, so let's make active use of it.

What is the HYPERLINK Function?

he HYPERLINK function is a feature in Looker Studio that creates dynamic, clickable links directly within a report. For example, when creating a report on pages with high session counts, you can click the link to smoothly navigate to the relevant page. Because these links are dynamically generated, there’s no need to manually set a link for each item.

Syntax

The syntax for the HYPERLINK function is as follows:

HYPERLINK("URL", "Link Text")

• "URL" specifies the address of the destination. This is the URL of the webpage that will open when the link is clicked in the report.
• "Link Text" is the text displayed for the link. This is the text that users see and click on.

How to Use the HYPERLINK Function

To use the HYPERLINK function, you need to create a calculated field in Looker Studio. There are two types of calculated fields: data source calculated fields and chart-specific calculated fields. This article will focus on creating a data source calculated field, but for more detailed differences between the two, please see the differences between data source calculated fields and chart-specific calculated fields.

Use case: Creating a List of GA4 Page Titles with Links in Looker Studio

Consider creating a list of pages with high session counts or views, where clicking on a page title opens the actual page. First, set up the calculated field as shown below. 

(Quote:Looker Studio) 

① Field Name: Please enter any field name.

② Formula: HYPERLINK(Full page URL,Page title)

③ Save: Once you have completed entering the information, click save.

A new field "Page Title with Links" was created as shown below.

(Quote:Looker Studio) 

 Use the created fields in your report. By setting up the Looker Studio report as follows, linked text will be displayed, and clicking on it will open the corresponding page.

(Quote:Looker Studio) 

 By adding metrics such as sessions and impressions, you can complete a table listing pages with high sessions and impressions. You can use the HYPERLINK function to efficiently check the site.

Use case: Creating a list of page referrer with links for GA4 in Looker Studio

A page's source URL refers to the URL of the page that was opened before the current page, regardless of whether it's inside or outside the site. It is used to understand from which page visitors transitioned to a specific page.

The page referrer URL refers to the URL of the page that was opened before a given page, regardless of whether it is internal or external to the site. It is used to understand from which page a user navigated to a specific page.

Set the calculated field as follows:

 (Quote:Looker Studio)

① Field Name: Please enter any field name.

② Formula: HYPERLINK(Page referrer,Page referrer)

③ Save: Once you have completed entering the information, click save.

 A new field "Page referrer with Links" was created as shown below.

  (Quote:Looker Studio) 

 You will use the created field in the report. By setting up the report in Looker Studio as follows, a linked page referrer URL will be displayed, and clicking on it will open the corresponding page.

 (Quote:Looker Studio) 

 Here, by setting a specific page in the filter, you can understand from which URL the transition to a specific page occurred. Let's efficiently check the page of the referrer URL using the HYPERLINK function.

Use case: Creating a List of Landing Page URLs with Links from Search Console in Looker Studio

Make the landing pages that received traffic via search clickable for more efficient review. First, set up the calculated fields as follows.

 (Quote:Looker Studio)

① Field Name: Please enter any field name.

② Formula: HYPERLINK(Landing page,Landing page)

③ Save: Once you have completed entering the information, click save.

 A new field "Landing page with Links" was created as shown below. 

 (Quote:Looker Studio)

Use the created fields in your report. By configuring the Looker Studio report as shown below, the landing page URL with a link will be displayed, and clicking on it will open the corresponding page.

(Quote:Looker Studio) 

 Let’s improve the usability of the report by creating links using the HYPERLINK function as described above.

Relevant Looker Studio Official Documentation

Looker Studio Official Help : About calculated fields

Looker Studio Official Help : Function list