Stanley|mcp-playground
Recipe 04

Analytics review

What you get

a weekly read of your own numbers that ends as next week's plan, ready to hand to recipe 02.

Needs

at least one platform publishing through Stanley, plus a few weeks of posting history on it; run /stanley-start if you are not sure what you have.

One warning up front: the numbers only mean something once Stanley has history to query. Say you started posting through him last week; the tables come back thin, and any pattern you spot is noise. Give it two or three weeks of steady posting first (recipe 02 gets you there).

Under the hood it's SQL over your historical post metrics: engagement, impressions, reactions, follower trends, posting streaks. You ask in plain English; Stanley writes the query. He can also pull live follower counts and recent post stats when a question calls for them, so "right now" questions work alongside the historical ones.

The weekly review

Run this once a week, in one conversation, so each answer builds on the last.

  1. Start at the top. Ask for the winners and, more useful, what they share.

    Show my top 5 posts by engagement across all platforms over the last 30 days, and tell me what they have in common: topic, format, platform, time of day.

    Expect a ranked list with per-post numbers and a short read on the shared traits. If the pattern he names doesn't match what you see in the posts, say so and he'll re-cut the data.

  2. Then the bottom. Weak posts teach as much as strong ones.

    Now show the 5 weakest posts from the same window and what those share.

    Look for a format or topic that keeps landing at the bottom. That's your cut list for next week.

  3. Compare platforms and formats.

    Compare my average engagement by platform and by format for the last 30 days. Where do my ideas perform best?

    The answer is a small comparison table. Say threads on X keep beating the LinkedIn versions of the same ideas; that tells you where drafts should start, and what to adapt from there.

  4. Check the follower trend.

    How have my follower counts moved per platform over the last 60 days? Flag any week that broke the trend.

    A longer window smooths out day-to-day wobble. When a week spikes, ask what you posted that week and read the two answers side by side.

  5. Check the streak.

    What's my current posting streak, and how does this week's volume compare with my usual?

  6. Turn it into a plan. This is the payoff step, so don't skip it.

    Based on everything above, propose next week's plan: which topics and formats to double down on, which to drop, and how many posts per platform.

    Stanley replies with a plan, not drafts. When it reads right, carry it straight into recipe 02: ask him to draft the week and schedule the drafts into your slots.

Where things land

Steps 1 through 6 are read-only; the queries change nothing, and the plan arrives as a message in the conversation. Drafts exist only once you ask for them in the recipe 02 handoff, and those land as scheduled drafts in your calendar slots, reversible as ever. Nothing in this recipe publishes live.

Questions worth keeping around

The weekly loop isn't the only shape. A few standalone questions that work any day:

Which of my posts from the last 90 days got the most impressions but the least engagement?

Did my engagement change after I moved my posting time?

Which format got the most reactions on LinkedIn this quarter?

How many followers did I gain on X in the last 7 days, and which posts drove it?

Each comes back as a short table or a sentence with the numbers behind it, and you can keep pulling the thread: "why", "show me those posts", and "break that down by week" all work as follow-ups.

When it breaks