The Scenario
It's the Friday before your agency's weekly optimization call and your performance marketer just messaged asking for "the ad squad breakdown" for the Snapchat account. You're running 40 ad squads across 5 campaigns and she needs spend, swipe-up rate, and CPA for each one before 9 AM Monday. The data is in Ads Manager. Your budget workbook is in Excel. They have never talked to each other.
The bad version:
- Switch the Ads Manager breakdown to ad squad level rather than campaign level — an easy setting to miss that gives you completely different aggregation.
- Export the report as CSV, open in Excel. The CPA column is missing for any ad squad that had no conversions — Excel shows it as blank, which messes up the sort.
- Sort by CPA ascending, realize you need to decide whether null CPA means "pause it" or "keep it," add a manual flag column, and send the file.
The optimization call is the same time every week. This is the same process every Friday. The 45-minute data pull-and-clean cycle is baked into the ritual.
The Easy Way: One Prompt in SheetXAI
SheetXAI sits inside your Excel workbook and connects to the Snapchat Marketing API so you can pull ad squad data without leaving the file.
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 sheet
What You Get
- One row per ad squad across all 5 campaigns
- Column A: ad squad name exactly as it appears in Ads Manager
- Column B: total spend for the 14-day window
- Column C: total swipe-ups
- Column D: CPA — shown as zero or null explicitly, not silently dropped
- Ready for a sort on column D to pull your bottom performers immediately
What If the Data Is Not Quite Ready
You only want ad squads from one specific campaign
Pull ad squad performance 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 as a percentage rather than raw swipes
Get 14-day 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, formatting column C as a percentage with one decimal place
You want an automatic flag for pause candidates
Fetch 14-day ad squad performance for Snapchat ad account abc123 — ad squad name, spend, swipes, CPA into columns A through D — then add column E that says Pause Candidate for any ad squad where CPA is more than 50% above the average CPA across all rows
Full optimization prep: pull data, add campaign context, rank, and flag
Get 14-day ad squad stats across all 5 campaigns in Snapchat ad account abc123 — ad squad name in A, campaign name in B, spend in C, CPA in D — sort by CPA descending, add a Rank column in E, and mark the bottom 8 with Pause in column F so the optimization workbook is ready Monday morning
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your weekly optimization data should land, then ask it to pull the last 14 days of Snapchat ad squad stats. Related: exporting campaign-level performance, and the hub overview for all Snapchat workflows.