The Scenario
You're a media planner at an agency pitching a new ABM campaign to a fintech client. They want to reach VP-level and above finance decision-makers across three specific industry verticals, and they have three different budget scenarios they want costed out. You've drafted all three targeting scenarios in an Excel workbook — job titles, industries, seniority levels, countries — and now you need LinkedIn's reach estimate and recommended budget for each one before the pitch deck can go to design.
The bad version:
- Open LinkedIn Campaign Manager, start a new draft campaign, navigate to the audience builder.
- Enter the targeting criteria for Scenario 1 manually — job titles, industries, seniority, geography.
- Note the estimated reach and impressions shown in the right panel.
- Close without saving, start over for Scenario 2. Then again for Scenario 3.
- Type all three sets of numbers into the workbook manually, hoping you read them correctly from the Campaign Manager panel.
Three scenarios sounds manageable until you realize Campaign Manager's audience builder resets every time you change the targeting, and there's no export for forecasts. You're reading numbers off a panel and typing them into a document like it's 2011.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the targeting criteria already in your worksheet and calls the LinkedIn Ads supply forecast API directly — no manual Campaign Manager navigation required for each scenario.
Get a LinkedIn Ads supply forecast for the targeting criteria in this worksheet — job title in column A, industry in column B, seniority in column C, country in column D — and write the estimated reach and impressions into columns E and F for each row
What You Get
- Column E: estimated unique reach for each targeting scenario.
- Column F: estimated impressions for a 30-day period at typical delivery.
- One result per row — all three scenarios come back in a single pass.
- Targeting combinations that are too narrow for a reliable estimate get flagged rather than left blank.
What If the Data Is Not Quite Ready
The job titles are informal and need to be mapped to LinkedIn's recognized values first
For each job title in column A, find the closest matching LinkedIn targeting entity and write the LinkedIn-recognized job title and its URN into columns B and C. Then use those URNs to get a supply forecast for the industry in column D and seniority in column E, writing the estimated reach into column F
One of the scenarios has multiple industries and I need them combined
For the targeting scenario in row 3 — job titles in B3, industries listed as a comma-separated value in C3, seniority in D3, country in E3 — get a LinkedIn Ads supply forecast treating all industries as a combined audience and write the estimated reach and impressions into cells F3 and G3
I want to add a recommended daily budget column based on the reach estimate
For the targeting criteria in rows 2 through 4, get a LinkedIn Ads supply forecast for each row. Write estimated reach into column E and estimated impressions into column F. Then calculate a recommended daily budget at a CPM of $40 and write it into column G
Full pitch-ready table in one shot
Get LinkedIn Ads supply forecasts for all three targeting scenarios in rows 2 through 4. For each scenario, write the scenario label from column A, estimated reach, estimated impressions, recommended daily budget at $40 CPM, and estimated monthly spend into columns B through F. Flag any scenario where estimated reach is below 10,000 members with "audience too narrow" in column G
That prompt produces a table you can paste directly into the pitch deck appendix, with guardrails already applied.
Try It
Get the 7-day free trial of SheetXAI and open your targeting scenario workbook, then ask it to fetch the LinkedIn supply forecast for each row. For related workflows, see the audience size estimator guide or the targeting URN research article.