Open your last 10 posts, copy the 50 most recent comments into one sheet, and sort each into one of five buckets. You will have 10 content ideas in about 45 minutes. Do it every Friday and you never face a blank calendar again.
TLDR: Comments are the cheapest audience research you own. Sort them into questions, objections, stories, requests and praise, turn each bucket into one post format, and publish the best two ideas first.
Most teams guess what to post, then wait for the numbers to say whether they guessed right. Comments skip the guess. The question is already written, in your customer's own words, under a post you made.
Sort 50 comments into five buckets
Read each comment once and give it one label. Do not analyze, just label.
| Bucket | What it sounds like | Post it becomes |
|---|---|---|
| Question | "Does this work for X?" | A short answer post or carousel |
| Objection | "Too expensive for what it is" | A post that answers the doubt head on |
| Story | "I tried this last month and..." | A customer-voice post or a reply thread |
| Request | "Can you do one on Y?" | The Y post, tagged to the person who asked |
| Praise | "This saved my week" | Social proof, held for a sales post |
Expect questions and objections to be 40 to 60 percent of the sheet on a helpful account. If praise is most of it, your audience is friendly but not curious, and you need to ask better questions in your captions.
Count repeats before you write anything
One comment is an anecdote. Three comments asking the same thing is a topic. Add a column called "times asked" and merge near duplicates.
Pick the top 10 by count. Ties go to the idea that is closest to something you sell. This is how you avoid a feed full of interesting posts that never connect to revenue.
Match each idea to a format in two minutes
Use the shape of the comment to choose the format.
- Short factual question: a single image or a text post with the answer in the first line.
- "How do I" question: a carousel with one step per slide.
- Objection: a plain-spoken post that states the doubt first, then the evidence.
- Story: a reply to the original comment, then a follow-up post if the reply gets traction.
In Mydrop's data, carousels ran 10% above an account's typical post. That makes the "how do I" questions your best candidates for the carousel slot.
Reply first, post second
Before you publish anything, answer the comment you mined. Two things happen. The person feels heard, and you learn whether your answer is clear, because they will tell you if it is not.
If you handle comments in several apps, collect them in one place. Mydrop's social inbox puts comments from every connected channel in one list, so the Friday sheet takes minutes to build instead of an hour of tab switching. Pair it with AI captions to draft the first version of each post from the comment itself.
Put the ideas on the calendar the same hour
An idea list that lives in a spreadsheet dies there. Drop the 10 ideas straight into your content calendar with the source comment pasted into the notes. Two weeks later you can see which bucket produced your best posts and mine that bucket harder.
A simple rule keeps it sustainable: no more than 3 of 10 ideas per week should be praise-driven. Praise belongs in your sales content (see how to find customers in your comments), not your editorial calendar.
Three mistakes that waste the Friday session
Mining only the loudest posts. Your top post gets the most comments, but they are often about the giveaway or the joke. Pull from the last 10 posts so quieter, more useful questions show up.
Writing for the commenter instead of the crowd. One person asked, but ten others had the same doubt and stayed silent. Write the post so it works for a stranger who never saw the thread.
Skipping the label step. Reading without labeling feels productive, yet you cannot count repeats from memory. Five minutes of tagging gives you the ranking for free.
Mine last month's comments today
- Export or copy the last 50 comments.
- Label them in five buckets and add "times asked."
- Pick the top three ideas and write the first lines.
- Reply to the three people who inspired them.
Run it again next Friday with fresh comments. By week four you will see your own pattern, and that pattern is a better brief than any trend report.
Google review
Trustpilot review
Product Hunt comment
