GA4维度与指标不兼容：Python获取eventCount数据的求助

我们已在Google Analytics Data API v1Beta中定义自定义维度，尝试用Python按date、campaignId、campaignName和eventName维度获取eventCount指标，统计不同campaignName下各eventName的eventCount，但请求时报错维度与指标不兼容，求可行解决方法。

原代码 #

import pandas as pd
import numpy as np
from google.analytics.data_v1beta import BetaAnalyticsDataClient
from google.analytics.data_v1beta.types import DateRange
from google.analytics.data_v1beta.types import Dimension
from google.analytics.data_v1beta.types import Metric
from google.analytics.data_v1beta.types import RunReportRequest

client = BetaAnalyticsDataClient()
## Format Report - run_report method
def format_report(request):
    response = client.run_report(request)
    # Row index
    row_index_names = [header.name for header in response.dimension_headers]
    row_header = []
    for i in range(len(row_index_names)):
        row_header.append([row.dimension_values[i].value for row in response.rows])
    row_index_named = pd.MultiIndex.from_arrays(np.array(row_header), names = np.array(row_index_names))
    # Row flat data
    metric_names = [header.name for header in response.metric_headers]
    data_values = []
    for i in range(len(metric_names)):
        data_values.append([row.metric_values[i].value for row in response.rows])
    output = pd.DataFrame(data = np.transpose(np.array(data_values, dtype = 'f')), 
                          index = row_index_named, columns = metric_names)
    return output
request = RunReportRequest(
        property='properties/'+property_id,
        dimensions=[            
            Dimension(name="date"),
            Dimension(name="eventName"),
            Dimension(name="campaignId"),
            Dimension(name="campaignName")
                ],
        metrics=[         
            Metric(name="eventCount"),
            ],
        date_ranges=[DateRange(start_date="2023-01-22", end_date="2023-01-25")],
    )

报错信息 #

InvalidArgument: 400 请移除eventCount以让请求兼容。当前请求的维度与指标不兼容。

解决方法 #

问题原因 #

campaignId、campaignName属于会话级维度，而eventCount是事件级指标，GA4不允许直接将会话级维度与eventCount这类事件指标组合使用。

可行方案 #

直接用totalEvents指标替换eventCount，它和eventCount统计逻辑一致（都是统计事件发生次数），但支持与会话级、用户级维度组合使用，完全满足你的统计需求。

修改后的请求代码片段：

request = RunReportRequest(
        property='properties/'+property_id,
        dimensions=[            
            Dimension(name="date"),
            Dimension(name="eventName"),
            Dimension(name="campaignId"),
            Dimension(name="campaignName")
                ],
        metrics=[         
            Metric(name="totalEvents"),  # 替换为totalEvents
            ],
        date_ranges=[DateRange(start_date="2023-01-22", end_date="2023-01-25")],
    )

内容的提问来源于stack exchange，提问作者Sardar Abdullah Khawar