The Scenario
You're two weeks into a 30-day creative test on Snapchat. Twenty-five different ad creatives, two campaigns, and your creative director just pinged asking for "an interim read" before the full test is done. The interim report lives nowhere — the data is scattered across ad squads in Ads Manager and has never been pulled into the Excel workbook your team uses for creative debriefs.
The bad version:
- Switch Ads Manager to ad-level breakdown. Select all 25 ads. Generate a report for the last 14 days. Export to CSV.
- Open the CSV in Excel. Discover that video view rate is expressed as a decimal (0.18) not a percentage, spend is in microcents, and one ad name has a comma in it that split the CSV column alignment for six rows.
- Spend 20 minutes on formatting, then another 10 building a table your creative director can actually read.
An interim read shouldn't require a data cleanup session. But that's where you end up every time you try to bridge Snapchat and Excel without a direct connection.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Excel workbook and connects to the Snapchat Marketing API, pulling ad-level data directly into a worksheet without the CSV step.
Get performance stats for all ads in Snapchat ad account abc123 for the last 14 days and write ad name, impressions, swipe-up rate, video view rate, and spend into columns A through E of the Creative Test sheet
What You Get
- One row per ad creative, covering all 25
- Swipe-up rate and video view rate formatted as percentages
- Spend in your billing currency, not microcents
- All rows ready to sort on any metric column without cleanup
What If the Data Is Not Quite Ready
You only want stats for ads in one specific campaign
Fetch Snapchat ad-level performance for all ads in campaign ID camp_789 for the last 14 days and write ad name, impressions, swipe-up rate, and spend into columns A through D
You want CPM alongside the other metrics for a cost-efficiency view
Pull 14-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, formatting CPM as currency with two decimal places
You need ad ID as a reference column because some ad names changed mid-test
Get 14-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, and spend in E — so we can match back to the creative brief even after name edits
Full creative debrief: pull stats, rank, label winners and cut candidates
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 for the bottom 5
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook your team uses for creative reviews, then ask it to pull the current Snapchat ad-level stats. Related: analyzing ad squad performance, and the hub overview for all Snapchat workflows.