How to Create a Social Media Dashboard

A Social Media dashboard enables you to measure your company’s social activities from Twitter engagement, Facebook comments to LinkedIn shares. With a dashboard, you can understand what’s working and what isn’t, and proactively work to optimize each social channel.

As Social Media becomes a more prominent medium for marketers, in having a dedicated Social Media dashboard that measures activities and ROI, it enables marketers to become data-driven and can secure executive buy-in and budget for further initiatives.

An optimal Social Media dashboard has charts and metrics that focus on two aspects of social initiatives:

  • Brand Social: the day-to-day operations of your social channels (tweets, Facebook and LinkedIn updates)
  • Campaign specific metrics: social activities that are associated with specific paid campaigns, often having a dedicated hashtag for the event, webinar, presentations, etc.

With this in mind, continue reading as we walk you through how to create a Social Media dashboard that quantifies ROI.

How to Create a Social Media Dashboard

Before you start connecting your social channels (Twitter, Facebook, LinkedIn, Google+, etc.), pause for a moment to consider your social goals. Your goals may vary based on your business, you may want to get more budget for a paid social campaign or just widen your brand awareness on a specific channel. Regardless, the first step in measuring Social Media is understanding your measurement plan and know what the ultimate goal is.

From these goals, you can then create metrics that align with those goals and measure them. For example, if you want to measure amplification metrics like ‘Page Likes’ to measure engagement—you can measure how many likes you get on Facebook.

socialmediadashboard.png

To create the Social Media dashboard above, follow these steps:

  1. Outline the specific goals you want to achieve from creating a Social Media dashboard. This helps with defining the metrics that will appear on your dashboard.
  2. Connect your social channels to an analytics solution that will measure all your social channels together, in one dashboard.
  3. If you’re using Chartio to create your dashboard, once you connect your data to Chartio, you can click the + New Dashboard button to create a new dashboard. A modal will appear to prompt you to name your dashboard.
  4. Once you’ve appropriately named your dashboard, click the Add Chart button on the right to create your first chart. (For dashboard best practices, read more here).
  5. In the Data Explorer, you can the option of writing SQL to query your data or you can use our Interactive Mode to drag and drop inputs into the measures and dimensions (without writing an SQL).
  6. There are 16 different chart types, so be sure to choose the appropriate chart for your metric.
  7. Once you’re done, save and share your dashboard with your Marketing team through a shareable link or a scheduled report per your choosing.
  8. Remember, your dashboard auto-updates at a timely interval, so you can check back periodically throughout the day to measure success and get social proof.

Metrics to Track on a Social Media Dashboard

For our example Social Media dashboard, we categorized metrics into four categories:

  1. Amplification
  2. Engagement
  3. Click-through Rate
  4. Paid 

The first three categories mainly measures Brand Social, while the fourth category heavily measures campaign-specific metrics.

Amplification

  • Page Likes
  • Page Views
  • Page Reach
  • Week-over-week change between the three metrics (likes, views, reach)

Engagement

  • Shares on Facebook
  • Shares on Twitter
  • Shares on LinkedIn
  • Shares on Google+
  • Week-over-week change between the four channels

Click-through Rate

  • Percentage of Click-Through Rate (into web content from social)
  • Bounce rate (into web content from social)

Paid

  • Number of promoted tweets
  • LinkedIn Sponsored Updates
  • LinkedIn InMails
  • Facebook ADs

Conclusion

As Social Media continues to be a prominent marketing medium and more Executives expect to see high-level metrics from it, you can easily create a Social Media dashboard that tracks all your channels in one place.

For more insight on how to create dashboards, download our white papers: The CMO’s Guide to Dashboards and The Six Dashboards Every Startup Needs.