域名历史访问量

import pandas as pd
from google.oauth2 import service_account
from googleapiclient.discovery import build

# 设置Google Analytics API凭证
credentials = service_account.Credentials.from_service_account_file(
    'path/to/your/credentials.json'
)

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

# 查询历史访问量数据
response = analytics.reports().batchGet(
    body={
        'reportRequests': [
            {
                'viewId': 'your_view_id',
                'dateRanges': [{'startDate': '30daysAgo', 'endDate': 'today'}],
                'metrics': [{'expression': 'ga:sessions'}]
            }
        ]
    }
).execute()

# 处理响应数据
rows = response['reports'][0]['data']['rows']
data = []
for row in rows:
    data.append(row['metrics'][0]['values'][0])

# 转换为DataFrame
df = pd.DataFrame(data, columns=['Sessions'])
print(df)