How to find your regular commenters across posts
The people who comment on every post are your community; the ones who show up once are reach. Telling them apart takes a few exports stacked in one sheet and one pivot table.
Updated Nov 17, 2026 · 6 min read
Stack the exports
- Export each post you want to compare (five to ten recent posts works well) and download Excel.
- Open the first file. Add a column
postafterhashtagsand fill it with a short label, such as the post date. - Paste each other file underneath, without its header row, filling
postfor its rows. - Make the whole range a table (
Ctrl+Tin Excel).
Use user_id (column D) as the identity, not username: over several weeks some people will have renamed their accounts.
On how many posts did each person comment?
Excel pivot: Rows: user_id and username. Values: post, summarised by Distinct Count (tick Add this data to the Data Model when creating the pivot, or Distinct Count will not be offered). Sort descending.
Google Sheets: list the people with =UNIQUE(FILTER(D2:D, D2:D<>"")) in a new sheet, then next to each:
=COUNTUNIQUE(FILTER(Comments!M:M, Comments!D:D = A2))
(M being the post column). That is the number of different posts the person commented on.
A simple loyalty score
Posts commented on divided by posts exported: =B2/5 for five posts. People at 0.8 and above are regulars. Add their total comments with =COUNTIF(Comments!D:D, A2) to separate people who comment once on every post from people who argue at length on one.
Sort by the score and look at the top twenty: those are the accounts worth replying to first, thanking, or inviting to test something.
Watch for gaps
A regular who seems to have skipped one post may simply be missing from that export. Before acting on "who stopped commenting", check each export's row count against the post's own count. A post exported with half its comments will make half your community look like it left.
FAQ
How many posts should I compare?
Five to ten recent posts of a similar type. Mixing a giveaway post in will flood the list with one-time entrants.
Do replies count as commenting?
For community, yes: someone who replies to others on every post is very engaged. Filter is_reply if you want only top-level comments.