How to write a monthly social media report
A useful social media report tells you what went live, which pieces people responded to and what happened after they got in touch. Use the four-row template below and a worked example to see which bookings you can actually trace to Instagram.
Start with the question the report needs to answer
Suppose you run a studio in Dubai and have an evening class to fill. A video showing the class might get played many times outside the city. A quieter post answering “Can a beginner join?” might prompt three people nearby to ask for a trial. If your question is whether the evening class needs a second session, open the booking diary before choosing a post to repeat. If your question is how far a launch announcement travelled, open the account insights instead.
Write the account, dates and timezone at the top of the report. Agree on one business question with the person who takes bookings. At a business with several branches, name the branch the offer applied to. Keep a short note if a class was full, the instructor was away or opening times changed. Otherwise a closed evening can look like a disappointing campaign.
What goes in a monthly social media report?
Keep four short rows. Give each one a source and an owner. When a number is missing, write “unknown”, with a note about where you looked. A blank export and a confirmed zero tell different stories.
| Question | Where to look | What to record |
|---|---|---|
| Did we publish the agreed work? | Approved calendar and live account | Formats planned and published, postponed items and why. A finished but unpublished edit counts as delivered, not published. |
| What did people see or respond to? | Platform insights for the account and dates | Reach where available, saves or replies, and the specific posts behind them. Mark promoted posts. |
| Who asked about the offer? | Direct messages, WhatsApp or the enquiry log | Distinct people asking about the service, how they found it if known, and whether anyone replied. |
| What happened to those enquiries? | Booking diary or CRM, checked by the business | Confirmed bookings from that group, unresolved enquiries and reasons the team actually recorded. |
Keep names, phone numbers and message screenshots out of a shared report. Reception can reconcile individual enquiries in its own system and send a count. If the agency cannot see that system, it can report the conversations it handled; the business supplies the appointment count. Agree who will make that check before the next review.
A worked example: eight enquiries, three bookings
These figures are invented to show the calculation. They are not results from a BEIZ client. Imagine a Dubai studio posts a Reel inviting beginners to an evening trial. Reception logs eight distinct people asking about that class during the month. Five identify Instagram as their source: two reply to the Reel itself; the other three remember the account but cannot say which post they saw. The remaining three give no source.
By month end, three of those eight people have booked. Two of the three confirmed guests identified Instagram as the source, but only one replied to the Reel. The owner can say “three of eight enquirers booked”, and “two confirmed guests mentioned Instagram”. Only one booking in this example can be linked to the specific Reel. Don't fill the other source fields from a hunch or divide all three bookings by the Reel's views.
One useful follow-up is to check the five open conversations. If two people asked for a weekend class, the instructor can decide whether to offer one. If someone asked for the address and never received it, reception can change the reply. Both actions come from the same set of enquiries; neither calls for increasing the number of Reels by default.
Keep paid and organic results separate
When a post also runs as an ad, mark where the paid spend and the reported responses came from. If you only have a combined figure for reach, label it “combined”; don't estimate the organic share by subtraction across different reports. A person may see both versions. Avoid adding account reach to post reach, or summing the reach of several posts and calling it unique people for the month.
A click that opens WhatsApp is a useful signal that someone found the contact link. It does not tell you whether they sent a message. Equally, the same customer may start in Instagram DMs and then move to WhatsApp to confirm a time. Count them once in the enquiry log if reception can match the conversations. Where that link is uncertain, record separate channel totals and leave the combined total unknown. For a paid campaign, our guide to following an enquiry after the ad click explains which steps the business can actually check.
Compare months without changing the definition
Use the same account, reporting window and definition of an enquiry. A like, a supplier's pitch and a request for a class time belong in different categories. Write down whether bookings mean appointments entered in the diary or visits that took place. If late cancellations matter, give attended appointments their own row. Keep dates consistent: if an October enquiry converts in November, update the October group at the next review, or count November bookings by date. Label the method and stick to it.
For a small account, write “three of eight” alongside any percentage. One more booking changes the picture considerably. Next to each comparison, note anything the reader needs to know: a new branch, an extra paid campaign or a change to the booking link. When the previous month is missing a source, start a baseline this month instead of reporting growth from zero.
End with a decision someone can carry out
Choose one change and write down who owns it and when you will check it. In the class example, reception could add a map link to the approved reply and track whether first-time guests still ask for directions. The content team could then plan a Story showing the entrance. If you need a short publishing schedule for that follow-up, use the seven-day content calendar.
For a real example of the work behind a feed, see our Dubai salon project. The project documents shoots with six models, Instagram publishing and four campaigns. It provides evidence of the work delivered; the trial-class figures above are a teaching example. Our social media management service explains which plans include inbox handling and who confirms a booking.
Questions about monthly reporting
What if the agency has no booking data? Publish the enquiry count with the available source. Ask the booking owner to review those enquiries and give an aggregate update. Until then, show the result as unknown.
Which post should we repeat? Look at its job first. Repeat a directions Story if it helped people find the entrance. For a post asking people to book, check the follow-up conversations before choosing a winner by views.
What goes on the first page? Put the reporting dates, the question you set out to answer, what you can support with evidence and the next action. The rest of the account export can sit underneath for anyone who needs the detail.
Know what you need?
Let’s make it happen.
Start with a conversation. We’ll come back with a plan, a timeline and an estimate.
Let’s talk