Search
Close this search box.

Funnel Visualization in Looker Studio

Last Modified on February 28, 2024

Are you interested in taking your data storytelling to the next level? 

Google Looker Studio is the rebranding of Data Studio, a popular data visualization tool. If you’re interested in getting the most out of your Google workspace, then this tool is something you should start exploring.

Looker Studio For Beginners

Subscribe & Master the Basics with our FREE Looker Studio Course

Along with this rebranding is an update that needs special consideration. This tutorial will cover one of the first things you need to master – funnels.

Follow along as we show you how to create a funnel visualization in Looker Studio so that you better understand your conversion or drop-off rates. We’ll also show you a few additional things you can do with this data visualization tool.

Here is an overview of what we’ll cover:

Let’s dive into the world of funnel data visualization!

Community Visualization Charts

Whether you have an eCommerce shop or you sell services, your customers go through multiple stages before buying something from you.

Depending on how you want to improve your customer experience, you might choose to monitor stages, journey step levels, website pages, and so on. The funnel options to focus on are endless, but the most commonly used ones are the marketing or sales funnels.

In this tutorial, we’ll assume that you have an eCommerce store and have already implemented Google Analytics 4 on your website.

Our goal is to visualize how many users are flowing through the different stages of the funnel and what is the conversion rate for the final transaction number. In an eCommerce store, this rate is from a product view to a transaction.

Currently, there isn’t a built-in, ready-to-use funnel visualization in Looker Studio. So, the first way we can visualize funnels is through community visualization charts.

If we go to the visualization library and search for a funnel, we’ll see that there are two charts available.

Third-party funnel visualizations available

For this tutorial, we’ll only cover one of these two, the one from Ayima, along with another one that is not visible here. Let’s start with the free community visualization from Ayima.

In your Looker Studio account, go to the edit mode. On the menu bar, click on the Community visualizations and components icon → Explore more.

Exploring the community visualizations and components

Scroll down and select the Funnel Chart by Ayima.

Selecting the funnel chart custom visualization

You can click and drag it anywhere on the dashboard. For the chart configuration, we want to see how users went from viewing our products, adding them to the cart, then buying them.

Click on the chart. On the setup menu to the right, add the following metrics in order: Item views, Add-to-carts, and Transactions.

Funnel chart metrics

When creating a funnel visualization in Looker Studio, you should add the metrics of interest to the chart in a high to low order. In other words, it should be arranged in a manner that captures a customer’s journey through your store.

Logically, the first step is for people to look at a product before adding it to the cart, then purchasing it. Reversing the order will not only make the funnel look unnatural but also incorrectly reflects the flow of the user through the website.

For example, if we switch the Add-to-carts and Item views metrics, you’ll see that the chart will not resemble a funnel because the step with the highest number is in the middle.

Reversed order of the funnel chart metrics

Therefore, make sure to add your metrics in the correct order.

We’ve successfully defined the metrics, but these numbers won’t tell us much. So, we’ll go to the Style tab → Computed Values section.

Going to the computed values section in the style tab

Of course, you can customize your preferred colors, fonts, and backgrounds in this tab to style your chart, but we’ll focus more on the computed values section.

What are the settings in the computed values section, and what are their functions if we enable them? These two aspects will show your conversion rates from one step to the other.

We have the percentage versus the previous and the percentage versus the initial. Enable both options and notice that additional columns have been added to the chart.

Computed values shown in the funnel chart

The difference in the two percentages is self-explanatory. The value in the bottom-right corner will always tell you the conversion rate from the first step to the last.

In our case, the 1.71% conversion rate is from the product views to the transactions.

Transaction conversion rate from item views

Great! We have successfully created a funnel visualization in Looker Studio.

However, this only covers the three predefined GA4 events. What if you want to monitor more events? Is there another option?

Funnel Chart with Drop-off Rate

Luckily, there is another free community visualization from TrueMetrics.

Funnel graph visualization by TrueMetrics

This one is not available in the official visualization library at the time of this writing.

So, how can you add it to your dashboard? 

This can be done in a similar way to how we added the previous funnel visualization in Looker Studio. You go to the community visualizations and components and click on explore more.

Once here, you click on Build your visualization.

Building a custom visualization

Since we’re not developers, we’re not going to start building our charts. Fortunately, some people have been generous to share their work. All we need to do to use them is by specifying the manifest path.

Go to the How to Build a Funnel in Data Studio article by TrueMetrics. Scroll to the bottom of the page and copy the manifest path for the FunnelGraph.

FunnelGraph manifest-path

Go back to Looker Studio and paste this in the Manifest path section, then click Submit.

Adding the FunnelGraph manifest-path

You should then be able to select the FunnelGraph Visualization by TrueMetrics and place it on your dashboard.

FunnelGraph Visualization by TrueMetrics

To build our funnel visualization in Looker Studio, we’ll add the Event name dimension in the Parameters section, and the Total users in the Metrics section.

Adding the parameters and metrics to the funnel graph

We could also select the event count for the metrics presented, but we’ll select total users because we believe it is more useful to look at it this way.

Keep in mind that sorting matters for this chart. For example, if we sort by Event name, it wouldn’t be too much of a funnel.

Choosing a different sorting method

Therefore, whenever you make a funnel visualization in Looker Studio, make sure that you sort by the same metric you used in the metrics section, arranged in descending order.

This leads us to the following graph:

FunnelGraph showing the total users by event name

Now, we could stop here, but we have an excessive amount of events in the funnel that doesn’t tell much of a story. It doesn’t help us understand how many users navigate our website and how they do this.

What we can do is filter the events by the main events that we want to see. For our example, we’ll filter the graph down to five main events.

Go to the Filters section and click on Add a Filter.

Applying a filter to the funnel graph

Here, we’ll select the Main 5 Events filter that contains our main 5 events.

Selecting the main 5 events filter

To build this filter, we need to utilize regular expressions or RegEx. Don’t be intimidated as the concept is much simpler than you may think.

Now, we’ll set our filter to only include events with an Event name that are matching with the following regular expression:

view_item|add_to_cart|add_shipping_info|add_payment_info|purchase
Main 5 events filter configuration

If we inspect our RegEx, you’ll notice that we listed the event names of our 5 main events separated by the vertical bar | symbol. In regular expressions, this means an “or” condition.

This enables our filter to only show events with an event name that matches either one of the 5 event names we have listed in our regular expression.

Once applied, you’ll see that we have a much clearer and cleaner presentation of the events. Currently, the events shown will be in an unfriendly format with the event names having an underscore in between each word.

Event names presented in the funnel graph

If you want an even cleaner look, we can go and create a new calculated field to change the default event names.

Click on the event name dimension, then click on Create Field.

Creating a calculated field

For this example, we’ll be utilizing the Case statement to build our calculated field. Specifically, we’ll use the following code:

CASE
WHEN REGEXP_MATCH(Event name, "view_item") THEN "Product View"
WHEN REGEXP_MATCH(Event name, "add_to_cart") THEN "Add to Cart"
WHEN REGEXP_MATCH(Event name, "add_shipping_info") THEN "Shipping Info"
WHEN REGEXP_MATCH(Event name, "add_payment_info") THEN "Payment Info"
WHEN REGEXP_MATCH(Event name, "purchase") THEN "Transaction"
END

If we analyze our code, we first start with a WHEN expression to specify the condition to apply our function. Next, the REGEXP_MATCH() function looks for events that match the event names of our top 5 events.

Finally, the THEN expression specifies what will happen after the starting condition is met. To put it simply, we just renamed the event names to a more presentable and user-friendly format.

Paste this code to the Formula section, then click Apply.

Calculated field renaming the event names

Now, you’ll see that the event names are more intuitive for viewers of this dashboard.

Renamed event names in the funnel graph

Other additional chart settings for this funnel visualization in Looker Studio can be seen in the Style tab. Here, we can change the direction of the funnel, the gradient direction, etc.

Style chart settings for the funnel graph

You have the option to edit your colors and fonts, and an important feature that you don’t want to miss is the sub-label option.

If we enable the Display sub-label option, we’ll see the drop-off rates.

Enabling the display sub-label option

The default parameter shown is the drop-off rate, but we could overwrite this in the overwrite sub-label section. However, the parameters format is not yet available publicly, so we don’t have other ones like conversion rates, for example.

Note that this is the drop-off that happens at each step level. For example, if we look at the Add to Cart step, around 70% of users did not move forward after viewing a product.

Drop off at the add-to-cart step

Therefore, we recommend that you add tooltip annotations to this type of funnel visualization in Looker Studio that will explain this information to your users.

For example, if we hover over the 🛈 symbol, a tooltip appears where we tell this information to the people that use the dashboard, whether that be your client or stakeholders.

Tooltip explaining the displayed drop-off rates

It is important to relay this information so that users are aware that the drop-off rate refers to the drop-offs happening at that specific step and not relative to the previous or initial step, compared to what we’ve seen with the Ayima funnel visualization in Looker Studio.

If we want to calculate either the conversion or drop-off rates from one step to the other, you will need to create data blends between the steps that you’re interested in.

For example, let’s look at the data blend we made to calculate the conversion rate from product view to add to cart. Click on the scorecard visualization, and then the edit button beside the data blend in the data source section.

Opening the data blend between product views and add-to-cart events

Here, we have joined the add-to-cart metric in one table to the item view in the other table.

Add to cart and item view metrics in the data blend

We have also filtered the tables to only have events that correspond to their event names.

Respective filters for the add-to-cart and item view events

In our case, we have around a 22% conversion rate from item view to add to cart, corresponding to a 78% drop rate.

Conversion and drop-off rate between item views and add to cart

However, what should we do if we have multiple steps in our funnel? Is there a way that does not involve creating multiple data blends?

Looker Studio Regular Table Chart

Using a regular table chart is a great alternative for creating a funnel visualization in Looker Studio.

It is a much simpler setup that avoids multiple data blends. This means faster loading time for your dashboard, reaching quotas, and so on.

🚨 Note: This method of creating a funnel visualization in Looker Studio is created by Mehdi. Check out his original How to Create a Funnel Report with a Single Google Data Studio Table Chart article.

This method will require a couple of calculated fields and one simple data blend.

First, we’ll select our chart, then click on Add a field in our GA4 Sample Data source.

Adding a calculated field to the GA4 sample data source

For this calculated field, we’ll be utilizing a similar formula to the one we used for the main 5 events filter. Instead of renaming the event names, we’ll assign a value of one to five for the first to the last step in the funnel.

CASE
WHEN REGEXP_MATCH(Event name,"view_item") THEN 1
WHEN REGEXP_MATCH(Event name,"add_to_cart") THEN 2
WHEN REGEXP_MATCH(Event name,"add_shipping_info") THEN 3
WHEN REGEXP_MATCH(Event name,"add_payment_info") THEN 4
WHEN REGEXP_MATCH(Event name,"purchase") THEN 5
END

We’ll name this field “Funnel step [CF]”, then p