The Scenario
You ran a MSG91 Segmento campaign yesterday. Expected event count: 600. The dashboard says 600 sent, but delivery numbers don't reconcile. You're a growth engineer and you know Segmento distinguishes between sent and delivered. Failed events have reasons attached. You need them in an Excel workbook so you can read the failure patterns and fix the data before the campaign re-run tomorrow morning.
The campaign ID is CAMP-8821. The failure data is inside MSG91. The gap is everything in between.
The bad version:
- Log into MSG91 Segmento, navigate to the campaign, find the failed events section.
- Scroll through failed events one at a time, copying event IDs, failure reasons, and timestamps into a blank worksheet — while not knowing if the UI is showing you the complete list.
- Build a manual frequency table by scanning the failure reason column by eye.
You end up with a partial picture, a lot of uncertainty about completeness, and a re-run that starts on shaky ground.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It calls the MSG91 Segmento API and pulls every failed event for the campaign you specify.
Fetch all failed events for MSG91 Segmento campaign ID 'CAMP-8821' and write the event ID, failure reason, and timestamp to this sheet.
What You Get
- Every failed event for CAMP-8821 is written to the workbook — event ID in column A, failure reason in column B, timestamp in column C.
- The list is complete — pulled via API, not scraped from a paginated UI.
- You can sort by failure reason immediately to find the dominant pattern.
What If the Data Is Not Quite Ready
Multiple campaign IDs to check at once
For each campaign ID in column A, retrieve the failed events from MSG91 Segmento and write the failure count and most common failure reason to columns B and C.
You only want failures within a specific time window
Fetch all failed events for MSG91 Segmento campaign 'CAMP-8821' where the timestamp is within the last 48 hours, and write the event ID, failure reason, and timestamp to columns A through C.
Join failures against the original send list on a second worksheet
Fetch all failed events for MSG91 Segmento campaign 'CAMP-8821' and write event ID and failure reason to the 'Failed Events' worksheet, then in column C mark any event ID that also appears in the 'Send List' worksheet column A as 'matched'.
Pull failures, categorise, count, surface top issue — one prompt
Fetch all failed events for MSG91 Segmento campaign 'CAMP-8821', write the raw data to the 'Raw Failures' worksheet, then on the 'Summary' worksheet write each distinct failure reason, its count, and its percentage of total failures, sorted by count descending.
Both the raw data and the diagnostic summary, without running a separate pivot table.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook after your next Segmento campaign run, then ask it to pull all failed events for the campaign ID so you can start debugging without guessing. See the sibling spoke on exporting the Segmento campaign list or return to the MSG91 hub.