In the first project, we will be building a very simple tool to do some basic keyword research. Just to set the expectations right this is in no way comparable to existing tools like Semrush, Ahref, and all the other sophisticated tools out there but will help you get a feel of what is possible with python and how you can automate many of the time consuming tasks.

Understanding what users are searching for on a platform gives an idea of what people are looking for and hence an opportunity for you to serve the people and answer the questions they are looking for.

Requirements

You need to have a working version of python on your laptop. Instead of repeating the whole topic on how to install python, I will link to some of the tutorials on how to do it step by step

Also, you will need a code editor to write code I prefer using VScode and you can install it here https://code.visualstudio.com/docs/setup/setup-overview and this amazing tutorial by JC https://www.jcchouinard.com/python-with-vscode/

Another alternative if you don't want to install python is to try online tools where you can write python code and test it out (Caveat: Many online tools won't allow you to make external calls without a paid account).

If you are still getting stuck at this point let me know and I can create a video on how to install it locally on your laptop.

Once python is installed you need to install 2 packages by

pip install requests
pip install pandas

Scenario 1:

Let's put on the SEO hat and say you are working on improving the SEO for a niche jewelry business. One thing you could look into is what people are searching for on google, youtube, amazon, Etsy, and Alibaba the most prominent sites with a considerable amount of daily active users. The first thing would be to go on those sites and start typing your target keyword or the industry. As soon as you start typing most of the search engines start auto-suggesting keywords that are based on what people search for on their sites. I have condensed the results for the query jewelry below.