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.|||Hello
On this page you will get
the requested information!
http://www.excel-spreadsheet.com/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment