How to download all attachments from a gmail thread

You may have several attachments within a Gmail email thread, but it’s too time consuming to download one attachment at a time. There’s a Forward All option in the top nav menu that allows you to forward the thread back to yourself, thus allowing you to conveniently download all attachments in a gmail thread.  See […]

How to get Google’s cached copy of a page and text version with parameters

If you can’t get the cached version the good old fashioned way by typing cache:www.example.com into Google search for some reason (other than the page not being indexed or having the noarchive tag), use this URL: https://webcache.googleusercontent.com/search?q=cache:https://www.example.com If you want the text version of the cache, add &strip=1 to the end like so: https://webcache.googleusercontent.com/search?q=cache:https://www.example.com&strip=1 

Python for beginners quick start (republished from Udemy)

beginner python tutorial

Epilogue Python is one of the most popular programming languages today, probably because it’s very easy to learn. This tutorial will give you a short introduction into the language and its core concepts, teaching you the basics about how Python works. The best way to learn a programming language is to pick a project you […]

How to combine server logs (all files) using Windows command prompt

For SEO purposes, we typically have to analyze server logs to understand what the heck robots are actually doing on our site – sometimes, you’ll get a bunch of individual files from your hosting company, which makes getting all of the data needlessly laborious. For those of you Windows fans, this is how you can […]

Functions that are easier in Google spreadsheets vs Excel

google drive google docs spreadsheets

There are quite a few functions I find much easier to use in Google docs, which I plan on detailing in this ongoing post. If you know of any cool / easier to use functions in Google docs vs Excel, please leave them in the commments and I’ll add them to the list. Let’s get […]

Where to find good datasets online – Quick list

dataset sources

Whether you’re looking for data for your high school statistics class, creating an infographic, or just generally interested in reading Census results before bedtime, here’s a decent list of sources online. Some datasets are completely free, some aren’t – I can’t guarantee the quality of the data, but I’ve cut down the list to the […]

Cross domain canonicals from Blogspot blog

blogger blogspot canonical

Disclaimer: I think Blogspot / blogger is a piece of cr*p. I don’t blame you for having a blogspot blog, but now that you’ve had to Google around to find a cross domain canonical fix, you know exactly how bad it is. For the love of {insert your preferred deity here}, DO NOT HOST ANYTHING […]

Google Language & Country code reference sheet

This post is in addition to my previous post on Distilled and simply provides an online Google Docs version of Google CCTLDs and language codes used by Google. If you see any errors, please let me know in the comments and I’ll happily credit you with a link 🙂 The sheet URL is here.  

Count characters in a cell without spaces – Excel & Google docs

By using =Len() you’re going to return the character count including spaces by default. Example: =len(“hey there”) This formula will return 9, this is because there’s a space between “hey” and “there”. Here’s the formula to get character count without spaces: =len(SUBSTITUTE(“hey there”,” “,””)) This will return: 8 How does this work? By nesting the […]

Internal 301 to homepage treated as 404 by Google

Back in May 2013, during a Webmaster central hangout with John Mueller, John confirmed that Google treats internal 301’s to the homepage as 404’s. That should mean that if you 301 internal pages to the root, they won’t pass PageRank. However, this can still be interpreted incorrectly as there are many questions that remained unanswered. […]