The Scenario
You're a media planner at a performance agency. Your client approved a Snapchat investment for Q3 but wants to see projected reach before budget is allocated. You've put together 8 targeting configurations in an Excel planning workbook — each row has a different age bracket, gender, and country mix. The budget allocation meeting is Monday. It's Friday afternoon.
Snapchat's audience size estimator is in the Ads Manager UI, one configuration at a time.
The bad version:
- Open Ads Manager. Navigate to the audience estimator. Enter the parameters for row 2: age group 18-24, female, United States. Note the reach estimate. Go back to the workbook. Enter the number.
- Return to Ads Manager. Enter the parameters for row 3. Read the estimate. Go back. Enter the number.
- Do this 8 times. Realize at row 6 that you entered the wrong country for row 4. Go back, fix it, re-enter.
Each round trip between Ads Manager and Excel takes 4-5 minutes. Eight configurations is 40 minutes of clicking, reading, and switching — to produce numbers you're going to copy into a slide.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your planning workbook and calls the Snapchat API for every row at once, without you leaving the file.
For each row in this workbook, 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 pass
- Minimum and maximum reach as returned by Snapchat's estimator
- No context switching between Ads Manager and your workbook
What If the Data Is Not Quite Ready
Some rows are missing a country value and you want a default applied
For each row in the Targeting Plan sheet, call the Snapchat audience size estimator using age group in B, gender in C, and country in D — if D is blank default to United States — and write minimum reach into column E and maximum reach into column F
You want abbreviated formatting for the client presentation
Run the Snapchat audience size estimator for each row using age group in B, gender in C, and country in D, write min reach in column E and max reach in column F, and format both as abbreviated numbers (e.g. 4.2M, 850K)
Your configurations include a device type parameter as a fifth column
For each row in the planning workbook, 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 pre-meeting prep: all estimates, small-audience flags, and recommended daily budgets
Call the Snapchat audience size estimator for all 8 rows using columns B, C, and D — write min reach in E, 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
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook containing your Snapchat targeting configurations, then ask it to run audience size estimates across every row. Related: comparing targeting insights with demographic breakdowns, and the hub overview for all Snapchat workflows.