The Scenario
You're a media planner at an agency and you're three days away from presenting channel budget recommendations to a CPG client. You've put together 8 different Snapchat targeting configurations in a planning sheet — each row is a different combination of age group, gender, and country. Before you allocate budget across them, you need audience size estimates so you're not guessing at reach.
Snapchat's Audience Size Estimator lives in the UI, and it accepts one targeting configuration at a time.
The bad version:
- Open the Ads Manager targeting configuration tool. Enter the parameters for configuration 1. Note the reach estimate. Close. Repeat for configuration 2.
- Do this 8 times. For each one: navigate to the audience size tool, type in the age group, gender, and country from your sheet, wait for the estimate, write the min and max reach into your planning sheet.
- Come back to a row and realize you entered the wrong age group for configuration 5. Go back, fix it, re-run.
Eight configurations should take eight minutes. It takes 45 because the workflow requires context-switching between Ads Manager and your sheet for every row.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your planning sheet and calls the Snapchat API for each configuration without you leaving the spreadsheet.
For each row in this sheet, call the Snapchat audience size estimator using the age group, gender, and country from columns B, C, and D, then write the estimated minimum reach into column E and maximum reach into column F
What You Get
- Columns E and F populated for all 8 rows in a single operation
- Minimum and maximum reach figures as returned by Snapchat's estimator
- No context switching between Ads Manager and your sheet
What If the Data Is Not Quite Ready
Some rows have missing country values and you need to default them to United States
For each row in the Targeting Plan tab, call the Snapchat audience size estimator using age group in column B, gender in column C, and country in column D — if column D is blank, use United States as the default — and write minimum and maximum reach into columns E and F
You want reach formatted as abbreviated numbers (e.g., 4.2M) rather than raw integers
Run the Snapchat audience size estimator for each row using age group in B, gender in C, and country in D, write the min reach into column E and max reach into column F, and format both columns as abbreviated numbers (e.g., 4.2M, 850K) for the client presentation
You have a fifth parameter — device type — and want to include it in the estimate
For each row, call the Snapchat audience size estimator using age group in B, gender in C, country in D, and device type in E, then write minimum reach into column F and maximum reach into column G
Full audience sizing pass: run all estimates, flag configurations below minimum viable reach, add a recommended budget column
Call the Snapchat audience size estimator for each of the 8 rows using columns B, C, and D — write min reach in column E and max reach in F — then write Too Small in column G for any configuration where max reach is below 500,000, and write a recommended daily budget in column H based on a target CPM of $8 and a 7-day flight using the midpoint of the reach range
The planning sheet goes from a set of hypotheses to a prioritized recommendation in one pass.
Try It
Get the 7-day free trial of SheetXAI and open your Snapchat targeting planning sheet, then ask it to run audience size estimates for each configuration. Related: comparing targeting insights with demographic breakdowns, and the hub overview for all Snapchat workflows.