Keyword stemming is the process of removing all modifiers of a keyword, including prefix, suffix, and pluralization, until only the root of the word remains. For example, “consulting” and “consultant” would be stemmed to the same root, “consult.” This technique is useful for SEO keyword research because it helps to identify and group similar keywords. …
Pssst… have you heard about Google Search Console’s BigQuery integration?? The thing I enjoy most about SEO is thinking at scale. Working at Postmates was fun because sometimes it’s more appropriate to size opportunities on a logarithmic scale than a linear one. But there is a challenge that comes along with that: opportunities scale logarithmically, …
SEO with the Google Search Console API and Python Read More »
The Google Search Console Fetch and Render Tool is like putting on a pair of Googlebot goggles and looking at your own site through those lenses. If you have a simple website, (WordPress for example) that hasn’t been modified too much, you may not appreciate why this is important. But the more complex your site …
You’ve written some Google Apps Script code and you are ready to Publish your web app. You click “Deploy as web app…” and navigated to the web app URL only to find… This is a simple fix— don’t worry. The problem is that your Google App Script web app code is missing one critical thing: …
You have probably imagined a Google Spreadsheet function that did exactly what you needed it to without messing around with 17 different functions just to get the desired result. Well, you are in luck! Google Spreadsheets supports custom macros written with Google Apps Script for this very reason. If you are familiar with Excel and …
2017 has been a wild year, to say the least. From waking up wondering if closed-mindedness was becoming mainstream to waking up wondering about the likelihood of nuclear war, to waking up in any one of over a dozen countries, there has been something remarkably unstable about 2017 (even for me). But amidst all the …
The three most important things I learned in 2017 Read More »
There is something so fitting about working with URLs in Google Apps Script and Google Spreadsheets. The cloud-based software works in the browser where, indeed, there are a lot of URLs to work with. Google Apps Script’s doPost, doGet, and UrlFetchApp make HTTP requests to URLs easy. Google Spreadsheets has similar functionality with IMPORTXML, IMPORTHTML, IMPORTFEED, and IMPORTDATA. If you work in web analytics, digital marketing, …
Working with URLs in Google Apps Script and Google Sheets Read More »
I’ve been spending a lot of time working with sitemaps lately. They are a critical component of getting sites indexed by search engines and a great way to learn about your competition’s architecture and search strategy. They literally map out the content that your competition is trying to add to search engine indexes and where …
As you know, I love learning, and I am a huge advocate for self-service education. Recently, I had the honor of being interviewed on the Measureschool Youtube channel, where I got to share my path in learning and employing the technical side of digital marketing. We talked about some of the resources I mentioned in the …
As Schema.org JSON-LD usage spreads across the internet and its utility increases, I find myself creating a lot more JSON-LD templates for non-standard entities… and then I find myself copying them over and over for each of their sibling entities. Finally, I decided I had had enough of this and looked to solve this problem …
JSON-LD Bulk Editor and File Generator for Google Sheets Read More »
