You rebuild a content calendar from data in four moves: pull 90 days of posts, split them into top and bottom quarters, find what the top quarter shares, and change one slot per week. That is the whole method. The rest of this post shows how to do each move without a data team.
TLDR: Rank your last 90 days of posts by engagement rate. Compare format, hour and topic between the top and bottom quarter. Change one calendar slot a week and judge it against your own median, not against a benchmark.
Pull one table, not ten dashboards
Start with a single sheet: one row per post, with date, platform, format, local hour, topic and engagement rate (engagement divided by reach or impressions, your choice, but keep it the same). Ninety days is enough for most accounts. Fewer than 20 posts per platform is too thin to trust.
Rank by engagement rate, then mark the top 25% and the bottom 25%. Ignore the middle half for now.
Check the three things that actually move numbers
Not every variable matters equally. Mydrop's September 2026 data on 7,945 posts across 336 accounts gives a useful order of priority.
| Variable | What the data showed | Worth testing? |
|---|---|---|
| Hour | Midnight to 6 am local time ran 17% below the median, 36% below on Instagram | Yes, if you post then |
| Weekday | Every day within 2% of the median | Rarely |
| Format | Carousels 10% above typical, a link in the caption 7% below | Yes |
| Hashtag count | At most 5% either way | No |
| Caption length | Under 80 characters ran 9% below, longer all within 3% | A little |
Weekday and hashtag count barely matter, so do not spend a month on them. Hour and format are the cheapest wins. These are averages across accounts, so your top quarter is the final word on your audience.
Compare top and bottom, then write one rule
Look at the top quarter and ask what repeats. Maybe nine of ten are carousels, or most were posted before 10 am, or most were about customer stories. Then check the bottom quarter for the opposite pattern.
Write a single rule: "Carousels on Tuesday and Thursday mornings, customer stories first." A rule you can say in one sentence is one you will actually put in the calendar. For benchmarks to sanity-check your numbers, see the Mydrop social media benchmarks.
Change one slot a week
Do not rebuild the whole calendar at once. Move one recurring slot (say, Thursday's post) to the new rule for two weeks. Compare those posts to your median for that platform.
If they beat it, move the next slot. If they do not, you learned something cheaply and you keep the old pattern. This is slower than a full rebuild, and it is the only version that tells you what worked.
Watch cadence, but do not read it as a cause
In our data, accounts posting under once a week had a median engagement rate of 7.0%, and accounts posting seven or more times a week had 0.7%. That is a correlation: small accounts post less and have closer audiences. So cutting your volume will not lift your rate. It does mean that posting more is not a fix for weak numbers either. Keep a pace you can hold.
Keep the data and the calendar in one place
The reason most calendars never improve is that the numbers live in one tool and the plan in another. Mydrop's performance analytics show per-post metrics by platform, and the content calendar is where you move the slot, so a review takes minutes instead of an afternoon.
Avoid the three traps that spoil a data review
First, one viral post can drag a whole average, so use the median and not the mean. Second, comparing platforms with each other is unfair: in Mydrop's data the median engagement rate was 3.1% on Instagram and 1.1% on Facebook, so judge each platform against its own median. Third, a quiet week is not a trend. Wait for at least two weeks of a changed slot before you decide, and write the date of each change in your sheet so you can tell later what caused what.
This week: pull the table and move one slot
Today, export your last 90 days, mark the top and bottom quarters, and write your one-sentence rule. Tomorrow, move one slot. In two weeks, compare. You can connect your profiles and see per-post analytics free at app.mydropai.com.
Google review
Trustpilot review
Product Hunt comment
