RecipeGoogle Analytics 4
Run a GA4 pivot for two-dimensional questions
Pivot reports for questions shaped like X by Y, batched when several cuts are needed.
IntentThe two-way cut a flat report cannot show.
- 2
- Steps
- 2
- Tools
- 1
- Rules
- 1
- Failure modes
When to use it
Use it when
- Device × channel, market × landing, any two-way question.
Do not use it when
- Beyond two dimensions at once: readability collapses and thresholds bite.
What it needs first
Required
Preconditions
- The account is ticked in the dashboard, confirmed via list_accounts.
Inputs
window- Analysis window.Default: last 30 days.
Procedure
In order. Every tool named is one the gateway ships, and links to its reference.
Run the pivot with the two dimensions.
Batch related pivots in one call where the question needs several.
Decision rules
The observable condition, what it lets you conclude, and what takes the conclusion back.
When
A cell result rests on tiny counts
Conclude
Mark it unjudged: pivots multiply thresholding, and small cells lie.
Evidence every conclusion must carry
- Every figure carries its account, metric and window.
- Anything below a readable sample size is reported as unjudged, not as zero.
Where the agent stops
- The readout changes nothing. Any change it motivates goes through Safe Writes: preview, human confirmation, then apply.
How it goes wrong quietly
The cases where the analysis is wrong and still looks right. Read them before trusting a number.
- Row limits truncate long tails silently: state the limit used.
What the answer contains
- 01Readout
- The figures, with windows and accounts named.
- 02Flags
- What deserves a deeper skill or a human decision.