The Scenario
You've been running a creative test for 30 days — 25 different Snapchat ad creatives split across two campaigns. Your creative director is asking for a "proper comparison" before you kill the bottom performers and scale the winners. The data lives across multiple ad squads and the Ads Manager UI doesn't give you the clean side-by-side view you need for a deck.
The bad version:
- Go into Ads Manager, switch the breakdown to ad level, configure a custom date range, select all the metrics you need — impressions, swipe-up rate, video view rate, spend — and generate the report.
- Download the CSV, open it in Sheets, discover that video view rate is expressed as a decimal (0.234) not a percentage, spend is in microcents not dollars, and three of the ad names contain characters that broke the column alignment.
- Fix the formatting issues, sort by swipe-up rate, and manually build the comparison chart your creative director actually wants.
You've done this three times this month already. Each run takes about 45 minutes of cleanup before the actual analysis can start.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that connects directly to the Snapchat Marketing API and writes the data into your sheet without the CSV middleman.
Get performance stats for all ads in Snapchat ad account abc123 for the last 30 days and write ad name, impressions, swipe-up rate, video view rate, and spend into columns A through E of the Creative Test tab
What You Get
- One row per ad creative across both campaigns
- Swipe-up rate and video view rate formatted as percentages
- Spend in your account's billing currency, not microcents
- All 25 rows ready for a sort by column B or C without any cleanup step
What If the Data Is Not Quite Ready
You only want stats for one campaign's ads, not the whole account
Fetch Snapchat ad-level stats for all ads in campaign ID camp_789 for the last 30 days and write ad ID, ad name, impressions, swipe-up rate, and video view rate into columns A through E
You want CPM added alongside the other metrics
Pull 30-day ad performance for all ads in Snapchat ad account abc123 — ad name, impressions, swipe-up rate, spend, and CPM into columns A through E of the Creative Test tab, formatting CPM as currency with two decimal places
Some ad names have changed and you need the ad ID as a reference column
Get 30-day stats for all ads in Snapchat ad account abc123 — ad ID in column A, ad name in B, impressions in C, swipe-up rate in D, spend in E — so we can match against the creative brief by ID even if names were edited
Full creative debrief: pull stats, rank by swipe-up rate, flag winners and cut list
Fetch 30-day Snapchat ad performance for all ads in ad account abc123 — ad name, impressions, swipe-up rate, video view rate, and spend into columns A through E — sort by swipe-up rate descending, add a Rank column in F, then write Scale in column G for the top 5 and Cut in column G for the bottom 5
The pattern: ask for the ranking logic in the same prompt and the deck-ready table is waiting for you when you come back.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your creative testing data should live, then ask it to pull the last 30 days of Snapchat ad-level stats. Related: analyzing ad squad performance, and the hub overview for all Snapchat workflows.