The Scenario
You're three days out from the next budget cycle meeting. You're running 40 ad squads across 5 campaigns and you have a standing rule: pause anything in the bottom 20% by CPA before the next allocation discussion. The problem is the CPA data is in Snapchat Ads Manager and your budget sheet is in Google Sheets, and they've never been in the same place at the same time.
The bad version:
- Export a 14-day ad squad performance report from Ads Manager — remember to switch the breakdown to ad squad level, not campaign level, otherwise you get aggregated numbers that are useless for this decision.
- Open the CSV, strip the summary rows, sort by CPA, and figure out that five of the ad squads have null CPA because they had no conversions — decide whether null means "pause it" or "leave it."
- Manually note which ad squads to pause, go back into Ads Manager, find each one, pause it, and repeat for all eight candidates.
The meeting is in 72 hours and this process touches three different tools. Every sprint cycle, you spend half a day just getting the numbers into the same place as the decisions.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Google Sheet. It reads the sheet and talks to the Snapchat Marketing API so you can pull ad squad data without leaving the spreadsheet.
Fetch performance stats for all ad squads in Snapchat ad account abc123 for the last 14 days and write ad squad name, spend, swipes, and CPA into columns A through D of the Ad Squad Performance tab
What You Get
- One row per ad squad, starting at row 2
- Column A: ad squad name as it appears in Ads Manager
- Column B: total spend for the 14-day window
- Column C: total swipes (swipe-ups)
- Column D: CPA — null or zero shown explicitly so you can filter for it
- The tab is ready for a sort-by-column-D to identify your bottom performers
What If the Data Is Not Quite Ready
You only want stats for one specific campaign, not the whole account
Pull ad squad performance stats from Snapchat campaign ID camp_456 for the last 14 days and write ad squad name, spend, swipes, and CPA into columns A through D
You need swipe-up rate instead of raw swipes
Fetch the last 14 days of ad squad stats for Snapchat ad account abc123 — ad squad name, spend, swipe-up rate (as a percentage), and CPA into columns A through D, and format column C as a percentage with one decimal place
You want a bottom-performers flag added automatically
Get 14-day ad squad performance for Snapchat ad account abc123 — ad squad name, spend, swipes, CPA into columns A through D — then add a column E that says "Pause Candidate" for any ad squad where CPA is more than 50% above the average CPA across all rows
Full budget prep: pull data, rank, flag, and add account context
Fetch the last 14 days of ad squad stats across all 5 campaigns in Snapchat ad account abc123 — ad squad name, campaign name, spend, and CPA into columns A through D — sort by CPA descending, add a Rank column in E, and flag the bottom 8 as "Pause" in column F so the budget review sheet is ready to act on
One prompt replaces the export-strip-sort-annotate loop that currently burns an afternoon before every budget cycle.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your ad squad data should land, then ask it to pull the last two weeks of Snapchat performance stats. Related: exporting campaign-level stats, and the hub overview for all Snapchat workflows.