Funnel Visualization Google Data Studio: An Easy Way

Nikhil Annadanam • Last Modified: December 29th, 2022

FUNNEL VISUALIZATION GOOGLE DATA STUDIO

Introduction

Whether you sell products on e-commerce or you sell services, your buyers go through multiple stages before purchase. As the customers go through this journey, a number of them drop out at various stages. Thus, the volume of potential customers resembles the shape of a funnel. The nearer the potential customers are to the bottom of the funnel, the closer they are to buying.  

In this article, you will see how you can build a simple funnel visualization on Google Data Studio when the conversion process has several steps, and you want to visualize the number of users who are dropping off/ going forward at each stage of the process. When it comes to creating a funnel visualization, Google Data Studio doesn’t have a straightforward option. Hence, there is no single way to do this. How you create a funnel depends on your specific goals.

Here is what you will cover in this blog:

What is Funnel Visualization?

Funnel visualization monitors and analyses the user interactions that lead to a website goal. It can classify the multiple steps that users take to achieve their goals. Funnel visualization builds a path to analyze the user’s sequence of hits, identify who is falling out, or who is falling through. It also identifies where a user went after each step in the campaign path, and where they navigated to after falling through or falling out through defined steps.

Building a Funnel Visualization on Google Data Studio

Here, let us build a simple funnel on Google Data Studio to visualize the conversion rates on a hypothetical website over a period of three months. There are 6 stages that this hypothetical business is interested in focusing on.

They are:

  • Impressions: The number of times the webpage appears in the search results for the users.
  • Website clicks: The number of times viewers have clicked on their website link.
  • Sign-up step 1: The users have completed the first stage of sign-up.
  • Sign-up step 2: The users have completed the second stage of sign-up.
  • Sign-up step 3: The users have successfully signed up to the Basic plan/ free plan.
  • Upgraded to Pro: The users have upgraded to the paid plan.
Funnel Visualization Google Data Studio: Funnel

We will use Bar charts and Scorecards to visualize this in Google Data Studio.

Let us dive into the steps!

Download the Guide on How to Set Up a Data Analytics Stack
Download the Guide on How to Set Up a Data Analytics Stack
Download the Guide on How to Set Up a Data Analytics Stack
Learn how to build a self-service data analytics stack for your use case.

Hevo: Analysis-ready Data at your Finger Tips

Hevo offers a faster way to move data from databases or SaaS applications into your data warehouse to be visualized in Google Data Studio. Hevo is fully automated and hence does not require you to code.

Get Started with Hevo for Free

Check out some of the cool features of Hevo:

  • Completely Automated: The Hevo platform can be set up in just a few minutes and requires minimal maintenance.
  • Real-time Data Transfer: Hevo provides real-time data migration, so you can have analysis-ready data always.
  • 100% Complete & Accurate Data Transfer: Hevo’s robust infrastructure ensures reliable data transfer with zero data loss.
  • Scalable Infrastructure: Hevo has in-built integrations for 100+ sources that can help you scale your data infrastructure as required.
  • 24/7 Live Support: The Hevo team is available round the clock to extend exceptional support to you through chat, email, and support calls.
  • Schema Management: Hevo takes away the tedious task of schema management & automatically detects schema of incoming data and maps it to the destination schema.
Sign up here for a 14-Day Free Trial!

Steps to Build a Funnel on Google Data Studio

The steps to build a funnel on Google Data Studio are as follows:

Step 1: Opening Google Data Studio

Open Google Data Studio by clicking here and click on the Blank Report to create a new report.

Step 2: Adding Data

In the pop-up Add data to report, select the source of your data. Mine is in Google Sheets and hence I will select Google Sheets. Select the file that contains the data and click on ADD. Check the data panel on the right to verify if you see the fields from the file.

Funnel Visualization Google Data Studio: Connect to data

Step 3: Adding a Chart

 Select Add a chart and click on the Horizontal Bar chart.

Funnel Visualization Google Data Studio: Add a Bar chart

Step 4: Adding Dimensions and Metrics 

I have data for 3 months (Jan, Feb, and Mar) in my file and I would like to group the data by month. So ‘month’  will be the Dimension.

I will add each stage of the funnel in order as a Metric. Since the top of the funnel is ‘Impressions’, it is added first, followed by ‘Website clicks’, the three sign-up steps, and finally, the upgrade field.

This is how the data panel on the right looks after this step.

Funnel Visualization Google Data Studio: DATA panel

This is how the visualization looks.

Step 5: Modifying the Chart

In the style panel on the right, you can make changes to modify the appearance of the chart. For example, you can change the horizontal bars into vertical ones by selecting the vertical symbol on top.

Funnel Visualization Google Data Studio: Vertical bar charts

You can select Show data labels to show the numbers on the chart.

Funnel Visualization Google Data Studio: Selecting 'Show data labels'

This how the chart looks after making such modifications.

Step 6: Creating Formulas for the Ratios

Next, let us show the conversion rates at various levels in percentages. For example, it might be useful to know the ratio of the number of users who finished step 3 of the sign-up to the ones who upgraded to pro. There might be several such ratios that are of interest but are not readily available as fields in the data. In such a case, we can use a Google Data Studio feature called Calculated fields. Using formulas, you can create your own fields from the existing ones.

Let us see how a calculated field can be created to show various KPIs that may be of interest to you.

In order to create calculated fields, go to the bottom of the data panel on the right and click on ADD A FIELD.

Funnel Visualization Google Data Studio: ADD FIELD

Give a name to this new field and create a formula. The formula created here is the ratio of Website clicks to the Impressions. This tells you what proportion of people who got the website URL on their search results clicked on the website link.

Funnel Visualization Google Data Studio: Create a formula

Save the new field and select DONE.

Similarly, you create ratios for every step to measure the proportion of users at a given stage who are moving to the next stage in the funnel.

Step 7: Adding and Designing Scorecards

Next, you can add a scorecard to the chart to display the conversion rates. Go to Add a chart and select Scorecard with compact numbers.

By default, Google Data Studio assigns it some random metric. Here is how you change it-

Since the data is grouped by month in the bar chart, drag and drop ‘month’ field to Date Range Dimension (in the DATA panel) of the scorecard.

I want the scorecard to display the ratio of website clicks to impressions (this is the first calculated field that was created in Step 6). So in the data panel for the scorecard, you can drag the field ‘impressions_to_click’ and drop it as the Metric.

Click on ADD A FILTER and create a filter. Give the filter a name so that you can use it again. Under Select a field, select ‘month’. Under conditions, select Contains, and in value, type ‘Jan’. Click on SAVE.

Funnel Visualization Google Data Studio: Add a filter

 This filter was named Jan_filter to filter to the month ‘Jan’.Similarly, create named filters for ‘Feb’ and ‘Mar’ as well. Once you create a filter, next time you can choose it directly from Filter picker when you click on ADD A FILTER.

Funnel Visualization Google Data Studio: Filter picker

Next, you want to ensure that the metrics in the scorecard are shown as percentages. To do that, go to Resources and select Manage added data sources

Funnel Visualization Google Data Studio: Manage added data sources

Click on EDIT corresponding to the data source. For all the calculated fields which contain the symbol ‘fx’, change the Type to Percent.

This is how the data panel on the right looks.

Funnel Visualization Google Data Studio: Data panel

Step 8: Placing the Scorecard on the Bar Chart

Drag the scorecard on top of the bar which shows the number of website clicks for Jan and then, resizes it appropriately. You can go to the style panel for the scorecard and change the size and color of the label as well. You can Hide Metric Name to avoid cluttering.

This is how the scorecard looks now.

Funnel Visualization Google Data Studio: The chart

Step 9: Adding More Scorecards

Similarly, you can add all the ratios you want to the chart on top of the bar columns by adding more scorecards as shown in Step 7. You should select the appropriate filter depending on the month you are displaying in the scorecard.

Funnel Visualization Google Data Studio: Funnel visualization

You can create funnel reports using Google Data Studio. Funnel report templates include funnel and pivot tables. A Pivot Table takes your rows in a standard table and pivots them so that it become columns. It supports the addition of multiple row and column dimensions that makes data really interesting.

Know more about visualization in Google Data Studio from here.

Conclusion

In this article, you have seen how you can build a simple funnel to visualize conversion rates at various stages in the chain for a hypothetical business on Google Data Studio. Since the metrics and KPIs vary from business to business, there is no single way to do this. Also, to create a funnel visualization Google Data Studio does not have a direct feature. So you should explore other ways of doing this to suit your specific purposes. You can also extend your funnel visualization and form a funnel report.

To get the best analysis results, it is important to look at data from multiple sources together. Use Hevo, a fully managed platform that performs data integration seamlessly.

Visit our Website to Explore Hevo

Check it out Hevo Data and Sign Up up for your 14-day free trial today.

Share your thoughts on Google Data Studio funnel visualization in the comments below!

Easily visualize your data in Google Data Studio