The Scenario
You're a Snapchat strategist working on a CPG client's Q3 plan. The client has two audience configurations in play: a broad 18-34 general targeting set, and a narrow interest-based set that's more expensive to reach but historically converts better. Before the budget allocation meeting on Thursday, you need to pull demographic breakdowns for both — age/gender/language composition — so you can make a defensible recommendation on where to put the spend.
The Snapchat Audience Insights tool shows this data in the UI. It does not export it.
The bad version:
- Open the Audience Insights tool for the first configuration. Read the age breakdown percentages off the screen. Type them into a planning sheet.
- Screenshot the gender breakdown. Type those in too.
- Switch configurations. Repeat. Realize the UI rounds to the nearest percent and doesn't show the language breakdown at all unless you hover over each row.
- Go back to the first config because you missed the 25-34 age bucket.
You're building a deck that compares two audiences. You have two data sources that only show one at a time and can't export.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to the Snapchat Marketing API and can call the targeting insights endpoint for multiple configurations from inside your Google Sheet.
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 tab
What You Get
- Demographic breakdowns for both configurations written back into the planning sheet
- Age, gender, and language distribution as returned by the Snapchat targeting insights endpoint
- Both configurations side-by-side in the same tab for easy comparison
What If the Data Is Not Quite Ready
The targeting specs are written in plain language, not JSON, in the sheet
Read the plain-language targeting description in column B of each row in the Planning tab, translate it into a Snapchat targeting spec, call the targeting insights endpoint for ad account abc123, and write the age breakdown into column F and gender breakdown into column G for each row
You want audience size estimates alongside the demographic breakdown
Generate Snapchat targeting insights and audience size estimates for the two configurations in rows 2 and 3 — write age breakdown into column F, gender breakdown into column G, language breakdown into column H, and estimated audience size into column I for each row
You have 5 configurations to compare, not 2
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 a recommendation flag
Generate targeting insights for ad account abc123 for the two 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 configuration with the larger audience size and Better Fit in column J for the configuration with a higher percentage of the 18-24 age cohort
The recommendation is supported by data pulled and compared in a single prompt.
Try It
Get the 7-day free trial of SheetXAI and open your Snapchat planning sheet with the targeting configurations you want to compare, then ask it to generate insights for each one. Related: estimating audience reach for multiple configurations, and the hub overview for all Snapchat workflows.