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 workbook.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. 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 worksheet — sorted and structured for comparison.
Fetch the location-based open stats for Moosend campaign ID camp789 and write each country's open count into my Excel 'Geo Report' worksheet sorted by total opens descending
What You Get
- A row for each country-campaign combination in the 'Geo Report' worksheet — 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 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' worksheet, fetch the geographic open stats and write campaign name, country, and total opens into the 'Geo Performance' worksheet — 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' worksheet, fetch the geographic open stats and write campaign name, country, and unique opens into the 'Geo Performance' worksheet — 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' worksheet, fetch geographic open stats and write campaign name, country, and total opens into the 'Geo Performance' worksheet — 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' worksheet — write campaign name, country, unique opens, and total opens into the 'Geo Performance' worksheet — 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 workbook.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook 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.