A template for SMS engagement is less about benchmarks than about bookkeeping. Text messaging does not report reads the way email does, so the sheet has to be built around what can actually be observed: what was sent, whether it arrived, who replied, who stopped, and what happened afterwards. Build columns for those five things and the sheet tells you something true about your own list.
What the template is for
Two jobs. First, it turns a campaign into a record rather than a memory, so a question about last spring's reminder series has an answer. Second, it makes campaigns comparable to each other, because the same columns are filled the same way every time.
It is not a dashboard and it does not need to be attractive. It needs to be dull enough to fill in every month without argument.
The columns that carry the work
- Campaign name, using a naming rule you can still read six months later.
- Send date and time, so timing effects stay visible.
- Segment, named by what the people in it have in common.
- Recipients, meaning numbers the send was attempted to.
- Delivered, meaning numbers that accepted the message.
- Failed, split by cause where the platform reports it.
- Replies, counted by a person reading them.
- Opt-outs, meaning stop requests that arrived from this send.
- Bookings that followed, matched against the calendar.
- Notes, for anything that changed mid-campaign.
Keep counted columns and calculated columns visually separate. Nothing on the sheet should be an estimate wearing a number's clothes.
Treat the sheet as a client record and store it accordingly. Campaigns can be tracked with numbers and segments alone, without names, and the file belongs somewhere access is controlled rather than on a shared desktop. A template that invites the team to paste a client list into a spreadsheet is a privacy problem waiting for a quiet week.
Definitions to fix before the first send
Four sentences decide most of the work later. What counts as a reply, since an automatic stop message is not engagement. What counts as a booking, since a click is not an appointment. Which window after the send counts, since a booking eight days later may have nothing to do with the message. And which recipients belong in the denominator, since numbers that failed to deliver were never in the audience.
Write those into a definitions tab with the date you settled them. When a rule changes, add a dated line rather than editing the old one.
Filling it campaign by campaign
Fill within a day of the send, while the replies are still fresh in the inbox. Match bookings against the calendar in one sitting rather than across a week, because two people applying two rules produce two different numbers.
Close each campaign before opening the next. Corrections go in the notes tab with a date, not into a figure someone has already read.
Reading it without outside comparisons
One campaign tells you about one campaign. Read four or five together and look for direction: which segments reply, which messages produce bookings, which sends produce opt-outs.
Resist published figures. A number quoted for a national retail list is not the same measurement as one clinic's reminder series, and the definitions behind it are rarely stated. Your own trailing campaigns are the reference line that survives contact with reality.
How the sends get sent
The sheet fills itself only if the sending side keeps records. Elevoi answers calls, captures client details, and sends confirmations, reminders, and follow-up messages from the booking record, which is what makes delivery, replies, and bookings matchable in the first place.
Fill one month first, then read the SMS marketing for med spas guidance before widening the sheet. The salon statistics hub covers the neighbouring measures.