Redirect in DOM Plugin
AI prompts at scale
How to prompt at scale using Google Colab
Sistrix API
How to query Sistrix’s API with Google Colab Sistrix is probably one of the most SEO tool in Germany. It has a large database of keywords and rankings which enables the computation of their Search Index (to make it simple: how a URL ranks for a keyword while taking into account the search volume) Sistrix has also an API which can easily be queried. This method show how to do it with Google colab in order to automatise precises request at scale. Let’s dive into the setting: we want to know what are the top 5 URLs ranking per keyword in order to see where we have potential to grow or where we don’t in order to decide if we should focus on this page type or not. So really simple SEO strategy stuff. On top, if we decide to optimise that Page type, we would also have an overview of who our competitors are and so on.
Google Colab
Google colab is a tool offered by Google for free that allows the user to run code on a machine in the cloud. I mainly use it to execute python scripts for daily tasks or have things running while I’m not able to have my computer on. While this sounds like a great deal (it’s free), it has some limitations: With these limitations in mind, it already scales down considerably what it can be used for. While the first limitation can be avoided with a little bit of scripting or an auto clicker, the 12 hours max runtime is a hard limitation. For example, one of my usages of this is having AI prompting done at scale since the execution time is easily around 6 to 8 hours and having it done on a cloud machine avoids a plethora of errors such as crashing the program because I switched to the VPN and the connection got lost… Therefore, depending on the usage rate of the APIs you are requesting, bigger batches might take longer than 12 hours. It is therefore important to slice the dataset accordingly. But let’s get back to a more general overview of Google colab ; especially since I already mentioned the downside, let’s look at the advantages: