How I think (the blog)

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 into Google search for some reason (other than the page not being indexed or having the noarchive tag), use this URL: If you want the text version of the cache, add &strip=1 to the end like so: 

Python for beginners quick start (republished from Udemy)

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

OAP.Ninja – A fun SEO test to challenge your skills

Disclaimer: If you’re looking for clues, they aren’t here 🙂 Keep trying! Most SEOs could use a bit of stimulation every now and again, and I don’t mean losing valuable hair because Google decides to change the internet every couple of months. Dean Cruddace, from created a fantastic, and challenging SEO test for anyone who

Functions that are easier in Google spreadsheets vs Excel

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

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

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

Scroll to Top