The Scenario
The school district's annual safety communications audit lands on the compliance officer's desk on a Thursday afternoon. The auditors want a full record of every broadcast sent in the past 12 months — broadcast name, date, type (voice or SMS), and recipient count — submitted by end of week.
There is no report. There's a DialMyCalls UI with paginated history and no bulk export button.
She's been in this situation before. Last year she spent three hours clicking through pages of broadcast records, copying totals into a workbook row by row, and still had to go back and fill gaps she missed. The auditors asked follow-up questions. She had to repeat the whole process for a narrower date range.
The bad version:
- Log into DialMyCalls, open the broadcast history view, and start clicking through pages — 20 records at a time.
- Manually enter each broadcast name, send date, type, and recipient count into a new Excel worksheet row.
- Realize page 7 has a date filter issue and you've been looking at the wrong year for the last 45 minutes.
The audit covers 12 months of broadcasts, not an afternoon of clicking. That's probably north of 200 individual records, and nobody's budget for this task includes four hours of data entry.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the workbook and through its DialMyCalls integration it can pull broadcast history — paginating through all records automatically — and write the results into a new worksheet in a single operation. Open the sidebar and ask.
Get all call broadcasts from DialMyCalls for the last 12 months and write broadcast name, send date, type, and recipient count into a new 'Broadcast Log' worksheet, sorted by send date descending.
What You Get
- A new 'Broadcast Log' worksheet created and populated automatically.
- Columns: Broadcast Name, Send Date, Type (voice/SMS), Recipient Count.
- Records sorted with the most recent at the top.
- All pages of history fetched in one pass — no manual pagination.
What If the Data Is Not Quite Ready
You only want completed broadcasts, not drafts or scheduled ones
Pull all DialMyCalls broadcasts from the last 12 months, filter to completed status only, and write broadcast name, send date, type, and recipient count into a new 'Broadcast Log' worksheet.
The audit requires voice and SMS in separate worksheets
Fetch all completed DialMyCalls broadcasts from the last 12 months. Write voice broadcasts into a 'Voice History' worksheet and text broadcasts into an 'SMS History' worksheet, each sorted by send date descending.
You need to cross-reference against a list of planned broadcast dates in column A
Fetch all completed DialMyCalls broadcasts from the last 12 months. For each date in column A of the 'Planned' worksheet, look up whether a broadcast was sent on that date and write the broadcast name in column B, or 'None found' if no match exists.
Pull the full history, flag any date gaps longer than 14 days, and format it for the auditors in one shot
Fetch all completed DialMyCalls broadcasts from the last 12 months. Write them into a new 'Audit Export' worksheet sorted by date. Then scan the send dates and flag any gap of more than 14 days between consecutive broadcasts by highlighting the row below the gap in yellow and writing 'Gap — X days' in column E.
The auditors get a clean, annotated log. The compliance officer doesn't spend Thursday afternoon clicking through UI pages.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook used for communications reporting, then ask it to pull your DialMyCalls broadcast history into a structured log. See also: Sync Opt-Outs to DialMyCalls DNC and the DialMyCalls hub overview.