Categorise Keywords

Branded & Non-Branded Keywords

Evidence from Google shows that your SEO rankings are affected by the search volume and rankings of Branded and Non-branded keywords.

It is therefore important to track and compare the rankings of your non-branded or generic keywords with your branded keywords.

You can add your branded keywords to your project like this:

branded_KWs.gif

Re-categorise all your keywords in new groups without losing the history in 3 steps

Have you redesigned your site or your tree structure? Are you changing all or part of your product range on your e-commerce site? You want to change a large part of the groups of keywords you have but without losing the potential keyword history? Follow the following 3-step tutorial to reorganise your keyword groups.
 
0: Prerequisite
 
Unclassified: Make sure that you have categorised all your keywords and that none of them are in the default "Uncategorised" group. If this is the case, create a "To be classified" group and move the keywords into this group.
 
Quota of keywords: it is possible that you already consume 100% of the keywords allocated to you. If you wish to add new expressions during the re-organisation, then you may encounter quota problems. In this case, and in order to use the method that will follow, you may have to delete the keywords you no longer want before starting the operation.
 
If you don't add any additional keywords, you have an excess of keywords, or you are just re-organising your groups during the manipulation, it doesn't concern you.
 
1: Export your data and modify your groups in an Excel/CSV file
 
In order to reorganise your keyword groups (without losing the history) you must first download your project's existing SEO module: 
Capture_d_e_cran_2021-04-07_a__12.17.43.png
 
 
You get a CSV file that you can open in Excel and then process to display the data in columns with the ";" separator.
mceclip1.png
 
mceclip2.png
 
 
To rearrange your keywords you can add or remove lines, it doesn't matter in which order you add or remove lines, as long as you keep the first line without renaming it, and that you indicate for each line all the requested information:
Adgroups: name of your group
- Keywords: keywords or expressions
- Engine: Google, Bing ou Yahoo 
Country: fr, en or other (see the list of engines/languages/cities)
Languages : fr, en, etc. (see the list of engines/languages/cities)
Device : desktop, mobile or tablet
City : (see the list of engines/languages/cities)
The file is not case sensitive, you can specify upper or lower case.
 
NB: to have a keyword on desktop AND mobile, or on Google AND Bing, or on London AND Dublin AND Cardiff, it is necessary to create 2 or 3 identical lines by varying this parameter.
 
Caution: to help you find your way around, we advise you to indicate a group of keywords systematically, even "To be categorised later" if you don't know how to categorise it.
 
Once your new groups and keywords have been reorganised, you can export your file in CSV- UTF8 format. The default setting is normally correct. If not, choose a semicolon separator ";".
 
Summary of the operation:
- export in "SEO module" format from your SEO/PPC monitoring
- manage the addition/deletion of groups and keywords in a spreadsheet software: excel (Google Sheet / Open Office / Numbers)
- export to CSV-UTF8 with a ";" separator (semicolon)
 
2: Delete your keyword groups in tracking
 
To re-inject your new keywords and re-organise your account, but without losing the history, you will need to delete all keyword groups from your account.
 
Click on the edit icon and click on "Manage groups".
A pop-up window with your group list appears: 
 
Capture_d_e_cran_2021-04-07_a__12.18.59.png
mceclip4.png
 
 
Hold down ctrl (PC) or cmd (mac) to select multiple groups by clicking on each one. If it concerns all groups, click on the "select all groups" button.
Then click on "Delete" at the bottom of the page.
 
Finally, click on "Finish" to return to your project.
 
3: Import your new file, delete non-categorised keywords
 
The last step is very simple, we will import the CSV file into the account (without having deleted keywords in your project beforehand).
 
Click on "add a keyword".
Click on the tab "CSV download".
Click on "Upload a CSV".
Capture_d_e_cran_2021-04-07_a__12.20.25.png
 
Select on your disk the previously exported CSV file and click on Validate.
 
The analysis of your file is done live to ensure that all lines are valid. In case of an error you can view the details to find out where the problem is coming from. Common errors: forgetting a column, wrong file format, bad handwriting of the city.
 
mceclip6.png
 
Click on "Validate the import" and that's it! You have just re-imported all your keywords with the new groups. 
 
The keywords for which you wanted to keep the history are still present and well arranged in the new categorisation you have just imported (with their history).
The new keywords are calculated live.
Keywords that were no longer in the file are grouped together in the "unclassified" group. 
 
All you have to do is delete the unclassified keywords if you do not wish to keep them.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.