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.
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.
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.
Adding a Facebook Pixel to your website using Google Tag Manager
Facebook's Pixel allows us to target users who have visited our website with adverts on Facebook. In this post I'll run through a method to install it on your website using Google Tag Manager.
I've based my method of installing on the procedure outlined in the excellent Measureschool video below.
How to combine events using a CASE statement in Google Data Studio
Let's say we want to combine certain event completions in Google Data Studio.
We might try and use the same formulas that we use for combining goal completions together into custom metrics.
How to track PDF downloads using Google Tag Manager
What's the best way to track PDF downloads on your website?
I'd recommend using Google Tag Manager to create a custom event, and then tracking the event in Google Analytics.
Example of a Website Visitors Dashboard in Google Data Studio
I wanted to share a Google Data Studio report I created, that is designed as a dashboard that can be checked regularly to see how your website is performing relative to the previous month as well as the previous year.
How to Blend Data in Google Data Studio
In this post I'll give a basic overview of how to blend data in Google Data Studio. Blending data is a very useful feature that will help you combine different data sets for your dashboard.
Below I'll give a basic step by step example of how to combine two different data sources.
How to create Custom Regions in Google Data Studio using CASE statements
The CASE statement in Google Data Studio allows users to create new categories and dimensions.
"CASE statements let you create new fields that use conditional logic to determine the field values. CASE is most often used to create new categories or groupings of data." - Data Studio Help