CategoryUncategorized

Google Data Studio: Relative to Base Data vs Corresponding Data

G

Comparison metrics in Google Data Studio have two options: ‘Relative to base data’ and ‘Relative to corresponding data’. Let’s see what these terms mean. Take a look at the below table and its configuration that follows. The dimension is ‘source’. The metric ‘Sessions’ is added twice. You will generally not need to add it twice. But I am doing so in this post to make it easy to explain the...

COVID19: Employee Self Declaration using Google Forms and Data Studio

C

Employees can report any COVID19 symptoms that they have using the Self-Declaration form. The data entered in this Google Form will be displayed in a Google Data Studio report. Demo Form: Demo Report: You can copy the form and the report and use it in your organization. Follow the below instructions to copy.   How to copy the form and store the responses in a Google Sheet? Click the link...

Google Data Studio Tips for Agencies with Multiple Clients

G

In this post, I will share a few ideas and Data Studio features to help Digital Agencies with multiple clients. The idea is to start a discussion around this topic and share notes among ourselves. 1. Create a master report 2. Chart specific vs Data Source calculated fields: Which ones to use? 3. Give descriptive names to data sources 4. Copy existing data source instead of creating new ones 5...

Google Data Studio Template: Goals Report From Google Analytics

G

This 5 page Google Data Studio template helps you visualize your Google Analytics Goals. The template also provides tips to help you get the most out of Google Data Studio features. Some charts include calculated fields, analytical functions, optional metrics, conditional formatting and sort features.   Open in a new window Let us have a look at the icons used in this template before we...

How to visualize a goal flow segment in Google Data Studio?

H

This post shows how to visualize a goal flow segment in Google Data Studio. I assume that you have basic knowledge of Data studio’s calculated fields. You can see the visualization in action here. Assume that the page paths for the goal flow are: /step1.html /step2.html /step3.html /step4.html Step I: Create custom field Now create a custom field with the below formula (replace the page...

Google Data Studio Dashboard for Web Analytics – Free

G

This Free 16 page Google Data Studio Template for Web Analytics consists of 16 pages. The data sources are: Google Analytics (with Adwords linked to Google Analytics) Google Search Console CLICK HERE TO GET THE TEMPLATE If you would rather have a customized data studio report, I can create one with Analytical functions (% of total etc.), Calculated fields (simple Math, Aggregation, CASE...

How to Give Consultants access to Google Data Studio and Data Sources?

H

Let us first look at two of the common methods of getting a Data Studio report built and why they are wrong. Wrong Method 1: Consultant creates a ready-to-use template that you copy to your Data Studio account and become the owner. Though sufficient in some cases, it is a generic template that is not tailored to your business. A report that is tailored to your requirements increases the...

How to copy a Google Data Studio Template and become the owner?

H

If you want to copy my free data studio template for web analytics or any other template, follow the below process. Once you copy a template to your Google account, you become the owner and can edit it.   Login to datastudio.google.com using your Google account. Now open the data studio template by pasting the url in the address bar. Click the copy button (two rectangles on the top righ side...

Google Data Studio: User manual for End users

G

This Google Data Studio user manual shows you how to use a Google Data Studio Report. This manual does not show you how to build reports but is written for end users. Navigate report pages Method 1: Click on previous(<) or next(>) icons to navigate Method 2: Click the current page name to see a list of all page. Click on the page you want to jump to. Rename a report You have copied a report...

I share practical knowledge that I have gained as a Google Data Studio freelancer since 2017. Subscribe for Google Data Studio Templates, Tutorial and Tips.
Sasi - DataSasi.com