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
Two Octobers became B-Corp certified in July 2020. Learn a little about how we got there.
A college student asked, “Do young people click on search ads?” We analyze the likelihood of clicking on ads by age.
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
Two Octobers was at NATCHCOM last week, the premier (and only?) digital marketing conference for natural brands. I got a chance to share some ideas about metrics and marketing strategy, but mostly it was a chance for me to listen and learn. First impression? I loved it! As an enthusiastic athlete, vegetarian and eater of
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
And additional focus on an old direction. When Kris Skavish and I started Two Octobers in 2010, we shared a vision of a collaborative team of smart, analytical marketers who enjoy helping businesses grow. We wanted to create a no-nonsense culture where results are valued over BS, and everyone is treated with respect. I say
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.
I’m leading the Denver Google Analytics Meetup tonight, and we’re going to be talking about dashboards. Sharing a summary here for the Meetup, and anyone else who wants to get started with dashboards. At the bottom of the post there are links to some great template dashboards, free for download in the Google Analytics Solutions
Thank you to everyone who attended my Denver Startup Week presentation on How to get the most out of Google Analytics! Here is a PDF of the presentation: DSW-GA-2017 Drop us a line if you’ve got questions or comments!
I’m presenting at the Denver Google Analytics Meetup tonight, and put together this cheat sheet on setting up Google Analytics event tracking in Google Tag Manager. Here’s a PDF version, and the image below links to a PNG version.
If you work with Google Analytics (GA), Google Tag Manager (GTM), and have lots of clients, you have probably run into this problem: you manage tags with GTM, but the client has the Google Analytics PageView tag placed directly on a subset of site pages. This problem is especially common on sites that span multiple
