The Scenario
You are a paid media director. The board deck is due Thursday. You need one table showing how organic, paid search, email, and direct channels compare on sessions, conversions, and revenue for Q1 2025 versus Q2 2025 — side by side, with a percentage change column, in an Excel workbook.
GA4's built-in Channel Groups report shows one period at a time. You can export Q1 and Q2 as separate CSVs, open both in Excel, and build the comparison table from two flat files. Except the channel group names are sometimes capitalized differently between exports, and aligning two CSVs manually with matching VLOOKUP keys is the kind of task that produces errors on the last row.
The bad version of building this table:
- Export Q1 channel group data from GA4, import into the workbook
- Export Q2, import beside Q1
- Notice "Paid Search" in Q1 exports as "Paid search" in Q2
- Manually fix the case inconsistency, redo the join
- Realize the revenue metric is missing from Q1 because you configured that report differently
- Re-export Q1 with revenue, repaste
- The deck goes out Thursday morning with numbers you are not confident in.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the GA4 API directly, so you do not need two CSV exports and a manual join.
Open the SheetXAI sidebar and type:
From my GA4 property, run a report comparing sessions, conversions, and revenue by default channel group for Q1 2025 vs Q2 2025. Write the results side-by-side in my workbook's Attribution tab with a column for each metric per quarter and a percentage change column for each metric. Start at row 2 with headers in row 1.
SheetXAI runs two GA4 API calls, aligns the channel group names, computes the change columns, and writes the comparison table into the Attribution tab. Both date ranges, one query, one pass.
What You Get
A board-ready comparison table in the Attribution tab:
- Row 1 — headers: Channel Group, Sessions Q1, Sessions Q2, Sessions Change %, Conversions Q1, Conversions Q2, Conversions Change %, Revenue Q1, Revenue Q2, Revenue Change %
- One row per channel group — aligned names across both quarters
- Change columns calculated at write time — no formula layer needed on top
Aligned channel names come from the API-level normalization. You do not fix capitalization in Excel after the fact — SheetXAI handles it before writing.
Want the table sorted by Q2 conversions descending, or a summary row totaling all channels? Add it to the prompt.
What If the Data Is Not Quite Ready
Channel attribution in GA4 has quirks that show up in real workbooks. SheetXAI handles them inline.
When some channels show zero revenue
Your GA4 property does not have e-commerce tracking on all channels, so some rows show zero revenue even though those channels drove purchases.
Run the Q1 vs Q2 channel group comparison for sessions, conversions, and revenue in my Attribution tab. For any channel group where revenue is zero in both quarters, write "Revenue not tracked" in a Notes column.
When you want to combine channel groups for reporting
Your organization counts Paid Search and Display as "Paid Media" for board-level reporting.
Run the Q1 vs Q2 channel group comparison and write the raw table at row 2 of the Attribution tab. Then add a second summary table starting at row 20 that combines Paid Search and Display into a single "Paid Media" row, summing sessions, conversions, and revenue for both quarters.
When only the top four channels matter
The board only cares about the top four channels by Q2 conversions.
Run the Q1 vs Q2 channel group comparison. Filter to the four channel groups with the highest Q2 conversions. Write only those four rows into the Attribution tab with percentage change columns, sorted by Q2 conversions descending.
When you need the table plus a written narrative in one shot
You want the comparison table and a two-sentence summary for the exec summary slide — in the same prompt.
Run a Q1 vs Q2 comparison of sessions, conversions, and revenue by default channel group from my GA4 property. Write the table into the Attribution tab at row 2 with headers in row 1 and percentage change columns. Then write a two-sentence summary of the biggest mover and the biggest decline into cell A14 for the board deck exec summary.
The pattern: instead of two CSV exports and a manual join, you describe the comparison table you need and SheetXAI produces it — change columns included.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull a Q1 vs Q2 channel breakdown from your GA4 property into your workbook. The Google Analytics integration is included in every SheetXAI plan. See also how to pull a full GA4 performance report into Excel or the Google Analytics in Excel overview.