News

  • Integrate Deepseek into Google Sheets

    Recently, Deepseek launched their own AI chatbot to compete with the giants at ChatGPT. Along with the launch of the chat bot, they also opened up ...
  • Import weather histories into Google Sheets in bulk

    Whether you like it or not, your sales are vulnerable to the elements. No one is going to buy gloves during a heatwave and no one is going to buy shorts during a blizzard. And if the weather takes a turn which impacts your sales, you may need to do some explaining to the boss as to why they're not making money. Alternatively, if your sales are boosted, its important to understand if this is a result of your marketing efforts or just dumb luck.

  • How to fix redirected internal links in bulk in WordPress

    One of the most common pieces of technical SEO advice I hear is to ensure that none of your internal links are redirected. However, the process of ...
  • Extract Google knowledge graph data using Google Sheets

    I created a cool little tool to extract knowledge graph data for any query instantly. Simply enter the query into this Google sheet and click the b...
  • Connect to Dragon Metrics API using Google Sheets

    In May this year, Dragon Metrics announced the release of their latest API. Not only does this allow you to easily export your data to create highl...
  • How Wiggle F****d up their SEO

    As an SEO, I love migrations. The risks are high and the work is extremely hard, but for some reason I find it really interesting. Especially ecomm...
  • Find related entities from Wikipedia

    Understanding entities is now considered an essential skill for any SEO. They allow search engines to easily understand a web page, how it fits in ...
  • Best Trump mugshot SEO memes

    It's only a week late, so we decided to finally get on the bandwagon of creating some SEO memes around the infamous Donald Trump mugshot. So we set...
  • How to visualise your keyword seasonality in Google Sheets

    Understanding the seasonality of your website is important to the success of your not just your SEO campaign but across all of your marketing chann...
  • How to optimise for Google Magi

    You don't.  It's not been released yet. It probably won't even be called Magi when it's released. Why are you even reading this?
  • The most influential people in SEO... as Bobbleheads!

    I've finally jumped on the Midjourney bandwagon as I've seen some beautiful results on social media. One trick I discovered (thanks to Kelvin Newma...
  • Create your own ChatGPT prompt with PHP

    The news is out, yesterday OpenAI released the ChatGPT API. This means that anyone can integrate their models into their own apps and websites. Thi...