The Scenario
You're the creative ops lead at an agency. Your Snapchat ad account has been active for 18 months and the media library has ballooned to 200-plus assets. Before your team starts building the next campaign, the creative director wants to know what's actually usable and what should be archived. Nobody has ever pulled a complete list of the creative library — the Ads Manager media browser shows 20 assets at a time and has no export.
The bad version:
- Open the Media Library in Ads Manager. Start copying asset IDs, names, types, and statuses into an Excel worksheet manually.
- Hit the next page. Copy more. After 40 assets you realize you haven't been noting the upload date, which your creative director specifically asked for.
- Start over, this time with a column for upload date. Halfway through the session times out.
200 assets at 2 minutes each is almost 7 hours of work. That's not ops, that's data entry.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can call the Snapchat Marketing API and pull your entire media library into a worksheet without pagination limits.
List all media assets in Snapchat ad account abc123 and write media ID, name, type, and status into columns A through D of the Media Audit sheet
What You Get
- One row per media asset — all 200-plus, fetched completely
- Column A: media ID
- Column B: asset name as uploaded
- Column C: type — IMAGE or VIDEO
- Column D: status (Active, Approved, Paused, etc.)
- Everything you need to filter, sort, and flag candidates for archiving
What If the Data Is Not Quite Ready
You need upload date to filter by recency
List all media assets in Snapchat ad account abc123 and write media ID, name, type, status, and upload date into columns A through E, formatting dates as YYYY-MM-DD
You only want video assets for the video creative audit
Fetch all media files from Snapchat ad account abc123 where type is VIDEO and write media ID, name, and status into columns A through C of the Video Assets sheet
You want to check which assets are currently referenced by active ads
List all media assets from Snapchat ad account abc123 — media ID in A, name in B, type in C, status in D — then check each media ID against active ads in the account and write In Use in column E for assets referenced by a live ad, and Unused in column E for assets that aren't
Full archival brief: all assets, age flags, in-use check, and prioritized cut list
Fetch all media from Snapchat ad account abc123 — media ID in A, name in B, type in C, status in D, upload date in E — then write Archive Candidate in column F for any asset uploaded more than 6 months ago that has status Approved and no active ad reference
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you're using for the creative library cleanup project, then ask it to export all media assets from your Snapchat ad account. Related: analyzing ad creative performance, and the hub overview for all Snapchat workflows.