The Scenario
You just inherited the Snapchat account after the strategist who set it up left the company. She built audience segments over 18 months and nobody knows what half of them are. Before the agency consolidates the account structure, your director wants a master list of every segment — name, type, status, and approximate reach — so overlapping audiences can be merged or removed.
You open Snapchat Ads Manager and click into the Audience Manager. There's no "export all" button.
The bad version:
- Click through each segment one by one to copy the name, type, status, and user count into a spreadsheet by hand.
- Realize partway through that the Audience Manager paginates at 50 results and you have at least 80 segments — so you have to load the next page, then the next, and keep going.
- Return to a row later to check a detail and find that the UI has timed out and you have to log back in.
This is audit prep work that shouldn't eat a morning. But Ads Manager was designed for running campaigns, not for extracting metadata about the account structure.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that can query the Snapchat Marketing API and write the results directly into a sheet — pagination handled automatically.
List all audience segments for Snapchat ad account abc123 and write segment name, type, status, and approximate user count into columns A through D of the Segment Audit tab
What You Get
- One row per segment, all pages fetched automatically
- Column A: segment name as shown in Ads Manager
- Column B: segment type (Customer List, Lookalike, SAI Interest, etc.)
- Column C: status (Active, Expired, etc.)
- Column D: approximate user count — shown as a range where Snapchat returns a range rather than an exact figure
What If the Data Is Not Quite Ready
You also need the segment ID for downstream API calls
List all segments for Snapchat ad account abc123 and write segment ID, segment name, type, and status into columns A through D — we need the IDs to reference them in subsequent API calls
You want to filter the list to only active segments
Fetch all audience segments from Snapchat ad account abc123, filter to only those with status Active, and write segment name, type, and approximate user count into columns A through C of the Active Segments tab
You want retention days included so you know which segments are about to expire
List all segments in Snapchat ad account abc123 and write segment name, type, status, retention days, and approximate user count into columns A through E, then highlight any row in column F where retention days is less than 30
Full audit: all segments, expiry flags, and a dedup check
Fetch all audience segments from Snapchat ad account abc123 — segment ID in A, name in B, type in C, status in D, retention days in E, approximate user count in F — then write Expiring Soon in column G for any segment with fewer than 30 retention days, and Duplicate Name in column H for any segment name that appears more than once
The pattern: pull everything first, then annotate in the same prompt so the audit sheet arrives with the decisions already surfaced.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet you're using for the account consolidation project, then ask it to export all audience segments from your Snapchat ad account. Related: uploading customer list audiences, and the hub overview for all Snapchat workflows.