The Scenario
It is 4 PM on Thursday and your marketing director wants the Q1 campaign performance numbers for the all-hands tomorrow. Total sent, in production, delivered, and returned — pulled from Stannp, written into the campaign performance workbook. The request came with a tight deadline and no instructions on how to actually get the data out of Stannp.
The bad version:
- Log into Stannp's reporting UI, set the date filter to Q1, wait for the summary to load.
- Read the status counts off the screen, switch to Excel, find the quarterly performance row, type the numbers in manually.
- Realize the Stannp UI shows counts in a different order than your workbook column layout — double-check you put delivered in column C and not returned.
- Get an email at 7 PM asking whether the numbers include test sends. Go back to Stannp to check. Correct one cell. Reply.
The quarterly performance review should not depend on how carefully you copy numbers from a UI. One wrong column and the director is presenting incorrect figures to the leadership team.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls the Stannp reporting API for the date range you specify and writes the status counts directly into the cells you point it at.
Pull the Stannp delivery report for all mailpieces in Q1 and fill this Excel table with date, status, and count for each status category.
What You Get
- One row per status category: total sent, delivered, in-production, and returned.
- The figures come directly from the Stannp API — no manual copy, no risk of transposing delivered and returned.
- The data lands in the table structure you already have in the workbook.
What If the Data Is Not Quite Ready
Date range stored as text values rather than Excel date cells
Parse the date strings in cells A1 and B1 — formatted as MM/DD/YYYY — convert them to ISO 8601, fetch the Stannp delivery summary for that range, and write the sent, delivered, in-production, and returned counts into cells C1 through C4.
Quarter-by-quarter comparison needed across multiple rows
For each row in this workbook where columns A and B contain a start and end date, fetch the Stannp delivery summary for that period and write the total sent, delivered, in-production, and returned counts into columns C through F of the same row.
Summary needs delivery rate percentage alongside raw counts
Fetch the Stannp delivery summary for the date range in cells A1 and B1, write the raw sent, delivered, in-production, and returned counts into cells C1 through C4, and write the delivery rate as a percentage in cell C5 by dividing delivered by sent.
Full quarterly performance package — fetch, calculate, and format in one pass
For each row in the Performance worksheet where columns A and B contain quarterly date ranges, fetch the Stannp delivery summary, write the raw counts into columns C through F, calculate the delivery rate into column G, and apply conditional formatting to highlight any row where the delivery rate is below 90%.
Pulling the aggregation and the rate calculation in one prompt means the director opens the workbook and the performance view is already complete.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook used for campaign reporting and ask it to pull Stannp delivery data for any date range. For the full mailpiece-level audit log, see the audit-mailpiece-log spoke. For the hub overview, see How to Connect Stannp to Excel.