freesixty 0.1.1

Simple Google Analytics API data extraction.

Freesixty

A simple Google Analytics API data extraction.

Simple example:

1. Install freesixty

pip install freesixty

2. Get data

import freesixty

SCOPES = ['https://www.googleapis.com/auth/analytics.readonly']
KEY_FILE_LOCATION = 'gcp_keyfile.json'
VIEW_ID = 'XXXXXXX'

query = {
    'reportRequests': [
    {
        'viewId': VIEW_ID,
        'dateRanges': [{'startDate': '2009-01-01', 'endDate': '2019-01-05'}],
        'metrics': [{'expression': 'ga:sessions'}],
        'dimensions': [{'name': 'ga:country', 'name': 'ga:date'}]
    }]
}

folder_uri = 'file:///tmp/example/folder'
analytics = freesixty.initialize_analyticsreporting(KEY_FILE_LOCATION)
freesixty.store_query(analytics, query, folder_uri, 'json')

3. Use it

ls /tmp/example/folder

4. Profit

:cake:

Splitting query example

In case a query would return over 100k rows of data it will fail. We can get around it by splitting the date range into smaller chunks. E.g.:

queries = freesixty.split_query(query=query, start_date='2019-01-01', end_date='2019-02-01', freq='D')

for q in queries:
    freesixty.store_query(analytics, query, folder_uri, 'json')