BTW009 Automate Statistics Feed from Google Analytics to Website Database

We need some statistical data captured by Google Analytics to be automatically sent to our MS SQL 2005 database, which we use for statistical analysis of our website's performance. Right now, we manually collect the Google Analytics data and insert it into the database using a web form in the back office of our web site. ? The statistics we collect from Google Analytics are: - Absolute unique visitors from the 1st of the month to the current day, and - Page views for /blog/[login to view URL] from the 1st of the month to the current day. Your job is to work out a way to automatically extract this data from Google Analytics on a daily basis, and insert it automatically into the specific fields in our database - for both the absolute unique visitors to the site and the page views for /blog/wineloversblog.cfm. The data must update on a daily basis during a month, and then be frozen for previous months. ? Once you have worked out how to do it, your job is also to implement this work - automating this statistical data collection from Google Analytics and inserting directly into our database. ## Deliverables Please see attached PDF document for more details on this project.