The Scenario
You are on a deliverability team managing four sending domains in Mailtrap. Over the last 30 days, your overall bounce rate has been climbing but the aggregate number does not tell you which domain is causing it.
You need the per-domain breakdown in an Excel workbook so you can run the analysis and identify which domain's DNS records need attention before the next major send in five days.
The slow version:
- You log into Mailtrap and look for a domain-level breakdown
- The default view shows all domains combined
- You filter by domain one at a time, write down the number, switch
- By domain three you realize you need two months of data, not one
- You repeat the filtering for the second month
- You spend Tuesday doing data entry and have no time to fix the DNS.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls the Mailtrap domain-level stats and writes the comparison table directly into the workbook.
Open the SheetXAI sidebar and type:
Fetch Mailtrap sending stats for the last 30 days grouped by sending domain. Write each domain's name, delivered count, bounce rate, open rate, and spam rate into columns A through E of the Stats tab. Sort by bounce rate descending.
SheetXAI pulls the stats for all four domains and writes the sorted comparison. The domain causing the problem is in row 2.
What You Get
A ranked comparison table:
- Columns A–E — domain name, delivered count, bounce rate, open rate, spam rate
- Sorted — highest bounce rate first
- All domains in one table — no switching between Mailtrap filter views
You see the problem domain immediately. From here, ask SheetXAI to add a "DNS Remediation Priority" column and flag any domain above your threshold.
What If the Data Is Not Quite Ready
Domain comparisons get more useful when you can see trends, not just a single period. SheetXAI handles multi-period pulls in the same prompt.
When you need two months side by side
Fetch Mailtrap sending stats grouped by sending domain for March 2026 and April 2026 separately. Write March data into columns A through E and April data into columns G through K with the same structure so I can compare month over month for each domain.
When you only want domains above a bounce rate threshold
Fetch Mailtrap sending stats grouped by sending domain for the last 30 days. Filter to domains where bounce rate exceeds 2%. Write name, delivered count, bounce rate, and spam rate into columns A through D for flagged domains only. Write the count of flagged domains into cell F1.
When you need bounce rate expressed as a percentage
Fetch Mailtrap sending stats grouped by domain for the last 30 days. Write domain name, delivered count, and bounced count into columns A through C. Calculate bounce rate as bounced divided by (delivered plus bounced) and write it as a percentage into column D. Sort by column D descending.
When you need the domain comparison plus a written escalation summary
Fetch Mailtrap sending stats grouped by sending domain for the last 30 days. Write the full comparison table into columns A through E sorted by bounce rate descending. Write a two-sentence escalation summary into cell G1 identifying the domain with the highest bounce rate, its rate compared to the next-worst domain, and the recommended first remediation step.
The pattern: pull the data and the interpretation in one prompt. The escalation ticket is ready for the DNS team without a separate analysis pass.
Try It
Get the 7-day free trial of SheetXAI and open any workbook you use for deliverability monitoring, then ask it to pull the Mailtrap domain-level breakdown. The Mailtrap integration is included in every SheetXAI plan. See also how to compare stats by email service provider or the Mailtrap in Excel overview.