Calculated Fields in Google Data Studio – Whiteboard Friday
Posted by DiTomaso
Google Data Studio is a powerful tool to have in your SEO kit. Knowing how to get the most out of its power begins with understanding how to use calculated fields to apply good old-fashioned math to your data. In this week’s Whiteboard Friday, we’re delighted to welcome guest host Dana DiTomaso as she takes us through how to use calculated fields in Google Data Studio to uncover more value in your data and improve your reports.
Click on the whiteboard image above to open a high-resolution version in a new tab!
Hi, Moz fans. I’m Dana DiTomaso, President and partner at Kick Point, and we love Google Data Studio at Kick Point. You may not love Google Data Studio yet, but after you watch this I think you probably will.
One of the first things that you think about Google Data Studio is: Why would I use this? It’s just charts. It’s the same thing I can get in Analytics or a billion other dashboarding tools out there. But one of the things that I really like about Google Data Studio is math. You can do lots of different stuff in Data Studio, and I’m going to go through four of the basic types in Data Studio and then how you can use that to improve your reports, just as you sort of dip your toes into the Google Data Studio pool. What I’ve done here is I have written out a lot of the formulas that you’re going to be using.
It’s a lot of obviously written out formulas, but when you get into Data Studio, you should be able to type these in and they’ll work. Let’s start at the beginning with the types.
- Basic math. This is pretty obvious. 1 + 1 = 2. Phone calls plus emails equals this, for example. You can add together different fields.
- Transforms. Let’s say people are really bad at writing some things upper case and some things lower case. You have a problem with URLs being written a couple of different ways. You can use a transform to transform upper case into lower case. That’s pretty nice.
- Formulas. Formulas is where you’re saying only show this subset of the data. Or how often does this happen? That could be things like the Count function, so count how many times this occurs, for example, and present that as a totally separate metric, which can be really useful for things like when you want to count the number of times an event occurs and then compare that against something else. It can just pull out that kind of data.
- Logic. This is the more complex one. If X, then Y. If this happens, then that’s going to happen. There’s a lot of really complex stuff in there. But if you’re just getting started, start with this, and then look at the Google Data Studio documentation. You’ll find some cooler stuff in there.
1. Basic math
Here are some examples of how we use this in our Google Data Studio dashboards. So basic math, one of the things that a lot of people care about is: Are people getting in touch with me?
This is the basics of the reason why we do marketing. Are people getting in touch? So, for example, you can do some basic math and say, “All right. So I know on our website in Google Tag Manager, we have a trigger that fires whenever somebody taps or clicks a MailTo link on the site.” In addition to that, we’re tracking how many people submit a form, as you should.
Instead of reporting these separately, really they’re kind …
You can read the full article at Moz Bloghttp://seopti.com/calculated-fields-in-google-data-studio-whiteboard-friday/http://seopti.com/wp-content/uploads/2013/07/moz-logo.pnghttp://seopti.com/wp-content/uploads/2013/07/moz-logo.pngSEOMOZ