GA报告API会话和产品关联

pip install google-api-python-client google-auth-oauthlib google-auth-httplib2

from google.oauth2 import service_account
from googleapiclient.discovery import build

# 加载凭据文件
credentials = service_account.Credentials.from_service_account_file(
    'path/to/your/credentials.json',
    scopes=['https://www.googleapis.com/auth/analytics.readonly']
)

# 构建API客户端
analytics = build('analyticsreporting', 'v4', credentials=credentials)

# 定义报告请求
report_request = {
    'viewId': 'YOUR_VIEW_ID',
    'dateRanges': [{'startDate': '30daysAgo', 'endDate': 'today'}],
    'metrics': [{'expression': 'ga:sessions'}, {'expression': 'ga:transactionRevenue'}],
    'dimensions': [{'name': 'ga:sessionID'}, {'name': 'ga:productSku'}],
    'orderBys': [{'fieldName': 'ga:sessions', 'sortOrder': 'DESCENDING'}]
}

# 发送报告请求
response = analytics.reports().batchGet(body={'reportRequests': [report_request]}).execute()

# 处理响应数据
for report in response.get('reports', []):
    for row in report.get('data', {}).get('rows', []):
        session_id = row.get('dimensions', [None])[0]
        product_sku = row.get('dimensions', [None])[1]
        sessions = row.get('metrics', [{}])[0].get('values', [None])[0]
        revenue = row.get('metrics', [{}])[0].get('values', [None])[1]

        print(f'Session ID: {session_id}, Product SKU: {product_sku}, Sessions: {sessions}, Revenue: {revenue}')