Open your last 10 posts, copy the 50 most recent comments into one sheet, and sort each one into one of five buckets. You'll have 10 content ideas in about 45 minutes. Do it every Friday and you'll never stare at 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 tell them whether the guess was 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. Don't analyse, 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, saved for a sales post |
On a helpful account, expect questions and objections to make up 40 to 60 percent of the sheet. 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's closest to something you sell. That's how you avoid a feed full of interesting posts that never connect to revenue.
Match each idea to a format in two minutes
Let the shape of the comment 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 "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 find out whether your answer is clear, because they'll tell you if it isn't.
If you handle comments across 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 your 10 ideas each 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're 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 labelling feels productive, yet you can't 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'll see your own pattern, and that pattern is a better brief than any trend report.
Google review
Trustpilot review
Product Hunt comment
