Kings XI Punjab
Facebook, Twitter, Google+, Instagram, YouTube
Weekly & Monthly
MS Word, MS Excel, MS PowerPoint
Created various reports on social media content performance, milestones, content planning, upcoming events, competitor analysis, campaigns + reports for brand partners, etc. among other things
Designed the monthly PowerPoint slide deck from scratch based on a brief + mentored a fellow teammate for the same with another account
Improved the weekly Excel report based on KXIP manager's requirement to make the Spreadsheet more visual than just all-text
Used data and limited sentiment analysis to guide the content strategy for KXIP's social media accounts
World Class Willow India
Facebook, Twitter, Instagram
Weekly & Monthly
MS Word, MS PowerPoint, Google Sheets
Created reports about social media content performance, milestones, content planning, social media strategy, campaigns, matches covered, key highlights, etc. among other things
Designed the reports from scratch, and reported to the company founder
Changed the social media strategy for WCW India's social media accounts based on past performance
OneCricket
Facebook, Twitter, Instagram
Weekly & Monthly
Google Docs, Google Sheets, Google Slides
Reported social media content performance, milestones, content mix, matches covered + campaign brief & rules, etc. among other things
Designed these reports from scratch, and reported to the manager & senior management
Changed the social media strategy from time-to-time based on how the likely audience was engaging with the content
Since these reports contain sensitive brand information, I am unable to share anything here in visual form.
Regarding KXIP, I submitted reports to my manager at TSD, and the manager was happy with the work. About emails sent to the KXIP manager, I introduced a quick summary for the week / month along with reports; and the idea was a success, too.
For WCW, the monthly MS Word document was shared with key content links and highlights for the month; whilst the weekly Google Sheets was updated every week twice, on Monday morning and Thursday evening. The founders were happy to have the work details and content performance in these two reports.
For OneCricket, the weekly and the monthly Google Sheets included new content ideas shared in a respective week / month along with the details of content types + detailed platform-specific metrics about the shared content. My manager was very impressed with how helpful and communicative the reports itself were.
I personally find working with reports a fun game, and I am quite efficient at creating the same; sometimes, even from the scratch—just give me the brief and consider it done. : )