Repurpose your best Sprout Social posts into new drafts

Every Monday at 7am, mine my own best Sprout Social content and turn it back into new posts for my other connected networks.

Start by using the Sprout Social Query Post Analytics operation to pull every post I published in the last 30 days along with its lifetime performance metrics. Post analytics metrics carry a "lifetime." prefix, so read fields such as lifetime.impressions and lifetime.engagements (profile analytics metrics do not carry that prefix). This operation is index paginated with page and limit and caps the total result set at 10,000, so page through until I have the full 30 day window.

Rank the posts by engagement rate rather than raw impressions. Compute engagement rate per post as lifetime engagements divided by lifetime impressions, so that a strong post on a small profile is not buried under a mediocre post on a large one. Take the top three.

Skip any post I already repurposed in the last 90 days. Keep a running record of the source post ids this workflow has reused, carry that record between runs, and age out entries older than 90 days. If one of the top ranked posts is on that skip list, move down to the next best post so the same winner is not recycled every month.

Use the Sprout Social List Customer Profiles operation to resolve my connected profiles, their customer_profile_id values, and their network types. Profile ids used in filters are customer_profile_id values. For each of the three winners, work out which network it originally ran on, then write a genuinely fresh variant for each of my other connected networks. Do not copy the caption across. Adapt length, tone, and hashtag use per network: short and punchy with minimal hashtags for X, a longer and more professional framing without hashtag spam for LinkedIn, visual-first with a fuller hashtag set for Instagram, and conversational for Facebook. Keep the idea and the hook that made the original work, and change the execution.

For each variant, use the Sprout Social Create Publishing Post operation to put it into Sprout as a draft targeting that network's customer_profile_id, scheduled for a slot later that same week. Sprout publishing creates drafts only: is_draft must be true and delivery.type only accepts SCHEDULED. That constraint is a feature here rather than a limitation, because it makes the human approval step natural, so never describe this workflow as publishing automatically. Spread the scheduled times across the week instead of stacking them all at once.

Finish by sending a single Slack message with the Slack Bot Send a Message operation to my marketing channel. List every draft that was created, grouped under the original post that inspired it, and include that original's engagement rate plus a one line explanation of why it did well (the hook, the format, the topic, or the timing). For each draft, show the target network and the scheduled time so a human can approve or edit it in Sprout before anything goes out. If nothing qualified this week, say that in one line rather than sending an empty summary.