Msg#: 3725536 posted 9:56 am on Aug 18, 2008 (gmt 0)
I've found Google Trends very useful my method was to find a relevant keyphrase with a low but non-zero scale value then always use this as the first in a list of keyphrases I'm interested in. On a Google Search I've searched for the phrase with " " round and got a count of the number of competing pages for each keyphrase. I have some exported Wordtracker results for certain phrases that I'm used to using with KEI values. With some simple maths in Excel I've converted the Scale from Google Trends into an equivalent KEI value. Its quite time consuming for a long list of keyphrases to look them all up in Google Trends then in Find the count in Google for the "phrase" in speachmarks. Is there a useful site or tool out there that will allow me to put a long list of perhaps between 100 and 2500 in at a time and run them through getting both the Google Trends Count relative to a certaing keyphrase and then also getting the Google number of competing pages for the keyphrase in speachmarks and produce a list I can easily import into a spreadsheet. The trouble with Wordtracker is that most of the keyphrases that I'm coming up with that have a scale in Google Trends when tried in "Keyword Universe" in Wordtracker then paste them all into Keyword Popularity they are not coming up with any count so can't be analyzed to produce a KEI in this way.