The Scenario
You are an email marketing manager at an ecommerce brand. You are running a creative retrospective next Friday — two hours with the creative team to decide which email formats, subject line styles, and campaign types to double down on for the second half of the year.
You need a six-month campaign comparison in a Google Sheet before that meeting: campaign name, channel, send date, open rate, click rate, and attributed revenue. And you need it sorted by revenue so the team can see at a glance which sends actually drove purchasing, not just opens.
The bad version of this week:
- You open Omnisend's reports section
- Filter to the past 6 months
- See the aggregate numbers but not the per-campaign breakdown you need
- Export what you can, realize it does not include attributed revenue in the same file
- Export separately, paste together, realize the campaign names are slightly different between exports
- Spend two hours reconciling before you can even start the analysis
- Go into the retrospective with a half-finished spreadsheet.
The fast version is one prompt and the comparison is ready before your next coffee.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the Omnisend API and writes the campaign data directly into your sheet, sorted and structured the way you need it, so you do not have to reconcile mismatched exports.
Open the SheetXAI sidebar and type:
List all Omnisend campaigns from the past 6 months and write campaign name, channel, send date, open rate, click rate, and total revenue into columns A through F — sort by revenue descending.
SheetXAI calls the Omnisend campaigns endpoint, extracts the fields you named, and writes the sorted table into the sheet.
What You Get
A single table covering every campaign from the past six months:
- Campaign name in column A — pulled directly from Omnisend, no reconciliation needed
- Channel in column B — email or SMS, so you can filter later
- Send date in column C — formatted consistently
- Open rate and click rate in columns D and E — percentages, ready to sort or chart
- Total attributed revenue in column F — sorted descending so your top performers are at the top
The sort is built into the pull. You do not have to do it manually after the data lands.
From here, you can ask SheetXAI to add a column G with cumulative revenue, showing which campaigns drove 80 percent of total revenue for a Pareto analysis.
What If the Data Is Not Quite Ready
Campaign data pulled from APIs always has some quirks. SheetXAI handles them inline.
When campaign names include test sends
The list includes A/B test variants and internal test sends that should not be in the retrospective comparison.
List all Omnisend campaigns from the past 6 months. Exclude any campaign where the name contains "test," "Test," or "TEST." Write the filtered results into columns A through F sorted by revenue descending.
When you want to see email and SMS separately
The team wants to compare email campaigns on their own before comparing across channels.
List all Omnisend campaigns from the past 6 months. Write email campaigns into sheet tab "Email Campaigns" and SMS campaigns into sheet tab "SMS Campaigns," each sorted by revenue descending. Add a summary row at the top of each tab showing total revenue and average open rate for that channel.
When you need to flag campaigns with below-average open rates
Some campaigns had great revenue but poor open rates, which suggests the subject line did not carry the load. You want those flagged.
After writing the campaign list to columns A through F, add a column G. For any campaign where the open rate is below the average open rate for all campaigns in the list, write "LOW OPEN RATE" in column G.
When you want the full Pareto breakdown built in one shot
You want the pull, the cumulative revenue column, and the 80-percent cutoff identified all in one prompt.
Fetch all Omnisend campaigns from the past 6 months. Write campaign name, channel, send date, open rate, click rate, and revenue into columns A through F sorted by revenue descending. Add a column G with cumulative revenue as a running total. Add a column H that marks each row as "Top 80%" until the cumulative total crosses 80 percent of total revenue, then marks remaining rows as "Tail." Write the full count of campaigns in cell I1.
The pattern: instead of pulling the data and then doing the analysis in a separate step, you describe both in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull your Omnisend campaign stats. The Omnisend integration is included in every SheetXAI plan. For related workflows, see how to export order history for attribution or the Omnisend in Google Sheets overview.