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 kill.
The review is at 2 PM. It is 11 AM. You have three hours.
The bad version of this morning:
- Open Ads Manager, switch to Ads view, set the date range to last 30 days
- Add the cost per purchase column — it is not in the default view
- Export CSV
- Open the CSV and realize hook rate is not a column in the export because it is a custom metric
- Go back to Ads Manager, create a custom column for hook rate, re-export
- Clean the CSV, paste into Google Sheets
- Sort by cost per purchase — but some rows have no purchases and show "—" instead of a number
- Spend 20 minutes replacing "—" with zeros before you can sort
- It is 12:45 and you still have not pulled the bottom five.
One prompt from inside the sheet saves the morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that pulls ad-level insights including custom metrics directly, so you do not have to reconfigure Ads Manager columns or clean export artifacts.
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, writes it with your column headers, handles the no-purchase rows with the placeholder, and sorts the sheet. You have your ranked list before noon.
What You Get
A ranked creative performance sheet:
- 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.
Want to add a column flagging ads where ROAS is below 1.5? Add it to the prompt and SheetXAI writes it inline.
What If the Data Is Not Quite Ready
Sixty running ads across three campaigns produce a lot of edge cases.
When ad names follow inconsistent naming conventions
The naming convention changed after the last creative refresh. Old ads use underscores, new ads use dashes, some have no convention at all.
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, and capitalize the first word. 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. You want the split to be visible.
Fetch last 30 days ad-level insights. In column H, write the creative format (VIDEO, IMAGE, CAROUSEL) for each ad. Then highlight in yellow any ad with format VIDEO and ROAS above 2.0, and in red any ad with format IMAGE and ROAS below 1.0.
When you need the full chain: raw pull, classification, and ranking in one shot
You have not looked at this account in two weeks. You want a fresh pull, a classification by creative type, a CPA calculation, and the top-5 / bottom-5 call-out all 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, or blank if zero purchases). Sort by column H ascending. Then 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 Google Sheet you have open. The Meta Ads integration is included in every SheetXAI plan. For related workflows, see how to audit your full creative library or the Meta Ads in Google Sheets overview.