I need a tool, that imports web analytics data from Google Analytics API and analyze them.
It should compare data from two periods of time for:
- Keywords that delivered visitors in the first period, but not in the second, to find lost rankings
- Keyword/URL Combinations that entranceBounceRate, pageviewsPerVisit, avgTimeOnPage, avgTimeOnSite are below a certain threshold
- (Optional) URLs that never became any search traffic (List of all URLs should be imported via [url removed, login to view] parsing/import)
PHP and MySQL should be used