See what the latest news is on Google Data Studio, Google’s powerful (and free) reporting tool.
Google Fonts (June 2020)
Want to use Google Fonts in Google Data Studio? Now you can. Ahmad and his team at Siavak have created a community connector that lets you import custom fonts from Google Fonts and even use the power of CSS to customize further. Check it out.
I always try to improve the look and feel of my data studio reports and topography is one of the most important parts of making it visually appealing dashboards. Today it’s only possible to choose from 78 fonts in Google data studio. We have a limited set of font sizes to choose from, and we can only choose from regular or bold 40 font thickness. On the other hand, there are more than 900 font families available on Google fonts for free. Some of these fonts have more than 18 size to choose from from super 10 to extra bold. Oh, you always wish that I could use some of these fonts in my Google Data Studio forms. That’s why we decided to liberate a fairly new feature of Google data studio, community visualizations and components, which is right now in developer preview mode to create a simple component that allows us to choose any Google font. And style it however we want using inline CSS. This is Ahmad from measureschool. Let’s go ahead and take a quick look.
Now let’s take a look at the component to add the component. You need to click on this small icon here and then click on, explore more. It is not right now available as a featured component in the part visualizations. It has to go through the review process by Google, before it can be added here. But right now what you can do is that you can click on build your own visualization and then scroll down and here type G S slash slash Siavak visualizations slash gallery and click submit. Once you do that, you can select this component and add it to your report. Let’s place it on the report. Now, the first thing you see will likely be an error message that says community visualizations disabled. To fix that, you need to go under the data properties tab and edit your data source. And here you need to click and enable the usage of community visualizations.
So that’s because usually community visualizations gets data from a data source and then visualize that data. But in this case, this component does not do anything with the data from the data source, but it’s still community visualizations option should be enabled for it. Now, as we can see in nonstandard Google fonts has been added to this report. Let’s see how we can change it. And what options do we have to style it. I’m gonna move on to the style tab. And here are all the options of this component. The the content of the text which we can change here. I’m gonna change it to no more limits and next with these two options, we have the possibility to select our own custom Google font. For now, there is no drop down menu. So we have to actually go to Google font and manually choose the font that we like.
Let me head over to Google fonts. And that’s where you need to go. And here you can search for any kind of font that you like. You can browse the list of the fonts. For example, it’s sorted by trending. These are the trending fonts. You can also filter based on the categories of font Serif, Sans Serif, display fonts, or handwriting fonts if you like. Or even better, what we’re excited about, you can choose based on language. So if you use a non-English language and you want to choose the specific fonts designed for your own language, then you can choose the font here to, for example, you can have our Japanese fonts here. You can have Chinese fonts here. And right now these fonts basically are not at all available in data studio. Other than these, you can choose to font properties. So for example, I just want to look at the fonts that have more than five styles, and I’m going to choose a font that is a bit thicker than the rest.
So let’s see, what do we have here? Let’s use this one, Heba. It is not available as a standard data studio font so we can use that for the purpose of this demo. When you click on the font, you can see all these styles listed at the bottom and you can select this style that you want by clicking on this button. Once you do that, you have to head over to the embeds app and grab the URL of the style of the font. That is fine in the href attribute without the quotation mark,.I’m going to copy this to the clipboard and I’m going to hit over to take it to studio. And here we need to remove this and paste this URL off the font, but we’re not finished. Before it starts to render the font. We have to actually put the name of the font as we can see above exactly like that here.
And then it’s a component can recognize the font and render it on the canvas. Once you added your text and set the fonts, it’s time to style it. You can write any inline CSS comment that you want here to start your text. You can change the color. You can change the font size, transparency, text alignment, line heights, padding, or even you can apply your shadow. But right now let’s start with something simple. I like to change the font size to let’s say 48, resize the component, and then change the text alignment to left. This was simple, but if you know CSS, you get the point. You can do anything you want, the sky’s the limit. For example, let me grab some CSS stat. And first of all, put it here for you to see this is the CSS. For example, it’s a bit complex, but it’s not the point we are using it to change the style of this one. Let me copy it again and paste it as the style of this text. And let’s see what happens. It’s a 3D effect. Isn’t it. Let’s see how it looks. 3D effect shadows and everything. I can view it. And it actually renders on your report. I’m not suggesting that it’s a good idea to have 3d effects in texts in your data studio reports, but I just wanted to demonstrate the possibilities that are at your fingertips with the custom fonts and inline CSS.
That’s it guys. I hope you enjoyed this video. If you’re new to measureschool, make sure to subscribe so you can get the future videos that be published. And if you want to learn more about data studio, I have more tutorials on YouTube that you can look up and watch. This is Ahmad see you on the next video.
Drag and Drop Fields (May 2020)
Hey guys, this is Ahmad from Measureschool. And today we’re going to take a look at three recent Google Data Studio updates that are gonna save you a ton of time. Let’s go ahead and get started.
3 Recent Google Data Studio Updates
Drag and Drop Fields
So I’m gonna start with this week’s Data Studio Update which is the ability to create charts by dragging fields and dropping them directly onto the canvas. And then I’m going to share two more time saving features. One from last week’s update, and one from a few weeks ago. So let me start with a blank report and connect it to our usual demo accounts. So as I said, this week’s feature is the ability to drag and drop fields directly onto the canvas to create charts.
Okay, so for example, if I drag a metric directly into the canvas over here, it will create a scorecard. If I drag a date and time field, it should create an Time Series charts. Or if I drag a geographic field like country, it will create a map, it actually creates a Google Map. Okay, if you drag and drop any other dimension, it will create a table. That’s it. We can also drag more fields directly onto an existing shot.
So if I want to see pageviews on this table, I can just drag and drop it, or I can also add it to the time series like this. That’s it quick and easy.
Okay, so this is the audience overview report. This is the acquisition overview report. And finally, the behaviors overview. To use any of these reports, you just need to click on Edit and share to open the report in your Google Data Studio account. So you will be the owner of the report. And from that point forward, you can either share it with your clients or use it as a baseline and customize it even further. So that’s it for today. That’s it guys. Thank you very much for watching. I hope you enjoyed this video. If you’re new to measureschool, make sure to subscribe to get notified of future videos that we publish. And if you’d like to learn more about Data Studio, I have several more tutorials that you can look up and watch. My name is Ahmad. See you in the next video.
Extract Theme from Image (May 2020)
Extract Custom Report Theme from an Image
Now let’s take a look at number two. And that’s the option to extract a custom reporting from an image. So before we either had to select from this list of predefined themes, for example, change the theme to a dark theme or we had to head over to the section to manually customize different aspects of the same like fonts, borders, sizes and colors. But now with the entire reduction of this extract seen from image feature, we can simply upload an image or copy and paste this URL and Data Studio will analyze the colors in the image and will extract the most prominent colors to create a custom themes for us automatically.
Let’s give it a try, I’m going to click extracting from image. And I have two options either upload an image from the computer, or copy and paste the URL. Let’s try copy and pasting the URL. I’ve already found this nice banana image on unsplash which I’m going to grab the URL of, copy image address, back to Data Studio and paste the URL. I’m going to click Upload. What happens now is that Data Studio tries to extract the main colors of the image and it will create three themes for us to choose from, usually two light and ones are colors. But sometimes it has three identical options.
The trick is to use an image with few prominent contrasting colors. Let’s select this one and click Apply. Interesting, isn’t it, we just created the custom reports in less than a minute. We can also click customize to adjust the same even further.
Google Analytics Integration (May 2020)
Google Analytics Integration
Okay, moving on to the third and final time saving update for today, which is Google Analytics integration. Let’s go to Google Analytics interface. From now on, we can create custom Data Studio dashboards directly from within the Google Analytics interface. To do that, we simply need to go to the customization section. And then at the top, we can click on any of these to create a custom Data Studio dashboard. Audiences acquisition and behavior.
New Map Type: Google Maps (May 2020)
Hello and welcome to today’s data studio update.This is Ahmad and I’m really excited to share with you the update that Google released yesterday for Google data studio. It’s a new chart type and it’s actually a Google map and today we’re going to discover all of the features and the data properties and the style properties of this new chart type together. Those of you that have used the previous map chart in Google data studio know that it had some types of limitations. You couldn’t find every city or region on that map. You couldn’t zoom in and out or you couldn’t pan around to see the different parts of the map and many people wanted a better option to plot the location specific data on a map. And then on the other hand, Google already has this awesome Google map that everybody uses on a daily basis. We use it to get the driving directions. We use it to find cafes and restaurants nearby.
We know how to use it.
Now with this update Google brought the same familiar interface and all the functionalities of a Google map inside data studio. And we can plot our data on top of this map. For example here, if I try to filter out this report to just take a look at California, it automatically zooms
in on the map. But again, we can zoom out if we want to. We can zoom in and this comes
in handy when our data is more granular. So for example, this place in city or even zip
codes and addresses. And yes, this map can also plot the addresses and zip code. So for
example, if we can put an address in the Google map and bring you directly to the exact location of that address. If your data set has addresses in that format in a format that Google can understand for any country then you can plot that data onto the Google map. It is exciting, isn’t it? Let’s go to the edit mode and try to recreate this map together. I’m using a dark interface. I hope you’re okay with that. And everything is visible and you can read the labels. So first let me delete this map and try to recreate it again. So to create such a map, just like any other chart, we go to the add a chart menu and just put the chart here. Let me resize as a bit. Okay. So the first thing that we notice is that unlike the previous map in Google data studio, this map uses bubbles overlaid on the map to plot the data. The
previous map, it could kind of bring shades to different areas, different cities, countries or regions, and show the data with different shades of a color. This is not yet available, but based on what I’ve had, it is on the roadmap and will be available soon. So now this map is plotting region. Okay. We can plot cities instead of regions and see number of bubbles should increase. Uh, let’s try and zoom in on the map interview mode. It is not possible to interact with the map in the edit mode. We have to go to the view mode to interact with the map. And right now because it is not filtered, it is showing the whole map. You can zoom in and see the data for each city. Okay. And the metric here is the number of records because
we’ve just added a single dimension city. So the cities are being plotted on the map. You can see, we can zoom in and see from which cities there are records in this dataset. And the dataset, by the way, is the Google analytics demo account, the 40 merchandise store. Let’s go back and see what else can we add. Now I want to change the style of this map because, uh, because I believe it’s not so much visible. We go to the start time and see what we can do. I’ve already looked at it. There are different styles that you can choose for this map. So you can choose silver, which uses a kind of a lightweight version of the map with just light gray and white, which allows us to better see our data. So if I, um, go to the view mode, this is easier to view for the remote user. And then let’s go back to the edit mode and see what
else do we have. So this was silver and we were using the dark mode before and this time
that is the standard colored interface of the Google map. Oh, I forgot. We cannot interact with the map in the edit mode. Okay. We just kind of do that. I was going to pan on the map, but uh, it wasn’t possible. So let’s do it.
Now, we can see the map on the colorful side. And then the final one. So we’ve seen the silver, the standard, the dark one. Uh, this one is coming from the report theme, which I applied to dark report theme and we also can have the satellite view. Okay. This is also cool.
Based on the theme that you’re using for your report, you can use the a satellite view.
And then let’s go back to the map view. And let me go to the view mode and zoom in a bit.
For example, let’s go, Oh, let’s see the United States because this is use demo accounts.
And I assumed there should be more data. Okay. So let’s try to take a look at New York.
Okay. So here we can see that as we zoom in, more data will become visible and we can edit this also in the start tab. So the level of granularity that we can see the maps and roads
and labels. So we can just try to show less roads. Okay. So just maybe let’s try it out. Yup. So it is not showing any roads if we just increase it a little bit. Now, it should only show kind of highways. I guess this one is when we are looking at a city level. So if I, let’s see if I can zoom one. No I cannot. So we have to zoom in even a bit more to see the impact. Uh, okay. So here we increase this. Now we can see this streets even more now we can see more labels on the map. Also we can do the same for the landmarks. Okay. So we can just remove them all to kind of make the map simpler. If we are showing a zoomed in view of the maps or we expect that our users are going to zoom in and the amount of data on the map might be overwhelming for them. So to the point that they cannot see the data. So we can for example, remove labels here. Okay. Just to see the names of the larger areas or the major cities. Okay. Something like that. Now another styling feature of the new Google map, which I’m so excited about and I’m going to show to you is that we can edit the JSon settings of the Google map styling. So the way it works that we open the Google map platforms, the styling wizard, okay, now we can click create and style and then we can adjust the settings of the map to make it look exactly like the way we want it. Okay. So we can for example, this theme like kind of Uber chain. And then, um, when we finished, we just come here, we can copy the JSon. Okay. And we can head back to Google Data studio, remove these and paste the Json here. This is so cool. This is so exciting. So we can stylize your map based on your brand colors, colors in their logo and the rest of the colors in the report. Especially if
the report is going to be viewed on larger screens in the office, your clients are going to love you. Okay, so let’s see. Now the style is custom. We cannot choose the level of details
for the roads and the landmarks anymore because it is being decided by the Jason object that we put in the custom field over there. Here we can choose how many bubbles do we want to see on our chart. Maybe you’re working with a data set that or too many bubbles on the chart and you want to just simplify it a bit. You can change this number here or let’s choose 1,000 to see if it is going to plot more bubbles. The report is loading. It seems that it is getting more data and Oh it is. It just kind of resets the zoom level. So we cannot actually figure out, I assume it’s getting data, um, from more rows and it’s plotting more data in here.
Let’s try to zoom in on the same level. It seems to be more bubbles. Okay. So assuming
your data has more rows, you can increase or decrease the number of bubbles that are
overlaid on your map. And then next we can choose the size of the bubble. So if you have
too many bubbles, you can maybe, reduce the size so they’re more visible. And if there are fewer and not visible at all, you might want to increase their size. Here we can change the color of the bubbles. So what we changed in the style setting and Json was for the map itself and now here we are deciding about the numbers and sizes and colors of the bubbles itself of the data that’s going to be plotted over the map. Next we can decide what kind of map controls do we want to give our users? Do we want to allow them to pan and zoom? Nope. Do we want to allow them to enter the street view? Okay. Personally, most of us don’t. I don’t want to, I cannot think of a reason. I want to give my users to enter this street view mode
when they’re looking at my report.
But anyway, the option is there. You might want to also restrict their ability to put the map on full screen, but it’s a nice feature. Let’s take a look. If I full screen the map, it’s going to explode and go out of the visible area that I’m recording right now because my monitor is actually my screen and it’s covered the screen completely. I have to reach over here to bring it back to edit mode and see what else do we have. This is one of the best visualizations. I’m best looking, I mean not most useful because depending on the type of data, you might not use it frequently. But it is the kind of best looking data visualization that’s been around in data studio so we can limit them and not allow them to go for the screen. We can allow them to change the map type to switch between the map and the satellite format and we also can show and hide the scale control, which shows you a little line over here that you can use to understand this scale of the map. Let me change these and bring the pan and zoom back on. And finally it sounded the same old style controls that we have for the rest of the charts and data studio. The background, which I don’t know exactly why exactly is the background
here. This is just a standard feature. The background is not visible obviously for this chart. But we can add a border if we want to. Okay. That’s kind of cool. Let’s see. Yeah, it has a border now. Now enough about the styling features of this new map type. Let’s take a look at
the data properties. So like every chart we have the data source. Of course our data source
should have some fields of the geographic type so we can use them to plot this map.
The first thing that we can configure here is the bubble location. It means are we plotting
based on a city, a country, a region, or in the United States it would be the state or
the continent. Okay. Now I’m going to change this for example, to region. Okay? So we can
see all the data based on the regions and different countries and the States in the United States. Let me just quickly decrease the size of the bubbles. The number is good. Go back to the data properties. The next thing is the tool tip. So when the user of the report, the report viewer, how was on one of these bubbles like this, okay, it is showing the value of the dimension that is set for the bubble location. So in this case, it’s the region. If we use it, if we
just hover over the bubbles in the US we see names of the state, right? One bubble per
state, and it’s the name of the state. But we can change it. And that’s the exciting point about it. So let’s say we want to see the region ID in here. And now we get the first error for our new Google maps on it. It says the tool tip dimension region ID has multiple values for the same bubble location region. It means that, okay, just think about it. When we hover over the region, the value of the dimension region ID should have a one to one relationship with that region. We cannot have two values for one region. If we do have this data studio doesn’t know which one of those values to show. Let’s try something else. Um, I don’t know why is it happening per region? There should be a one to one location. Maybe there is something I don’t know about the region dimension. But that’s right. With countries, each country has an ISO code and there should be, there must be a one to one relationship between the country’s name and the country’s ISO code. So if for example, let’s say choose the country as the bubble location. Okay, so here we have it. Now we have to get another error because there are multiple region IDs per country of course. But if we put the countries ISO code, which must be unique for each country, now we have our data plotted. Let’s go to the view mode and see what do we have here? Let’s go to the Europe. Okay, so let’s look at Germany. See, let’s look at Hungary, where I live. HU or Netherlands NL. Okay, so there is, you can see that there is a one to one relationship between the main dimension, the bubble location and the tooltip. Whenever you have two dimensions that have one to one relations like this, you can use one of them as the value for the tool tips. Okay. Next, what do we have in the data properties tab? So we have our bubble location. We can decide this is optional.
We can decide from which dimension do we get the value for the tool tip. If we remove it,
it gets, it shows the actual name of the country for the tool tip. And then we can choose the bubbles color and we have bubble color here and also here. So we can apply a metric as the bubble color or apply dimension. Let me just switch back to the region because I want more bubbles. And let me just remove this. Get rid of it. Okay. Let me quickly zoom in so the, I don’t want to always zoom into the US let’s do something about it. Okay, so let’s filter our Google map. Let’s see if we can filter our Google map. Let’s add a filter that says we only
want to show data for the US so I don’t want to zoom in United States. Save. And that’s it. Okay, so we have Hawaii and Alaska here, and that’s why it doesn’t zoom in completely on the map. Theoretically, we can filter them out, but it just takes too much time. Let’s go back
to the edit mode. Okay. Let’s take a look at bubble color. We can add a dimension as the bubble color or add a metric. Okay? And there are differences about it.
Let’s start with a dimension. Let’s say we want to give each region specific color, okay? Now, instead of all the bubbles being in the yellow color that we’ve selected in the style tab earlier,
we can see different colors. Okay? They kind of look like each other, but they’re actually different. And if we come back to the style tab, now we can choose manage dimension value