The Scenario
A content strategist noticed something in the last campaign report: opens from Germany and France were running nearly double the UK rate. Her director wants to know if this holds across the last 3 campaigns before they decide whether to greenlight a localized content track. The country-level breakdown is buried inside each individual campaign report in Moosend.
The bad version:
- Open campaign 1 in Moosend, find the geographic breakdown tab, screenshot or manually copy the country rows you need
- Open campaign 2, repeat — and notice the UI sorts countries differently so the top 5 is a different list
- Open campaign 3, repeat — and realize you forgot to note the total sends for each campaign so the open-count numbers aren't comparable
Three campaigns, three reports, three different sort orders. The comparison table is in your head, not in a sheet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Moosend through its built-in integration, fetches the geographic breakdown for each campaign, and writes all the country-level data into one sheet — sorted and structured for comparison.
For each campaign ID in column A of the 'Campaign List' sheet, fetch the geographic open stats and write country, unique opens, and total opens into the 'Geo Performance' sheet
What You Get
- A row for each country-campaign combination in the 'Geo Performance' sheet — campaign ID, country, unique opens, total opens
- Data from all 3 campaigns lands in one table, making cross-campaign comparison straightforward
- The pull is repeatable — add more campaign IDs to column A and re-run to extend the dataset
What If the Data Is Not Quite Ready
You want the data sorted by total opens within each campaign
For each campaign ID in column A of the 'Campaign List' sheet, fetch the geographic open stats and write campaign name, country, and total opens into the 'Geo Performance' sheet — sorted by campaign then by total opens descending
You only want countries with more than 50 unique opens
For each campaign ID in column A of the 'Campaign List' sheet, fetch the geographic open stats and write campaign name, country, and unique opens into the 'Geo Performance' sheet — only include rows where unique opens is greater than 50
You want to flag which country is the top performer for each campaign
For each campaign ID in column A of the 'Campaign List' sheet, fetch geographic open stats and write campaign name, country, and total opens into the 'Geo Performance' sheet — add a 'TOP' flag in column D for the country with the highest total opens in each campaign
Full regional analysis: pull geo data, flag top markets, and summarize
Fetch geographic open stats for all 3 campaign IDs in column A of the 'Campaign List' sheet — write campaign name, country, unique opens, and total opens into the 'Geo Performance' sheet — flag top-performing country per campaign in column E — then write a one-sentence summary of which country led across all three campaigns into cell G1
Running the pull, the flags, and the summary together means the deck-ready insight is waiting when you open the sheet.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with your campaign IDs, then ask SheetXAI to pull the geographic performance breakdown from Moosend into a comparison table. See also the Export Campaign Performance Stats spoke or the full Moosend overview.