If you are thinking about buying keyword mapping Add-on, I’m pretty sure that you know basics of On-Page SEO.
I can cut the crap and shoot all the answers but if that’s too advance for you, I have covered another in-depth article that will tell you the importance of Keyword Mapping.
I’m assuming that you already have keywords. Don’t worry if you don’t have them yet. You can use any paid tool from which you can get keywords along with the accurate volume quickly.
Demo: I have used the following parameters to prepare this demo.
Note: Ahrefs.com is my favorite. You can use any of the tools including SEMrush, Ubersuggest, Moz, Majestic, etc. Even keywords from free tools can help you in understanding the keyword mapping add-on.
How to use Keyword Mapping Add-on
It is quite easy to use keyword mapping google sheet add-on. We know that processing thousands of keywords while content planning is a daunting task. This add-on helps in processing a single word per association and gives more freedom, creativity, and clarity.
Remember: It’s all about how you interpret the data presented in the form of keyword mapping. Also, it’s possible that different people create a different content strategy and planning with the same data.
Keep practicing and trying to understand keywords and its intent.
We have to ensure that the list of keywords we are using is the finest list. Keep in mind that your keywords are the raw product and they will decide how useful keyword map this Google Sheet add-on will generate.
Let me start with an example of coffee keyword and you can follow these steps every time. You can modify it according to your convenience.
1. Removing Irrelevant Keywords
When we export keywords from Keyword Research Tools, we do get irrelevant keywords in different forms. We have to scan our keywords manually and identify such irrelevant keywords to make sure that we process the finest list when we use keyword mapping add-on.
Sort Volume column from Z to A
Hide unnecessary columns
Hide or delete columns like Position, URLs, CPC, Last update etc.
Delete duplicate keywords
Your first step must be to delete duplicate keywords. Else your keyword map will be confusing. A similar effect will be found if you don’t delete Typos.
Example: I found “verismo” and “verissimo” in the list. I deleted “verissimo” keyword.
Delete unrelated keywords
- Remove URLs (If any)
- Remove year if it is not part of your focus keywords
- Skim keywords and delete
- Example: 1) I found “what is the best *k” in the list. It doesn’t serve any purpose so remove it. 2)”keurig® my k-cup® universal reusable filter”
- Generate Keyword Map and try to spot errors and remove them
Merge Keyword, Volume and Difficulty for better understanding
You can combine keyword, volume, and difficuly so that when reading Keyword Map you can understand all aspects of that keyword.
=IF(ISBLANK(A2),,(CONCATENATE(A2," ",B2,"|",C2))) where A2=Keywords, B2=Volume, and C2=Difficulty
Generate Keyword Map
Hurrah!! You are ready to create fresh, ultra-useful content for products and services. The kind you know your customers really want.
I would recommended to start with 100-150 keywords only. Fewer keywords ensures that you get meaningful keyword map.
- Group keywords (Focus on weight and size of keywords)
- Identify Keyword variations
- Identify Money Keywords
- Identify synonyms and related terms
- Identify Long-Tail Keywords
- Generate New Keyword Map and Set your focus based on search volume
If you have any doubts, feel free to connect with me. I will try my best to help you with keyword analysis and content strategy using Keyword Mapping Google Sheet Add-on.