Embedded Content Example: The Alien Franchise in Google Data Studio
In this post I wanted to give an example of how you can use embedded content to complement a Google Data Studio report.
In this case I've chosen to focus on the Alien Film Franchise, because why not?
How to embed a YouTube video in Google Data Studio
In this short post, I'll show you how to embed a YouTube video in a Google Data Studio report.
In a follow up blog post, I'll give more examples of embedding external content.
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.
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.
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.
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.
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.
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.
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.
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.