Our social media team uses a social media management tool (outside of Workfront) for scheduling, posting and analysis. However, one of our objectives over the summer was figuring out a way to get applicable social media efforts incorporated into Workfront.
Courtney, we use a number of platforms and channels as well, and we also did not want to go down the 'a project for every tweet' route. But, we still needed a way to capture data for the team's reporting needs, as well as to weave in social media workflow(s) and tasks into our Marketing projects. So, what we did was create a "Social Media Development" section of tasks within applicable Project Templates (think Webinars, Videos, etc.), where social media was part of the overall workflow. We also created a specific "Social Media Template" for the team's usage when dealing with larger social media campaigns that would carry through the span of a few weeks/months.
In order to capture the data that the team needed, we created a "Social Media Custom Form" for social media team usage only that includes a checkbox field called "Social Media Channel", listing out Twitter, Facebook, etc. There is display logic applied such that if "Twitter" is selected, then it displays our channels (another checkbox field), as well as a numeric text field to indicate number of Twitter Posts. (In the Custom Form, I also included some calculated fields so that the multiple checkbox fields could be used as a grouping in reports/charts.). A dashboard was then created for the social media team, where they can view charts that show: number of Twitter Posts by Twitter Channel, number of Facebook Posts by Facebook Channel, etc. And from that, they can delve deeper into each channel and other data fields, as needed.
Hope this helps out
--Terry Terry Hynd EBSCO Information Services