- AI-Agent
- Ready to Run
Compile SMS Delivery Reports
Match campaign receipts and report delivery in your sheet
Use this Agent instantly or customize it - no programming needed
- Campaign ready noticeCampaign ready notice
You mark the campaign Ready for report after its final text sends.
- Campaign detailsCampaign details
Your campaign tag identifies the send, and its end time sets the pending deadline.
- Recipient send logRecipient send log
Your send log ties each intended recipient to a message ID and send result.
- Delivery receiptsDelivery receipts
Your receipt events show each message's status, event time, and any failure reason.
- Pending time limitPending time limit
You choose when a pending text needs follow-up.
Your campaign sheet starts the report and keeps recipient statuses, delivery totals, and follow-up names.
Brevo provides delivery events for the campaign tag, including message IDs and failure reasons.
- Reporting issueReporting issue
Your campaign row shows missing details or a receipt retrieval error.
- Reporting issueReporting issue
Your campaign row shows missing details or a receipt retrieval error.
- Delivery reportDelivery report
Your dated report shows delivery totals, each recipient's status, and any unresolved matches.
- Follow-up listFollow-up list
Your list names failed and overdue pending recipients, with their phone numbers and reasons.
This Agent waits for your campaign to be ready for a report. It matches text delivery receipts to your send log. You get delivery totals and a follow-up list in your campaign sheet.
Modify Agent
Customize this Agent to fit your needs using natural language.
Start Agent for Free
Enter your email address and we will send you a secure link to continue.
Google SheetsUsed as:
- Campaign sheet
Google Sheets starts the report and keeps recipient statuses, delivery totals, and follow-up names.
AirtableUsed as:
- Campaign sheet
Airtable starts the report and keeps recipient statuses, delivery totals, and follow-up names.
BrevoUsed as:
- Text messaging service
Brevo provides delivery events for the campaign tag, including message IDs and failure reasons.
Microsoft ExcelUsed as:
- Campaign sheet
Microsoft Excel starts the report and keeps recipient statuses, delivery totals, and follow-up names.
Microsoft Office 365Used as:
- Campaign sheet
Microsoft Office 365 starts the report and keeps recipient statuses, delivery totals, and follow-up names.
SmartsheetUsed as:
- Campaign sheet
Smartsheet starts the report and keeps recipient statuses, delivery totals, and follow-up names.
KintoneUsed as:
- Campaign sheet
Kintone starts the report and keeps recipient statuses, delivery totals, and follow-up names.
Made for your industry
Compile SMS Delivery Reports is made for businesses in these industries.
- Advertising and Marketing
Show which client campaign texts arrived and which need follow-up.
Show all Agents for the Advertising and Marketing industry - Retail
Count delivered promotional texts and flag shoppers needing follow-up.
Show all Agents for the Retail industry - Nonprofit Organizations
Flag donor outreach texts that failed or still await a delivery result.
Show all Agents for the Nonprofit Organizations industry - Political Organizations
Track delivery of voter outreach texts and flag people needing follow-up.
Show all Agents for the Political Organizations industry
Made for your role
Compile SMS Delivery Reports is made for people in these roles.
- Campaign Manager
Reconcile text campaign deliveries and show who needs follow-up.
Show all Agents for the Campaign Manager role - Campaign Coordinator
Update the campaign sheet with delivery counts and follow-up names.
Show all Agents for the Campaign Coordinator role - Marketing Operations Coordinator
Match text receipts to send logs and publish campaign delivery totals.
Show all Agents for the Marketing Operations Coordinator role - Marketing Manager
Show text campaign delivery totals and contacts needing follow-up.
Show all Agents for the Marketing Manager role - Outreach Coordinator
Find contacts whose campaign texts failed or still lack a receipt.
Show all Agents for the Outreach Coordinator role - Digital Marketer
Report delivery results for bulk text campaigns beside the send list.
Show all Agents for the Digital Marketer role - Fundraiser
Show which donor campaign texts arrived and which need follow-up.
Show all Agents for the Fundraiser role - Customer Communications Coordinator
Track message delivery by recipient and flag contacts for follow-up.
Show all Agents for the Customer Communications Coordinator role
Made for your department
Compile SMS Delivery Reports is made for people in these departments.
- Marketing
Add text delivery totals and follow-up contacts to campaign reports.
Show all Agents for the Marketing department - Communications
Report text delivery by recipient and flag unresolved messages.
Show all Agents for the Communications department - Outreach
Show which outreach texts arrived and which contacts need follow-up.
Show all Agents for the Outreach department - Fundraising
Flag failed donor texts and overdue delivery receipts for follow-up.
Show all Agents for the Fundraising department
How Compile SMS Delivery Reports works
4 steps, in order, on every run.
-
Read the Campaign Send LogRead the campaign and intended recipients when you mark the send ready for its report. Note a missing campaign tag or send log on the campaign row.
-
Gather SMS Delivery ReceiptsRead every page of receipts for your campaign tag through report time. Leave the report unfinished if receipt retrieval fails.
-
Match Receipts to RecipientsMatch receipts by message ID and phone number. Classify every recipient as delivered, failed, or pending. Flag unclear matches for review.
-
Write the Delivery ReportWrite delivery totals and recipient statuses to your campaign sheet. Add failed and overdue pending texts to your follow-up list.
How to Get Started
Connect the tools you already use, such as Google Sheets, Airtable or Brevo.
7 tools
- Connect the campaign sheet and SMS account, and choose the campaign table and recipient send-log table.
- Store one unique campaign tag on each campaign row and apply it to every text sent for that campaign; keep each intended recipient's name, phone number, message ID, and send result in the sheet.
- Mark a campaign Ready for report only after its bulk send has ended, and choose how long an undelivered message may remain pending before it appears on the follow-up list.
Use safe mode to approve every result before it goes out, or let the Agent run automatically.
FAQs
Frequently asked questions about the Compile SMS Delivery Reports:
Connect your campaign sheet and SMS account. Choose the campaign and send-log tables. Keep recipient details and message IDs in the send log.
Mark a campaign Ready for report after its last text goes out. That change starts the report for your campaign.
A missing receipt leaves that recipient pending. You choose when pending texts need follow-up. You review unclear matches and conflicting results.
No. A delivery receipt confirms arrival at the recipient's phone. It does not show whether they read the text.
It stops and asks you. The Agent does not guess when it reaches a decision you have not approved.
Yes. Every run creates a plain-language log that you can review and export. Logs are kept for twelve months.
The Agent stops at the end of the billing month and its tool connections are removed. Your run logs remain available for twelve months.