Data Studio has not come up with an easy way of making a funnel report (yet).

I recently had a client ask if I could create a visual report for a form the user fills out, immediately I thought, “easy I will use Data Studio”. Much to my dismay, there was not a funnel report or even a way to create a cool funnel graphic like you can in Excel.

I went to the internet to see if anyone had any ideas or had created one in data studio that I could use. After searching for a few minutes I did not really find anything that I liked, so I took to excel and created a funnel graphic.

After creating the funnel graphic in Excel I took a screen grab and placed that into Data Studio.

Next, I used the following steps to get the metrics into my graphic in Data Studio:

  • Open Data Studio and create a new page
  • Add Graphic
    • Under Insert select image
      Image1
    • You will get a cursor so you can draw a picture box
    • After you draw your image box, on the right side a window will appear called “Image Properties”
    • This is the area that you will select your image file to upload
      Image2
    • Click select file and upload the image of the funnel
Image3
  • Now that the image is in Data Studio you need to add metrics to the funnel graphic
    • Select the “Scorecard” icon and draw a box in the funnel for the metrics that you want to see
      Image4
    • Now that the data is in place, select the data you wish to have in each step of the funnel
Image5
  • Completed Funnel
    • After you add in the metrics you want you will have a complete funnel
Image6

 

This is the third in a series of posts about Google Data Studio tips and tricks that you might be helpful. Read our additional posts to learn more tips!

  1. Google Data Studio: Tips + Tricks #1
  2. Google Data Studio Quick Tips: Creating a New Calculated Field

Want more Google Data Studio insights? Contact your InfoTrust Consultant today!

Join thousands of subscribers.

No sales pitches, no spam, and an easy one-click unsubscribe.

About The Author: