📮 Track Social Media
This template is intended for those seeking a minimal social media tracker, pipeline and DM management space. For me, social media is something I'm quite behind with, so I created this little page to keep track of everything and start generating ideas. Included are two databases.
The DM Management Database
At the top of this template is a parent/child relational database to check, answer and file DMs.
The Social Media Pipeline And Archive
Included in this database are three views: Pipeline, Archive and Admin Hub
The Pipeline
There are 4 status options, 3 of which are viewable in the Pipeline: Idea, Edit, Post and Archive. Every entry labeled “Archive” is pushed to the next database view as shown below.
The Archive
The Admin Hub
This is where I keep all stats and engagement numbers for a quick look at social growth. Included are number of likes, number of comments and a simple engagement calculation.
Engagement Formula:
round(100 * prop("Comments") / prop("Likes")) / 100
