Rails / Google Analyticsのデータを使って分析や管理画面のためのグラフをつくる

1
2
3
#Gemfile
gem 'google-api-client'
gem 'signet'

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
#lib/ga_api.rb 

require 'google/api_client'

class GaApi

    KEY_FILE = "#{Rails.root}/certificate/xxxxxxxxxxx.p12"
    ACCOUNT_EMAIL = "[email protected]"
    KEY_SECRET = "xxxxxxxxxxx"
    VIEW_ID = "xxxxxxxxxxx"
    VERSION = "v3"
    CACHED_API_FILE = "#{Rails.root}/certificate/analytics-#{VERSION}.cache"

    def initialize
        @client = Google::APIClient.new(
            application_name: 'xxxxxxxxxxx',
            application_name: '1.0'
        )
    end

    # Cache api file to avoide round-trip
    def api
        analytics = nil
        if File.exists? CACHED_API_FILE
            File.open(CACHED_API_FILE) do |file|
                analytics = Marshal.load(file)
            end
        else
            analytics = @client.discovered_api('analytics', VERSION)
            File.open(CACHED_API_FILE, 'w') do |file|
                Marshal.dump(analytics, file)
            end
        end
        analytics
    end

    def signing_key
        return if @signing_key
        @signing_key = Google::APIClient::KeyUtils.load_from_pkcs12(KEY_FILE, KEY_SECRET)
    end

    def authorize!
        @client.authorization = Signet::OAuth2::Client.new(
                  token_credential_uri: 'https://accounts.google.com/o/oauth2/token',
                  audience: 'https://accounts.google.com/o/oauth2/token',
                  scope: 'https://www.googleapis.com/auth/analytics.readonly',
                  issuer: ACCOUNT_EMAIL,
                  signing_key: signing_key
        )
        @client.authorization.fetch_access_token!
    end

    def get_data(options = {})
    @client.execute(
      api_method: api.data.ga.get,
      parameters: {
        "ids" => "ga:#{VIEW_ID}",
        "start-date" => options[:start_date].to_s,
        "end-date" => options[:end_date].to_s,
        "metrics" => options[:metrics],
        "dimensions" => "ga:year,ga:month,ga:day",
        "sort" => "ga:year,ga:month,ga:day"
      }
    )
    end

end

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
require 'ga_client'

class AdminsController < ApplicationController
  def show
    api = GaApi.new
    api.authorize!
    analytics = api.get_data(
      start_data: 1.month.ago(Date.today),
      end_data: Date.today,
      metrics: "ga:newUsers"
    )
    analytics  = JSON.parse(analytics.response.body)
  end
end

1
2
3
4
5
6
@new_visitor = 

{ "2014-10-05" => 1234 }
{ "2014-10-06" => 1234 }
{ "2014-10-07" => 1234 }

1
2
3
4
5
6
7
8
9
start_date = 1.month.ago(Date.today)
end_date = Date.today
@new_signup = User.where(created_at: [start_date..end_date]).group("DATE(created_at)").count

start_date.upto(end_date).each do |date|
    @new_signup[date] = 0 unless @new_signup.has_key?(date)
end
@new_signup = @new_signup.map { |key, val| [key.strftime('%Y-%m-%d'), val] }
@new_signup.sort!

1
2
3
4
5
6
@new_signup = 

{ "2014-10-05" => 123 }
{ "2014-10-06" => 123 }
{ "2014-10-07" => 123 }

1
gem "chartkick"

1
2
3
4
5
6
7
8
9
<%= javascript_include_tag "//www.google.com/jsapi", "chartkick" %>

<%= line_chart [
    { name: "新規に訪れた", data: @new_visit },
    { name: "登録した", data: @new_signup },
    { name: "自分史を作った", data: @has_timeline },
    { name: "ストーリーを書いた", data: @has_story }
    ]
%>