Category Archives: Google Data Studio

Understanding Data Source Credentials in Google Data Studio

When you create/edit a data source file in Google Data Studio, you get the option to change data source credentials via the data source editor: Use this setting to determine how data from this data source can be viewed by others.  The default value ...

Understanding Data Freshness in Google Data Studio

When you create/edit a data source file in Google Data Studio, you get the option to change ‘data freshness’ setting via the data source editor: Use this setting to determine how frequently the data source should check for fresh data.    If...

How to Share Data Source with others in Google Data Studio

When you create/edit a data source file in Google Data Studio, you see the ‘Share’ button at the top right hand side of the data source editor: Use the ‘share’ button to share your data source with others.    Follow the steps below: Ste...

How to create and configure a data source in Google Data Studio

Configuring the data source (also known as ‘Data Modeling’) Data modeling consist of customizing your data source fields (dimensions and metrics) so that your reports visualize the data in your desired format. You configure a data source by: Rena...

Guide to Data Source in Google Data Studio

What is a data source in Google Data Studio? A data source is a data studio file which 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....

Guide to Data Source Fields in Google Data Studio

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

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

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 a language of your choice, follow the steps below:   Step-1: Login to your Google account and then navigate to ...

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

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

Guide to Supermetrics queries for Google Sheets

Every time you pull data from a data source, the Supermetrics Google Sheets add-on create and run a query in the background. So if you pulled data from four different data sources (say Google Analytics, Google Ads, Facebook Ads and Google Search Cons...

How to extract data from Google Search Console into Google Sheets

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 Sheets. Make sure you have installed the Supermetrics for Google Sheets add-on before you cont...

How to extract data from Facebook Ads into Google Sheets

Pulling the data from Facebook Ads into Google Sheets is similar to pulling the 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...

How to extract data from Google Ads into Google Sheets

Pulling the data from Google Ads into Google Sheets is similar to pulling the 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: St...

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

error: Alert: Content is protected !!