Looker Studio (formerly Google Data Studio) Funnel Visualization
Just 10 years ago, a funnel had a clear definition as a pipe that is wide at the top and narrow at the bottom. But now, if you ask Google or chatGPT what funnel is, you’ll get the answer that it’s a marketing concept depicting the customer journey from awareness to conversion (or even retention). A funnel is shown as an inverted pyramid consisting of several layers that refer to a certain stage of the customer journey. Funnels can be used in different cases, and, therefore, they differ by the stages depicted within. For example, a marketing funnel will start with awareness and end with taking an action. In sales, the funnel will start with lead generation and end with closing a sale.
Marketers of all kinds build funnels to focus their marketing efforts on the most efficient strategies. They can use different tools for that. In this piece, I’m talking about how you can create a Looker Studio funnel visualization (formerly Google Data Studio).
What are the options to create a Looker Studio funnel?
You’ve probably expected that building funnel visualization in Looker Studio would be kid’s stuff since all you need to do is to add a respective chart… but it’s not. Actually, there is no native funnel chart in Looker Studio as, for example, in Power BI🤔 You won’t be able to get something like this with a few clicks.
At least for now. Nevertheless, you can still rest on three options to create Looker Studio funnel visualization (formerly Google Data Studio):
- Scorecards – you can design the Looker Studio funnel by placing scorecard charts in the form of a reversed pyramid. The result may look like this:
- Horizontal bar chart – you can build a Looker Studio funnel using a horizontal bar chart, which is natively supported by the platform. Actually, you’ll need two horizontal bar charts placed together to form a Looker Studio funnel visualization like this.
- Community visualization – you can use the visualizations built by third-party developers and shared in the Looker Studio community. It may look like this:
Each visualization option has its benefits and drawbacks, of course. Below you’ll find a guide on how to build a Looker Studio funnel visualization (formerly Google Data Studio) with each of the mentioned methods.
How to build a funnel in Looker Studio
Before you and I get our hands dirty, let’s get some data to use for building funnels. I’m going to build a sales funnel, so I need the data about deals. I chose a sales CRM Pipedrive as a data source and connect it to Looker Studio with the help of Coupler.io. Here is a video guide on how this process works:
Coupler.io is a data automation and analytics platform that provides multiple Looker Studio integrations and connectors for other destinations. In addition to this, Coupler.io provides data expert services for businesses to cope with advanced data analytics and data management tasks.
Using Coupler.io as a connector between Pipedrive and Looker Studio will let me automate data refresh on a schedule. This means that the data in my Looker Studio funnel will always be up to date.
Once the data source is connected to Looker Studio, I have the following:
The data contains lots of columns, but for the funnel, I mostly need to know the number of deals per each stage. You can get this information from the column stage.name. Do the following:
- Click Add dimension then choose stage.name as the dimension.
- Click Add metrics then choose stage.name as the metric.
Note: If you already have stage.name chosen as the metric, then make sure to change its Aggregation to Count, not Count Distinct.
After these manipulations, you should get your funnel stages and the number of deals per each stage in a table like this:
Now I’m ready to show you how to implement a Looker Studio funnel visualization (formerly Google Data Studio).
Funnel visualization Looker Studio using scorecards
The idea of using scorecards to build a funnel visualization in Looker Studio is simple and consists of two steps:
- Create separate scorecards per each stage
- Arrange the scorecards one after the other in the form of the funnel
Create separate scorecards per each stage
- Click Add a chart, then select Scorecard, and locate your scorecard on your dashboard.
The scorecard will display the total number of deals in your funnel. To fix these, you’ll need to do the following:
- Change the default metrics to stage.name with the Aggregation set to Count.
- Scroll down to the bottom of the setup properties and click Add filter. You need to create a new filter with the following configuration:
Include - [column] - Contains - [stage-name]
In my example, it looks like this:
After I click Save, the scorecard value changes:
You’ll need to repeat this process to create a separate scorecard and a separate filter for each stage of your funnel.
Arrange the scorecards in the form of a funnel
In my example, I designed the scorecards and arranged them this way:
I also want to share one tip on how you can add names to your scorecards. You need to select Always show for the Chart Header option.
Then create a text element with the name of your stage and add it to the header area of the scorecard.
We’re done here and can move on to the next method to make a Looker Studio funnel visualization (formerly Google Data Studio), which should be less time-consuming to implement.
Build a funnel in Looker Studio using horizontal bar charts
The idea of using horizontal bar charts to build a funnel visualization in Looker Studio includes the following:
- Create a horizontal bar chart.
- Duplicate the horizontal bar chart.
- Attach two horizontal bar charts together with one of them to be reverted to the x-axis.
Create a horizontal bar chart
- Click Add a chart, then select Bar chart, and locate your chart on your dashboard.
- Change the default dimension to stage.name. Add stage.name as a metric as well, and remove the default metric that you’ve had. Do not forget to change the metric’s Aggregation to Count. As a result, you’ll get the following:
Then customize the chart style to your liking. In my case, I did the following:
- Switched on data labels.
- Changed the color, removed showing axes, and enabled the reverse X-axis direction.
As a result, my chart began to look like half of a funnel chart:
Let’s make the other half then 🙂
Duplicate the horizontal bar chart
- Right-click on your chart and select Duplicate.
You’ll get a copy of your chart. You can tune it to your liking, which in my case is as follows:
- Change the Type of your metric to Percent; Comparison calculation to Percent of max – Relative to corresponding data.
- Go to the chart Style and unclick Reverse X-axis direction. Here is the second half of the funnel visualization in Looker Studio.
Attach horizontal bar charts together
There is no way to glue both halves together without a gap between them. Here is what it looks like:
However, in my case, I found a solution by placing textual elements with the stage names in between:
It looks pretty to me, but you can go with the other way around.
Looker Studio funnel chart from the community
The third option to create a Looker Studio funnel visualization (formerly Google Data Studio) is both the most actionable and the least reliable one. Actionable because it does provide a ready-to-use funnel chart, which was built and is available in the Looker Studio community gallery. So far, there are two funnel charts available: Metric Funnel by PowerMyAnalytics and Funnel Chart by Ayima.
The drawback is, however, that these funnel visualization charts are not officially supported by Google. So, you may face bugs and other issues. For example, in my case, the funnel visualization just disappeared for no reason for a day and then came back. Anyway, let’s see how it works in the example of the Funnel Chart by Ayima. You can add it by clicking the Community visualizations and elements button. I already have it as featured, and you’ll have to proceed to +Explore more and search for it the in the community gallery.
The added funnel chart will display some default metrics which are not what we need. So, let’s tune the funnel chart setup as follows:
- Click Add metric then Create a field
You’ll need to insert the following formula:
case when [column]='[stage-name]' then 1 else 0 end
It only returns the records that have a particular stage name, and Looker Studio will shortly sum them up. In my case, it will look like this:
Click Apply and here is what the result is:
You’ve probably got it that you need to add such metrics for each stage of your funnel and remove the default ones. Here is what it looks like:
Of course, feel free to customize the style of your funnel visualization in Looker Studio as you see fit.
Sales funnel Looker Studio vs. other BI tools
I cracked open the wisdom of building funnels in Looker Studio, and now you can use it. Meanwhile, it’s worth mentioning that some other BI tools offer funnel visualization options as well. For example, in Power BI, this is a built-in feature that doesn’t require any workarounds. In Tableau, however, building a funnel is a trickier process. At the same time, this BI tool provides more design customization options.
Funnel visualization in Power BI
In Microsoft Power BI, you can add a funnel chart to your report by simply selecting the funnel icon from the visualizations option. Then you’ll need to configure columns to be used for the funnel. The funnel visualization in Power BI has one shape:
For example, here is what a sales funnel may look like in Power BI on the sales dashboard built by Coupler.io data experts.
If you want more fancy designs for your funnel visualization, then you should check out Tableau.
Funnel visualization in Tableau
Tableau offers a lot of design variations for your funnel chart. It can be a regular funnel made of bars:
An inverse pyramid like this:
Or even in the form of an interactive 3d visualization:
Are you not a fan of pyramids and bars? In Tableau, you can uncover your inner artist even for data visualizations. For example, here is what a donut funnel looks like:
The funnel charts above are community charts, so you can copy them for your use just like I did in Looker Studio above.
So, which option should you choose to build a funnel visualization for your chart?
In terms of usability, Power BI is a winner since it provides a built-in funnel chart option. A few clicks of a button will let you enjoy a simple yet actionable funnel visualization in your report.
In Tableau, it’s not that easy to build a funnel, but the tool allows you to do this in many creative designs. So, it will be a good choice for those who want to go beyond sampled visualizations in their charts.
As for the main character of this text, Looker Studio, it is a lightweight solution, which works well for simple funnels. Anyway, it’s up to you to decide which chart or visualization your dashboard requests. And if it’s difficult to make a choice, you can always contact our data experts to get a custom solution for your analytical needs. Good luck!Back to Blog