The Scenario
You're a Snapchat strategist building the Q3 media plan for a CPG client. The plan calls for two distinct audience approaches — a broad 18-34 general awareness targeting set and a narrower interest-based set that's historically more efficient. Before your planning deck goes to the client, you need the demographic composition of both: age breakdown, gender split, language distribution.
The Snapchat Audience Insights tool shows this inside the UI. It does not export to Excel. It shows one audience at a time.
The bad version:
- Open the Audience Insights tool for configuration 1. Read the age percentages off the screen and type them into your planning workbook.
- Screenshot the gender breakdown. Type those numbers in too.
- Switch to configuration 2. Repeat.
- Realize after switching that you missed the language breakdown for configuration 1 because it only shows when you scroll past the fold. Go back.
You're building a comparison table. The tool shows one thing at a time and offers no export. The only way out is manual transcription.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your planning workbook and calls the Snapchat targeting insights endpoint for multiple configurations from inside the file.
Generate Snapchat targeting insights for ad account abc123 comparing the base targeting spec in row 2 against the target spec in row 3, and write the age, gender, and language breakdown into columns F through H of the Planning sheet
What You Get
- Demographic breakdowns for both configurations written directly into the planning workbook
- Age, gender, and language distribution as returned by the Snapchat targeting insights endpoint
- Both configurations in the same sheet for a clean side-by-side comparison
What If the Data Is Not Quite Ready
The targeting specs are written in plain language in the workbook, not as API schema
Read the plain-language targeting descriptions in column B for rows 2 and 3 of the Planning sheet, translate each into a Snapchat targeting spec, call the targeting insights endpoint for ad account abc123, and write age breakdown in column F and gender breakdown in column G for each row
You want audience size estimates included alongside the breakdowns
Generate Snapchat targeting insights and audience size estimates for the two configurations in rows 2 and 3 — write age breakdown in F, gender breakdown in G, language breakdown in H, and estimated audience size in I for each row
You have 5 configurations to compare across the workbook
For each of the 5 targeting configurations in rows 2 through 6, call the Snapchat targeting insights endpoint for ad account abc123 and write age breakdown, gender breakdown, and language breakdown into columns F, G, and H respectively
Full audience comparison: insights, size estimates, and recommendation flag
Generate targeting insights for ad account abc123 for the configurations in rows 2 and 3 — age breakdown in F, gender breakdown in G, language breakdown in H, estimated audience size in I — then compare the size estimates and write Broader Reach in column J for the larger audience and Better Fit for the one with a higher share of the 18-24 cohort
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your Snapchat audience planning configurations, then ask it to generate targeting insights for each one. Related: estimating audience reach for multiple configurations, and the hub overview for all Snapchat workflows.