Keyword Planner Keyword Generation and Filtering

Keyword Planner Keyword Generation and Filtering

Please understand that each project handed out in this job pays five dollars each.

It takes me between a half hour and an hour to do each report in most cases.

--------------------

1) I would send you a URL and you would look through it and extract 20 to 50 good relevant keywords from the site's obvious content.

2) Then put that list and the URL into the Google Keyword Planner and generate 800 or so keywords. Use the entire United States as the area unless otherwise instructed.

3) Export this list to a spreadsheet and open it in Excel or OpenOffice.

4) Delete the contents of the column with USD in it. The column should remain.

5) Then delete the Competition column completely

6) Then delete the four bogus columns to the right of CPC. Now you have your raw material to copy into the spreadsheet that I will send you. It looks like the picture.

7) Copy everything but the headers into the Rank Sort tab of the supplied spreadsheet. The headers and two sample lines are already there for you. Just copy and paste carefully. Select only the things you are going to copy, no extra cells. Replace the two sample lines with the new data.

Now comes the real work. Sorting through the big list of keywords to find the ones that I am going to think are worth presenting to the client as options, and which ones the client will be impressed with us omitting but irritated if they are included. If the keyword would be used by someone looking for that product or service, then it's good, if not, then it's bad. If you're not sure, put the keyword into Google and see what comes up. If it's the web site in question's competitors, then it's a good keyword, if not, then it's probably not. I have been getting very low accuracy rates with regards to this kind of evaluation and that has been troubling. I'm looking for a few people who want to make a lot of money over the next few months. I've got tons of work for the right person.

8) Sort the keywords into good and bad by marking the Code column with a "1" or an "x".

9) Then do a "Sort" by the Code column to separate the two lists

10) Cut and paste the X keywords into the Unused Keywords tab.

11) Name the file according to the format below and email it to me through both Upwork and positronicdave@GMail using the subject line naming format below.

Notes on File Submission
put the URL in the subject line of your email and the name of the file.

The subject line should read
SEO Keywords for xxxx.com

the file should be called
SEO Keywords for xxxxx.xls

Then you will be done.

You don't need to put anything in any other tabs. That will come later if you pass this test.

I need extremely high accuracy rates that would rival my own or it's not worth outsourcing. Sophisticated understanding of English and American culture required. Ability to look things up to find out if a keyword you don't know is appropriate is absolutely required.

All tasks need to be timed with the number of keywords total recorded. I am trying to create data about the process. The price is fixed but I still want to know how long it took you.

There is more sophisticated work beyond this if you're good.

These jobs will come in 24 hours a day. I will need the work back within 2 hours in most instances. It takes me between a half hour and an hour to do each web site's report myself. Reporting will be via Gmail account and Gchat. If you don't have a gmail account, get one before applying. You will need an Adwords account too so you can access the Keyword Planner.

---

Requirements

Excellent English Language Vocabulary

Ability to look things up on Google to see if the keyword is a match

Familiarity with American culture and business and shopping

Ability to follow written instructions perfectly and without unrequested additions

---

Skills Required

Keywordresearc Seoresearch