Google Analytics icon

Google Analytics

Use the Google Analytics API

Actions236

Data (V1Beta) - Property → Run Pivot Report

AI-generated

Overview

This node integrates with the Google Analytics API, specifically supporting a wide range of administrative and data operations across different API versions (v1alpha, v1beta) and resources. For the Data (V1Beta) - Property resource with the Run Pivot Report operation, it allows users to run pivot reports on Google Analytics properties. Pivot reports are useful for analyzing multidimensional data by aggregating metrics across various dimensions, enabling detailed insights into user behavior and performance.

Typical use cases include:

  • Generating customized pivot tables from Google Analytics data.
  • Analyzing complex relationships between multiple dimensions and metrics.
  • Creating reports that summarize data in a cross-tabulated format for better visualization and decision-making.

Example: Running a pivot report to analyze user sessions segmented by device category and geographic location.

Properties

Name Meaning
Property ID The identifier of the Google Analytics property on which to run the pivot report.
Query Parameters Optional parameters to refine or filter the request. Includes options like Calculated Metric ID, Entity level, Filter expressions, Pagination controls, Show Deleted flag, Universal Analytics Property ID, and Update Mask.
Request Body JSON object containing the detailed configuration of the pivot report request, such as dimensions, metrics, pivots, date ranges, filters, and other report specifications.

Details on Query Parameters Options (subset relevant to this operation):

  • Calculated Metric ID: ID for any calculated metric to be used in the report.
  • Entity: Specifies whether the report is at the property or account level.
  • Filter: Expression to filter the results.
  • Page Size: Maximum number of results to return.
  • Page Token: Token for pagination.
  • Show Deleted: Whether to include soft-deleted properties.
  • Universal Analytics Property ID: To look up connected GA4 property.
  • Update Mask: Fields to update (in snake case).

Output

The output is a JSON array where each element corresponds to the response from the Google Analytics API for the pivot report request. The structure of the JSON matches the Google Analytics Data API's pivot report response, typically including:

  • Pivot Headers: Descriptions of the pivoted dimensions.
  • Rows: Data rows with dimension values and corresponding metric values.
  • Metadata: Information about the report such as totals, counts, and schema.

No binary data output is indicated for this operation.

Dependencies

  • Requires an OAuth2 credential configured for Google Analytics API access.
  • The node uses the Google Analytics Data API endpoints (https://analyticsdata.googleapis.com/v1beta).
  • Proper permissions on the Google Analytics property are necessary to run pivot reports.

Troubleshooting

  • Missing Credentials Error: If the node throws "Missing Google Analytics API Credentials," ensure that OAuth2 credentials for Google Analytics are properly set up and selected.
  • Required Parameter Errors: Errors like "Property ID is required" indicate missing mandatory inputs; verify all required fields are filled.
  • API Call Failures: Errors returned from the Google Analytics API will be wrapped with messages like "Error calling Google Analytics API." Check the error message and stack trace for details, and verify API quotas, permissions, and request correctness.
  • Pagination Issues: When using page tokens, ensure correct handling of tokens to fetch subsequent pages.

Links and References

This summary focuses on the Data (V1Beta) - Property resource and the Run Pivot Report operation, describing its purpose, input properties, output format, dependencies, and common troubleshooting tips based on static analysis of the provided source code and property definitions.

Discussion