Google Data Studio Part 3: Dashboard Strategic Best Practices

In this multi-part series, we’ll take a tour through Google’s newest digital tool, Data Studio. We’ll look at it from a marketer’s perspective, including:

Part 3: Dashboard Strategic Best Practices

Before starting a dashboard in Google Data Studio – or any other dashboard software – we need to review some basic dashboard best practices.

A dashboard is nothing more than a narrative, a story we tell about our data. If we think about a dashboard as a story rather than a series of data points, we stand a much better chance of creating a dashboard that our audience will use.

To craft this narrative for our dashboard to deliver maximum impact, we need two structures:

  • 6W
  • Why/what/how

6W Structure

The 6W structure helps us decide the contents of the dashboard. Assemble a spreadsheet or document which answers these questions as thoroughly as possible before starting a dashboard:

  • Who: Who will be viewing the dashboard? Will it be senior executives? Middle management? General staff?
  • What: What key metrics does our audience care about? What are they held accountable for? What directional data leads to those key metrics?
  • Where: Where will our audience view the dashboard? On their desktop? Mobile device? Will someone else read it and interpret it for them?
  • When: How often will our audience view our dashboard? Will they dig into it monthly? Will they glance at it daily?
  • Why: Why does our audience need a dashboard? Does it replace a more onerous document? Does it save them time or money?
  • How: How will our audience use the information provided by the dashboard? Will they turn it into a bullet point in a presentation? Will they execute program changes from it?

Once we have these answers, we have a much more clear idea of what should and shouldn’t be in our dashboard. Interview as many of your audience members as you can about their needs before starting your dashboard. When you receive conflicting answers, keep digging! Conflicting answers means conflicting priorities, and you may uncover a hidden common priority which can make your dashboard even more powerful.

Why / What / How

Once we’ve ascertained what should be on the dashboard, we likely have a pile of pieces: metrics, charts, graphs, scorecards, images, etc. Instead of slapping everything on the page haphazardly, think about structuring your dashboard into three sections: why, what, and how.

dashexample.png

The Why section is first; it’s color-coded red in the image above. It should contain the most valuable things, the one or two KPIs that our audience cares about first. It should also contain enough labeling and navigation so that someone unfamiliar with the dashboard can orient themselves quickly.

The What section is next; it’s color-coded yellow in the image above. What contains a more detailed explanation or dive into the KPIs. If Why is at a glance, What explains the details. What are the trends, what are the patterns in the data that can lend additional insight into our KPIs?

Finally, the How section is last; it’s color-coded green in the image above. How tells us the diagnostics which lead to our KPIs. In the example, if Revenue is a KPI, what sources drive that revenue? If New Users is a KPI, where do new users come from?

Note that this is only a sample, an example dashboard. You’ll need to develop your own based on the answers you obtain in your 6W research.

Conclusion

A final word of caution via Avinash Kaushik: when it comes to dashboards and visualization, less is more. The higher up in an organization a dashboard or visualization goes, the less data you need and the more insight and analysis you need. Avoid cramming your dashboard full of every possible scrap of data you can find. Instead, whittle down to the bare minimum. What necessary pieces of information must you include? Everything else should be shelved, put in alternate reporting formats, or assessed at more junior levels in your organization.

Google Data Studio is a valuable addition to every Google-centric digital marketer’s visualization toolkit. With Data Studio, you can create fast, simple, inexpensive dashboards which tell the story of your marketing data.


If you enjoyed this, please share it with your network!


Want to read more like this from ? Get updates here:

subscribe to my newsletter here


Marketing Blue Belt Preorder

Order your 2016 Marketing Planning Framework


Google Data Studio For Marketers, Part 2: Setting Up Your First Dashboard

In this multi-part series, we’ll take a tour through Google’s newest digital tool, Data Studio. We’ll look at it from a marketer’s perspective, including:

Part 2: A Video Walkthrough of Data Studio

Google’s Data Studio makes wonderful interactive dashboards. In this 17-minute video introduction, we’ll walk through how to connect data sources, what data sources are included, how to hack around some of the data source limitations, and we’ll build our first dashboard.

In the video, we first show how to add text, images, and data, then look at a data storytelling narrative around visualizing Twitter data, blending Twitter data with Google Analytics Twitter-specific data. If you’d like to try out the final product, simply click this link to view:

datastudioexample.png

As a reminder, users receive 5 dashboards for free under the current plan.

Next: Strategic Best Practices

In the next part in this series, we’ll discuss strategic best practices for marketing dashboards.


If you enjoyed this, please share it with your network!


Want to read more like this from ? Get updates here:

subscribe to my newsletter here


Marketing Blue Belt Preorder

Order your 2016 Marketing Planning Framework


Google Data Studio For Marketers, Part 1: Introduction

In this multi-part series, we’ll take a tour through Google’s newest digital tool, Data Studio. We’ll look at it from a marketer’s perspective, including:

Part 1: What is Data Studio?

Google’s Data Studio makes dashboards. That’s the simplest way to put it. It’s been in beta since last year, when it was first revealed to Google Analytics Certified Partners.

datastudio.png

Data Studio connects to various Google data sources such as Google Analytics, AdWords, BigQuery, and Google Sheets. It provides drag and drop visualization of common metrics, and your dashboards can easily be shared with others. When we share a dashboard, the shared page is interactive, so others can view or even remix our dashboards if we permit them to.

Data Studio comes with 5 free dashboards for all users; after the first 5, a monthly fee applies. Thus, for the average individual marketer, Data Studio is a great first dashboard tool to learn.

What Data Studio Isn’t

Data Studio is a simple, easy to use tool. As such, it trades off sophistication found in other dashboard software for ease of use.

Data Studio is also a pure visualization tool. It offers many different ways to chart and visualize data. However, it offers virtually no analysis or computational capabilities. If you’re accustomed to doing in-visualization computation (such as with Watson Analytics or Tableau), Data Studio will not fit the bill.

Data Studio also offers very restricted data sources. If you don’t operate in the Google Analytics/AdWords/BigQuery ecosystem, Data Studio will be of limited use to you out of the box.

Next: Setting Up

In the next part in this series, we’ll step through the process of building your first Data Studio dashboard.


If you enjoyed this, please share it with your network!


Want to read more like this from ? Get updates here:

subscribe to my newsletter here


Marketing Blue Belt Preorder

Order your 2016 Marketing Planning Framework


mautic is open source marketing automation