The Scenario
You are an SEO analyst. 60 days of data, 12 countries, 80 landing pages. Your content director wants to know which landing pages are underperforming for organic search in specific countries — so the team can prioritize localization work for Q3.
You need a pivot: landing pages as rows, countries as columns, organic sessions as values. GA4 Explore does not export pivot-shaped output. It exports a flat file, which means you would have to reshape the data in Excel using a PivotTable — which is doable, but requires importing the flat CSV first, aligning column names, and building the pivot table configuration.
The bad version of this analysis:
- Export flat organic sessions data by landing page and country from GA4 Explore
- Import the CSV into Excel, fix the column headers
- Build a PivotTable with page path as rows, country as columns, sessions as values
- Realize the page path dimension includes query strings — your pivot has hundreds of rows instead of 80
- Strip query strings from the page path column, rebuild the pivot
- You spend the morning on data reshaping and the content director gets the pivot table Thursday, not Tuesday.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can run a GA4 pivot report and write the cross-tab directly into a tab — no CSV import, no PivotTable configuration.
Open the SheetXAI sidebar and type:
Run a GA4 pivot report with landing page as rows, country as the pivot dimension, and organic sessions as the metric for the last 60 days. Write the result as a cross-tab into the Pivot tab of my workbook — landing pages as row headers in column A, countries as column headers in row 1, session counts as cell values. Start at A1.
SheetXAI calls the GA4 Pivot API, structures the response as a cross-tab, and writes the output with landing page names in column A and one country per subsequent column.
What You Get
A cross-tab pivot table in the Pivot tab:
- Row 1 — country names as column headers
- Column A — landing page paths as row headers
- Cell values — organic session count per page × country combination
- Zeros where a page had no organic traffic from that country — informative, not blank
The pivot structure is ready for conditional formatting. Ask SheetXAI to highlight cells below 10 sessions and it adds the formatting after writing the data. Pages with strong US organic traffic and low Germany traffic are your localization candidates.
What If the Data Is Not Quite Ready
Organic search data in GA4 has tracking quirks. SheetXAI handles them inline.
When landing page paths include query strings
GA4 logs /blog/post?ref=newsletter and /blog/post as separate rows, splitting your traffic across near-duplicate page entries.
Run the GA4 pivot report for landing page × country × organic sessions for the last 60 days. Before writing the cross-tab, strip query strings from page paths and consolidate duplicate rows by summing sessions. Write the clean pivot into the Pivot tab at A1.
When you only want the top 20 landing pages
The full pivot has 80 pages and most have negligible traffic. You want to focus on the pages that matter.
Run the GA4 pivot report for landing page × country × organic sessions for the last 60 days. Filter to the 20 landing pages with the highest total organic sessions. Write the cross-tab into the Pivot tab at A1 with those 20 pages as rows and 12 country columns.
When you want a "Top Country" column added
After the cross-tab, you want a column that names the country with the most organic sessions for each landing page.
Run the GA4 organic sessions pivot for landing page × country for the last 60 days and write the cross-tab into the Pivot tab at A1. Then add a column labeled Top Country at the end of each row naming the country with the highest session count for that landing page.
When you want the full geo-gap analysis in one shot
You need the pivot, the top-country column, and a five-row summary table of the biggest localization gaps — all before Tuesday.
Run a GA4 pivot of organic sessions by landing page and country for the last 60 days. Write the cross-tab into the Pivot tab at A1. Add a Top Country column. Then below the cross-tab starting at row 85, write a five-row summary table showing the landing pages with the largest gap between their highest-performing and lowest-performing country (minimum 50 sessions in the top country). Label that table "Localization Gaps."
The pattern: instead of importing a flat CSV and building a PivotTable manually, you describe the cross-tab structure you need and SheetXAI writes it directly from the GA4 Pivot API.
Try It
Get the 7-day free trial of SheetXAI and ask it to run a GA4 pivot report into your workbook. The Google Analytics integration is included in every SheetXAI plan. See also how to batch-run five GA4 reports into separate tabs in Excel or the Google Analytics in Excel overview.