The Scenario
You are an email strategist. Every quarter, the VP of Marketing wants the same thing: a Google Sheet showing engagement metrics for every campaign sent in the past three months. Open rate, click rate, bounce count, unsubscribes. Across 20 campaigns.
Q2 ended last week. The quarterly review is Friday at 2 PM.
The slow version:
- Log into Benchmark Email
- Click into campaign 1, read the stats, write them down
- Switch to Google Sheets, paste the numbers into the right row
- Go back to Benchmark Email, find campaign 2
- Repeat for 20 campaigns
- Realize you transposed the click rate for campaign 11
- Fix it
- The review is in an hour and the chart still does not exist.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls campaign stats from Benchmark Email directly and writes them into the sheet, so you do not have to read a single dashboard manually.
Open the SheetXAI sidebar and type:
Fetch Benchmark Email engagement statistics for all campaign IDs in column A of my sheet and write campaign name, send date, open rate, click rate, bounce count, and unsubscribe count into columns B through G. Add a summary row at the bottom showing averages for each metric.
SheetXAI calls Benchmark Email for every campaign ID in column A, writes the stats into columns B through G, and drops a summary row at the bottom. The sheet is ready before you have finished your coffee.
What You Get
A complete engagement table across all 20 campaigns:
- Campaign name and send date — columns B and C, pulled directly from Benchmark Email
- Open rate, click rate — percentages as returned by the API, columns D and E
- Bounce count, unsubscribe count — raw numbers, columns F and G
- Summary row — averages across all metrics so the VP can see the quarter at a glance without doing the math
The data is directly from Benchmark Email's reporting API, not a CSV export. If a campaign is still accumulating opens, you get the most current number, not a snapshot from last week.
What If the Data Is Not Quite Ready
Campaign ID sheets from quarterly planning docs are rarely clean.
When the campaign names from Benchmark Email use internal codes instead of readable names
The API returns names like "Q2_NL_05_23" and you need them to say "May Newsletter."
Fetch engagement stats for all campaign IDs in column A. Write the Benchmark Email campaign name into column B as-is, then write a cleaned readable name into column C by replacing underscore separators with spaces and removing the "Q2_" prefix. Write all other stats into columns D through H.
When you need to flag campaigns below the open-rate threshold
Your benchmark is 20% open rate. Anything below that is a problem and the VP wants them highlighted.
Fetch engagement stats for all campaign IDs in column A. Write results into columns B through G. In column H, write "Below threshold" for any campaign with an open rate under 20%, and "OK" for everything else.
When the campaign ID list includes a few campaigns from last quarter
The sheet was built from a running campaign log and has some Q1 IDs mixed in. You only want Q2.
Fetch engagement stats for all campaign IDs in column A. Only include campaigns with a send date between April 1 and June 30. Skip any campaign outside that window and write "Out of range" in column B for those rows. Write stats for qualifying campaigns into columns B through G.
When you need the engagement table plus a full interpretation for the VP's slide deck
The numbers exist. What the VP actually needs is the story: which campaigns underperformed, which exceeded expectations, and what to try differently next quarter.
Fetch Benchmark Email engagement stats for all campaign IDs in column A — write name, send date, open rate, click rate, bounce count, and unsubscribes into columns B through G. Calculate averages in a summary row. Then in a second tab called "Q2 Narrative," write a plain-English summary: three campaigns that overperformed and why, three that underperformed, and two recommendations for Q3 based on the patterns.
The pattern: pull the data and interpret it in one prompt. The sheet and the narrative come out together.
Try It
Get the 7-day free trial of SheetXAI and open a sheet with Benchmark Email campaign IDs in column A, then ask SheetXAI to pull the quarterly engagement stats. The Benchmark Email integration is included in every SheetXAI plan. See also how to pull A/B test results into Sheets or the Benchmark Email in Google Sheets overview.