This map shows the number of pageviews in cities across the world. Create a data-source-level field, which will make that field available in any report that uses that data source. You can even display your report on your company website or personal portfolio—which can be a great way to highlight the results you’ve gotten for a client or project. This style is misleading—for example, here it suggests every medium drove the same number of users. So let’s move along quickly. You can find the final report here. For instance, if you click on “organic” in this chart, the other charts on the page will update to show data for organic traffic only—just like you’d applied a traditional filter control. This is major game changer for Data Studio and opens up a lot of possibilities. Now you can add this calculated field to any chart just like a normal field. Not a problem. In this guide, I’ll walk you through the most useful Data Studio tools. Show all. For instance, I wanted to look at organic users for the HubSpot Blog (blog.hubspot.com) and main site (www.hubspot.com) at the same time. Here’s where you can access all of your reports (equivalent to a workbook in Tableau or Excel). Geben Sie die Anfangsbuchstaben einer Dimension, Metrik oder Funktion ein und wählen Sie diese dann aus. Don’t know RegEx? To log in, you’ll need a Google account, and once you log in, your home page will have the Data Studio dashboard, which looks like this. Das Tool ist kostenlos. For instance, let’s say that you majored in English and it’s always bothered you “Source” in Google Analytics is lower-case. 1. Im Gegensatz zu Google Analytics können hier benutzerdefinierte und interaktive Berichte und Dashboards erstellt werden. That time period will always supersede the date range control. (No, I’m not talking about myself. Earth Studio is an animation tool for Google Earth’s satellite and 3D imagery. This brings you back to that Overview tab. I added the organic traffic segment to both sources, but you can choose whichever segment you’re interested in (paid traffic, social traffic, etc.) In fact, here are some additional ideas for blending a source with itself: When your existing data doesn’t give you enough information, it’s time to create a calculated field. For example, my reports always default to the last 30 days, but if one of HubSpot’s blog editors wants to see how their property performed in the previous calendar month, the date range controls let them adjust the report. You can create a calculated field that takes the metric “Transactions” and divides it by the metric “Users.”. A box will appear on your report. All the limitations of the other type are reversed: while you can’t use a chart-level calculated field in another chart, filter control, or additional calculated field, you don’t need to have edit rights to the original data. You might be thinking, “Okay, great, but was that formula written in Klingon? If you decide the new chart is valuable, it’s easy to export it back into the report. Yep, same here. For example, if you’ve added a filter for Source / Medium, you may want to exclude the “baidu /organic” filter so your viewers don’t see that as an option. So you’ll need to view the report in Google Data Studio. In this article, I’ll help you get started with Data Studio and explore different available features. . Once you’ve picked your join key(s), the rest of the process should feel familiar. This is particularly handy when you’re working with customers, since you may not want to give them access to the live report. To see this report populated with the relevant data, these team simply need to select their view from the “data source” drop down and voila—all the charts will update automatically. The goal of using Data Studio is to become a data communicator, not a data plumber. We're committed to your privacy. Loves Data’s Benjamin Mangold’s has an excellent round-up of sample calculated metrics, including: If you want a little practice before you start going to town on your own data, Google offers a handy sample exercise. And again, everything is stored on the cloud, and you can access it from anywhere. Perhaps you want to create a new field for city and country. Sie können sie dann im neuen Diagramm nach Bedarf bearbeiten. Once you select the chart type, the right-hand pane will appear, and here is what you will see. No problem! And also just like filter controls, you can group chart controls. If you have a group of stakeholders that need to see your report on a recurring basis, considering using Data Studio’s “scheduled report” feature. For example, suppose you want to compare how users behave on your website versus your app. Select the chart(s) as well as the box, then choose Arrange > Group. You’ll be prompted to authorize the connection. Wenn eine Formel in einem berechneten Feld fehlerhaft ist, wird eine Warnmeldung angezeigt, und das Feld kann nicht gespeichert werden. Add a caption next to charts that support interactive filtering so your viewers know it’s an option: Data controls may just be one of the coolest Data Studio features, full-stop. As Google Sheets expert Ben Collins points out, this trick will also standardize any custom naming; for example, if some people on your team used “chat” for a campaign, and others used “Chat,” the UPPER function will aggregate both together. If you’re creating a report for a client and don’t know their hex codes, Seer Interactive’s Michelle Noonan has an excellent tip: use a free color picker tool to identify what they’re using on their website. Select the “blank report” option. Most powerfully of all, you won’t need to rely on others (like a data analyst or ops specialist) to get the answers you need. You have to activate “Interactions” / Apply filter at the bottom of the map properties. And here’s where you add data sources. Berechnete Felder. For instance, let’s say you’ve created a table in Data Studio that shows the top landing pages by conversion rate. Note: Make sure you’re choosing views with mutually exclusive data. Calculated fields take your data and, as their name suggests, perform calculations on them. See up-to-date reports for multiple projects and data sources in one easy interface. Don’t be scared off! Speaking of that dashboard, if you prefer, you can also start with Explorer (rather than a Data Studio report). 1,000 bubbles for other geographic field types. And with that, the first report is officially done. This gives users the option to create or import their own custom Map Styles which opens up a huge number of possibilities! Sie müssen Bearbeitungszugriff auf die Datenquelle haben, damit Sie berechnete Felder erstellen und ändern können. Like most Google tools, Data Studio can be hard to master, but it’s well worth the effort. (You can also do this by clicking the pencil next to the data source and then selecting “Add a field” in the upper right corner of your field menu.). Then do the same for your second. (To learn more, check out this W3Schools primer.)