How to create a Weekly Users Dashboard in Google Data Studio

How to create a Weekly Users Dashboard in Google Data Studio

In this post I'll be showing how to build a Weekly Users dashboard in Google Data Studio.

The goal is to show how many users visit your website on any day of the week, and at what time of day they visit.

Read more


How to create a Social Media dashboard in Google Data Studio

How to create a Social Media dashboard in Google Data Studio

In this post, I'll be discussing how to create a social media dashboard in Google Data Studio. One of benefits of creating a dashboard in Data Studio is that it can be easily shared or embedded.

It can also be customized to include useful information to help people understand the data.

Read more


Filtering Data using a Geo Map Region in Google Data Studio

Filtering Data using a Geo Map Region in Google Data Studio

In this post I'll show you a simple method for Filtering Data using a Geo Map Region in Google Data Studio.

I'd like to thank Lee Hurst (@Helpfullee) for giving me the idea to try out filtering by using geographic regions.

Below is the Data Studio I reported. It shows users from Canada that visited the Google Merchandise Store.

Read more


Daily Dashboard Template in Google Data Studio

Daily Dashboard template in Google Data Studio

Today I'm sharing a template for a 'Daily Dashboard' in Google Data Studio.

This is the type of Dashboard you can use to check on the daily performance of your website. This example uses Google Analytics data.

Read more


Two Methods for displaying Year on Year Channel Data in Google Data Studio

Two Methods for displaying Year on Year Channel Data in Google Data Studio

In this blog post I'm going to show you two methods for displaying year on year Google Analytics Channel data in Google Data Studio.

The Data Studio report I've created is below.

Read more


How to track Excel file downloads in Google Analytics using Google Tag Manager

How to track Excel file downloads in Google Analytics using Google Tag Manager

In this post I'll show how to setup a tag to track Excel file downloads in Google Analytics.

The first step is to open up your Google Tag Manager container and add a New Tag.

Read more


How to Send Emails using a VBA macro in Excel

How to Send Emails using a VBA macro in Excel

Here is a method for how to send Emails using a VBA macro in Excel. In this post, I won't go through a step by step guide on how sending emails using Excel is possible using macros and VBA options in Microsoft Excel.

This is because the spreadsheet template I would like to share was created for a very specific purpose, and is unlikely to be useful to the average blog reader.

Read more


How to compare Google Analytics Segments by blending data in Google Data Studio

How to compare Google Analytics Segments by blending data in Google Data Studio

In today's post I'm going to show a very simple but effective way of blending data in Google Data Studio.

Rather than blending different data sources, as I've mentioned in a previous post, we're going to be blending three different segments from the same Google Analytics account.

Read more


Geographic Data in Data Studio

Visualizing Geographic Data using Google Data Studio

In this blog post I'll provide some examples of how to visualize Geographic data using Google Data Studio.

Read more


How to Track YouTube video views using Google Tag Manager

How to track YouTube video views using Google Tag Manager

Today I'll be sharing a method to track YouTube video views using Google Tag Manager.

This method is used for tracking embedded YouTube videos on your website.

Read more