Social media monthly stats spreadsheet:Reporting guidance

Athar Abidi, Jo Birdsey, Charlotte Hopwood

7 July 2026

The free social media monthly stats template provides you with a robust method for recording your channel stats every month, as well as calculating your engagement rates and generating reporting graphs.

This accompanying guide helps you use the spreadsheet, understand the terms used, and where to find the information you need on the platforms.

Credits

Athar Abidi, Jo Birdsey and Charlotte Hopwood developed this template and method in 2025 to monitor platform stats and report on social media performance at Cancer Research UK. The accompanying guidance was made in 2026 to support sector use.

Thanks to the authors and to all of the CharityComms members for making this resource possible. We’re only able to offer this template for free because of the support of our members. If you’d like to access more content and membership benefits, get in touch with the CharityComms’ membership team on admin@charitycomms.org.uk to find out more about becoming a CharityComms member.

Contact us

If you have any questions about this template or social media support, please contact the comms team on comms@charitycomms.org.uk.

Athar Abidi

head of social, Cancer Research UK

Athar Abidi is the Head of Social at Cancer Research UK.

Jo Birdsey

Social Media Manager, Cancer Research UK

Jo is a Social Media Manager at Cancer Research UK, where he's worked since 2019. As well as leading on the team's analytics and reporting, he is responsible for supporting the charity's Health and Science campaigns on social.

Charlotte Hopwood

Social media specialist and communications project manager,

Charlotte Hopwood is a Communications Project Manager at National Institute for Health and Care Research and a freelancer at HopComms, a social media reporting and strategy consultancy. Previously Charlotte was a Social Media Officer at Cancer Research UK.