Skip to main content
Data Runs Deep Menu

Main navigation

  • Home
  • Who We Are
    • Careers
    • What We're Up To
    • What We Believe In
    • Ethical Policy
  • What We Do
  • Google Marketing Platform
    • Analytics 360
    • Tag Manager 360
    • Salesforce and GA360
    • Google Analytics App+Web
    • Data Studio
    • Optimize
  • Google Cloud Platform
    • Google BigQuery
      • Google BigQuery Training
      • Google Analytics Integration
  • Consulting
    • Strategy
    • Implementation
      • Google Analytics Audit
      • Google Tag Manager Audit
      • Enhanced Ecommerce Implementation
      • Google Tag Manager
    • Analysis
      • Google Data Studio
        • Google Data Studio Case Study - Mona
      • UX Analysis
  • Training
    • Five Day Google Analytics Online Workshop
    • Advanced Google Analytics Training
    • Google Tag Manager Training
    • Google Analytics 360 Training
    • Advanced Analytics Bootcamp
  • Partnerships
    • Conductrics
  • Blog
  • The Flying Beagle
  • Merch
  • Contact

Reporting Against Targets in Google Data Studio

Targets Dashboard
By: Nick Hood
Posted in
  • Data Studio
Article Date
December 21, 2016

When it comes to reporting, context is essential. 

For those immersed in the digital side of a business the metrics covered in a standard web report may be second nature, but for the wider audience it might be hard to quantify how good or bad a certain value is. Sure you can compare with last month, or last year, but doing better than last month isn't always the same as doing well.

One way to add some additional context to your Data Studio reports is to look at performance against a target. 

Here is an example report we’ve created showing performance against a target for three key metrics:

Targets Dashboard

This report is intended as a wall board that updates daily to show progress against targets, but the same concepts apply if you wanted to simply have a % of target field added to a monthly report.

All we need to do to bring a target comparison into a report is create a calculated field with our metric divided by our target:

Registrations Target Calculated Field

We then used that new metric in a bar chart:

Bar Chart Properties

Even though we want to look at just the metric in our bar chart we need to specify a dimension, so we’ve just created a calculated field to get an “All users” dimension. There’s a number of ways to do this but here’s how we’ve done it:

All Users Calc

So now we have a single bar chart that looks something like this:

Bar Chart No Style

We fluff around with the display settings a bit, turn off the axis labels and legend, overlay some labels of our own, add the overall metric count at the top and add our dashboard styles to the page  and we now have our nice little scale that will fill up each time the data is refreshed to show the current progress against the target.

Chart Styled

This is just one use case for targets in Data Studio but once you've created that simple calculated field it can be incorporated in many ways. If you have any questions just let us know using the form below.

 

Get in touch

To find out more, email us on hello@datarunsdeep.com.au or complete a quick contact form.

Get in touch

Talk to us: 1300 737 885

08:30 - 16:30, Monday to Friday. We love to chat

Visit us, we’re at:

Level 8, 313 Little Collins Street Melbourne, VIC 3000

Footer

  • Home
    • Who We Are
      • What We Do
      • What We're Up To
      • Careers
      • Contact
  • Training
    • Google Analytics Training Courses
    • Advanced Google Analytics Training
    • Google Tag Manager Training
  • Consulting
    • Analysis
    • Implementation
    • Strategy
    • Google Analytics Audit
    • Google Tag Manager Audit
  • Google Cloud Partner
  • Google Marketing Platform Sales Partner
  • Bitcoin accepted here
  • Registered Looker Consulting Partner Melbourne
  • Twitter
  • LinkedIn
  • Google Plus
  • Blog RSS feed
Copyright © 2009-2021 Data Runs Deep Pty Ltd. All Rights Reserved. Google Analytics is a trademark of Google Inc.
Website by Marin Sekesan