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 a Google Sheet, realize your open rates are formatted as decimals in Curated and percentages in your sheet, 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 Google Sheet. 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:
List all published issues from my Curated publication and write issue number, title, publish date, open rate, and click rate into my Google Sheet — one row per issue
What You Get
- Every published issue from your Curated publication is written into the sheet, 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.
- Rates are formatted as percentages so they're ready to chart without a formatting step.
- Issues are ordered by publish date, oldest to newest, so the timeline is already sorted.
What If the Data Is Not Quite Ready
You want a ranking column added automatically
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 — 1 is the best-performing issue.
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" tab — one row per issue.
You want to flag which issues beat the average
Export all published Curated issues into the "Performance" tab 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.
Full performance audit with ranking, trend flag, and summary stats in one shot
Pull all published Curated issues into the "History" tab — 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, full picture — no intermediate steps.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, 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.