Paste in about three months of your posts, and the workbook shows which formats get the most engagement and how many of each to post next month.

It shows each format’s typical engagement rate across the 90 days and in each 30-day period, says how many posts each result is based on, and explains every number in plain words.

Includes:

  • Five sheets (Start Here, Your Posts, Your Plan, By Month, and How It Works, which explains every number)
  • Sample posts (already filled in, so every sheet shows a worked example when you open it)
  • A plan for next month (a number of posts for each format, split in proportion to each format’s typical engagement rate, with a test post for any format that has only a few posts so far)
  • The typical engagement rate (each format’s median engagement rate, so one viral post doesn’t make a format look better than it usually does)
  • Evidence labels (each format is marked Solid, Building, or Early by how many posts it has and how many of the three 30-day periods they cover)
  • A Check column (it says in plain words whether each post counted, and what to change if it didn’t)

It takes three steps. On Start Here, fill in the date you pulled your numbers and how many posts you plan next month. On Your Posts, select the sample posts, press Delete, and paste your own into the lime columns: the date, the format, the reach, and the likes, comments, shares, and saves. Then open Your Plan.

It compares one platform at a time. It leaves out posts from the last 7 days, which are still collecting engagement, and boosted posts, whose paid reach isn’t comparable. Format is only one reason a post does well, so treat the plan as a starting point and run it again next month.

You might also like