I need a skilled research assistant who is familiar with doing SEO keyword research. I currently have 3 travel sites that I need article ideas for, based on key SEO numbers.
Attached is a tab separated spreadsheet with the initial keyword research I've done. I'm looking for Restaurants, Hotels, Attractions, Theatres, Museums, Things To Do, Transportation, Bars/Nightlife, Shopping, Golf, and anything else an incoming traveler would want to know about.
You are to continue filling out keyword ideas, until EACH location has a total of 225 keywords. As you'll notice, I've already given you a very good start. A keyword qualifies if...
1) it's something in that location, if it's not in that location (ex. it's an attraction in the state, but not necessarily in that city) then it doesn't count
2) it must receive at a minimum of 1,000 EXACT match searches in Google. Input all of the keywords you provide here [url removed, login to view] and select Exact match (NOT Broad), and see if each keyword gets at least 1,000 global searches per month
3) it CAN'T be a variation of another keyword. For example, you can't use dallas airport, dallas airports, dallas texas airport etc. That only counts as ONE keyword.
Visit other travel sites, use your own keyword research abilities, and find key phrases that would make great articles to write about.
In your PM, it would be a good idea to show your extensive ability to complete this task.