The Scenario
You are a marketing analyst. For the past six months, your team has run A/B tests on every campaign, always two variants with different subject lines. You have 15 campaigns worth of test results in Benchmark Email.
Your marketing director wants to know which subject line patterns win. Urgency words? Questions? Personalization? She wants the analysis in an Excel workbook by end of week so she can filter it herself 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 results tab, write down variant A and B subject lines, open rates, and winner
- Paste them into the workbook
- Repeat for all 15 campaigns
- Try to eyeball patterns across 15 rows of subject lines
- You finish 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 Excel workbook that pulls A/B test results from Benchmark Email and does the pattern analysis in the same step.
Open the SheetXAI sidebar and type:
Fetch A/B split test results from Benchmark Email for each campaign ID in column A of my workbook 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 in a second tab. Ready before you send your next message.
What You Get
A structured A/B test log across all 15 campaigns:
- Subject line A and B — 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
- Winning variant — which variant Benchmark Email called the winner, column H
- Summary tab — three pattern observations from the actual data
The pattern observations are grounded in the data. If urgency words won 11 of 15 tests, the summary says that.
What If the Data Is Not Quite Ready
When Benchmark Email returns subject lines with HTML encoding artifacts
Fetch A/B test results for all campaign IDs in column A. Decode any HTML entities in the subject lines 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 each subject line tagged by pattern type
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 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
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, 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 subject line recommendation for the next campaign
Fetch A/B test results for all campaign IDs in column A. Write the comparison table into columns B through H. Decode any HTML entities. Then in the Summary tab, write three observations about winning patterns, and at the bottom write a recommended subject line for our summer product launch campaign based on what has worked in these 15 tests.
The pattern: collect the historical data and extract the actionable recommendation in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a workbook 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 campaign engagement stats in Excel or the Benchmark Email in Excel overview.