Warning: this content is older than 365 days. It may be out of date and no longer relevant.

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.


You might also enjoy:


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

subscribe to my newsletter here


AI for Marketers Book
Take my Generative AI for Marketers course!

Analytics for Marketers Discussion Group
Join my Analytics for Marketers Slack Group!