如何使用Java判断GA4报表是否存在更多分页数据

我正按照Google开发者文档提供的代码示例读取GA4信息，但不知道如何判断是否存在更多分页数据。仅通过结果集大小判断似乎有所遗漏，我的代码如下：

Files.createDirectories(Paths.get(credentialsJsonPath).getParent());

GoogleCredentials credentials =
        GoogleCredentials.fromStream(new FileInputStream(credentialsJsonPath));

BetaAnalyticsDataSettings betaAnalyticsDataSettings =
        BetaAnalyticsDataSettings.newBuilder()
        .setCredentialsProvider(FixedCredentialsProvider.create(credentials))
        .build();    

try (BetaAnalyticsDataClient analyticsData =
        BetaAnalyticsDataClient.create(betaAnalyticsDataSettings)) {

    RunReportRequest request =
            RunReportRequest.newBuilder()
            .setProperty("properties/" + "my propertyId")
            .addDateRanges(DateRange.newBuilder().setStartDate("2022-10-02").setEndDate("2022-11-02"))

            .addDimensions(Dimension.newBuilder().setName("fullPageUrl")) 
            .addDimensions(Dimension.newBuilder().setName("pagePath"))  
            .addDimensions(Dimension.newBuilder().setName("eventName"))  
            .addDimensions(Dimension.newBuilder().setName("date")) 
            .addDimensions(Dimension.newBuilder().setName("customEvent:dim1"))
            .addDimensions(Dimension.newBuilder().setName("customEvent:dim2"))
            .addDimensions(Dimension.newBuilder().setName("customEvent:dim3"))
             

            .addMetrics(Metric.newBuilder().setName("activeUsers"))  
            .addMetrics(Metric.newBuilder().setName("engagementRate"))
            .addMetrics(Metric.newBuilder().setName("sessions"))
            .addMetrics(Metric.newBuilder().setName("eventCount"))  
            .addMetrics(Metric.newBuilder().setName("userEngagementDuration"))
            .addMetrics(Metric.newBuilder().setName("averageSessionDuration"))
            .addMetrics(Metric.newBuilder().setName("screenPageViews"))  
            .addMetrics(Metric.newBuilder().setName("totalUsers"))
            .addMetrics(Metric.newBuilder().setName("eventCountPerUser"))
            .addMetrics(Metric.newBuilder().setName("bounceRate"))                          
            

            .build();
    RunReportResponse response = analyticsData.runReport(request);

    if(response.getRowsList().size()>0) {
        for (Row row : response.getRowsList()) {
          // 此处读取所需信息
        }
    }
}

GA4的RunReportResponse确实提供了getNextPageToken()方法来判断是否存在更多分页数据，结合请求中的分页参数就能完整获取所有数据，具体实现如下：

修改后的完整代码 #

Files.createDirectories(Paths.get(credentialsJsonPath).getParent());

GoogleCredentials credentials =
        GoogleCredentials.fromStream(new FileInputStream(credentialsJsonPath));

BetaAnalyticsDataSettings betaAnalyticsDataSettings =
        BetaAnalyticsDataSettings.newBuilder()
        .setCredentialsProvider(FixedCredentialsProvider.create(credentials))
        .build();    

try (BetaAnalyticsDataClient analyticsData =
        BetaAnalyticsDataClient.create(betaAnalyticsDataSettings)) {

    String nextPageToken = null;
    do {
        RunReportRequest request =
                RunReportRequest.newBuilder()
                .setProperty("properties/" + "my propertyId")
                .addDateRanges(DateRange.newBuilder().setStartDate("2022-10-02").setEndDate("2022-11-02"))
                // 维度配置
                .addDimensions(Dimension.newBuilder().setName("fullPageUrl")) 
                .addDimensions(Dimension.newBuilder().setName("pagePath"))  
                .addDimensions(Dimension.newBuilder().setName("eventName"))  
                .addDimensions(Dimension.newBuilder().setName("date")) 
                .addDimensions(Dimension.newBuilder().setName("customEvent:dim1"))
                .addDimensions(Dimension.newBuilder().setName("customEvent:dim2"))
                .addDimensions(Dimension.newBuilder().setName("customEvent:dim3"))
                // 指标配置
                .addMetrics(Metric.newBuilder().setName("activeUsers"))  
                .addMetrics(Metric.newBuilder().setName("engagementRate"))
                .addMetrics(Metric.newBuilder().setName("sessions"))
                .addMetrics(Metric.newBuilder().setName("eventCount"))  
                .addMetrics(Metric.newBuilder().setName("userEngagementDuration"))
                .addMetrics(Metric.newBuilder().setName("averageSessionDuration"))
                .addMetrics(Metric.newBuilder().setName("screenPageViews"))  
                .addMetrics(Metric.newBuilder().setName("totalUsers"))
                .addMetrics(Metric.newBuilder().setName("eventCountPerUser"))
                .addMetrics(Metric.newBuilder().setName("bounceRate"))
                // 分页参数设置
                .setPageSize(10000) // GA4 API允许的最大单页数据量
                .setPageToken(nextPageToken)
                .build();
                
        RunReportResponse response = analyticsData.runReport(request);

        if (!response.getRowsList().isEmpty()) {
            for (Row row : response.getRowsList()) {
                // 处理每条数据的逻辑
            }
        }
        // 更新下一页token，为空则终止循环
        nextPageToken = response.getNextPageToken();
    } while (nextPageToken != null && !nextPageToken.isEmpty());
}

关键要点 #

• setPageSize：设置单页返回的最大数据条数，GA4 API上限为10000，默认值为1000。
• getNextPageToken()：如果返回非空字符串，说明还有未获取的数据，将该token传入下一次请求的setPageToken即可获取下一页。
• 循环终止条件：当nextPageToken为null或空字符串时，所有数据已获取完成。

内容的提问来源于stack exchange，提问作者Shila Mosammami