Finding Golden Keywords with Python in 5 minutes

Learn how to identify lower competition level but higher search volume for next keyword strategy in 2023

Are you struggling with budget-sucking keywords?

You are not alone.

Reviewing thousands of keywords’ performance can be intimidating, tedious and futile. The 80–20 rule, which is also called “ the Pareto Principle”, implies that only 80% of your revenue come from 20% of your keywords.

How can you outrank your competitor? Maximizing your strategy efficiency by digging 20% top-performing keywords is the key.

Big industries dominates popular, short-length keywords. That basically eliminates your chances of ranking for them.

In order to outrank fast, bidding those longer tail keywords can improve both paid search and Search Engine Optimization. However, hunting long-term keywords takes hours.

Thanks to the Google Ad Planner, we can download a list of keywords in a finger tips. Thanks to the powerful library of Pandas, we can clean and process the data, exclude the outliners, and use heatmap to find the golden keywords with high search volume but lower competition index.

The valentine day is approaching fast.

Perhaps a more rewarding way is to find a list of relevant keywords for your Valentine campaign as well as enrich your current keyword bank.