The Scenario
You are a marketing ops manager. Platform migration starts in four weeks. Your team is moving analytics platforms and needs a complete inventory of every custom dimension and custom metric on your GA4 property — all 25 custom dimensions and 10 custom metrics — in an Excel workbook that engineers and stakeholders can both read.
The GA4 Admin panel shows each custom dimension one at a time. No export button. No file download. Pulling the full list requires the GA4 Admin API, and that requires writing a script — which no one on the team has time for right now.
The bad version of the next two days:
- Open GA4 Admin → Custom Definitions → Custom Dimensions
- Manually type each of the 25 dimensions into Excel: display name, parameter name, scope, description
- Repeat for the 10 custom metrics, adding a Unit column
- Realize you missed the archived filter — some of the 25 are archived and you did not capture their status
- Go back and check each one for its status, update the workbook
- Finish Thursday afternoon with a sheet you are not fully sure matches the actual property.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can list all custom definitions from your GA4 property in one call.
Open the SheetXAI sidebar and type:
List all custom dimensions and custom metrics on my GA4 property. Write them as two separate tables into my workbook: custom dimensions in the Custom Dims tab starting at row 2 (headers in row 1) with columns for Display Name, Parameter Name, Scope, Description, and Status; and custom metrics in the Custom Metrics tab starting at row 2 with the same columns plus Unit.
SheetXAI calls the GA4 Admin API, pulls both lists in full including archived entries, and writes them into the two tabs.
What You Get
Two reference tabs in your workbook:
Custom Dims tab:
- Display Name, Parameter Name, Scope, Description, Status (Active or Archived)
- 25 rows, one per custom dimension, including archived ones
Custom Metrics tab:
- Display Name, Parameter Name, Scope, Description, Unit, Status
- 10 rows, one per custom metric, including archived ones
Both tabs include archived entries. This is the complete property state. For a migration, you need to know what is archived as well as what is active — archived entries may still be referenced in historical data.
What If the Data Is Not Quite Ready
Migration inventories surface surprises. SheetXAI handles them inline.
When you want to flag parameters that might conflict with GA4 standard fields
Some custom parameter names overlap with GA4 built-in parameters, which can cause data collection issues.
List all custom dimensions on my GA4 property with display name, parameter name, scope, and status. After writing the table into the Custom Dims tab, add a "Conflict Risk" column — flag any parameter name that matches or closely resembles a GA4 standard parameter like page_title or session_id.
When you want the list sorted by scope
Your engineers need user-scoped dimensions separated from event-scoped dimensions for the migration plan.
List all custom dimensions from my GA4 property and sort so user-scoped dimensions appear first, then event-scoped. Write into the Custom Dims tab at row 2 with headers in row 1. Include archived entries with their status.
When you need last-month event counts added
Knowing a custom dimension exists is one thing. Knowing it fired 80,000 times last month tells you whether it is business-critical.
List all custom dimensions and metrics on my GA4 property. For each, also pull the count of events that sent that parameter last month. Write into the Custom Dims and Custom Metrics tabs with an additional Last Month Events column.
When you want the full migration doc in one shot
You need both tables, event count columns, active vs archived totals, and a migration note — all by end of day.
List all custom dimensions and custom metrics on my GA4 property. Include display name, parameter name, scope, description, status, and last-month event count. Write custom dimensions into the Custom Dims tab at row 2 and custom metrics into the Custom Metrics tab at row 2. Below each table, write a count row: "X active, Y archived." Then write a two-sentence migration note in cell A30 of the Custom Dims tab describing which dimensions appear critical based on event count and which appear safe to archive.
The pattern: instead of two days of manual Admin panel data entry, you describe the inventory you need and SheetXAI pulls it directly from the GA4 Admin API.
Try It
Get the 7-day free trial of SheetXAI and ask it to export your GA4 custom definitions into your workbook. The Google Analytics integration is included in every SheetXAI plan. See also how to export GA4 key events with counts for a tagging audit in Excel or the Google Analytics in Excel overview.