The Scenario
You are a creative strategist. Every Friday you run a creative review. Your account has 60 running ads across three campaigns and you need to rank them by cost per purchase so you know which five to scale and which five to cut.
The review is at 2 PM. It is 11 AM.
The bad version of this morning:
- Open Ads Manager, switch to Ads view, add the cost per purchase column
- Export CSV
- Open in Excel — some rows have "—" instead of a number for cost per purchase
- Replace all "—" with a large number so they sort to the bottom
- Sort by cost per purchase ascending
- Realize you still need to identify the bottom five by name
- It is 12:45 and the ranked list still needs annotation.
One prompt saves the morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls ad-level insights directly and handles the no-purchase row problem inline.
Open the SheetXAI sidebar and type:
Fetch insights for all ads in our Meta Ads account for the last 30 days. Write ad name, ad set name, campaign name, spend, impressions, CTR, and cost per purchase into columns A through G. Sort by cost per purchase ascending. Where cost per purchase is not available (no purchases), put 999 in column G so those ads sort to the bottom.
SheetXAI fetches the ad-level data, handles the no-purchase rows with the placeholder, and sorts the workbook. You have your ranked list before noon.
What You Get
A ranked creative performance workbook tab:
- Column A — ad name
- Columns B–C — ad set and campaign for context
- Columns D–F — spend, impressions, CTR
- Column G — cost per purchase, with no-purchase ads sorted to the bottom
The top five and bottom five are immediately visible. The creative review becomes a conversation about the data, not a fight to find it.
What If the Data Is Not Quite Ready
Sixty running ads across three campaigns produce edge cases.
When ad names follow inconsistent naming conventions
The naming convention changed after the last creative refresh. Old ads use underscores, new ones use dashes.
Fetch last 30 days ad-level insights. In column A write the original ad name. In column B write a cleaned version: replace underscores with spaces, strip leading/trailing whitespace. Write metrics in columns C through G.
When you only want ads from one specific campaign
The creative review this week covers only the retargeting campaign.
Fetch last 30 days ad-level insights for ads in the campaign named "Retargeting — All Audiences." Write ad name, spend, impressions, CTR, and cost per purchase into columns A through E sorted by cost per purchase ascending.
When you want to separate video ads from static ads
Your creative hypothesis is that video outperforms static in the retargeting window.
Fetch last 30 days ad-level insights. In column H, write the creative format (VIDEO, IMAGE, CAROUSEL) for each ad. Then apply conditional formatting: yellow fill for VIDEO ads with ROAS above 2.0, red fill for IMAGE ads with ROAS below 1.0.
When you need the full chain: pull, classify, rank, and annotate in one prompt
You have not looked at this account in two weeks and want everything in one output.
Fetch last 30 days insights for all running ads. Write ad name, campaign, spend, impressions, clicks, purchases, and creative format into columns A through G. In column H calculate CPA (spend ÷ purchases, blank if zero purchases). Sort by column H ascending. In column I write "TOP 5" for the five ads with the lowest CPA that have at least 5 purchases, and "BOTTOM 5" for the five ads with the highest CPA.
The pattern: one prompt does the pull, the calculation, and the editorial call. You walk into the creative review with a view that would have taken your morning to build manually.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull ad-level performance into any Excel workbook you have open. The Meta Ads integration is included in every SheetXAI plan. For related work, see how to audit your full creative library in Excel or the Meta Ads in Excel overview.