Custom Segments can help break down your existing traffic to give you a more relevant view of your data. In this video we take a closer look at how Advanced Segments can help you turn your data into insights. Advertisements
How to do Index Match in Excel: The basics. Watch this video tutorial to find out how you can use Index & Match for more complex lookup problems. This video shows you how Index Match works with simple and to the point explanation. It first shows you […]
(Video) Measure School of Google Analytics – How to install Autotrack.js Plugin for Google Analytics ?
Autotrack JS is a plugin for Google Analytics that allows you to track events, social interactions and media queries automatically. In this video, you will learn how to install it with the help of Google Tag Manager.
(Video) Learn Microsoft Excel – Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
Find out how to do a VLOOKUP in Excel and for what situations you can use Excel’s Vlookup and Hlookup formulas for. The Excel VLOOKUP formula can search for a specific category or value in an Excel data table and return the “opposing” value from adjacent columns. […]
(Video) Measure School of Google Analytics – How to Use GTM Download Redirects to Track Links, Downloads and Email Clicks ?
Tracking email links, downloads, and others outbound resources accurately can be challenging. In this video, I show you how you do all these with a combination of redirects Google Tag Manager and Google Analytics.
In this video you will learn how to create an interactive dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel 2007 onward for Windows & Excel 2016 onward for Mac.
(Video) Measure School of Google Analytics – How to Track Conversion Values with Google Tag Manager ?
How do we track conversion values and send them over to Google Analytics? In this video, I will share to you two methods of implementing Conversion Value Tracking that work great with Adwords, Facebook and other Conversion Tags.
This beginner’s guide will help you get started using Google Maps to learn about the world and to find the best routes from place to place. Google Maps was updated a couple of years ago and many people haven’t been fully using the new features, so come […]
(Video) Measure School of Google Analytics – How to Use Regular Expressions with Google Tag Manager & Google Analytics ?
Regular Expressions can help you gain flexibility when searching and matching URLs in Google Tag Manager and Google Analytics. In this video, we go through some examples of Regular Expressions and show how you can use them to take your analytic skills to the next level.
In this video I explain how to refresh pivot tables automatically when the source data changes. This solution uses a simple VBA macro and the Worksheet Change event. The Worksheet Change event macro runs every time a change is made to a worksheet. We can use this […]
(Video) Measure School of Google Analytics – How to Use Custom Calculated Metrics with Google Analytics ?
Let’s explore Google Analytic’s newest feature, Calculated Metrics. In this video, we take a look at some of its great uses and show you how you can create your own custom calculated metrics that meet your business or client needs.
This is part 3 in the series on Pivot Tables and Dashboards. In this video we bring it all together to create the interactive dashboard. You will learn how to: Group dates into months and years to create a time series trend chart. Group amounts to create […]
(Video) Measure School of Google Analytics – How to Build Your Own Event Driven Timer Trigger in Google Tag Manager
GTM has a built-in timer that starts when a user enters the page. With this trigger we cannot control when the timer trigger actually starts. In today’s video, I will share with you how to build our own timer trigger that starts based on user’s interaction in […]
Learn the very best Windows 10 (and earlier) features, tips and tricks in this tutorial.
(Video) Measure School of Google Analytics – Google Analytics Dashboard with Google Sheets (Reporting API)
Google Analytics Dashboard and custom Reporting functionality are not always flexible enough. That’s why Digital Analyst prefer to export the data out of GA (via the Reporting API) and manipulate the data in other Tools. In this video, we’ll take a look at how you can accomplish […]
Form submissions are the best way to gather information from your website users and visitors. All information we can get will surely help us with segmentation, retargeting, and analyzing customer groups and preferences. In today’s video, I will teach you one technique to extract data from a […]
Learn how you can quantify the amount of time a user spends on your website before he converts. This metric can provide us valuable data for segmentation, retargeting and analysis. In today’s video, I will teach you techniques on how to set this up in GTM using […]
This is part 2 in the series on an introduction to pivot tables and dashboards. In this video I explain some of the different pivot table calculation types. Learn how to calculate the average, count, sum, and percentage of total. I explain how to update your pivot […]
In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Don’t worry if you have never created a Pivot Table before, I cover the […]