Skip to content
Floskool

Chapter 1 · Your Numbers, Without Drowning in Them

Your Monthly Review in 15 Minutes

Free lesson 10 minGroup Flopost

Follow this course in your space: your progress is saved, and the community answers your questions.

Follow for free

The monthly review isn't a report. It's a 15-minute meeting with yourself, say the first Monday of the month, to answer three questions. Set a timer: when it rings, move on to the next question.

Before you start

Keep the table below up to date during the month: one row per post, filled in 7 days after it goes live. It takes a minute per post. On review day, everything's already there.

The table template to copy

Copy this table into a note, a document, or a spreadsheet. In the "Notes" column, jot down what you notice in a few words (context, a reaction in the comments, a customer who came in because of the post).

| Date | Platform | Topic | Format | Hook | Views | Likes | Comments | Shares | Saves | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| 11/03 | Instagram | Morning bake | Video | "It's 5 a.m., here's what's happening" | | | | | | |
| 11/06 | TikTok | Morning bake | Video | "It's 5 a.m., here's what's happening" | | | | | | |
| 11/10 | Facebook | Pumpkin pie | Carousel | "3 mistakes that make your crust soggy" | | | | | | |

The sample rows are only there to show how to fill it in: replace them with your own. If you post the same video on several platforms, use one row per platform: their numbers don't compare with each other.

The 3 questions, timed

Question 1 (5 minutes): what worked best?

Sort your table by the number you picked in lesson 2 (shares per reach, for example). Look at the top three posts and compare them to your average. Circle the ones well above it.

Don't try to understand yet. Just note the winners, plus the two that did worst.

Question 2 (5 minutes): why?

For each winner, look at the topic, format, hook, and notes columns. Look for what they have in common:

  • the same topic (behind the scenes, a before/after, a customer question)?
  • the same format (short video, carousel)?
  • the same type of hook (a question, a number, a mistake to avoid)?
  • a helpful context (a holiday, a season, a news event)?

Read the winners' comments too: people often say what they liked. Write your hypothesis in one sentence: "My behind-the-scenes videos with a specific time in the hook do better."

Question 3 (5 minutes): what to repeat or stop next month?

Turn your hypothesis into concrete decisions:

  • repeat: one or two posts modeled on the winners (lesson 4 gives you the method);
  • stop or change: what's been below your average for several months, not just one post;
  • test: a single new thing, so you learn something fresh.

Put these decisions in next month's posting calendar. A review that doesn't change your calendar is wasted time.

The prompt to analyze your month

AI is good at spotting patterns in a table. It doesn't know your customers or your neighborhood, so you stay the judge of its conclusions. Copy this prompt, fill in the brackets, and paste your table.

You are a social media analyst for small businesses.
I'm a [your trade] in [your city]. My customers are [your audience].
My goal on social media is [bring people into the shop / get quote
requests / sell online / fill my calendar].

Here is the table of my posts for [month], with numbers logged
7 days after each post:
[paste your table]

My average [shares / likes / saves] per reach, over my previous
10 posts, is [your average]%.

1. For each post, calculate the [your number] rate per reach
   (or per views if reach is missing), and rank them.
2. Tell me which posts are well above my average and what they
   have in common (topic, format, hook, day).
3. Tell me which ones are well below, and whether the context
   (day, season, topic) could explain it.
4. Suggest 3 post ideas for next month, built on what worked,
   and 1 thing to stop.
Rules: draw no conclusion from a single post, tell me when there's
too little data, and don't make up any numbers.

Your turn

  1. Copy the table into the tool you open most often (phone note, spreadsheet, notebook).
  2. Fill it in for this month's posts that are at least 7 days old.
  3. Put a 15-minute appointment in your calendar for the first Monday of next month, called "Monthly review."