How to build a Twitter dashboard in Google Data Studio using IFTTT

How to build a Twitter dashboard in Google Data Studio using IFTTT

A while back I wrote a post about how to build a Twitter dashboard in Google Data Studio. Unfortunately it seems that that version no longer works, or if it does work is very buggy. But I have discovered a new way of getting tweets into Data Studio so figured I'd write a new post about how to do it.

Read more


New Partner Visualizations available in Google Data Studio

New Partner Visualizations available in Google Data Studio

Google Data Studio has recently launched a range of new custom visualizations called Partner Visualizations.

When you click "Community Chart" you will see four community visualizations, as shown below.

Read more


Looking back at all blog posts from 2019

Looking back at all Blog Posts from 2019

Since 2019 is rapidly drawing to a close, I thought I'd a 'Year in Review' type article about all my Blog Posts from 2019.

Read more


How to make a detailed Ecommerce report in Google Data Studio

How to make a detailed Ecommerce report in Google Data Studio

In this post I'll show you how to create some of the different sections of a detailed Ecommerce report in Google Data Studio.

Ecommerce in Google Analytics allows you to monitor the performance of your online business. Google Data Studio allows you to create custom reports that suit your own needs.

Read more


Create Revenue Targets in Google Data Studio using CASE statements

Create Revenue Targets in Google Data Studio using CASE statements

I had been looking for a way to create Revenue Targets in Google Data Studio, and tested out a method using CASE statements that works. So thought I'd share it!

Read more


Use the CONCAT function to create Custom Dimensions in Google Data Studio

Use the CONCAT function to create Custom Dimensions in Google Data Studio

In this post I'll show you how you can use the CONCAT function in Google Data Studio to create Custom Dimensions.

In this case, we can combine multiple different dimensions into one dimension and filter our data accordingly.

Read more


How to analyse sales data using Google BigQuery and Data Studio

How to analyse sales data using Google BigQuery and Data Studio

In this post I'll show you how to analyse sales data using Google BigQuery and Google Data Studio.

According to Google Cloud; "BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in."

Read more


How to make a simple Ecommerce dashboard in Google Data Studio

How to make a simple Ecommerce dashboard in Google Data Studio

In this post I'll show you how to make a simple Ecommerce dashboard in Google Data Studio. This report gives you a quick overview of how your online store is performing.

Read more


How to use Conditional Formatting in Google Data Studio

How to use Conditional Formatting in Google Data Studio

Today I'll take a first look at the recently launched Conditional Formatting in Google Data Studio.

Read more


Create Custom Channel Groupings in Google Data Studio using CASE statements

In this post I'll discuss how to create custom channel groupings in Google Data Studio using CASE statements.

Read more