Jenny asks…
How To Sort or Cluster Keyword Phrases in Microsoft Excel Spreadsheet Step By Step?
Having done the keyword research through the Google Adwords Keyword Tool for starting up my first online business, now I have a list of different keyword clusters that I would like to sort out by the searchers’ intentions (problem statements) within an Excel spreadsheet.
For example, I have the following list of different keyword phrases:
how to best feed dogs
how to drill a dog to be a guard dog in the army
how to drill a dog to be a police dog
how to feed a dog
how to make a dog to be a guide to the blind
how to make a dog to be an entertainer
how to prevent dogs from barking
how to stop dog from barking
how to teach a dog to fight a burglar
how to teach a dog to stop barking
how to teach dog to be a guide-dog
how to teach dog to be obedient
how to teach dog to find drugs
how to teach dog to track drugs
how to teach dogs to juggle a ball
how to teach dogs to trace drugs
how to teach dogs tricks
how to train a dog
how to train a dog to be a circus entertainer
how to train a dog to become a drugs detector
how to train a dog to play balls
how to train dog to stop to bark
how to train dogs to fight burglars
how to train dogs to fight criminals
how to train dogs to find drugs
how to train dogs to help protect house
Now, I would like if you could show me step by step how I could sort out or cluster the above mentioned group of different dog related keyword phrases by intention or problem statements that a specific group of keyword phrases have in common.
In other words, I would appreciate it if you could show me step by step how I could get the above mentioned list of different keyword phrases sorted out or clustered through using the Excel spreadsheet (that’s the Excel sort and filter tasks) the way I get precise results exactly showing how many keyword phrases share the intention related to ‘barking dogs,’ how many keyword phrases share the intention related to ‘drugs dogs,’ how many keyword phrases share the intention related to ‘burglar dogs,’ how many keyword phrases share the intention related to ‘balls dogs,’ etc.
Preferably, I would like to sort out different keyword clusters the way each cluster is marked in different color and the way I exactly know how large each cluster is that’s being able to see the exact number of how many similar keyword phrases each cluster has (that’s the number showing next to each keyword phrase colored by and belonging to the same cluster).
In advance many thanks.
scottparat answers:
Hello
On this page you will get
the requested information!
Http://www.excel-spreadsheet.com/
Sandra asks…
How can I find out what is guiding my website visitors searches?
How can I research my web site visitors or prospective ones to find out what seems to be on their minds when they choose this or that keyword or key phrases in their web searches? In other words, is it possible to get some idea of what they really want and what likes or dislikes are guiding them?
Thanks,
David
scottparat answers:
Hi david, while it’s not easy to predict what drives users to search for this or that term, there was an insightful study done by a search expert in IBM who classified search behaviors into 3 types:
1. Informational searches (50% of all searches). User is trying to educate himself on the term, or place.So if the user is searching for “ottoman empire”, “honda fit reviews” or “casablanca”, he will click through multiple sites, and if your site offers informative content, he will click through and might even come back again.
2. Transactional searches (30% of all searches). User is looking for a site to make a transaction – buy, sell, download. So if the searcher types in “cnet downloads”, “amazon books” or “cars ebay”, they are looking to download a file or buy something. Many users will click on till they find the best deal – low price, best quality, quick download speed etc. If your site focuses on transactions, then make sure you offer these great terms.
3. Navigational searches (20% of all searches). The user already has a website in mind and is using the search engine to find this website’s URL. So if the searcher types in “amtrak” wanting to buy a train ticket, he will click only once, on the “amtrak” site only. So if yours is not the site user has in mind, it will not be clicked on.
Keep these search behaviors in mind as you select your keywords, check your traffic logs or your site analytics tools (as the aforementioned google analytics) to see how and why searchers find you, and keyword tools to find keywords and check how they impact your rankings. I use the rank tracker tool for this from seo powersuite software pack.
Powered by Yahoo! Answers
Related posts:
- Keyword Research Question Ruth asks… How can i take decision for niche research...
- Keyword Research Seo Question Steven asks… How do you do competitive analysis in SEO...
- Keyword Research Software Question Mary asks… Overture gives keyword traffic data for Yahoo. Does...
- Keyword Research Question Chris asks… Why is a keyword research important in SEO?...
- Review of Keyword Research Pro The Ultimate Google Keyword Research Tool What can be better than the Google Keyword Research Tool?...
Recent Comments