What awaits you:<\/h2>\n\n\n\n- Why is a keyword mapping important?<\/li>
- How do I create a keyword mapping?<\/li>
- Using VLookup in the keyword mapping<\/li>
- Set meta data for the page<\/li>
- Conclusion<\/li><\/ol>\n\n\n\n<\/div>\n\n\n\n
1. Why is a keyword mapping important?<\/h2>\n\n\n\n
The term keyword mapping is for many with a question mark, which is why we first clarify what it is. We are moving here in the onpage optimization<\/strong>. A keyword mapping is a document in which each URL of your website is assigned to a keyword. A URL may of course have several keywords, but a keyword should not be assigned to two different URLs at the same time.<\/strong><\/p>\n\n\n\nTo illustrate it a bit, think of each URL as an island. On the islands are different paths that represent your keywords. An island can have several paths, but a path (keyword) must not be assigned to two different islands (URLs). Because paths usually do not cross water, this is easy to remember. If the keywords were assigned to multiple URLs, keyword cannibalization<\/strong> would occur. Google then no longer knows for which keyword the corresponding URL really ranks, i.e. whether the path to island 1 or island 2 is meant.<\/p>\n\n\n\nKeyword research = keyword mapping?<\/strong>
No, a keyword mapping is not a keyword research! However, keyword research or keyword analysis<\/a> is part of keyword mapping. The research involves a basic search for appropriate keywords for your website. Here you can search for general keywords that are applicable to your website or niche keywords. Always put yourself in the shoes of potential users here. What do I google to find my website? Keyword mapping, on the other hand, goes one step further and assigns the keywords to the corresponding URLs for which they are to be optimized. This is why a thorough keyword mapping is so important. It creates an overview for which keyword the corresponding page should rank and is also an important basis for content creation later on.<\/p>\n\n\n\n<\/p>\n\n\n\n
<\/div>\n\n\n\n2. How do I create a keyword mapping?<\/h2>\n\n\n\n
To create a keyword mapping as clearly as possible, Google Sheets is recommended. Here you can work with the function “VLookup<\/strong>“.
To make the whole thing understandable, let’s work with a fictitious example: The provider “Surfing Abenteuer” wants to optimize its website and creates its keyword mapping after a keyword research. Surfing Abenteuer is a German provider and offers various courses, vacations and equipment related to surfing. The site has many subpages, each with their own URLs. These would be for example:<\/p>\n\n\n\n- https:\/\/surfing-abenteuer.com<\/li>
- https:\/\/surfing-abenteuer\/surfer-notes<\/li>
- https:\/\/surfing-abenteuer\/surfer-beaches<\/li>
- https:\/\/surfing-abenteuer\/surfer-blog<\/li>
- https:\/\/surfing-abenteuer\/surfer-shop<\/li>
- https:\/\/surfing-abenteuer\/surfer-shop\/surfboards<\/li>
- https:\/\/surfing-abenteuer\/surfer-shop\/surf-equipement<\/li><\/ul>\n\n\n\n
In a Google Sheets table, the individual columns are now labeled differently. The best way to do this is to use the following breakdown: page type, click depth, URL, topic, keywords, SV (search volume) and ranking. <\/strong>The whole thing looks like this:<\/p>\n\n\n\n![\"\"](\"https:\/\/weventure.de\/wp-content\/uploads\/2021\/02\/Bild-1-englisch.png\")
Create keyword mapping, screenshot from Google Sheets<\/figcaption><\/figure><\/div>\n\n\nSince subpages are often thematically very similar, you should pay attention and really assign the appropriate keywords to the corresponding URL.
Another important clue is the search volume: pay attention to how many people search for the term on average per month. After all, what good is it to you and your potential customers if you optimize your site for a term that nobody searches for?<\/p>\n\n\n\n
To determine the search volume for a keyword, you can use tools such as the Keyword Planner in Google Ads<\/a>. You can determine the search volume<\/strong> and add it manually in a column next to the keyword. For our example surfing adventure it looks like this:<\/p>\n\n\n\n![\"\"](\"https:\/\/weventure.de\/wp-content\/uploads\/2021\/02\/Bild-2-englisch-1024x483.png\")
Keyword mapping with search volume, screenshot from Google Sheets<\/figcaption><\/figure><\/div>\n\n\nSometimes it is not so easy to compile a large number of keywords – especially if the pages differ only minimally from each other. Often, you quickly run out of ideas for new keywords. That’s why we’ve gathered the 9 best keyword tools<\/a> that can make your keyword mapping easier.<\/p>\n\n\n\n\n\n
1. Why is a keyword mapping important?<\/h2>\n\n\n\n
The term keyword mapping is for many with a question mark, which is why we first clarify what it is. We are moving here in the onpage optimization<\/strong>. A keyword mapping is a document in which each URL of your website is assigned to a keyword. A URL may of course have several keywords, but a keyword should not be assigned to two different URLs at the same time.<\/strong><\/p>\n\n\n\n To illustrate it a bit, think of each URL as an island. On the islands are different paths that represent your keywords. An island can have several paths, but a path (keyword) must not be assigned to two different islands (URLs). Because paths usually do not cross water, this is easy to remember. If the keywords were assigned to multiple URLs, keyword cannibalization<\/strong> would occur. Google then no longer knows for which keyword the corresponding URL really ranks, i.e. whether the path to island 1 or island 2 is meant.<\/p>\n\n\n\n Keyword research = keyword mapping?<\/strong> <\/p>\n\n\n\n To create a keyword mapping as clearly as possible, Google Sheets is recommended. Here you can work with the function “VLookup<\/strong>“. In a Google Sheets table, the individual columns are now labeled differently. The best way to do this is to use the following breakdown: page type, click depth, URL, topic, keywords, SV (search volume) and ranking. <\/strong>The whole thing looks like this:<\/p>\n\n\n Since subpages are often thematically very similar, you should pay attention and really assign the appropriate keywords to the corresponding URL. To determine the search volume for a keyword, you can use tools such as the Keyword Planner in Google Ads<\/a>. You can determine the search volume<\/strong> and add it manually in a column next to the keyword. For our example surfing adventure it looks like this:<\/p>\n\n\n Sometimes it is not so easy to compile a large number of keywords – especially if the pages differ only minimally from each other. Often, you quickly run out of ideas for new keywords. That’s why we’ve gathered the 9 best keyword tools<\/a> that can make your keyword mapping easier.<\/p>\n\n\n\n\n\n
No, a keyword mapping is not a keyword research! However, keyword research or keyword analysis<\/a> is part of keyword mapping. The research involves a basic search for appropriate keywords for your website. Here you can search for general keywords that are applicable to your website or niche keywords. Always put yourself in the shoes of potential users here. What do I google to find my website? Keyword mapping, on the other hand, goes one step further and assigns the keywords to the corresponding URLs for which they are to be optimized. This is why a thorough keyword mapping is so important. It creates an overview for which keyword the corresponding page should rank and is also an important basis for content creation later on.<\/p>\n\n\n\n2. How do I create a keyword mapping?<\/h2>\n\n\n\n
To make the whole thing understandable, let’s work with a fictitious example: The provider “Surfing Abenteuer” wants to optimize its website and creates its keyword mapping after a keyword research. Surfing Abenteuer is a German provider and offers various courses, vacations and equipment related to surfing. The site has many subpages, each with their own URLs. These would be for example:<\/p>\n\n\n\n
Another important clue is the search volume: pay attention to how many people search for the term on average per month. After all, what good is it to you and your potential customers if you optimize your site for a term that nobody searches for?<\/p>\n\n\n\n
![\"\"](\"https:\/\/weventure.de\/wp-content\/uploads\/2021\/02\/interface-3614766_1280-1024x683.png\")
![\"\"](\"https:\/\/weventure.de\/wp-content\/uploads\/2021\/02\/Bildschirmfoto-2021-02-08-um-10.51.07.png\")
![\"\"](\"https:\/\/weventure.de\/wp-content\/uploads\/2021\/02\/Bildschirmfoto-2021-02-18-um-11.34.01.png\")
![\"\"](\"https:\/\/weventure.de\/wp-content\/uploads\/2021\/02\/Bildschirmfoto-2021-02-08-um-10.54.17-Kopie.png\")