I need to find niche products which pay high dividends through Google Adsense, yet have relatively little competition. I also need a list of long tail keywords associated with each subject. Please include in your bid the cost per subject, including 70 long tail keywords. Detailed instructions for doing this are below. This project takes very little time – a few minutes per subject, once you have your system set up, however the keyword rankings must be tracked over some months. This is an ongoing small project and I can use up to 30 subjects and their related keywords per month.
Start with keyword lists from adsenseheaven dot com which guesstimates the most expensive keywords to bid on in the PPC AdWords side of the Google ad world. Ignore the top 1000, as they are very competitive.
Store this data every month in a mySQL database with the previous months data, and over time see which phrases are consistently in the lists and unlikely to disappear. These are called the long term performers.
Cross check each phrase with the number of pages currently indexed in google, to see how much competition there is for a each key phrase. The pages with the less competition for the phrase are the best.
Cross check each phrase with google trends data which has an RSS feed. Collect and store this data in a separate SQL database hourly.
If an adsenseheaven keyphrase is found to appear in the Google trends history database, it's flagged as hot. If there's less than a million indexed pages it's further flagged as a top candidate.
Once a month after the new list is released analyze the data after it's been processed and I pick a shortlist of hot key phrases for that subject.
As an example, one top phrase and subject found this way is 'Acai Berry'.
Find long tail keywords for the selected phrase to use as subjects for articles written about the main subject. One place to find the long tail keywords is [url removed, login to view], another is the google keyword tool. Find the top 70 results for the main subject.
Correction: I need 40 subjects and their long tail keywords per month.