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.
Project:
Develop an application that extracts Google Analytics Data displays it and generates daily and monthly reports.
Objective:
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
Region
Continent
City
Country
Direct Traffic
Referring sites
Search engines
Language
Pageviews
# of Bounces (per page)
# of Entrances
# of Exits
Time on page
Time on site
2)Content
Exit pages
Landing pages
Unique pageviews per page
3)Goals
Total Goal values
Goal Values
Goal Completions
Goal Starts
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.
Requirements:
Must have experience with:
- PHP5 (we currently use the Zend Framework)
- MySQL
- XML and/or CSV
- Google Analytics API