Free Excel workbook

Know what to repeat.

The Cohort Engagement Analyzer

Turn 90 days of post data into next cycle’s plan. Compare your formats on like-for-like footing, then get a specific number of posts to publish for each one.

Get the free workbook See inside

Built for SMMsExcel, Mac, SheetsSample data included

free to keep

90day analysis window

8content formats

6guided sheets

1plan for next cycle

01 / What it answers

Not another top-post tracker.

One good week can make the wrong format look like a strategy. This workbook looks for the formats that perform well enough, often enough, across several months of posts — and then tells you what to do about it.

A like-for-like comparison

Formats are only compared when every post was measured at the same age. If one was not, the workbook says so rather than quietly averaging them together.

Median, not your best day

The headline number is the median engagement rate per format, so a single viral post can't make a weak format look like a strategy.

Evidence you can see

Every format is labelled Stronger, Developing or Thin based on how many posts and how many monthly groups sit behind it. A small sample is never dressed up as certainty.

A plan, not a verdict

You get a specific number of posts per format for next cycle, with a role for each one: core, challenger, or worth testing.

02 / Inside the workbook

The plan first. The evidence underneath.

Six guided sheets take you from your export to a plan you can hand a client. The sample data is already worked through, so every view means something the moment you open it.

Dashboard showing a next-cycle plan: posts per content format, each format’s role and evidence, and data health checks — Your next cyclePosts per format, not a vague nudge

Cohort analysis table showing engagement across three monthly groups, stability, trend and evidence per format — The evidence underneathEvery number traces back to your rows

Data import worksheet with sample posts, yellow input cells, and a row status column explaining what to fix — Guided importIt tells you what to fix

03 / How it works

From export to direction.

The setup stays simple, and none of the assumptions behind the result are hidden from you.

Set your rules first

Pick one account, platform, distribution and goal, set your analysis date, and say how many posts you plan to publish next cycle. Every yellow cell is yours to fill.

Paste your posts

Replace the sample rows with your own: dates, format, engagement counts, and reach, impressions, views or an imported engagement rate. Row Status tells you exactly what to fix, in plain English.

Read the plan

The dashboard gives you posts per format for next cycle, what to post more of, what to test next, and what still needs measuring before you trust any of it.

Built for direction, not certainty.

01It compares one platform at a time, so different engagement definitions never get mixed together.
02It uses one rate method across the whole analysis: reach, impressions, views, or an imported platform rate.
03It refuses to call a comparison fair when posts were measured at different ages, rather than averaging them anyway.
04It labels thin samples as thin, and says so on the face of the plan.
05The share policy is written down in the workbook, in numbers you can argue with and change.
06It suggests what to publish and test next. It never claims format alone caused the result.

Ready when you are

Get the workbook.

Enter your first name and email to download the Excel file. It includes worked sample data, a quick-start page, row-by-row data checks, the full dashboard, and a metric guide that explains every number. Works in Excel 2010 and later, Excel for Mac, Google Sheets and LibreOffice.

Need specialist analytical production for a client audit? Tide can work inside your brief and branding, then give you the evidence notes, editable report, and walkthrough you need to review and contextualize it.

Explore white-label audits