Keyword Mapping with URL

The technique of assigning keywords to different pages of your website is known as keyword URL mapping. It’s an important component of the on-page SEO process because it aids search engines in determining the relevancy of a page for specific search intent. It also generates new content concepts. 

Without a keyword URL map to guide your content efforts, you risk confusing search engines and making it difficult for them to determine which of your website pages should be displayed to the person searching.

Here’s how to do keyword mapping

1. Using a keyword tool, create a list of potential keywords.
2. List all of the website’s current pages.
3. Using a keyword research tool, determine the monthly search volume and ranking difficulties.
4. Each page of the website should be given a keyword.

If you want to try your hand at making a keyword map, here’s a step-by-step guide to getting you started.

First, prep the document

You’ll need a new Google Sheets or Excel document for this. Give it the file name “Keyword URL Map” and then the name of your website or company.

After that, go to the bottom of the sheet and rename “Sheet1” to “Keyword URL Map.” Then, by hitting the small ‘+’, create a second tab and label it “Possible Keywords.” “Keyword Volume & Difficulty” should be the third and last tab you create.

Next, build your list of possible keywords

Now that you’ve got everything set up, it’s time to start filling in the details and keywords. List all of the obvious keywords connected with your business and sector on the “Possible Keywords” page. 

What are the simple-to-remember keywords and phrases that customers use when searching for businesses like yours? In your document, make a list of them.

Pull current organic keywords

The next step is to figure out the keywords your website already ranks for. Go to Google Search Console(GSC) to get started. A list of requests over the last three months may be found in the performance section.

There’s an export feature on the right. Export the keywords and put them into the same “Possible Keywords” tab where you were previously working. 

Uncover competitor keywords

To do this, you’ll need an SEO keyword tool. Various tools are available in the market that allows you to plug in a competitor’s website and view a list of terms the site ranks for in the organic keywords area.

I’m also able to see how many keywords they’re attempting to target. Thousands upon thousands of people are involved at times. That is excessive and needless. For our purposes, only the top 200 search words used by a competitor are relevant.

Export the keywords in the same way you did with GSC, and then copy/paste them below the possible keywords you’ve pulled so far.

Find what people are searching

Answering the Public and Google are two of my other favourite methods for finding what people are looking for.

Answer the public is a massive Google search database. These are the terms and phrases that people are searching for. It’s free, and the data may be exported.

You can see all the different ways people are using one of the keywords linked with your business or sector by typing it in. Copy/paste the keyword list into your document once more.

You can also utilise Google to find out what others are looking for. Google’s auto-complete feature is quite useful. Start typing a search query into Google.com, and Google will show you a drop-down list of common search terms. Voila! You’ve come up with a tonne of new keyword and phrase suggestions.

You must manually type the terms into your Keyword Mapping Sheet, unlike the previous instances where you can export the data.

Your file should now have one long column of potential search words. You’ll likely come across certain keyword mentions that are repeated. There’s an easy approach to get rid of duplicates if you’re using Google Sheets. From the toolbar, select ‘Data’ and then ‘Remove Duplicates.’

It’s now time to focus on the information that’s already live on your website.

Make a list of all the pages on your present website

You’ll need a detailed list of all the pages on your website before you can give a keyword to each one. This includes all of your blogs, your contact page, and everything else!

Use free SEO tools easily available on the internet to make this list. It crawls your site by entering your URL. After the crawl, filter the results to see HTML files and ignore image and CSS files to gather the data you need for your keyword map. In the top left corner, change the setting.

Then, export the data to an excel or.csv file so you can access it on your desktop, and copy/paste the first column (without the header) into the first column of the Keyword URL Map sheet.

Then, in your Keyword Mapping sheet, you’ll want to add these columns: 

1. Determine whether the URL refers to a page, a blog post, a portfolio, or something else.
2. Keyword
3. # of Searches
4. Difficulty

This helps you prioritise the keyword mapping process so you can get a good start.

Check the volume, competition, and complexity of keywords

Your keyword mapping document is coming together beautifully, and now it’s time to get to the fun part: determining the keyword’s power.

A keyword is only valuable to you if it has a lot of pulling power and you have a chance of ranking for it. Check this by looking up the number of monthly searches for each of the keywords you’ve listed. Several tools can help you sort it all out.

Copy and paste all of the keywords from the Possible Keywords tab into the Keyword Explorer at once. The number of monthly searches and how difficult or easy it is to rank for that term are displayed. (This is referred to as ‘difficulty.’)

Short-tail keywords (one or two words in a search query) are typically more difficult to rank for than long-tail keywords (three or more phrases in a search query).

Export the list and paste it into the Google Sheet’s Keyword Volume & Difficulty tab.

Adding keywords to each page of a website

Keywords with a high search volume and a low difficulty score are the best. You may choose terms with a lower search volume. It’s easier to achieve your aim if you can get a page to rank well for a term with a low search volume. Lead generation, traffic volume, or a sale are all examples of goals.

Take the keyword and add it to a page in the Keyword URL Map tab, along with the number of searches and keyword difficulty, so you can keep track of it.

Your keyword list is done.

That’s all there is to it! You’ve got a snazzy new keyword map, but it’ll be outdated in a day. Kidding! Kinda. Keyword maps are dynamic documents that must be revisited and updated regularly. 

Create your keyword map.

A simple version of a Keyword URL Map can also be downloaded. Before you start filling in your personal information, make a copy. If you have many websites, you’ll have a clean template to go back to or use again and again.

Additional Readings:

• What is Keyword Mapping?