Google Analytics input plugin for Embulk

Embulk input plugin for Google Analytics reports.

Configuration

json_key_content: See example config.
view_id: View ID for target data. See Get View ID (string, required)
time_series: Only ga:dateHour or ga:date (string, required)
dimensions: Target dimensions (array, default: [] )
metrics: Target metrics (array, default: [] )
start_date: Target report start date. Valid format is "YYYY-MM-DD". (string, default: 7 days ago)
end_date: Target report end date. Valid format is "YYYY-MM-DD". (string, default: 1 day ago)
incremental: true for generate "config_diff" with embulk run -c config.diff (bool, default: true)
last_record_time: Ignore fetched records until this time. Mainly for incremental:true. (string, default: nil)
retry_limit: Try to retry this times (integer, default: 5)
retry_initial_wait_sec: Wait seconds for exponential backoff initial value (integer, default: 2)

New update from verions 0.1.18

Started from version 0.1.18, the Plugin also supports User Account Authentication along with Service Account Authentication see: OAuth 2.0 for Server-side Web Application. Extra optional configuration keys were added and the json_key_content is made optional

client_id: client_id for application (string, optional)
client_secret: client_secret for application (string, optional)
refresh_token: the refresh_token obtained during exchange authentication code (string, optional)

Get View ID

Go to the Google Analytics sign in page and sign in.
Click "Admin" tab at left below
Select the "Property" using the drop-down menu below ‘Property’.
Select ‘View Settings’ beneath ‘View’.
The View ID for the selected property is listed first under ‘Basic Settings

About `json_key_content` option.

You need a service account on Google.

Open the Service accounts page. If prompted, select a project.
Click Create service account.
In the Create service account window, type a name for the service account, and select Furnish a new private key. If you want to grant Google Apps domain-wide authority to the service account, also select Enable Google Apps Domain-wide Delegation. Then click Create.

From: https://developers.google.com/identity/protocols/OAuth2ServiceAccount

Screenshot: Service Account

Why the result doesn't match with web interface?

Google Reporting API uses "sampling" data.

That means sometimes result will be unmatched with Google Analytics web interface, and the result is based on sampled data, not all of raw data. This is a Google API's limitation.

Currently a sampling level supported by this plugin is DEFAULT only. Let us know if you want to use other sampling level (SMALL or LARGE).

Example

in:
  type: google_analytics
  json_key_content: |
    {
      "type": "service_account",
      "project_id": "....",
      "private_key_id": "....",
      "private_key": "-----BEGIN PRIVATE KEY-----\n..........................\n-----END PRIVATE KEY-----\n",
      "client_email": ".....",
      "client_id": ".........",
      "auth_uri": "https://accounts.google.com/o/oauth2/auth",
      "token_uri": "https://accounts.google.com/o/oauth2/token",
      "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
      "client_x509_cert_url": ".........."
    }
  view_id: 123111111
  time_series: "ga:dateHour" # hourly basis

  # https://developers.google.com/analytics/devguides/reporting/core/dimsmets
  dimensions:
    - "ga:browser"
  metrics:
    - "ga:visits"
    - "ga:pageviews"

  start_date: "2016-06-27"
  end_date: "2016-06-28"

Config example using User Authentication

 in:
  type: google_analytics
  client_id: "#############apps.googleusercontent.com"
  client_secret: "##############QLxgrfis4"
  refresh_token: "##########awWNT9lTeGq8weKE"
  view_id: 123111111
  time_series: "ga:dateHour" # hourly basis
  dimensions:
    - "ga:browser"
  metrics:
    - "ga:visits"
    - "ga:pageviews"

  start_date: "2016-06-27"
  end_date: "2016-06-28"

Build

$ rake