The Scenario
Your content marketing manager asked for a quarterly review of newsletter performance last Tuesday. It's Thursday. You told her you'd pull the numbers from Curated.
Your Curated publication has been running for fourteen months. Fifty-two issues. The performance data — open rate, click rate, publish date, issue title — lives inside Curated's dashboard, one issue at a time.
The bad version:
- Open Curated, navigate to issue 1, write down the open rate and click rate, go back, open issue 2, write them down, go back.
- Realize around issue 15 that you should have been logging publish dates too. Start over.
- Get to issue 52, paste everything into an Excel workbook, realize your open rates are formatted as decimals in Curated and percentages in your workbook, fix the formatting, build the chart, send it.
The quarterly review was supposed to be about editorial insights. You've spent three hours doing data collection.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your data and, through its built-in Curated integration, can pull performance history for every issue in your publication — not one at a time.
Open the SheetXAI sidebar and paste this:
Pull the performance stats for every issue in my Curated publication into an Excel sheet and add a column ranking issues by click rate from highest to lowest
What You Get
- Every published issue from your Curated publication is written into the workbook, one row each, with issue number in column A, title in column B, publish date in column C, open rate in column D, and click rate in column E.
- Column F contains a ranking by click rate, with 1 assigned to the highest-performing issue.
- Rates are formatted as percentages so they're ready to chart without a formatting step.
What If the Data Is Not Quite Ready
You want to flag which issues beat the average
Pull all published Curated issues into the "Performance" worksheet with title, publish date, open rate, and click rate. Calculate the average open rate across all issues. In column F, write "Above average" or "Below average" based on each issue's open rate relative to that mean.
You only want data from a specific date range
Pull all Curated issues published between January 1, 2025 and December 31, 2025. Write issue title, publish date, open rate, and click rate into the "2025 Performance" worksheet — one row per issue.
You want to compare open rate trend across consecutive issues
Export all published Curated issues into the "History" worksheet — issue number in A, title in B, publish date in C, open rate in D, click rate in E. In column F, write the change in open rate compared to the previous issue: a positive number if it went up, a negative number if it went down, and "First issue" for row 1.
Full performance audit with ranking, trend flag, and summary stats in one shot
Pull all published Curated issues into the "History" worksheet — issue number in A, title in B, publish date in C, open rate in D, click rate in E. Rank each issue by click rate in column F (1 = highest). In column G, flag "Improving" if the issue's open rate is higher than the previous issue's, "Declining" if lower, and "Flat" if within 1 percentage point. Add a summary row at the top with average open rate, average click rate, highest-performing issue title, and total issue count.
One prompt, complete picture — no intermediate steps.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull your complete Curated issue history with open and click rates. You can also bulk-import links to a draft or export your subscriber list for CRM cross-referencing — the other guides in this series cover both.