试用 Google Analytics 的 MCP 服务器。从
GitHub 安装,并参阅
公告了解详情。
Pivot
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
JSON 表示法 |
{
"fieldNames": [
string
],
"orderBys": [
{
object (OrderBy )
}
],
"offset": string,
"limit": string,
"metricAggregations": [
enum (MetricAggregation )
]
} |
字段 |
fieldNames[] |
string
报告响应中可见列的维度名称。添加“dateRange”会生成日期范围列;对于响应中的每一行,日期范围列中的维度值将指示请求中的相应日期范围。
|
orderBys[] |
object (OrderBy )
指定维度在数据透视表中的排序方式。在第一个数据透视表中,OrderBy 用于确定行和 PivotDimensionHeader 的排序;在后续的数据透视表中,OrderBy 仅用于确定 PivotDimensionHeader 的排序。这些 OrderBy 中指定的维度必须是 Pivot.field_names 的子集。
|
offset |
string (int64 format)
起始行的行数。第一行计为第 0 行。
|
limit |
string (int64 format)
此数据透视表中要返回的维度值的唯一组合数量。limit 为必需参数,对于单个枢轴请求,limit 通常为 10,000。 RunPivotReportRequest 中每个 pivot 的 limit 的乘积不得超过 25 万。例如,如果两个 pivot 请求中的每个 pivot 都包含 limit:
1000 ,则请求会失败,因为产品为 1,000,000 。
|
metricAggregations[] |
enum (MetricAggregation )
使用指定的 metricAggregation 按维度汇总此数据透视表中的指标。
|
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2025-07-26。
[null,null,["最后更新时间 (UTC):2025-07-26。"],[[["\u003cp\u003eJSON representation describes the structure for defining the layout and data of a report, including visible dimensions and rows.\u003c/p\u003e\n"],["\u003cp\u003eIt allows specifying dimension names, ordering, data range, row limits, and metric aggregations for the report output.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eorderBys\u003c/code\u003e field determines the ordering of dimensions within the report, impacting both row and pivot dimension headers.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eoffset\u003c/code\u003e and \u003ccode\u003elimit\u003c/code\u003e fields control the range of rows returned, with \u003ccode\u003elimit\u003c/code\u003e being a required parameter subject to specific constraints.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003emetricAggregations\u003c/code\u003e enables the aggregation of metrics based on dimensions, providing summarized insights within the report.\u003c/p\u003e\n"]]],["The core content defines the structure for visible report dimensions. `fieldNames` specifies dimension names, including \"dateRange\" for date-specific columns. `orderBys` dictates dimension ordering within pivots. `offset` and `limit` control row selection, with `limit` denoting the number of unique dimension combinations. `metricAggregations` allows for metric aggregation by dimensions. The combined `limit` of all pivots in a request must not exceed 250,000.\n"],null,["# Pivot\n\n- [JSON representation](#SCHEMA_REPRESENTATION)\n\nDescribes the visible dimension columns and rows in the report response.\n\n| JSON representation |\n|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| ``` { \"fieldNames\": [ string ], \"orderBys\": [ { object (/analytics/devguides/reporting/data/v1/rest/v1beta/OrderBy) } ], \"offset\": string, \"limit\": string, \"metricAggregations\": [ enum (/analytics/devguides/reporting/data/v1/rest/v1beta/MetricAggregation) ] } ``` |\n\n| Fields ||\n|--------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `field``Names[]` | `string` Dimension names for visible columns in the report response. Including \"dateRange\" produces a date range column; for each row in the response, dimension values in the date range column will indicate the corresponding date range from the request. |\n| `order``Bys[]` | `object (`[OrderBy](/analytics/devguides/reporting/data/v1/rest/v1beta/OrderBy)`)` Specifies how dimensions are ordered in the pivot. In the first Pivot, the OrderBys determine Row and PivotDimensionHeader ordering; in subsequent Pivots, the OrderBys determine only PivotDimensionHeader ordering. Dimensions specified in these OrderBys must be a subset of Pivot.field_names. |\n| `offset` | `string (`[int64](https://developers.google.com/discovery/v1/type-format)` format)` The row count of the start row. The first row is counted as row 0. |\n| `limit` | `string (`[int64](https://developers.google.com/discovery/v1/type-format)` format)` The number of unique combinations of dimension values to return in this pivot. The `limit` parameter is required. A `limit` of 10,000 is common for single pivot requests. The product of the `limit` for each `pivot` in a `RunPivotReportRequest` must not exceed 250,000. For example, a two pivot request with `limit: 1000` in each pivot will fail because the product is `1,000,000`. |\n| `metric``Aggregations[]` | `enum (`[MetricAggregation](/analytics/devguides/reporting/data/v1/rest/v1beta/MetricAggregation)`)` Aggregate the metrics by dimensions in this pivot using the specified metricAggregations. |"]]