Weekly LinkedIn Ads draft audit and launch-readiness brief in Notion

Every Friday at 3pm (cron trigger), audit my LinkedIn Ads draft campaigns and publish a launch-readiness brief in Notion so my team can decide on Monday what actually ships.

Step 1. Find the drafts. Call LinkedIn Ads Search Campaigns against my configured ad account, filtered to status DRAFT. Make the ad account URN a configurable input. If there are no drafts, still produce a Notion page that says so for the cycle, then stop.

Step 2. For each draft campaign, pull its targeting criteria, bid, budget (daily and total), and run schedule from the campaign record returned by Search Campaigns (use Get Campaign if any field is missing). Then run two checks against LinkedIn's planning endpoints:

• Get Audience Counts on the campaign's targeting criteria, to confirm the matched audience clears LinkedIn's 300 member serving floor. Anything below 300 returns 0 and means the campaign cannot serve.

• Get Supply Forecasts on the same targeting plus the campaign's bid and budget, to project expected impressions, clicks, reach, and spend over the campaign's run schedule.

Step 3. Assign each draft a readiness verdict:

• Green: audience comfortably above the 300 floor, bid at or above LinkedIn's suggested floor, forecast shows non-zero impressions, and the run schedule is at least 7 days. Ready to launch.

• Yellow: will probably serve but something is marginal, for example audience just above 300, very short schedule, or forecast spend well below the budget cap. Note the concern.

• Red: cannot serve as configured. State the specific blocker, such as audience under 300, bid below the LinkedIn floor, missing creative, schedule shorter than 1 day, or zero forecasted impressions.

Step 4. Write one Notion page per cycle via Notion Create a Page, under a configurable parent page or database. Title it 'LinkedIn Ads draft readiness, week of {date}'. For each draft campaign, include a section with the campaign name and id, a one-paragraph targeting summary in plain English (locations, job functions, seniorities, company size, skills, etc.), the audience count, a small forecast table with impressions, clicks, reach, and spend over the run schedule, and the verdict (green, yellow, or red) with the specific blocker if not green. End the page with a short summary line: how many drafts were reviewed, how many green, yellow, and red.

Configurable inputs: ad account URN, Notion parent page or database id, optional minimum-schedule-length and minimum-forecasted-impressions thresholds for the yellow vs green cutoff.

Additional information

What does this prompt do?

Pulls every LinkedIn Ads campaign currently sitting in draft so nothing waiting to ship slips through the cracks.
Confirms each draft's targeted audience clears LinkedIn's 300 member serving floor before Monday's launch window.
Projects expected impressions, clicks, reach, and spend across the campaign's run schedule so you know what you're about to commit to.
Writes a single Notion brief per cycle with a green, yellow, or red readiness verdict and the specific blocker for anything that isn't ready.

What do I need to use this?

A LinkedIn Ads login with admin access to the ad account you want audited.
A Notion workspace and a parent page where the weekly brief should live.

How can I customize it?

Move the run time. Fridays at 3pm is the default, but any weekly slot works if your launch cadence is different.
Point it at a different Notion parent page or a dedicated database of weekly briefs.
Tighten or loosen the readiness rules, for example a minimum forecast spend, a stricter audience floor, or a required minimum schedule length.

Frequently asked questions

Does this launch the campaigns for me?

No. The brief is read only. Drafts stay as drafts until someone in Campaign Manager flips them to active. The point is to make that decision a five minute review instead of an hour of clicking.

What does the green, yellow, or red verdict actually mean?

Green means the audience clears the serving floor, the bid and budget look sane against the forecast, and the run schedule is long enough. Yellow means it will probably serve but something is off, such as a thin audience or a very short schedule. Red means it cannot serve as configured, usually because the audience is under 300 members or a required field is missing.

Why 300 members for the audience floor?

LinkedIn does not serve ads to audiences smaller than 300 matched members. It is the most common reason a draft sits and never delivers, so the brief flags it explicitly.

What happens on a week with no drafts?

You still get a Notion page so the cadence is predictable. It just notes that the ad account had no campaigns in draft status that week.

Can I run this across multiple ad accounts?

Yes. Configure the ad account in the prompt, or duplicate the workflow per account if you manage several. Each run produces one brief.