The Scenario
You're a growth marketer building the audience strategy for a product launch. You've got eight different combinations you want to test — different job titles, industries, seniority mixes — and you want to know the estimated LinkedIn audience size for each one before you commit budget. The old way involves opening Campaign Manager eight separate times, entering each combination manually, reading the estimated audience number from the right panel, and typing it into your planning sheet. You did it once last month and it took forty minutes. You have eight combinations this time.
The bad version:
- Open Campaign Manager, start a new draft campaign, open the audience builder.
- Enter the criteria for combination 1, note the audience size from the sidebar, close without saving.
- Repeat seven more times, manually transcribing a number each time and hoping none of them get mixed up in the spreadsheet.
- Realize you need to test a ninth combination and start over.
The person who owns the budget decision wants this by end of morning. You have three other launch tasks running in parallel, and "manually clicking through Campaign Manager eight times" is not something that scales.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the targeting criteria already laid out in your rows and calls the LinkedIn Ads audience count API for each combination — no Campaign Manager navigation, no manual transcription.
For each targeting scenario in this sheet — job titles in column B, industries in column C, countries in column D — get the LinkedIn audience size estimate and write the result into column E
What You Get
- Column E: estimated LinkedIn audience count for each targeting combination in your sheet.
- One result per row, returned in the same order as your input.
- Combinations that return a result below LinkedIn's minimum reportable threshold get a note in column E rather than a blank, so you know the audience is too narrow to estimate.
What If the Data Is Not Quite Ready
The job titles are free-text and might not match LinkedIn's entity values exactly
For each job title listed in column B, look up the closest LinkedIn targeting entity match and write the confirmed entity name and URN into a helper column. Then use those URNs with the industries in column C to fetch audience size estimates and write them into column E
I need to add seniority filtering to half the rows but not all
For each row in this sheet, get a LinkedIn audience size estimate using job titles in column B, industries in column C, and country in column D. For rows where column F contains a seniority value, include it in the targeting. For rows where column F is blank, run the estimate without a seniority filter. Write results into column E
Two of the rows have multiple countries and I want a combined estimate
For rows 3 and 5 where column D lists multiple countries as comma-separated values, get a LinkedIn audience size estimate treating all listed countries as a combined geography. Write the combined estimate into column E for each of those rows, and process the remaining rows normally
Full audience sizing table with feasibility flags in one shot
For all eight targeting scenarios in rows 2 through 9, get the LinkedIn audience size estimate using job titles in column B, industries in column C, and countries in column D. Write the estimated audience size into column E. Add a column F: "launch-ready" if the estimate is above 50,000, "narrow — consider expanding" if between 10,000 and 50,000, and "too narrow" if below 10,000. Sort the output by estimated audience size descending
That last prompt gives you a ranked, flagged table your planning conversation can actually use.
Try It
Get the 7-day free trial of SheetXAI and open your audience planning sheet, then ask it to fetch LinkedIn audience estimates for every row in one pass. For related workflows, see the targeting URN research guide or the campaign supply forecast article.