Category Archives: Google Data Studio

Data Sources in Google Data Studio – Tutorial

What is a data source in Google Data Studio? A data source is a Data Studio file that is used to define how a connector should provide data from a specific data set to the report(s) in Data Studio.  You create a data source for a specific data set....

Data Source Fields in Google Data Studio – Tutorial

A data source is made up of a set of fields called data source fields. You see these fields when you create and configure your data source in Google Data Studio: Connectors provide fields from a data set to a data source.  Some connectors (like the...

Field editing in reports – Google Data Studio

When you create/edit a data source file in Google Data Studio, you get the option to change ‘Field Editing in Reports’ setting via the data source editor:   Use this setting to allow or stop report editors from changing data source field def...

Dimensions and metrics in Google Data Studio

A dimension is the attribute of visitors to your website. It is used to describe or categorize your data. For example, let’s say a man aged between 25-34 from London visited your website after clicking on an organic search listing on Google which h...

Data Source Version History in Google Data Studio

When you create/edit a data source file in Google Data Studio, you get the option to view or restore previous versions of the data source via the clock icon on the data source editor: Use this setting to view and/or restore previous versions of the d...

Community Visualization Access in Google Data Studio

When you create/edit a data source file in Google Data Studio, you get the option to change the ‘community visualization access’ setting via the data source editor: Use this setting to allow or prevent community visualizations (charts created by ...

How to use Google Data Studio in another language

Google Data Studio is available in 37 languages and supports number, date, and time formats in those languages. To use Data Studio in the language of your choice, follow the steps below: Step-1: Login to your Google account and then navigate to ‘Da...

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 data studio: Step-4: Click on the ‘Create’ butt...

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

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

How to extract data from Facebook Ads into Google Sheets

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

How to extract data from Google Ads into Google Sheets

Pulling data from Google Ads into Google Sheets is similar to pulling data from Google Analytics into Google Sheets. Make sure you have installed the Supermetrics for Google Sheets add-on before you continue. Follow the steps below: Step-1: Before yo...

How to extract data from Google Analytics into Google Sheets

Before you pull data into Google Sheets from any data source, you should first figure out the overall layout and format of how your data table should look like in the Google Sheets. It’s like creating a wireframe before you actually start designing...

How to use Supermetrics for Google Sheets Add-on

If you want to pull just Google Analytics data into Google Sheets then you can do that by installing and using the Google Analytics Spreadsheet add-on (developed by Google) or by using the Supermetrics for Google Sheets add-on. I use and recommend t...

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...

error: Alert: Content is protected !!