The Scenario
You're the paid social manager at a SaaS company running five campaigns with roughly forty creatives between them. Three weeks ago you noticed one campaign's CPM climbing without explanation. After digging in, you found two creatives had been placed on serving hold due to a LinkedIn policy review — and no one had caught it because the alert went to an inbox nobody monitors. Now leadership wants a full audit of every creative across all campaigns: status, review status, serving hold reasons, associated campaign. They want it in a workbook by end of day.
The bad version:
- Open Campaign Manager, navigate to each campaign one at a time, click into the Creatives worksheet, scan for any non-active status, manually note the creative ID and hold reason in a separate doc.
- Repeat for all five campaigns, cross-referencing the campaign name each time.
- Transfer everything into the audit workbook, check for copy errors, format the status column so it's consistent.
There are forty creatives. At two minutes per creative, that's eighty minutes of clicking — for a report that will need to be refreshed again next quarter, or sooner if the policy situation changes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook structure, connects to LinkedIn Ads, and can pull every creative's status and review details in one pass — no campaign-by-campaign navigation required.
List all LinkedIn Ads creatives for account ID 12345, including their status, review status, serving hold reasons, and associated campaign name, and write them into this worksheet starting at row 2 with headers in row 1
What You Get
- Row 1: column headers — Creative ID, Campaign Name, Status, Review Status, Serving Hold Reasons.
- Rows 2 onward: one creative per row across all campaigns in the account.
- Serving hold reasons appear as written descriptions rather than raw API codes.
- Any creative with no hold reasons gets a blank in that column, making it easy to filter for the problem rows.
What If the Data Is Not Quite Ready
I only want to see creatives that are actually on hold
List all LinkedIn Ads creatives for account ID 12345 that have a non-empty serving hold reason. Write the creative ID, campaign name, status, and hold reason into columns A through D — skip any creative with no hold issues
The campaign names in column A should be normalized to title case
List all LinkedIn Ads creatives for account ID 12345. For each creative, convert the campaign name to title case before writing it into column A, then write creative ID, status, review status, and hold reasons into columns B through E
I need to cross-reference which creatives belong to campaigns that are themselves paused
List all LinkedIn Ads creatives for account ID 12345. For each creative, also check whether its parent campaign is active or paused and write that into column E. Write creative ID, campaign name, creative status, review status, and campaign status into columns A through E
Full cleanup and triage in one shot
List all LinkedIn Ads creatives for account ID 12345. Filter out any with status "archived." For the remaining rows, sort by review status so any creatives with hold reasons appear first. Add a Priority column in column F: mark "urgent" if the hold reason mentions policy, "monitor" for any other hold reason, and "ok" if no hold reason exists. Write creative ID, campaign name, status, review status, hold reasons, and priority into columns A through F
That last prompt turns a manual triage into a structured audit output — ask for the classification logic inline and you get a prioritized list, not a raw data dump.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull all your LinkedIn creatives with their serving status. For more LinkedIn Ads workflows, see the campaign performance metrics guide or the multi-account campaign audit.