Search Term Analysis
This project is in 2 parts. If you want to bid for one of the parts then please state this on your bid.
Part 1. Analyze Apache logs
I want a script to download a 1and1 log file every day and find the search terms used to get to my sites. It needs to parse the log to find date, website, search term, and the number of times the search term was used. The data then should be written to a mysql db.
Part 2. Google Keywords
Take the search terms from the mysql db and using Google’s Keyword tool, find the local and global volume of that search term. Write the data back to the db so it will show date, website, search term, frequency, Google local volumes and Google global local volumes.
To avoid being locked out of Google, advise the method used to achieve this e.g. API, IP change etc
