Name change monitor
This post explains @monitorname – a Twitter bot which tracks accounts and notifies you when they change their profile name or display picture.
How do I make my site rank for a keyword
This post is a duplicate of my post on distilled.net and it is canonicalised to that address. In my experience, the most common reasons a website doesn’t rank for a specific keyword are: The site isn’t actually relevant There isn’t any single page which actually uses that keyword There are too many pages which use that keyword.
2019 UK party manifesto word clouds
Word clouds from the 2019 UK political party manifestos, generated using this python code. I leant heavily on this excelled word cloud library from Andreas Mueller.
Good Place Word Clouds
I am a huge fan of the Good Place so I created these Good Place word clouds specific to each of the core “team cockroach”. Zoom in to find phrases or words you recognise from the show. I’ll follow up with more detail about how these were created but I used scripts from the show, …
How to fix broken or redirecting links
As I said in my post about why we should fix broken or redirecting links – even though broken links and redirects aren’t ideal, we can’t hope to get rid of all redirects or broken links, as with anything in business, we need to prioritise what will have the biggest impact. We need to find …
Why Melt (unpivot) is the most powerful function in Pandas
Pandas is a Python library that lets us do Excel-type-stuff. Well, that’s not really giving it the credit it deserves. Pandas is a Python library which makes Excel-type stuff waaaaaaaaaaaaaaaaaay easier. You might have seen me speak about how Jupyter Notebooks can make our lives easier as marketers (if not – you’ve clearly been missing …
Why Melt (unpivot) is the most powerful function in Pandas Read More »
Why should I fix my site links?
If you feel like you already have a good understanding of why you should fix broken or redirecting links on your site and just want to get fixing, go to my post here which shares a free Google Colab notebook which will help identify and prioritise problems for you with some easy and dev-readable Excel …
How to Do Change Detection with Screaming Frog and Google Sheets
I made a Google Sheet that does change detection for you based on two Screaming Frog crawls. I’ll tell you why that’s important. Two problems frequently come up for SEOs, regardless of if we’re in-house or external. Knowing when someone else has made key changes to the site Keeping a record of specific changes we made to the site, and when. …
How to Do Change Detection with Screaming Frog and Google Sheets Read More »
How to Check Your Site Speed: 5 Things You Need to Know About the Google User Experience Report
This is a copy of a post at distilled.net and is canonicalised there. You’ve done your keyword research, your site architecture is clear and easy to navigate, and you’re giving users really obvious signals about how and why they should convert. But for some reason, conversion rates are the lowest they’ve ever been, and your …
Tips for social media competitor analysis: Let’s stop talking about follower count
This is a copy of a blog post on distilled.net and is canonicalised there. This year, Hootsuite announced that 3.196 billion people are now active social media users. That is 42% of all the people on earth. In the UK, that percentage climbs to 66% and it’s 71% in the US. Even with recent data protection scandals, platforms …
Tips for social media competitor analysis: Let’s stop talking about follower count Read More »