Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Read Meta's rules
One private reply per comment, within 7 days, follow-ups only after they reply and within 24 hours. The rules tab has Meta's wording and links.
Pick and test the keyword
Type your keyword, the spellings people use and words to exclude. Paste real comments into the tester and check what matches and which questions need a manual reply.
Write message 1 and the follow-up
Pick a script (free guide, discount code, product link, booking, waitlist), edit it, keep message 1 under about 300 characters, and paste it into your comment-to-DM tool.
Track every post
After each post or ad, type comments, matches, replies sent, link clicks, replies and sign-ups. The tracker shows the rates and flags the weakest step.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Rule | Condition | Default |
|---|---|---|
| One message | One private reply per comment | Meta's rule |
| 7 days | Private reply sent within 7 days of the comment | Meta's rule |
| Follow-up | Only after they respond, within 24 hours | Meta's rule |
| Where | Posts, reels, stories, Live (only while live) and ad posts | Meta's rule |
| Keyword | One short word, matched as 'contains', any case | Plus spellings and exclusions |
| Questions | Comment has no keyword but has a ? | Reply by hand |
| Match rate | Matched ÷ comments | Flag under 80% |
| Click rate | Link clicks ÷ comments | Flag under 30% |
| Reply rate | Replies ÷ comments | Flag under 15% |
| Sign-up rate | Sign-ups or sales ÷ comments |
Worked review example
Fictional 'Comment GaaS' ad: 2,140 comments, 1,940 matched the keyword and got a private reply, 1,020 clicked the link, 590 replied YES and 230 signed up (11% of comments).
A carousel with the keyword FORMATS matched only 63% of its 95 comments (people wrote 'format' and 'formats pls'), so the tracker flags the keyword as too hard.
What this template does and does not establish
Meta's rules are from its developer docs as read on 17 November 2026 and can change; tools add their own limits. Covers Instagram and Facebook only. Matching behaviour differs between tools, so test yours. Funnel flags are rules of thumb, not benchmarks. Example comments and counts are fictional. No account connection, macros or automatic sending.
