Google Analytics Automation

1---
2name: google-analytics-automation
3description: "Automate Google Analytics tasks via Rube MCP (Composio): run reports, list accounts/properties, funnels, pivots, key events. Always search tools first for current schemas."
4requires:
5  mcp: [rube]
6---
7 
8# Google Analytics Automation via Rube MCP
9 
10Automate Google Analytics 4 (GA4) reporting and property management through Composio's Google Analytics toolkit via Rube MCP.
11 
12## Prerequisites
13 
14- Rube MCP must be connected (RUBE_SEARCH_TOOLS available)
15- Active Google Analytics connection via `RUBE_MANAGE_CONNECTIONS` with toolkit `google_analytics`
16- Always call `RUBE_SEARCH_TOOLS` first to get current tool schemas
17 
18## Setup
19 
20**Get Rube MCP**: Add `https://rube.app/mcp` as an MCP server in your client configuration. No API keys needed — just add the endpoint and it works.
21 
22 
231. Verify Rube MCP is available by confirming `RUBE_SEARCH_TOOLS` responds
242. Call `RUBE_MANAGE_CONNECTIONS` with toolkit `google_analytics`
253. If connection is not ACTIVE, follow the returned auth link to complete Google OAuth
264. Confirm connection status shows ACTIVE before running any workflows
27 
28## Core Workflows
29 
30### 1. List Accounts and Properties
31 
32**When to use**: User wants to discover available GA4 accounts and properties
33 
34**Tool sequence**:
351. `GOOGLE_ANALYTICS_LIST_ACCOUNTS` - List all accessible GA4 accounts [Required]
362. `GOOGLE_ANALYTICS_LIST_PROPERTIES` - List properties under an account [Required]
37 
38**Key parameters**:
39- `pageSize`: Number of results per page
40- `pageToken`: Pagination token from previous response
41- `filter`: Filter expression for properties (e.g., `parent:accounts/12345`)
42 
43**Pitfalls**:
44- Property IDs are numeric strings prefixed with 'properties/' (e.g., 'properties/123456')
45- Account IDs are prefixed with 'accounts/' (e.g., 'accounts/12345')
46- Always list accounts first, then properties under each account
47- Pagination required for organizations with many properties
48 
49### 2. Run Standard Reports
50 
51**When to use**: User wants to query metrics and dimensions from GA4 data
52 
53**Tool sequence**:
541. `GOOGLE_ANALYTICS_LIST_PROPERTIES` - Get property ID [Prerequisite]
552. `GOOGLE_ANALYTICS_GET_METADATA` - Discover available dimensions and metrics [Optional]
563. `GOOGLE_ANALYTICS_CHECK_COMPATIBILITY` - Verify dimension/metric compatibility [Optional]
574. `GOOGLE_ANALYTICS_RUN_REPORT` - Execute the report query [Required]
58 
59**Key parameters**:
60- `property`: Property ID (e.g., 'properties/123456')
61- `dateRanges`: Array of date range objects with `startDate` and `endDate`
62- `dimensions`: Array of dimension objects with `name` field
63- `metrics`: Array of metric objects with `name` field
64- `dimensionFilter` / `metricFilter`: Filter expressions
65- `orderBys`: Sort order configuration
66- `limit`: Maximum rows to return
67- `offset`: Row offset for pagination
68 
69**Pitfalls**:
70- Date format is 'YYYY-MM-DD' or relative values like 'today', 'yesterday', '7daysAgo', '30daysAgo'
71- Not all dimensions and metrics are compatible; use CHECK_COMPATIBILITY first
72- Use GET_METADATA to discover valid dimension and metric names
73- Maximum 9 dimensions per report request
74- Row limit defaults vary; set explicitly for large datasets
75- `offset` is for result pagination, not date pagination
76 
77### 3. Run Batch Reports
78 
79**When to use**: User needs multiple different reports from the same property in one call
80 
81**Tool sequence**:
821. `GOOGLE_ANALYTICS_LIST_PROPERTIES` - Get property ID [Prerequisite]
832. `GOOGLE_ANALYTICS_BATCH_RUN_REPORTS` - Execute multiple reports at once [Required]
84 
85**Key parameters**:
86- `property`: Property ID (required)
87- `requests`: Array of individual report request objects (same structure as RUN_REPORT)
88 
89**Pitfalls**:
90- Maximum 5 report requests per batch call
91- All reports in a batch must target the same property
92- Each individual report has the same dimension/metric limits as RUN_REPORT
93- Batch errors may affect all reports; check individual report responses
94 
95### 4. Run Pivot Reports
96 
97**When to use**: User wants cross-tabulated data (rows vs columns) like pivot tables
98 
99**Tool sequence**:
1001. `GOOGLE_ANALYTICS_LIST_PROPERTIES` - Get property ID [Prerequisite]
1012. `GOOGLE_ANALYTICS_RUN_PIVOT_REPORT` - Execute pivot report [Required]
102 
103**Key parameters**:
104- `property`: Property ID (required)
105- `dateRanges`: Date range objects
106- `dimensions`: All dimensions used in any pivot
107- `metrics`: Metrics to aggregate
108- `pivots`: Array of pivot definitions with `fieldNames`, `limit`, and `orderBys`
109 
110**Pitfalls**:
111- Dimensions used in pivots must also be listed in top-level `dimensions`
112- Pivot `fieldNames` reference dimension names from the top-level list
113- Complex pivots with many dimensions can produce very large result sets
114- Each pivot has its own independent `limit` and `orderBys`
115 
116### 5. Run Funnel Reports
117 
118**When to use**: User wants to analyze conversion funnels and drop-off rates
119 
120**Tool sequence**:
1211. `GOOGLE_ANALYTICS_LIST_PROPERTIES` - Get property ID [Prerequisite]
1222. `GOOGLE_ANALYTICS_RUN_FUNNEL_REPORT` - Execute funnel analysis [Required]
123 
124**Key parameters**:
125- `property`: Property ID (required)
126- `dateRanges`: Date range objects
127- `funnel`: Funnel definition with `steps` array
128- `funnelBreakdown`: Optional dimension to break down funnel by
129 
130**Pitfalls**:
131- Funnel steps are ordered; each step defines a condition users must meet
132- Steps use filter expressions similar to dimension/metric filters
133- Open funnels allow entry at any step; closed funnels require sequential progression
134- Funnel reports may take longer to process than standard reports
135 
136### 6. Manage Key Events
137 
138**When to use**: User wants to view or manage conversion events (key events) in GA4
139 
140**Tool sequence**:
1411. `GOOGLE_ANALYTICS_LIST_PROPERTIES` - Get property ID [Prerequisite]
1422. `GOOGLE_ANALYTICS_LIST_KEY_EVENTS` - List all key events for the property [Required]
143 
144**Key parameters**:
145- `parent`: Property resource name (e.g., 'properties/123456')
146- `pageSize`: Number of results per page
147- `pageToken`: Pagination token
148 
149**Pitfalls**:
150- Key events were previously called "conversions" in GA4
151- Property must have key events configured to return results
152- Key event names correspond to GA4 event names
153 
154## Common Patterns
155 
156### ID Resolution
157 
158**Account name -> Account ID**:
159```
1601. Call GOOGLE_ANALYTICS_LIST_ACCOUNTS
1612. Find account by displayName
1623. Extract name field (e.g., 'accounts/12345')
163```
164 
165**Property name -> Property ID**:
166```
1671. Call GOOGLE_ANALYTICS_LIST_PROPERTIES with filter
1682. Find property by displayName
1693. Extract name field (e.g., 'properties/123456')
170```
171 
172### Dimension/Metric Discovery
173 
174```
1751. Call GOOGLE_ANALYTICS_GET_METADATA with property ID
1762. Browse available dimensions and metrics
1773. Call GOOGLE_ANALYTICS_CHECK_COMPATIBILITY to verify combinations
1784. Use verified dimensions/metrics in RUN_REPORT
179```
180 
181### Pagination
182 
183- Reports: Use `offset` and `limit` for row pagination
184- Accounts/Properties: Use `pageToken` from response
185- Continue until `pageToken` is absent or `rowCount` reached
186 
187### Common Dimensions and Metrics
188 
189**Dimensions**: `date`, `city`, `country`, `deviceCategory`, `sessionSource`, `sessionMedium`, `pagePath`, `pageTitle`, `eventName`
190 
191**Metrics**: `activeUsers`, `sessions`, `screenPageViews`, `eventCount`, `conversions`, `totalRevenue`, `bounceRate`, `averageSessionDuration`
192 
193## Known Pitfalls
194 
195**Property IDs**:
196- Always use full resource name format: 'properties/123456'
197- Numeric ID alone will cause errors
198- Resolve property names to IDs via LIST_PROPERTIES
199 
200**Date Ranges**:
201- Format: 'YYYY-MM-DD' or relative ('today', 'yesterday', '7daysAgo', '30daysAgo')
202- Data processing delay means today's data may be incomplete
203- Maximum date range varies by property configuration
204 
205**Compatibility**:
206- Not all dimensions work with all metrics
207- Always verify with CHECK_COMPATIBILITY before complex reports
208- Custom dimensions/metrics have specific naming patterns
209 
210**Response Parsing**:
211- Report data is nested in `rows` array with `dimensionValues` and `metricValues`
212- Values are returned as strings; parse numbers explicitly
213- Empty reports return no `rows` key (not an empty array)
214 
215## Quick Reference
216 
217| Task | Tool Slug | Key Params |
218|------|-----------|------------|
219| List accounts | GOOGLE_ANALYTICS_LIST_ACCOUNTS | pageSize, pageToken |
220| List properties | GOOGLE_ANALYTICS_LIST_PROPERTIES | filter, pageSize |
221| Get metadata | GOOGLE_ANALYTICS_GET_METADATA | property |
222| Check compatibility | GOOGLE_ANALYTICS_CHECK_COMPATIBILITY | property, dimensions, metrics |
223| Run report | GOOGLE_ANALYTICS_RUN_REPORT | property, dateRanges, dimensions, metrics |
224| Batch reports | GOOGLE_ANALYTICS_BATCH_RUN_REPORTS | property, requests |
225| Pivot report | GOOGLE_ANALYTICS_RUN_PIVOT_REPORT | property, dateRanges, pivots |
226| Funnel report | GOOGLE_ANALYTICS_RUN_FUNNEL_REPORT | property, dateRanges, funnel |
227| List key events | GOOGLE_ANALYTICS_LIST_KEY_EVENTS | parent, pageSize |
228