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.
Try this yourself — free for 7 days
SheetXAI installs in your Excel workbook in about a minute. Paste the prompt below and watch it run.
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.