Google AnalyticsのデータをAPIで取得
2020-12-09
2020-12-09
Google Analytics Reporting API v4を使用して、アクセス解析レポートデータを取得することができます。
ライブラリをインストールする
```sudo pip install --upgrade google-api-python-client ```
レポートデータを取得する
データを取得するにはbatchGetメソッドを使用します。viewIdはGoogleアナリティクスの管理画面の「管理」→「ビューの設定」→「基本設定」のビューIDから確認することができます。
```from apiclient.discovery import build
from oauth2client.service_account import ServiceAccountCredentials
SCOPES = ['https://www.googleapis.com/auth/analytics.readonly']
KEY_FILE_LOCATION = '<キーのファイル名を置き換えます>'
VIEW_ID = '<VIEW_ID の値を置き換えます>'
def initialize_analyticsreporting():
"""Initializes an Analytics Reporting API V4 service object.
Returns:
An authorized Analytics Reporting API V4 service object.
"""
credentials = ServiceAccountCredentials.from_json_keyfile_name(
KEY_FILE_LOCATION, SCOPES)
# Build the service object.
analytics = build('analyticsreporting', 'v4', credentials=credentials)
return analytics
def get_report(analytics):
"""Queries the Analytics Reporting API V4.
Args:
analytics: An authorized Analytics Reporting API V4 service object.
Returns:
The Analytics Reporting API V4 response.
"""
return analytics.reports().batchGet(
body={
'reportRequests': [
{
'viewId': VIEW_ID,
'dateRanges': [{'startDate': '7daysAgo', 'endDate': 'today'}],
'metrics': [{'expression': 'ga:sessions'}],
'dimensions': [{'name': 'ga:country'}]
}]
}
).execute()
def print_response(response):
"""Parses and prints the Analytics Reporting API V4 response.
Args:
response: An Analytics Reporting API V4 response.
"""
for report in response.get('reports', []):
columnHeader = report.get('columnHeader', {})
dimensionHeaders = columnHeader.get('dimensions', [])
metricHeaders = columnHeader.get('metricHeader', {}).get('metricHeaderEntries', [])
for row in report.get('data', {}).get('rows', []):
dimensions = row.get('dimensions', [])
dateRangeValues = row.get('metrics', [])
for header, dimension in zip(dimensionHeaders, dimensions):
print header + ': ' + dimension
for i, values in enumerate(dateRangeValues):
print 'Date range: ' + str(i)
for metricHeader, value in zip(metricHeaders, values.get('values')):
print metricHeader.get('name') + ': ' + value
def main():
analytics = initialize_analyticsreporting()
response = get_report(analytics)
print_response(response)
if __name__ == '__main__':
main()
```
ユーザーごとのアクティビティデータを取得する
```def get_report(analytics, user_id):
return analytics.userActivity().search(
body={
"viewId": VIEW_ID,
"user": {
"type": "CLIENT_ID",
"userId": clientId
},
"dateRange": {
"startDate": "7daysAgo",
"endDate": "today",
}
}
).execute()
```