The Scenario
You ran a MSG91 Segmento campaign yesterday. The expected event count was 600. The dashboard shows 600 sent, but the delivery confirmation numbers don't add up. You're a growth engineer, and you know from experience that "sent" and "delivered" are not the same thing in Segmento. There are failed events somewhere, and they have reasons attached. You need them in a Google Sheet so you can read the failure patterns and fix the data.
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 — assuming there is one in the UI.
- Scroll through failed events one at a time, copying event IDs, failure reasons, and timestamps into a blank sheet.
- Realise the UI doesn't make it obvious how many failures there are or whether you've seen them all.
You end up with a partial list, no confidence it's complete, and a fix process that can't start until you have a real count.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. 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 campaign CAMP-8821 is written to the sheet — event ID in column A, failure reason in column B, timestamp in column C.
- The list is complete — pulled via API, not scrolled from a paginated UI.
- You can immediately sort by failure reason to identify the patterns causing the most failures.
What If the Data Is Not Quite Ready
You have multiple campaign IDs to check in bulk
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 from a specific date range
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.
You want to join failures against the original send list on a second tab
Fetch all failed events for MSG91 Segmento campaign 'CAMP-8821' and write event ID and failure reason to the 'Failed Events' tab, then in column C mark any event ID that appears in the original send list on the 'Send List' tab as 'matched'.
Pull failures, categorise by reason, count each category, surface the top issue — one prompt
Fetch all failed events for MSG91 Segmento campaign 'CAMP-8821', write the raw data to the 'Raw Failures' tab, then on the 'Summary' tab write each distinct failure reason, its count, and its percentage of total failures, sorted by count descending.
That prompt gives you 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 Google Sheet after your next Segmento campaign run, then ask it to pull all failed events for the campaign ID so you can start debugging immediately. See the sibling spoke on exporting the full Segmento campaign list or return to the MSG91 hub.