v4多指标查询

Question

我一直试图获取所有urls的指标，这些urls中包含一个特定的id。从这个问题：Adding ga:pagePath dimension to get page views for a particular URL using Google Analytics Reporting API v4，我看到了查询方法，并尝试了它，而不是面向对象的版本。在查询方法中，代码工作非常出色，但它将只返回最后发送的度量(在本例中，它只返回唯一的页面视图，因为它是最后列出的度量标准)。我需要所有三个返回的值，而不必三次访问api。这是我的代码：

$query = [
        "viewId" => $profileId,
        "dateRanges" => [
            "startDate" => "2018-01-25",
            "endDate" => "2018-01-25"
        ],
        "metrics" => [
            "expression" => "ga:pageviews",
            "expression" => "ga:avgTimeOnPage",
            "expression" => "ga:uniquePageviews"
        ],
        "dimensions" => [
            "name" => "ga:pagepath"
        ],
        "dimensionFilterClauses" => [
            'filters' => [
                "dimension_name" => "ga:pagepath",
                "operator" => "PARTIAL", 
                "expressions" => $theId
            ]
        ]
    ];

    // build the request and response
    $body = new Google_Service_AnalyticsReporting_GetReportsRequest();
    $body->setReportRequests(array($query));
    $report = $analytics->reports->batchGet($body);

对我如何正确做这件事有什么想法吗？

Answer 1

尝试以下函数，只需将ENTER_ID替换为ID即可。

function segmentRequest(&$analyticsreporting) {

  // Create the DateRange object.
  $dateRange = new Google_Service_AnalyticsReporting_DateRange();
  $dateRange->setStartDate("2018-02-01");
  $dateRange->setEndDate("2018-02-15");

  // Create the Metrics object.
  $pageviews = new Google_Service_AnalyticsReporting_Metric();
  $pageviews->setExpression("ga:pageviews");
  $pageviews->setAlias("pageviews");

  //Create the browser dimension.
  $path = new Google_Service_AnalyticsReporting_Dimension();
  $path->setName("ga:pagePath");

  // Create the segment dimension.
  $segmentDimensions = new Google_Service_AnalyticsReporting_Dimension();
  $segmentDimensions->setName("ga:segment");

  // Create Dimension Filter.
  $dimensionFilter = new Google_Service_AnalyticsReporting_SegmentDimensionFilter();
  $dimensionFilter->setDimensionName("ga:pagePath");
  $dimensionFilter->setOperator("PARTIAL");
  $dimensionFilter->setExpressions(array("ENTER_ID"));

  // Create Segment Filter Clause.
  $segmentFilterClause = new Google_Service_AnalyticsReporting_SegmentFilterClause();
  $segmentFilterClause->setDimensionFilter($dimensionFilter);

  // Create the Or Filters for Segment.
  $orFiltersForSegment = new Google_Service_AnalyticsReporting_OrFiltersForSegment();
  $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));

  // Create the Simple Segment.
  $simpleSegment = new Google_Service_AnalyticsReporting_SimpleSegment();
  $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));

  // Create the Segment Filters.
  $segmentFilter = new Google_Service_AnalyticsReporting_SegmentFilter();
  $segmentFilter->setSimpleSegment($simpleSegment);

  // Create the Segment Definition.
  $segmentDefinition = new Google_Service_AnalyticsReporting_SegmentDefinition();
  $segmentDefinition->setSegmentFilters(array($segmentFilter));

  // Create the Dynamic Segment.
  $dynamicSegment = new Google_Service_AnalyticsReporting_DynamicSegment();
  $dynamicSegment->setSessionSegment($segmentDefinition);
  $dynamicSegment->setName("Visits to /en/listings.php");

  // Create the Segments object.
  $segment = new Google_Service_AnalyticsReporting_Segment();
  $segment->setDynamicSegment($dynamicSegment);

  // Create the ReportRequest object.
  $request = new Google_Service_AnalyticsReporting_ReportRequest();
  $request->setViewId("XXXXX");
  $request->setDateRanges(array($dateRange));
  $request->setDimensions(array($path, $segmentDimensions));
  $request->setSegments(array($segment));
  $request->setMetrics(array($pageviews));

  // Create the GetReportsRequest object.
  $getReport = new Google_Service_AnalyticsReporting_GetReportsRequest();
  $getReport->setReportRequests(array($request));

  // Call the batchGet method.
  $body = new Google_Service_AnalyticsReporting_GetReportsRequest();
  $body->setReportRequests( array( $request) );
  $response = $analyticsreporting->reports->batchGet( $body );

  printResults($response->getReports());
}

Answer 2

对于那些想继续使用数组构建查询的人来说，这应该是可行的：

$request = [
    "viewId" => "123456789",
    "dateRanges" => [
        "startDate" => "2018-01-01",
        "endDate" => "today"
    ],
    "metrics" => [
        "expression" => "ga:pageviews"
    ],
    "dimensions" => [
        ["name" => "ga:browser"],
        ["name" => "ga:sessionDurationBucket"]
    ],
    "dimensionFilterClauses" => [
        'filters' => [
            "dimension_name" => "ga:pagepath",
            "operator" => "EXACT",
            "expressions" => $url
        ]
    ]
];

Answer 3

您可以通过为每个表达式(["expression" => "ga:uniquePageviews"])使用数组定义数组样式的多个度量。

  $query = [
          "viewId" => profileId,
          "dateRanges" => [
              "startDate" => "2018-01-25",
              "endDate" => "2018-01-25"
          ],
          "metrics" => [
              ["expression" => "ga:pageviews"],
              ["expression" => "ga:avgTimeOnPage"],
              ["expression" => "ga:uniquePageviews"]               
              
          ],
          "dimensions" => [
              "name" => "ga:pagepath"
          ],
    ];