A handy trick for using google sheets regex File under: anecdotes from my love affair with Google Sheets. If you’ve ever had to consolidate a bunch of messy data into a few stem patterns, read on. I recently found myself needing to consolidate a bunch of Google Analytics page view data into a shortened list.
Part I – Failure and recovery This post is aimed at people who work in marketing and advertising, and are interested in automating tasks to improve quality and efficiency. It describes my recent journey towards achieving these goals. For a little context on my philosophy of automation, check out this post from a few
We are doing a presentation on September 15th for Denver Startup Week. More to follow after the presentation, but here is a link to the Google Presentation: How to get the most out of Google Analytics And here is a description of what we will be presenting on the Denver Startup Week site. The jittery
The Google Analytics assisted conversions report is very helpful for demonstrating which channels or sources indirectly influence conversions on a client’s site, but there are two somewhat confusing aspects to this report. The number of conversions shown by channel or source does not match other Google Analytics reports. Huh? The conversion numbers in the assisted conversions column sometimes exceeds
A quick primer on the nature of the problem One of the most common problems I run into with Google Analytics (GA) occurs when a website uses a 3rd-party shopping cart, booking system or other transactional functionality. These systems often run on another domain, which means a user goes from xyz.com to xyz.shoppingcart.com to
At Two Octobers, one of our core working principles is that collaboration makes work more productive and fun. To get better at it, we brought in some of the fabulous folks at On Your Feet. Here’s a short video capturing the ensuing productivity and fun. Video production, direction and editing: Johan Christanson Muse: Balto
Copyright 2024 Two Octobers® LLC
