google data studio 360 tutorial

14
Powerpoint Templates Page 1 Powerpoint Templates Google Data Studio

Upload: veeranjaneyulu

Post on 13-Jan-2017

411 views

Category:

Education


47 download

TRANSCRIPT

Page 1: Google Data Studio 360 Tutorial

Powerpoint Templates Page 1Powerpoint Templates

Google Data Studio

Page 2: Google Data Studio 360 Tutorial

Powerpoint Templates Page 2

Google Data Studio Data Studio part of Google Analytics 360 Suite, a platform that will help you evaluate the full customer journey and drive results. The Suite is comprised of 6 products, as schematized below.

Data Studio 360 - Data Analysis and Visualization (cherry on top!): Build beautiful and shareable reports, with all your data in one place.

Page 3: Google Data Studio 360 Tutorial

Powerpoint Templates Page 3

Data Studio lets you connect to all your marketing data and turn that data into beautiful, informative reports that are easy to understand, share, and fully customizable.

With multiple data connectors, we can now easily create dashboards from many different types of data and share with everyone in your organization - and we can mix and match data sources within a single report.

Create Beautiful Reports (even if we aren’t a graphic designer)

For example, you can combine Google Analytics data and Google AdWords data into a single report

Page 4: Google Data Studio 360 Tutorial

Powerpoint Templates Page 4

Google Data Studio Overview:

• Connect - The first thing you have to do when working with data is making sure you have it! Once you do, check whether any preparation is required (e.g. calculated fields, different formatting, cleaning up) in order to make the data useful.

• Visualize - Creation of reports, sheets using the data

• Share - Can share reports, insights with colleagues…

Page 5: Google Data Studio 360 Tutorial

Powerpoint Templates Page 5

Google Data Studio: How Does it Work?

•First, log in with the Google account you use to manage your Analytics and AdWords accounts.

•Login at https://datastudio.google.com. You will see something similar to the following page.

Page 6: Google Data Studio 360 Tutorial

Powerpoint Templates Page 6

Sync Google Data Sources

Next, enter the Reports section, and connect to your preexisting data sources or select “Create New Data Source” in the bottom right corner.

The main data sources you can pull in right now include:

Page 7: Google Data Studio 360 Tutorial

Powerpoint Templates Page 7

Data Sources: Access, Transform, and ManageClick on Data Sources in the left “sidebar". Maybe you will already have some Data Sources in there, maybe you won't. In any case, you will see a “+" sign in the bottom-right corner of your page, click on that to create a new Data Source.

The first choice you have to make is where you are getting the data from: Google Analytics, BigQuery, Sheets, etc. Once you click on one of them, choose among the accounts you have access to and click the “Connect" button. You will get to a screen similar to the following.

Page 8: Google Data Studio 360 Tutorial

Powerpoint Templates Page 8

1. Create a calculated field: you can use this to create new metrics based on a formula that transforms one or more existing metrics. There are dozens of operators available, here is a reference list.

2. Field type: choose the formatting and the type of your metric. Here are the top level types, each has a bunch of options: Numeric, Text, Date & Time, Boolean, Geo.

3. Field aggregation: choose the aggregation that should be used for your metric. For example, if your metric is a ratio such as Conversion Rate, you should use Average, if it is an absolute value such as sessions, you should use Sum.

4. Create a report:

Page 9: Google Data Studio 360 Tutorial

Powerpoint Templates Page 9

Organize Your Data:

As soon as you’ve chosen the data source you’d like to pull from, you can move on to the customizable live reports segmented by:•Time periods•Geographies•Segments•Filters …and more.

Page 10: Google Data Studio 360 Tutorial

Powerpoint Templates Page 10

Reports Best Practices:

Page 11: Google Data Studio 360 Tutorial

Powerpoint Templates Page 11

• Filter controls give power to the users. Filter controls will drive users forward and offer a rich analysis experience. 

• Headers and page dividers are great for organization and consistency

• Chart diversity makes the report more engaging. Having different chart types makes the analysis more interesting.

• Color styling helps guiding the eyes, Do not overuse color!

• The Report purpose informs the design. The purpose of the visualizations is incredibly important during the conception and creation of your Reports.

Page 12: Google Data Studio 360 Tutorial

Powerpoint Templates Page 12

Data Studio uses the Google Drive sharing model, which you are hopefully acquainted with. It is important to notice that when you share a Report or Data Source with a person, the access will be given unrelated to whether the person has access to the data in Google Analytics, Sheets, BigQuery, etc. This means that it is extremely important to make sure that the data can be shared with the person.

Let's look at an example.

Sharing is caring: in moderation!

Page 13: Google Data Studio 360 Tutorial

Powerpoint Templates Page 13

Page 14: Google Data Studio 360 Tutorial

Powerpoint Templates Page 14