Organise and monitor you're social media content with this Google Sheets - Social Media Planner. 
 
The planner includes fields for:
Content, Platform, Content Pillar, Details, Status, Scheduled Date, File and Notes.
 
Google sheets allows you to gather data on each field. 
This will give you a breakdown of how often you posted to each platform, and number of posts for each content pillars tag, etc. 
 
You will recieve a PDF file that contains the link to the Google Sheet template and an explainer.