The Scenario
You are a product marketer. Last month you sent a five-email onboarding sequence to every new trial user. The sequence is done running. Now you need to know which emails drove clicks and which were dead weight.
You want an Excel workbook with daily click totals and unique click counts for the past 30 days. You also want a breakdown by browser family to see whether mobile or desktop users are clicking more. The attribution meeting is Friday at 3 PM.
The slow version:
- Log into Postmark, navigate to click statistics, export the CSV
- Export the browser breakdown separately
- Open both in Excel, combine them, reformat headers, add the unique click column
- You spend the morning on admin instead of analysis.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that fetches Postmark click data and writes it into the workbook in the format you need.
Open the SheetXAI sidebar and type:
Fetch Postmark total click counts for the past 30 days and write the daily date, unique click count, and total click count into columns A, B, and C of the 'Click Stats' tab. Include a header row. Sort by date ascending.
SheetXAI calls the Postmark click stats endpoint and writes 30 rows. You have a clean table ready for a line chart before your next meeting.
What You Get
A 30-row daily click table in the 'Click Stats' tab:
- Column A — date
- Column B — unique click count
- Column C — total click count
Sorted chronologically so the trend is immediately visible. You can see which days the sequence drove traffic.
Want the browser breakdown too?
Fetch Postmark click statistics grouped by browser family and write browser name and click count into columns A and B of the 'Browser Clicks' tab, sorted by count descending.
What If the Data Is Not Quite Ready
Click reporting requests always evolve after the first look.
When your boss wants click-to-open rate added
She mentioned it in standup and you did not have time to add it.
Pull Postmark click stats and open stats for the past 30 days. Write date, unique clicks, total clicks, and unique opens into columns A through D of the 'Click Stats' tab. Add column E as click-to-open rate (unique clicks / unique opens) as a percentage.
When you want to compare the first 15 days versus the last 15
You want to see whether the sequence front-loaded or back-loaded its engagement.
Fetch Postmark click stats for the past 30 days. In the 'Click Comparison' tab: write days 1–15 in columns A–C (date, unique clicks, total clicks). Write days 16–30 in columns E–G in the same format. In column I, write the sum of unique clicks for each half labeled 'First 15 days' and 'Last 15 days'.
When you need the browser breakdown alphabetically
The VP of Design wants it sorted by browser name, not click volume.
Fetch Postmark click statistics grouped by browser family and write browser name and click count into columns A and B of the 'Browser Clicks' tab, sorted alphabetically by browser name ascending.
When you need the full click brief — daily trend, browser breakdown, CTR, and a summary all in one shot
The attribution meeting is in two hours.
Fetch Postmark click and open stats for the past 30 days. In the 'Click Stats' tab: write date, unique clicks, total clicks, unique opens, and click-to-open rate into columns A through E. Add a totals row at the bottom. In 'Browser Clicks': write browser name and click count sorted by count descending. Add a summary row at the top of 'Click Stats' showing total clicks, total unique clicks, average daily CTR, and the day with the highest unique click count.
The pattern: instead of pulling data and calculating metrics separately, you ask for the complete attribution brief in one prompt.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull Postmark click analytics into any workbook you have open. The Postmark integration is included in every SheetXAI plan. For related workflows, see how to pull Postmark daily send stats in Excel or the Postmark in Excel overview.