Solution: Use today’s post to specify core use cases and to build a spreadsheet that provides empirical labor estimates. I recommend that you revisit this exercise periodically to fine tune current and forecasted resource needs, which in turn play a substantial role in defining the "I" of your social media ROI calculations.
Use Case 1- Read Content
- If you haven’t yet invested in a social media monitoring tool, start with Google.
- Count up the quantity of brand mentions that appear in a week. Break this out by major channels/categories like Facebook, Twitter, Blogs, YouTube, Flickr, news, and channels specific to your business model (Amazon product reviews, for example).
- Make a “feels right” estimate for how much time will be needed to read a mention. Hint: It’s somewhere between 15 seconds and three minutes.
- Multiply the time per mention by quantity of mentions.
- On average, about what percent of mentions will your brand respond to? Again, try to break out by channel/category. For example, response rates to Flickr photos will be far lower than posts on your Facebook wall.
- Multiply your percentage by the total quantity of mentions estimated in the prior use case to establish an estimated quantity of replies per week.
- Like you did with “Read Content,” estimate time per response and multiply by total estimated responses.
- Estimate how much time per week will be needed to record mention and response metrics for your brand in a spreadsheet.
- Another hint: Social media monitoring tools require no time to generate reporting, whereas the operational cost of “free” tools can begin to look daunting once the building spreadsheet reports is considered.
- Allocate enough time per week to allow analysis. Analysis should be conducted by resources beyond those who participate in the first three use cases. Think along the lines of a 15 – 30 minute review per week by Marketing, Customer Service, and Sales executives, for example.
- “Planned Content” tends to skew more towards marketing and awareness than the responsive content mentioned above. This includes executing contests, content that ties in with other channels, and more.
- Clicking “yes” to allow friends and fans to follow your brand doesn’t take that much time per week, but record it nonetheless to complete the picture. Over time, these small activities add up.
- Bigger brands might need an hour per week. Smaller businesses should expect something more like 15 minutes a week.
- It’s important to earmark time per week for pure browsing of mentions across different channels. Without allocating this time, organizations tend to gain tunnel vision around primary sources of content at the risk of missing out on emerging new blogs, for example, or the long tail of mentions across the internet at large.
Keep this data relevant: By necessity, most of the inputs (and therefore outputs) of this exercise are estimates. As time goes by, however, you’ll have real data coming in. On a regular basis, fine-tune the numbers for both volume and for time spent per use case. These refinements will bring more clarity to your current state and can support more accurate forecasting, too: Use trends to estimate when fans/followers/mentions will increase by 25%, 50%, and beyond and note how turning these dials affects overall resource demands. Along with other data inputs, your spreadsheet will become a budgeting and resourcing blueprint that justifies shifting resource costs from traditional areas like call centers and Marketing/PR to where the customers are: Social Media.