Hi What you will need: - For this project you will need to be able to use the Adwords Keyword Tool API. What the project involves: - Gathering a large (50,000+) list of keywords beginning with the term 'how to'. Here are the steps you need to follow: - Open the attached zip file containing a list of verbs. - The Keywords Tool settings need to be set to English Speaking, United States, include adult content in keywords, broad match. - I need the following 3 columns - keyword, estimated average cpc in $, global monthly search volume. - Keywords are to be collected for the term 'how to + verb', i.e. from the verb list - how to acquire, how to add, how to address etc through to 'how to write a business plan'. Each pass should gather about 150 words (as if you were using the Adwords interface). - Once that is finished, repeat for all the verbs, but add an 'a' to the end, i.e. how to aquire a, how to add a, how to address a, etc. - Remove all duplicates. - Sort by global monthly search volume. - Export to CSV file. Note: - I had a previous coder try this and they said they didn't have enough IP addresses to finish it. So I suggest you make sure you have at least 2. - alternatively, slow down the rate of API calls so you don't trigger google to block you. To win this bid: a) send me the first 1000 keywords in CSV format from the list to show me you can do this. b) Lowest bidder to satisfy (a) with a 9+ rating will win. Please include any API fees/charges in your bid. Look forward to working with you Max
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Microsoft excel, mysql database.