How to build a compact Google Search Console Dashboard in Google Data Studio

How to build a compact Google Search Console Dashboard in Google Data Studio

In this post I'll show you how to make a compact, one page Google Search Console Dashboard using Google Data Studio.

Read more


How to Filter by Email in Google Data Studio

How to Filter by Email in Google Data Studio

In this post I'll be showing you how you can filter by email in Google Data Studio.

This is a new feature, and I'll be giving a simple overview of it and how it works. To learn more about this feature see the official Google notes or this blog post from Wissi Analytics.

Read more


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


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


A Top Content report in Google Data Studio

How to make a Top Content report in Google Data Studio

In this post I'll show you how to make a top content report in Google Data Studio. This report shows you how the top pages on your site perform, based on your choice of sessions, users, page views, bounce rate or average time on page.

Read more


How to Compare Google Analytics segments in Data Studio

How to Compare Google Analytics segments in Data Studio

In this post I'll show you how you can compare Google Analytics segments in Google Data Studio.

In Data Studio we can use CASE statements to create our own segments, but there is also the option to use pre-existing segments that we've created in Google Analytics.

Read more