The Scenario
You're a programmatic advertising manager at a media agency. You've just been handed a new LinkedIn ad account and tasked with building three campaigns in the next two weeks. Before you touch Campaign Manager, you want to know what audience segments are already available in the DMP library — specifically the names, types, and estimated sizes of all 25 segments so you can decide which ones to activate.
The previous person who held this role left behind incomplete documentation. There's a sheet template with column headers labeled Segment ID, Segment Name, Type, and Member Count, but every row is blank. You have no idea which segments are first-party uploads, which are LinkedIn-native, and which are matched audiences. The briefing is in three days.
The bad version:
- Log into Campaign Manager, navigate to the Matched Audiences section under Plan.
- Open each segment one at a time to see its name, type, and estimated size.
- Note the details in your sheet manually, watching the row count creep from 1 to 25.
- Realize that Campaign Manager doesn't display the segment type clearly on the list view and you have to open the detail pane for each one.
- Check whether any segments are expired or too small to be actionable before including them in your planning.
Twenty-five segments. Even at three minutes per segment, that's over an hour of clicking and typing for information that exists in the API and should take seconds to retrieve.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to LinkedIn Ads and can list all DMP segments in your ad account — IDs, names, types, member counts — in one pull.
List all LinkedIn DMP segments for ad account 12345 and write the segment ID, name, type, and member count into this sheet starting at row 2
What You Get
- Row 2 onward: one segment per row for every DMP segment available in the account.
- Column A: Segment ID.
- Column B: Segment Name as it appears in Campaign Manager.
- Column C: Segment Type (e.g., first-party list upload, retargeting, LinkedIn native).
- Column D: estimated member count as returned by the API.
What If the Data Is Not Quite Ready
Some segment IDs in column A already exist — I want to fetch details for those specific ones
Fetch details for each DMP segment ID in column A from LinkedIn Ads and write the segment name, status, and estimated size into columns B, C, and D
I want to flag segments that are too small to activate
List all LinkedIn DMP segments for ad account 12345. Write the segment ID, name, type, and member count into columns A through D. Add a column E: flag any segment with fewer than 300 members as "too small to activate" and any segment with status expired as "expired — refresh needed"
I need to separate first-party segments from LinkedIn-native segments into different tabs
List all LinkedIn DMP segments for ad account 12345. Write all first-party uploaded segments into the tab named First-Party with columns for segment ID, name, and member count. Write all LinkedIn-native or retargeting segments into the tab named LinkedIn-Native with the same columns
Full targeting library audit in one shot
List all LinkedIn DMP segments for ad account 12345. Write segment ID, name, type, status, and member count into columns A through E. In column F, add an actionability flag: "ready" if status is active and member count is above 1,000, "borderline" if active but member count is between 300 and 1,000, "too small" if member count is below 300, and "inactive" if status is not active. Sort by member count descending so the largest segments appear first. Write column headers in row 1
That prompt gives you a planning document your whole team can use — with actionability already classified.
Try It
Get the 7-day free trial of SheetXAI and open your LinkedIn campaign planning sheet, then ask it to pull your full DMP segment library with member counts and status. For related workflows, see the campaign audit guide or the targeting URN research article.