Category Archives: Google Data Studio

How to use Google Data Studio with Google Sheets

  Step-1: Navigate to https://datastudio.google.com/overview Step-2: Click on the ‘Use it for free’ button:   Step-3: Sign in with your Google email and password. You should now see the home page of the data studio:   Step-4: Click...

How to format Google Sheets data for Google Data Studio

Before you upload data from Google Sheets to Google Data Studio, you need to make sure two things: You pulled data correctly into Google Sheets.  The data you pulled into Google Sheets is in the correct format. Because this is going to affect your d...

How to extract data from Excel or CSV file into Google Sheets

In order to pull data from Excel or CSV file into Google Sheets, follow the steps below: Step-1: Navigate to your Google Drive account: https://drive.google.com/drive/my-drive Step-2: Click on the ‘+New’ button on the left-hand side: Step-3: Clic...

Supermetrics Queries for Google Sheets – Tutorial

Table of Contents How to view query information in Google Sheets via Supermetrics Viewing query information via Supermetrics sidebar Viewing query information via a SupermetricsQueries sheet How to modify queries in Google Sheets via Supermetrics Mod...

How to extract data from Google Search Console into Google Sheets

Make sure you have installed the Supermetrics for Google Sheets Add-on before you continue. Pulling the data from Google Search Console into Google Sheets is similar to pulling the data from Google Analytics, Google Ads or Facebook ads into Google Sh...

Google Data Studio Tutorial – 2020

In this Google Data Studio Tutorial you will learn about data sources, data connectors, how to use data studio with Google Sheets...

How to extract data from Facebook Ads into Google Sheets

Make sure you have installed the Supermetrics for Google Sheets Add-on before you continue. Pulling the data from Facebook ads into Google Sheets is similar to pulling the data from Google Analytics or Google Ads into Google Sheets. Follow the steps ...

How to extract data from Google Ads into Google Sheets

Make sure you have installed the Supermetrics for Google Sheets Add-on before you continue. Pulling the data from Google Ads into Google Sheets is similar to pulling the data from Google Analytics into Google Sheets. Follow the steps below to extract...

Google Data Studio Report Tutorial

Learn all about Google Data Studio reports in this easy to understand tutorial. Reports in data studio are used to tell stories with data. Every report you create should have some purpose. The purpose can be to provide actionable insight, give recomm...

Guide to Data Types in Google Data Studio

The data type of a data source field determines the kind of data to expect (in the connected data set) when processing the field.  For example, when the data type of a field is ‘Number’, it tells Data Studio to expect a number when processing th...

Understanding Aggregation in Google Data Studio

In the context of Google Data Studio, aggregation is the process of summarizing tabular data. Tabular data is data that is in the form of a table. Following is an example of tabular data: You can aggregate/summarize tabular data in Google Data Studio...

Geo Data – Country, Region, Latitude, Longitude in Google Data Studio

Google Data Studio provides the Geo data type for geographical data. You see this data type when you create or edit a data source in Data Studio: Use the Geo data type if you want Data Studio to expect a geographic region (like a city, region, countr...

Why You Should Avoid Using Functions and Calculated Fields in Data Studio

The use of functions in calculated fields can greatly increase the load time of your reports in the Data Studio. Even the use of calculated fields themselves can greatly increase the load time of your Data Studio reports. If you want to do any type ...

How to Edit a Calculated Field in Google Data Studio

In order to edit a data source specific calculated field, follow the steps below: Step-1: Navigate to the Data Source Editor. Step-2: Click on the ‘fx’ symbol next to the calculated field you want to edit: Once you clicked on the ‘fx’ symbol,...

Understanding Functions in Google Data Studio

Table of Contents Every function in Data Studio has some purpose Every function in Data Studio has syntax All functions expect one or more parameters Parameters are listed in the syntax All functions return a value Almost all functions have certain r...

Formula Rejection in Google Data Studio

If there is an error in a calculated field formula, you’ll see a warning message, and you won’t be able to save the field. When this happens it means your formula has been rejected by Data Studio: If you are new to using calculated field...

Working with Timezones in Google Sheets and Google Data Studio

Table of Contents How to find out what timezone Google Sheets is using Changing the date format and timezone in Google Sheets Changing the date format and timezone across all Google Sheets Changing the timezone used by Supermetrics Changing the timez...

The Data Set Configuration Error in Google Data Studio

If your data source schema is not set up correctly and you create/refresh a report in Data Studio then your data source is not able to connect to your data set and you see a data set configuration error: Following is an example of a data source schem...

How to work with the Boolean data type in Google Data Studio

If a data field in your data set can have only one of the two possible values: true or false then you should use the Boolean data type while setting up your data source schema. For example, consider the following data set: Here the field ‘Is Revenu...

How to work with the Text data type in Google Data Studio

When you create or edit a data source in Google Data Studio, you get the option to select the data type of the data source field.  One of the data types supported by Google Data Studio is: ‘Text’: Select the ‘Text’ data type, if you want Dat...

error: Alert: Content is protected !!