A number of free online Key Word online tools, collect data about popular searches and can be used an excellent tool to build up information about the interests of your target audience, so that your webpage is as popular as it has the potential to be. Now, imagine that you are unfamiliar with a topic but you have been told to create a website on this unfamiliar topic, and you need to ensure that the website is as relevant as possible to the topic and cuts across the key trends. This is where KeyWord software can help you!
Using the Case Study example of the FLEGT-VPA process in Vietnam, the agreement with the EU that is currently in negotiations, to reduce illegal timber by making sure that any Timber products exported to the EU are made from legal timber, this article will show you how KeyWord software can be a great research tool!
An initial Google Search on your topic, will usually link you to an article which contains some basic search terms. For me, this article below (http://www.fern.org/campaign/forest-law-and-governance/what-flegt-vpa ) gave me a basic introduction to the topic, and alerted me that some of the Key Terms are:
• FLEGT
• VPAs
• Illegal Logging
• EU Forest Law Enforcement
![]() |
Finding Seeding keywords |
![]() |
Ȕbersuggest brings many related Seeding keywords |
![]() |
Long tail keywords of FLEGT |
![]() |
Copy to an Excel database file |
Using the “Select All Keywords” and then the “get” function, you can easily copy and export these suggestions to another file. This helps you to gain an understanding of the topics related to your chosen topic. In order to keep a better record of these related searches, I am going to export these keywords into an Excel file, so that later I can sort the search results.
![]() |
Get to copy all selected keywords |
![]() |
Copy text then paste into Excel |
The next step, was to repeat the same process with similar phrases relating to the FLEGT topic – I collected the KeyWord results for the other KeyWords “Illegal logging”, “EU’s Forest Law Enforcement” and “VPA”.I decided to search for “Voluntary Partnership Agreement” rather than “VPA” because many of the search results for “VPA” were irrelevant.
I exported these results into an excel document, and had a total of 424 results about my topic – and it only took me about 5 minutes! Next, I highlighted all of the search results and used the “Sort & Filter” button to arrange the results alphabetically.
![]() |
Sorting keywords |
This enabled me very easily to see any duplicate results and delete them – I had a total of 313 results. Next I sorted them into different categories, as you can see below:
![]() |
Removing the duplicate keywords |
![]() |
Grouping keywords into categoríe |
For the next stage, I utilised the “Smart Art” function of excel to create the following Hierachy tree:
![]() |
“Smart Art” helps to create the following Hierarchy tree then you can make a website structure |
By Florence -Minh Vu
Great Post..seo audit tool
ReplyDeleteGreat Post..seo audit tool
ReplyDeleteHow to download Google Duo on windows 10
ReplyDeleteGood post it's amazing the knowledge you have in your Niche
ReplyDeletecricfree