Build App – Google Yahoo Api
Here is how the app works:
Step 1 – Google Keywords API
Make a webpage with a text input box where user can enter a list of “seed keywords”.
On submit, each keyword is sent to the Google Keyword API.
Google’s API will return a variety of similar keywords, with traffic levels and competition levels for each keyword in the list.
Remove any keywords that have competition levels greater than 4 out of 5 (80%).
Remove any keywords that have last month search volume less than 20,000
Save results to a csv file.
Step 2 – Yahoo Site Explorer API
For each keyword in the list above, search in Google.com
Record the URL of the 5 websites in search result positions #1, #2, #3, #9, #10.
For each of those 5 websites, send to Yahoo Site Explorer API.
Find the number of “inlinks” (sites linking to the website) using these parameters:
Look at “inlinks”
Except from this domain (omit_inlinks=domain)
To entire site (entire_site=1)
The results will say how many other sites “inlink” to the site in position #1, #2, #3, etc.
Record the number of inlinks to each of the 5 URLs in the csv file.
If possible, sort the inlinks by Google Page rank. Then get the average Google Page Rank of the first 100 inlinks in the sorted list. Record that average value in the csv file.
Step 3 – Sort Results
Create 3 csv files for the final results:
Good
Medium
Bad
Each keyword needs to be sorted into ‘good’, ‘medium’ or ‘bad’.
Good:
All 5 URLs have number of inlinks less than 1,500
Average PR 1 or less for first 100 inlinks
Medium:
ALL URLs have number of inlinks between 1,500 and 5,000
At least 2 URLs have number of inlinks less than 1,500
Average PR 2 or less for first 100 inlinks
Bad:
Anything not fitting the criteria for ‘good’ or ‘medium’
Step 4 – Master Record
Add ALL records to a master csv file.
Append the records to any existing records. (add new records to end of old records).
The master csv file will contain a history of all records created since the app was created.
LINKS TO GOOGLE API AND YAHOO API ARE IN THE ATTACHED DOC, WITH SCREENSHOTS