Download the Social Media Dashboard from
This Social Media Dashboard (Excel Template) is designed to consolidate metrics across multiple Social networks such as Facebook, Twitter and YouTube and present in a single-page dashboard. If you are trying to create a monthly view of business impact of content posted across all the social networks by your business, then download this free template to create an instant monthly dashboard.
This template does not automate the data collection process. Once we are able to compile the monthly aggregated data from the different social networks, we can use this template to instantly build the dashboard as shown below.
FEATURES OF SOCIAL MEDIA DASHBOARD
The Social Media Dashboard template has the following features
Add up to 8 social media channels. Choose only ones relevant to your business.
Designed for Facebook, Twitter, Google+, YouTube, Blog, LinkedIn, Pinterest and Instagram
7 social media metrics (Audience, Activity, Applause, Amplification, Conversation, Conversion and Revenue)
Choose to display metrics as either absolute volumes or rate per activity
Add each month’s data and store all data in one file
Automatically calculates Month over Month (MOM) change %
Control alerts by setting thresholds on each metric
Alerts highlight only metrics which exceed thresholds (with red or green arrows)
Dashboard displays large numbers with M (millions) or K (thousands) for better readability
INSTRUCTIONS (HOW TO USE SOCIAL MEDIA DASHBOARD)
The template is very easy to use.
Step 1: Choose the social networks to include in dashboard
Check the boxes next to social networks you would like to display in the dashboard.
Step 2: Set Thresholds for change in metrics
Before we talk about these thresholds, let’s discuss the metrics the dashboard presents.
Audience: Number of Fans/Followers/Page Likes (depending on the network)
Activity Number of Posts/Updates
Applause: Number of Likes; Applause Rate: Average number of Likes per Activity
Amplification: Number of Shares; Amplification Rate: Average number of Shares per Activity
Conversations: Number of Comments; Conversation Rate: Average number of Comments per Activity
Conversions: Number of Conversions; Conversion Rate: Average number of Conversions per Activity
Revenue: Total Revenue Generated; Revenue per Activity: Revenue generated per Activity
When we display the Month over Month change for each metric, the dashboard can become very distracting with a lot of numbers.
The purpose of the dashboard is to allow us to focus only on metrics that require our attention and action.
So we use thresholds to only flag metrics that exceed our thresholds. Once a certain metric’s month over month (MOM) change exceeds the threshold in positive direction, Green arrows appear on dashboard. If the change exceeds the threshold in negative direction, Red arrows appear on the dashboard.
The metrics that are within the thresholds are grayed out so that they do not distract us from the action-required metrics.
Step 3: Enter monthly data for social media channels in DATA sheet. Data for all the 8 social networks are stored in the same table. You can add a new row for each month. (How to enter data in Excel Tables?)
Step 4: View DASHBOARD sheet
Now that we have entered our data, we can view the Dashboard in the DASHBOARD sheet.
Change Month drop down to view stats for that month
Change Metric type to show absolute volumes or rate per activity
For example, if there are 200 conversations from 10 Facebook posts in Mar 2016, 200 is the absolute volume of Conversations and 200/10 = 20 is the Conversation Rate.
Print or share DASHBOARD sheet as PDF, if needed
The Dashboard sheet is set up as print-friendly. Using the in-built Excel features, we can either print the sheet or export to PDF and share with our colleagues or clients.
If you find the template useful, please share with your friends. If you have any suggestions to improve the template, I would love to hear from you. Please post your thoughts in the comments.
Simple and Effective Excel Templates: http://indzara.com/
Free Excel Templates: http://indzara.com/free-excel-templates/
Premium Excel Templates: http://indzara.com/shop/
Small Business Management Templates: http://indzara.com/small-business-excel-templates/
Project Management Templates: http://indzara.com/project-management-excel-templates/
HR Templates: http://indzara.com/hr-excel-templates/
Personal Finance Templates: https://indzara.com/personal-finance-free-excel-templates/
Free Excel Course: http://indzara.com/useful-excel-for-beginners/
Subscribe to YouTube: http://www.youtube.com/user/theindzara?sub_confirmation=1