- FALSE tells Excel that the data must match exactly. TRUE would be for a partial match, but in this case, you want the keywords to match each other exactly.
- Make sure to put the $ in the formula to prevent the data from changing as you copy, paste, or drag the formula to other cells in the Current Position column. For example, in cell B3 in the Keyword Plan tab example above, put the formula =VLOOKUP(A3,'Current Position'!$A$1:$B$49995, 2, FALSE) and not the formula =VLOOKUP(A3,'Current Position'!A2:B49996, 2, FALSE). The lookup row needs to change from A2 to A3, and you don't want the range to lookup to change from 'Current Position'!A1:B49995 to 'Current Position'A2:B49996.
You can track changes in positions, progress, gaps in rankings, etc. by periodically updating these rankings. This also allows you to view rankings for all the ways you've categorized your keywords to see if your positions are strong or weak within a given topic or category.
For example, filtering this list by "HDMI" shows that the website ranks for many of vietnam phone number sample the top HDMI terms, but still clearly needs work to rank better for many of them.
cables shows that the site is not in the top 100 for many of the top terms. That suggests that the website may need more SEO, more content, more links, etc. for the "ethernet" terms than for the "HDMI" topic.
image.png
Topics / Categories
Sorting your keywords into related topics and categories is one of the most time-consuming and essential aspects of keyword research. Google is getting better and better at determining the full set of keywords a page deserves to rank for, sometimes even if those keywords don't appear on the page.
Understanding natural language, how documents and concepts relate to each other, what terms typically appear together and when those terms are relevant, understanding “entities” – these are concepts that Google has been working on for a long time. They are the backbone of major updates such as Hummingbird, RankBrain, and BERT. To learn more about these updates and concepts, check out the following resources:
Hummingbird:
Google Hummingbird
Does Hummingbird mean more entity-based search?
RankBrain: