Share on facebook
Share on twitter
Share on linkedin
Share on email

Bullet Charts for Conversion Funnels in Google Data Studio

Bullet Chart Conversion

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. 


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.


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:


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 “”. You can slice and dice with a RegEx as well:


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


12) Also under the Style tab, uncheck “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


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


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


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


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


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.
Share on facebook
Share on twitter
Share on linkedin
Share on email

Other Articles You Will Enjoy

4 Retail Digital Analytics Trends to Follow in 2021

4 Retail Digital Analytics Trends to Follow in 2021

The world-changing events of 2020 impacted nearly every industry, with retail and eCommerce seeing dramatic shifts in consumer behavior. While the COVID-19 pandemic is…

Which Analytics, TMS, and A/B Testing Platforms are Used by the Top 100 Digital News Outlets?

Which Analytics, TMS, and A/B Testing Platforms are Used by the Top 100 Digital News Outlets?

As the marketing technology landscape continues to grow beyond 8,000 martech solutions (up 13.6% YoY), the team at InfoTrust is taking a deep-dive look…

Google Analytics 4: An Introduction to Predictive Metrics

Google Analytics 4: An Introduction to Predictive Metrics

My wife and I welcomed our first child, Leon, to our family last year. His arrival brought sleepless nights, lots of time inside playing…

5 Retail Remarketing Audiences for your Holiday Campaigns

5 Retail Remarketing Audiences for your Holiday Campaigns

Holiday campaigns are top-of-mind for most marketers this time of year, and tying results to business objectives is key to success. Each customer interaction…

Identity Resolution 101: Keys to Embracing 3rd Party Cookie Regulations Using 1st Party Data Strategy

Identity Resolution 101: Keys to Embracing 3rd Party Cookie Regulations Using 1st Party Data Strategy

Marketers from all types and sizes of companies are concerned about the new regulations restricting third-party cookies on a customer’s browser and the effects…

InfoTrust to Lead Webinar on Analytics Maturity Using Google Marketing Platform

InfoTrust to Lead Webinar on Analytics Maturity Using Google Marketing Platform

If you’re a marketer looking to sharpen your skills, or a business owner hoping to take your organization to the next level, then look…

How Will the Apple iOS 14 Update Impact Advertising?

How Will the Apple iOS 14 Update Impact Advertising?

In June 2020, Apple announced that their iOS 14 update would include a very important new privacy update. Naturally, this update puts many businesses—or,…

What is a Data Clean Room?

What is a Data Clean Room?

“Data clean room” is a growing buzzword in marketing, analytics, and advertising industries. Although data clean rooms aren’t an entirely new concept, they haven’t…

Introduction to Ads Data Hub

Introduction to Ads Data Hub

The internet is changing and surely, you don’t want to be left behind. We are seeing users’ privacy becoming a standard, not an option,…

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.

Our website uses cookies and may collect user information to provide a good experience. Read our Privacy Policy here.

Leave Us A Review

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