Category Archives: Google Sheets

Working with Timezones in Google Sheets and Google Data Studio

Table of Contents Some interesting facts about working with timezones 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 ...

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

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

Understanding Aggregation in Google Sheets

In the context of Google Sheets, aggregation is the process of summarizing tabular data.  You can aggregate/summarize tabular data in Google sheets by calculating the sum, average, maximum, minimum, median, etc of all the values of a field. Consider...

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

error: Alert: Content is protected !!