{"id":13626,"date":"2022-05-19T13:59:35","date_gmt":"2022-05-19T13:59:35","guid":{"rendered":"https:\/\/www.searchenginejournal.com\/python-seo-striking-distance\/423009\/"},"modified":"2022-05-19T13:59:35","modified_gmt":"2022-05-19T13:59:35","slug":"using-python-streamlit-to-find-striking-distance-keyword-opportunities-via-sejournal-leefootseo","status":"publish","type":"post","link":"https:\/\/marketingnewsbox.com\/?p=13626","title":{"rendered":"Using Python + Streamlit To Find Striking Distance Keyword Opportunities via @sejournal, @LeeFootSEO"},"content":{"rendered":"

Python is an excellent tool to automate repetitive tasks as well as gain additional insights into data.<\/p>\n

In this article, you\u2019ll learn how to build a tool to check which keywords are close to ranking in positions one to three and advises whether there is an opportunity to naturally work those keywords into the page.<\/p>\n

It\u2019s perfect for Python beginners and pros alike and is a great introduction to using Python for SEO<\/a>.<\/p>\n

If you\u2019d just like to get stuck in there\u2019s a handy Streamlit app<\/a> available for the code. This is simple to use and requires no coding experience.<\/p>\n

There\u2019s also a Google Colaboratory Sheet<\/a> if you\u2019d like to poke around with the code. If you can crawl a website, you can use this script!<\/p>\n

Here\u2019s an example of what we\u2019ll be making today:<\/p>\n

\"AnScreenshot from Microsoft Excel, October 2021<\/em><\/span>\"An<\/div>\n

These keywords are found in the page title and H1, but not<\/strong> in the copy. Adding these keywords naturally to the existing copy would be an easy way to increase relevancy for these keywords.<\/p>\n

By taking the hint from search engines and naturally including any missing keywords a site already ranks for, we increase the confidence of search engines to rank those keywords higher in the SERPs.<\/p>\n

This report can be created manually, but it\u2019s pretty time-consuming.<\/p>\n

So, we\u2019re going to automate the process using a Python SEO script.<\/p>\n

Preview Of The Output<\/h2>\n

This is a sample of what the final output will look like after running the report:<\/p>\n

\"ExcelScreenshot from Microsoft Excel, October 2021<\/em><\/span>\"Excel<\/div>\n

The final output takes the top five opportunities by search volume for each page and neatly lays each one horizontally along with the estimated search volume.<\/p>\n

It also shows the total search volume of all keywords a page has within striking distance, as well as the total number of keywords within reach.<\/p>\n

The top five keywords by search volume are then checked to see if they are found in the title, H1, or copy, then flagged TRUE or FALSE.<\/p>\n

This is great for finding quick wins! Just add the missing keyword naturally into the page copy, title, or H1.<\/p>\n

Getting Started<\/h2>\n

The setup is fairly straightforward. We just need a crawl of the site (ideally with a custom extraction for the copy you\u2019d like to check), and an exported file of all keywords a site ranks for.<\/p>\n

This post will walk you through the setup, the code, and will link to a Google Colaboratory sheet if you just want to get stuck in without coding it yourself.<\/p>\n

To get started you will need:<\/p>\n

We\u2019ve named this the Striking Distance Report as it flags keywords that are easily within striking distance.<\/p>\n

(We have defined striking distance as keywords that rank in positions four to 20, but have made this a configurable option in case you would like to define your own parameters.)<\/p>\n

Striking Distance SEO Report: Getting Started<\/h2>\n

1. Crawl The Target Website<\/h3>\n