As an SEO consultant, I often find myself discussing user experience (UX) with my clients. This is in part because UX factors influence search engine ranking, but mostly because we measure our success in terms of engaged visitors and conversions, as opposed to ranking and clicks. As I discuss UX with a client, I often […]
Improve UX by Quantifying Your Intuition Read More »
Use SERP Features To Rank in Google 97% of Google SERPs (search engine results pages) include rich results like local pack, shopping, in-app-search, knowledge panel, answer box, etc. Businesses need to take note, along with the web developers, content creators, marketers, and SEO specialists they rely on to represent their brand and business online. We
SERP Optimization: Myth of the 10 Blue Links Read More »
Part II – My First Project The problem: automated budget tracking and management My first project with Google Sheets and Google Apps Script (GAS) was to rebuild the campaign budget tracker we use to monitor budget pacing in paid search campaigns. This was the core functionality I had tried to replace first with a
Marketing Automation – a Journey with Google Sheets and Supermetrics – Part II Read More »
At Two Octobers, we are always striving to better understand consumer behavior as it relates to our client’s business goals. The more we understand about how consumers research and make decisions, the more we can sharpen our messaging, offers, and UI interactions. Over the past year, I have been doing a considerable amount of consumer
During Election Years, Where Do People Want to Move? Read More »
Using the Google Merchant Center API, Supermetrics & More By Nico Brooks & Maggie Castle It doesn’t take much to upend a Google Merchant Center (GMC) account. A single recalled product in a feed of thousands could suspend an entire feed. Discrepancies in shipping costs, lost site verification, or expired feeds are also common culprits.
Advanced Reporting & Automation for Google Shopping Read More »
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.
Find and Replace in Google Sheets with regex Read More »