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
It is with great pride and joy that I announce: Several weeks ago, we received confirmation that we have met all of the requirements necessary to become a Certified B Corporation™. B Corps are for-profit companies that use the power of business to build a more inclusive and sustainable economy. Becoming a B Corp means
Analyzing Search Ad CTRs by Age I teach search engine marketing at a local university, and I love hearing the perspective of young people on trends in digital marketing. One question that has come up in more than one class is, “do people really click on search ads?” When we discuss this, there has been
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!
