Bullet Charts for Conversion Funnels in Google Data Studio

Bullet Chart Conversion
Estimated Reading Time: 6 minutes

It’s not uncommon to look through the list of Google Data Studio chart options and wonder “How would I even use that?” Which translates to “How could this possibly be valuable?” The fact of the matter is, we tend to create dashboards with the tool we already want in mind “Oh, this guy needs a pie chart!” or “a colorful histogram would make my data sing.” So prepare to venture outside the box. Fasten your pencil protectors and have a seat, fellow visual geeks. 

Bullet charts, or bullet graphs, are a pretty simple concept — though its inventor, Stephen Few, might beg to differ. It’s a variation of your standard bar chart, but only using a single metric, and logging a scale as values progress. Much like a thermometer, where the temperature metric rises and falls. Bullet charts also tend to include benchmarking, or color-coded values your metric may strive for (or against). In literal terms, changes in value create a single, visual “bullet” across the X axis. 

classic-bullet-chart

But with Google Analytics data, we’re more often analyzing several metrics, potentially across several dimensions, relative to other data. In other words, if you want to know the conversion rate of five different Google Analytics Goals, you may opt to use a standard bar chart or histogram to see which goals are performing the highest.

Google Analytics has a new Custom Report Feature, currently in Beta, which allows for Funnel creation but does not allow for the flexibility and granularity of a Data Studio configuration or shiny perfect branding for you nor your client.

custom-report

With all of this in mind, there are a few sneaky ways you can make bullet charts inside of Google Data Studio, including the semblance of conversion funnels and mock-histograms.

The Bullet Chart Conversion Funnel

Conversions and funnels and paths (oh my). We all know that customer journey’s often take many, many twists and turns. This is why Google Analytics offers reports such as Behavior Flow, and (reminder, still in beta) Conversion Funnel Custom Reports. The latter is the closest approximation to what a bullet chart can get you. It works best when establishing an exclusively linear path for your user journey. For instance, your user’s checkout process of users who visited the Cart Page >> Checkout Page >> Payment Page >> Confirmation Page. You can build these funnels to track users inside of one session, or inside of any session. But a major problem is, we can’t zap these funnels into Google Data Studio. 

Another example of conversion funnel behavior is your site may be using a selector tool or wizard. Say you want to analyze how your users find out which cocktail is right for them. 

Your wizard steps may include page URLs indicating:

  1. website.com/my-perfect-cocktail
  2. website.com/my-perfect-cocktail/chocolate-v-vanilla
  3. website.com/my-perfect-cocktail/personality-type
  4. website.com/my-perfect-cocktail/form-or-function
  5. website.com/my-perfect-cocktail/results

Each page would be sequential. Unique pageview visitors would not be viewing /results if they had not first viewed /chocolate-v-vanilla. Make sense?

We can use Bullet Charts as visual cues to determine which percentage of users traveled from one step to the next. This can help you identify where users may be dropping off, and thereby test methods of improving their completion rates.

Here’s How It’s Done

1) Create a Scorecard chart (stay with me, it won’t be a scorecard forever!)

2) Assign Unique Pageviews metric to the scorecard

3) Build and apply a Filter of Include >> Page >> equals >> /my-perfect-cocktail

NOTE: be certain you have excluded unnecessary query parameters and also if you have the hostname URI appended to your “page” dimension, use the full page location of “website.com/my-perfect-cocktail”. You can slice and dice with a RegEx as well:

bullet-chart-screenshot

4) Apply this filter to your scorecard

5) Click your scorecard, copy & paste

6) Click the pasted scorecard, go to the right of your dashboard, and click “bullet chart” (this will convert your selected scorecard automatically — magic!)

7) Reselect your scorecard, and to the right under scorecard properties, select Style

8) Click Hide Metric Name

9) Gaze at that beautiful integer

10) Reselect your Bullet Chart

11) Under Style, select the Range Color, then select “Transparent

color-chart

12) Also under the Style tab, uncheck “Show Axis

show-axis

13) Head back to your Data tab and uncheck “Show Target

14) Look just above this and find Range 3. Change this range to be significantly higher than the Unique Pageviews you’re working with, and remember this number.

In this case, we’ll choose 10,000,000

range-screenshot

15) Give yourself a pat on the back, and admire creating the first bar of your Histogram and first funnel step for your visitors on /my-perfect-cocktail

From here, it is a matter of replicating the above steps, but with the appropriate page filter for each. Just be sure to copy and paste both the scorecard and the bullet chart (prior to removing and applying the proper page filter) so that your formatting is maintained. This will make life easier for you 🙂

16) Replication will eventually look something like this

replication-screenshot

17) Once your page filters are configured and applied, you may leave your data as a mock-histogram we mentioned earlier like this:

mock-histogram

18) Or if you’re more of a funnel purest, you may shift your workaround for something with a little more zazzle

second-mockup

19) You may even opt to spice things up further by adding filter options for your viewers. For instance, if you’d like to see how different traffic sources go through your funnel, simply add a source/medium to your dash, and you’re off and running

source-medium

20) Et, voila!

What can you do with this data? Say, for instance, your Email traffic has a high completion rate, but your Organic traffic could use a boost. Simply segment this audience in Google Analytics and remarket to increase conversions. This is just one of the countless ideas for you and your data!

Remember, this works on historical data, and no goal configuration is required 🙂 

Happy analyzing, everybody!

Contact InfoTrust Today

Interested in learning more about conversion funnels? We're happy to connect you with one of our experts today.

Author

Facebook
Twitter
LinkedIn
Email
Originally Published: October 29, 2020

Subscribe To Our Newsletter

August 29, 2022
Originally published on October 29, 2020

Other Articles You Will Enjoy

How to Integrate Google Analytics 4 with BigQuery for Enhanced Data Analysis and Reporting

How to Integrate Google Analytics 4 with BigQuery for Enhanced Data Analysis and Reporting

Has your business found that its reporting needs require advanced analysis of your analytics data beyond what is practical in the Google Analytics 4…

4-minute read
Leveraging Attribution Models in Google Analytics 4 to Improve Your Marketing Strategy: Tips and Best Practices

Leveraging Attribution Models in Google Analytics 4 to Improve Your Marketing Strategy: Tips and Best Practices

In the dynamic landscape of digital marketing, understanding the customer journey is crucial for optimizing strategies and maximizing ROI. Google Analytics 4 (GA4) introduces…

5-minute read
Tracking User Behavior with Events in Google Analytics 4: Examples and Use Cases

Tracking User Behavior with Events in Google Analytics 4: Examples and Use Cases

So you’ve created your Google Analytics 4 (GA4) properties, created your data stream(s), and followed all the necessary steps to configure your property. Now…

5-minute read
Predictive Analytics in Google Analytics 4: How to Use Machine Learning to Forecast User Behavior and Outcomes

Predictive Analytics in Google Analytics 4: How to Use Machine Learning to Forecast User Behavior and Outcomes

Google Analytics 4 (GA4) is embracing the power of machine learning by incorporating predictive analytics within the platform so that you can use your…

7-minute read
How Does BigQuery Data Import for Google Analytics 4 Differ from Universal Analytics?

How Does BigQuery Data Import for Google Analytics 4 Differ from Universal Analytics?

All Google Analytics 4 (GA4) property owners can now enable ‌data export to BigQuery and start to utilize the raw event data collected on…

2-minute read
Is It Time to Upgrade? 4 Signs Your Organization Needs Google Analytics 4 360

Is It Time to Upgrade? 4 Signs Your Organization Needs Google Analytics 4 360

As VP of Partnerships at InfoTrust, I’ve had the opportunity to talk with hundreds of decision-makers about their interest in upgrading to Google Analytics…

4-minute read
App Install Attribution in Google Analytics 4: What You Need to Know

App Install Attribution in Google Analytics 4: What You Need to Know

App install attribution in Google Analytics for Firebase (GA4) is a feature that helps you understand how users discover and install your app. It…

6-minute read
Leveraging Custom Dimensions and Metrics in Google Analytics 4 for Content Performance Measurement: Best Practices and Real-World Examples

Leveraging Custom Dimensions and Metrics in Google Analytics 4 for Content Performance Measurement: Best Practices and Real-World Examples

In today’s digital landscape where content reigns supreme, understanding how your audience interacts with your content is paramount for success. For news and media…

5-minute read
Best Practices for Leveraging Custom Insights in Google Analytics 4

Best Practices for Leveraging Custom Insights in Google Analytics 4

What Are Custom Insights? Google Analytics 4 (GA4) offers Custom Insights to detect changes in your data that are important to your team specifically….

3-minute read

Get Your Assessment

Thank you! We will be in touch with your results soon.
{{ field.placeholder }}
{{ option.name }}

Talk To Us

Talk To Us

Receive Book Updates

Fill out this form to receive email announcements about Crawl, Walk, Run: Advancing Analytics Maturity with Google Marketing Platform. This includes pre-sale dates, official publishing dates, and more.

Search InfoTrust

Leave Us A Review

Leave a review and let us know how we’re doing. Only actual clients, please.