在日期范围内按自定义尺寸进行的GA4度量聚合？

Question

我正在使用 php-data-analytics 客户端库返回a ga4 pivot报告我正在尝试获得看起来像这样的结果：

我想在每个 object_id 中返回每个 depaterange 中的汇总指标，但是我的请求似乎返回两个日期范围的聚合物，而不是分别返回。我目前拥有的是：

$args = array(
    "dimensions" => [
        new Dimension([ 'name' => 'nthDay' ]),
        new Dimension([ 'name' => 'streamId' ]),
        new Dimension([ 'name' => 'customEvent:listing_id' ])
    ],
    "metrics" => [
        new Metric([ 'name' => 'screenPageViews' ]),
        new Metric([ 'name' => 'activeUsers' ]),
        new Metric([ 'name' => 'userEngagementDuration' ])
        ],
    "dimensionFilter" => new FilterExpression([
        'filter' => new Filter([
            'field_name' => 'streamId',
            'string_filter' => new Filter\StringFilter([
                'match_type' => Filter\StringFilter\MatchType::EXACT,
                'value' => $stream_id,
            ])
        ])
    ]),
    "pivots" => [
        new Pivot([ 
            'field_names' => [ 'customEvent:listing_id', 'nthDay' ],
            "order_bys" => [
                new OrderBy([
                    'desc' => false,
                    'dimension' => new OrderBy\DimensionOrderBy([
                            "dimension_name" => 'customEvent:listing_id',
                            "order_type" => OrderBy\DimensionOrderBy\OrderType::NUMERIC
                    ])
                ]),
                new OrderBy([
                    'desc' => false,
                    'dimension' => new OrderBy\DimensionOrderBy([
                        "dimension_name" => 'nthDay',
                        "order_type" => OrderBy\DimensionOrderBy\OrderType::NUMERIC
                    ])
                ])
            ],
            'metric_aggregations' => [ MetricAggregation::TOTAL ],
            'limit' => 100
        ]),
        new Pivot([ 
            'field_names' => [ 'dateRange' ],
            'limit' => 100
        ])
    ]
);

我应该如何构建 runpivortreport 请求产生上述报告？还是有更好的方法？

Answer 1

我会说，开始简单地使它起作用而无需任何复杂性，来自此示例文档使用普通API，然后逐步构建在其上方，直到达到目标。
顺便说一句，示例正在显示您正在寻找的设计。
然后将请求主体转换为您的编程语言（PHP）。
希望这对您有帮助。

POST https://analyticsdata.googleapis.com/v1beta/properties/GA4_PROPERTY_ID:runPivotReport
  {
    "dateRanges": [{ "startDate": "2020-09-01", "endDate": "2020-09-15" }],
    "dimensions": [
        { "name": "browser" },
        { "name": "country" },
        { "name": "language" }
      ],
    "metrics": [{ "name": "sessions" }],
    "pivots": [
      {
        "fieldNames": [
          "browser"
        ],
        "limit": 5
      },
      {
        "fieldNames": [
          "country"
        ],
        "limit": 250
      },
      {
        "fieldNames": [
          "language"
        ],
        "limit": 15
      }
    ]
  }