The Scenario
You are a digital marketer at a mid-size e-commerce brand. The quarterly stakeholder review is Thursday. Your CMO wants a slide showing email channel performance for the past year, and the data is all in Brevo.
You have sent 30 email campaigns in the past twelve months. You need campaign name, send date, recipient count, open rate, and click rate in an Excel workbook by Wednesday afternoon so you can build the chart and write the commentary.
The bad version of this week:
- You go to Brevo's Reports tab and export campaign statistics as CSV
- You open it in Excel and the column names do not match what you want in the chart
- You spend thirty minutes reformatting headers and fixing the layout
- You realize the export only goes back six months by default
- You repeat the export with an earlier date range, get another file, and combine them
- You deduplicate the overlapping rows
- You realize the open rate column is a decimal and your chart expects a percentage
- You are still fixing the workbook at 11 PM on Wednesday.
The fast version is one prompt and the chart data is ready before lunch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls Brevo campaign data directly, so you get the columns you need in the format you need them.
Open the SheetXAI sidebar and type:
Pull all sent Brevo email campaigns from the past 12 months into the Campaigns tab of this workbook. Include campaign name, send date, total recipients, open rate as a percentage, and click rate as a percentage. Sort by send date ascending. Write results starting from row 2 with headers in row 1.
SheetXAI calls Brevo's campaign API, pulls all 30 campaigns, converts the open and click rates to percentages, and writes them sorted by date into the Campaigns tab. Done before your second coffee.
What You Get
A clean Excel workbook tab with one row per campaign:
- Campaign name — exactly as it appears in Brevo
- Send date — formatted as a date, not a Unix timestamp
- Total recipients — the count Brevo delivered to
- Open rate — expressed as a percentage (e.g. 24.3, not 0.243)
- Click rate — same
The rows are sorted by send date, so you can drop the data directly into a chart without reordering anything. No reformatting. No CSV merge. No unit conversion by hand.
Want to add subject line and sender name for the slide's footnotes? Add those fields to the prompt. SheetXAI pulls whatever columns Brevo exposes.
What If the Data Is Not Quite Ready
Campaign data gets messy when you are filtering, comparing, or calculating derived metrics.
When you want to filter by campaign type
You ran a mix of newsletters and promotional campaigns and the stakeholder slide should show them separately.
Pull all sent Brevo email campaigns from 2025 into the Campaigns tab. Include campaign name, type, send date, recipient count, open rate as a percentage, and click rate as a percentage. Add a "Type" column labeling each row "Newsletter" or "Promo" based on whether the word "newsletter" appears in the campaign name. Sort by type, then by send date.
When you need quarter-over-quarter comparison
The CMO wants to see Q1 vs Q2 vs Q3 vs Q4 performance in the same view.
Pull all Brevo email campaigns sent in 2025 into the Campaigns tab. Add a "Quarter" column derived from the send date. Then create a Summary tab with one row per quarter showing average open rate and average click rate for each quarter.
When some campaigns are tests and should be excluded
You have a handful of A/B test sends with small recipient counts that would skew the averages.
Pull all sent Brevo email campaigns from the past 12 months. Exclude any campaign with fewer than 500 recipients. Include campaign name, send date, recipient count, open rate as a percentage, and click rate as a percentage. Write results into the Campaigns tab.
When you need the full analysis in one shot for the board slide
The CMO also wants to know the best-performing campaign by open rate, the worst by click rate, and whether there is a seasonal trend — all in the same workbook.
Pull all 30 Brevo email campaigns from the past year into the Campaigns tab with campaign name, send date, recipient count, open rate as a percentage, and click rate as a percentage. Identify the top 3 campaigns by open rate and the bottom 3 by click rate, and write those findings into a Highlights tab. Also check whether open rates are higher in Q4 than the rest of the year and write a one-sentence finding in cell A1 of the Highlights tab.
The pattern: instead of pulling the data and then doing the analysis separately, ask for both in one prompt. The CMO gets a workbook that is already half a presentation.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to pull your Brevo campaign stats. The Brevo integration is included in every SheetXAI plan. For related workflows, see how to export Brevo contacts for a data audit in Excel or the Brevo in Excel overview.