In this video tutorial, we walk through key building blocks of regular expressions using the incredibly powerful REGEXEXTRACT function in Google Sheets. To follow along, make a copy of this Sheet. Topics covered: Matching characters and sets of characters Using ORs to match multiple things Using escapes to match special characters Matching the beginning and
What do the different account permission levels in Google Analytics (GA) actually mean? Where you can assign them in the GA interface? We’ve got the answers. Google offers four permission levels which you can assign to users individually or as a combination. These four permission levels are: 1) Read & Analyze Users can see report
I promise you there is a gem hiding inside your Google Analytics that will have a real impact on your business. It might be a piece of data whose impact can be felt beyond the website and into the core of your business. It may be something that could drive more visitors to purchase, uncover
You launched your new website, and you celebrated! (As you should! That was a lot of work.) But you’re not done. Your website can get better. You want more leads and sales. And of course, your boss wants marketing driving growth. The key to getting more leads from your website is to always be improving
The world gathers data at an alarming rate – 2.5 quintillion bytes of data every day. We’ve become extremely proficient at collecting data – be it from enterprise systems, documents, social media, or email and collaboration services. Our challenge as marketers is how to use that data well.
This post describes a method for reporting on scroll tracking in Google Analytics. Setting up scroll tracking as an event in GA gives you the ability to see how far people scroll down pages. This data is very useful for identifying content that isn’t performing well, and specifically where you are losing visitors. Until I
With zero coding, a small investment, and a little bit of time, you can create your own BigQuery data warehouse of marketing data. In the video below, I walk through how to set this up using these tools: Google Sheets – if you haven’t switched to Sheets from Excel yet, you are either a VBA
Our business development director, Ray Stein, is presenting on the perfect marketing mix at Denver Startup Week. In his presentation, Ray addresses how to prioritize digital marketing channels, tips for getting the most out of each channel, and where they belong in the customer journey. You can view a PDF of his presentation here.
By: Maggie Castle and Jaimee LaTorra Storytelling transcends industries and is often a focus in business books, conferences, sales trainings, and much more. Storytelling, specifically as it relates to data and analytics, is a routine challenge for digital marketers. Certainly in an agency setting, we’re frequently in a position where we need to explain complex
This post is a write-up from the Google Analytics December 2017 Meetup. It is intended for Google Analytics users who do not have much experience with SEO. How to Set Up Google Search Console in Google Analytics Google Search Console is a toolset that allows webmasters to view a website’s performance in Google organic search.