Promote top LinkedIn organic posts as sponsored ads

Every Tuesday at 10am in my timezone, run a workflow that turns my best-performing LinkedIn organic post from the past week into a draft sponsored ad and routes it through Slack for approval before any budget is spent.

Step 1. Pull the last 7 days of organic posts published from my LinkedIn company page using the LinkedIn Find Posts by Author action, scoped to my organization URN. The lookback window should be configurable at setup.

Step 2. For those posts, pull impressions, clicks, reactions, comments, and shares using the LinkedIn Get Page Share Statistics action, time-bound to the same window. Compute engagement rate per post as (reactions + comments + shares) divided by impressions.

Step 3. Pick the post with the highest engagement rate. If the winner clears a configurable threshold (default 3%), continue. If nothing clears the threshold, skip steps 4 and post a short Slack message saying no organic post was strong enough to amplify this week, then exit.

Step 4. Use the LinkedIn Ads Create Creative action to create a new sponsored creative inside my designated Organic Amplification campaign. The campaign URN, ad account URN, and company page URN are all supplied at setup. Reference the winning organic post's URN so the sponsored version inherits the same copy and media. Set intendedStatus to DRAFT so the creative does not start serving until I activate it.

Step 5. Send a message to my Slack approval channel using the Slack Bot Send a Message action. The message should include: a link to the original organic post, the engagement numbers that justified the pick (impressions, engagement rate, and the strongest engagement type), a link to the new draft creative in LinkedIn Campaign Manager, and a clear Review and activate call to action.

Configurable inputs at setup: LinkedIn company page URN, LinkedIn Ads account URN, Organic Amplification campaign URN, engagement rate threshold (default 3%), lookback window (default 7 days), schedule, and the Slack channel for approval messages.