GA4 pivot report
ga_run_pivot_reportCross-tab one GA4 dimension against another (e.g., landing pages by device) and return a matrix with row totals. Specify row/column dimensions and metrics; the tool builds the pivot report automatically.
Instructions
Cross-tab one dimension against another, e.g. landing pages (rows) by device category (columns) with sessions. Simpler than the raw API: give rowDimension, columnDimension and metrics; the tool builds the two pivots and returns a matrix plus row totals.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| endDate | No | yesterday | |
| metrics | No | ||
| rowLimit | No | ||
| rowOffset | No | Skip this many values of the row dimension (pagination). | |
| startDate | No | 28daysAgo | |
| propertyId | Yes | GA4 property ID, e.g. '123456789' (see ga_list_properties). | |
| columnLimit | No | ||
| filterLogic | No | How to join several dimensionFilters. | and |
| rowDimension | No | landingPage | |
| columnDimension | No | deviceCategory | |
| dimensionFilters | No |