The Scenario
You are a marketing analyst. For the past six months, your team has been running A/B tests on every campaign, always two variants with different subject lines. You have 15 campaigns worth of test results sitting in Benchmark Email.
Your marketing director wants to know which subject line patterns win. Urgency words? Questions? Length? Personalization? She wants the analysis by end of week, and she wants it in a Google Sheet so she can filter and share it with the broader team.
Nobody has looked at these results systematically. They have just been stacking up.
The slow version:
- Click into campaign 1 in Benchmark Email, find the A/B test results tab, write down variant A and B subject lines, open rates, click rates, and winner
- Paste them into the sheet
- Repeat for all 15 campaigns
- Then try to eyeball patterns across 15 rows of subject lines
- You finish the data entry by Thursday but the analysis never really happens.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls A/B test results from Benchmark Email and does the pattern analysis in the same step, so you do not have to collect data and think about it separately.
Open the SheetXAI sidebar and type:
Fetch A/B split test results from Benchmark Email for each campaign ID in column A of my sheet and write variant A and B subject lines, open rates, click rates, and the winner into columns B through G. Then in a Summary tab, write three observations about which types of subject lines won more often based on the data across all 15 campaigns.
SheetXAI pulls the test results for every campaign ID, writes the comparison table, and produces the summary observations in a second tab. The analysis you wanted by Thursday is ready before you send your next Slack message.
What You Get
A structured A/B test log across all 15 campaigns, plus a summary:
- Subject line A and B — the exact text of each variant, columns B and C
- Open rate A and B — columns D and E
- Click rate A and B — columns F and G (if available from Benchmark Email)
- Winning variant — which variant Benchmark Email called the winner, column H
- Summary tab — three pattern observations written from the actual data
The pattern observations are grounded in the data, not generic. If urgency words won 11 of 15 tests, the summary says that.
What If the Data Is Not Quite Ready
Fifteen campaigns of A/B test results rarely come out clean.
When Benchmark Email returns subject lines with HTML encoding artifacts
The subject lines came back with "&" instead of "&" and "'" instead of apostrophes because the API returns raw HTML-encoded strings.
Fetch A/B test results for all campaign IDs in column A. Decode any HTML entities in the subject line columns before writing them — replace & with &, ' with ', " with ". Write cleaned subject lines into columns B and C, and all other stats into columns D through H.
When you want to tag each subject line with its pattern type
Before looking for winners, you want each subject line tagged: "urgency," "question," "personalization," "benefit," or "neutral."
Fetch A/B test results for campaign IDs in column A. Write subject lines, open rates, and winner into columns B through G. For each subject line in columns B and C, add a tag in columns I and J categorizing the subject line type as: urgency, question, personalization, benefit, or neutral. Then in the Summary tab, show win rate by subject line type.
When only some campaigns had A/B tests and the rest were single-variant sends
Not every campaign ID in column A actually ran an A/B test. You want to skip the single-variant sends without failing.
Fetch results for all campaign IDs in column A. For campaigns that ran an A/B test, write the full comparison into columns B through H. For campaigns that did not run an A/B test, write "Single variant" in column B and leave the rest blank. Do not error out on non-A/B campaigns.
When you need the full analysis plus a recommendation for the next campaign's subject line
You have the pattern data. Now you want a recommendation you can actually use.
Fetch A/B test results for all campaign IDs in column A. Write the comparison table into columns B through H with subject lines, open rates, click rates, and winner. Decode any HTML entities in the subject lines. Then in the Summary tab, write three observations about winning patterns, and at the bottom write a recommended subject line for the next campaign about our summer product launch, based on what has worked in these 15 tests.
The pattern: collect the historical data and extract the actionable recommendation in one prompt. You do not need to analyze first and ask second.
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 A/B test results and find the winning patterns. The Benchmark Email integration is included in every SheetXAI plan. See also how to pull general campaign engagement stats or the Benchmark Email in Google Sheets overview.