We are DirectWithHotels Ltd. We boost the performance of our clients' website through our service for a performance-based fee.
We are tracking at least 800 hotel websites through Google Analytics. And every month, we manually log in and generate site performance reports.
Develop an application that extracts Google Analytics Data displays it and generates daily and monthly reports.
To automate the process of reporting through data extraction functionality using Google Analytics' Data Extraction API.
Data Feeds to be extracted from Google Analytics:
1)Visitors & Traffic Sources
# of Visitors
Visitor type (refers to unique and returning visitors)
Date of visit (follows YYYYMMDD format)
Day of visit
# of Bounces (per page)
# of Entrances
# of Exits
Time on page
Time on site
Unique pageviews per page
Total Goal values
The idea is to have a module in the application that logs into Google Analytics and allows us to extract data via XML or CSV to a database. And from the database, displays information in a viewer's module. Displayed data can also be extracted into a spreadsheet (Excel).
The application must also include a drop-down selection of all accounts and websites per account, this will determine the data of which hotel website to display in the viewer's module.
Must be knowledgeable with:
PHP5 (we currently use the Zend Framework)
XML and/or CSV
Google Analytics API