Have you ever wondered why titles are the way they are in Google Data studio. I mean some of these things we just want to rename, don’t we? That’s what we’re going to solve today, with field editing.
Google has recently brought about a new feature in data studio where you can have a little bit more control of the naming and summarizing of your dimensions and metrics within data studio.
Before we get into that, I do want to direct you over to DigitalMetrics.Guru/03download. Go there, sign up, and you’ll get to download the latest PDF diving much more in depth into what is possible with Google Data Studio field editing. It will go through all of the options within those customization’s of dimensions and metrics. Today we’re just going to deal with the naming but that’ll show you a little bit more what you can do, and just how powerful it all is.
I’m over here in a dashboard I’ve created within Google Data studio, called sample report for this video. You see a line chart here, a table, and a couple of scorecard metrics as well. Let’s face it, we talk in a different language than our data sources we have in our reports.
Getting right into an example for that, I have sessions and pageviews here. There is one thing that I talk about a little bit differently to clients and that’s average session duration. It’s a
little formal for most people. I understand what Google is doing in naming it this way, but I still call it average time on site.
Before a few weeks ago you wouldn’t be able to do anything about the naming convention in a Data Studio report. You would either leave it like this or, as horrible as this is, click into here, go over to style and tell it to hide the metric name. Then I would reduce the size of the metrics scorecard and put text in there stating average time on site.
This is a little bit of a hack but it could be done. However, every time something changed you would have to redo it. This newly available approach is a much better way of accomplishing the same task. You can go ahead and edit those names by using the field editing feature right within your report.
You do that by hovering over where in the metric name is. It’ll say 123 if it’s a metric and if it’s a dimension it’ll say ABC. Now if you don’t see this that’s quite all right what you’ll want to do is go over to your data source up to resources and edit the data source. I have mine here and you’ll want to click edit to re-configure the data source. You’ll also always want to make sure that the field editing in reports option is on. It is right now. Make sure that’s on and you’ll be able to utilize field editing just how we’re going to do right now.
So select that again and it’s super simple, all you need to do is just click on that edit and start typing the name right in here. Let’s call it average time on site and you see everything goes right along with it there.
Similarly I’ve run into this problem a ton with clients as well. You only have a limited space really on your dashboard. You can create new pages and what not, but you want to fit it how you want. So you have your sources here, your total sessions, and your goal completions, which actually are all of your actual conversions. Google calls them goals and goal completions.
You’ll want to go ahead and apply field editing to it and call it conversions and just like that it updates automatically. Great right! Hopefully your mind is thinking of all the ways you’re going to go ahead and edit your current or future reports.
Then another one specifically with Google Analytics data that gets me is right here. This is one of the goals, blog post completion. It’s the percentage that users completed and then it also says goal two conversion rate. It creates a really really long line of text within the table. Blog post completion is a perfectly fine title. So all you need to do is go in there and rename it to blog post completion. This will get rid of all that excess goal text information and just deliver conversion rate.
I will pause here for just a second you see that metrics will always be auto aggregated but there are a few different other options in here to customize the output. Wit the type option, which is currently a percent, you can choose percent numeric whatever it may be and then also any analytical function. This includes percent of total, difference of total, and percent difference of total.
Make sure to dive in and fool around with these options to get a little bit more in depth on the available options. We’re not going to do that right in this video but if you head over to DigitalMetrics.Guru/03download, you can go in and download everything right there. It’s a PDF that gets you more in-depth on a step by step of how to better utilize those functions both within metrics and dimensions.
Just to show you the different options for dimensions real quick, select the source and edit that. It could be text, date and time, geolocation, and other available options. So those are some things that we’ll get into in that PDF. Again DigitalMetrics.Guru/03download. Also subscribe on the YouTube Channel for information on Google Data Studio, Tag Manager, Analytics and more.
I hope to see you for the next video, thanks.