social media channel analytics dashboard (excel template)
TRANSCRIPT
Facebook 8 -17
Twitter 8 -5LinkedIn 7 1Other 0
Total 23 -21
Facebook 20,200 4,000Twitter 72,458 14,958
LinkedIn 724 424Total 93,382 19,382
Twitter LinkedInSept. Impressions 20,200 72,458 724
Interactions 390 227 6
Engagement 12.0% 0.3% 58.0%YTD Impressions 147,581 255,486 4,220
Interactions
EngagementBenchmark Engagement 1.5% 0.50% 1.00%
New Videos Views Views TD Subscribers Increase MOMYouTube 0 17 3,407 5 0.0%
Sept. YTD Last Month MOM6 70 18 -12
Total Clicks 116 100 243 -12740 419 25 154 30 12 -82 25 6 -8
50.00% 83.33% 50.00% 100.00%
Social Lead Conversion Dashboard xx/xx/2014
Total New Subscribers MOM = Month over Month To update Awareness:
23 New Subscribers Increase MOM Step 1: Fill out SocialData tab with new data under the month column - charts to automatically updateStep 2: Go to Social Dash and change new subscriber and Monthly Impressions column Letter in calculation (i.e. all B's c Total should update
New Subscribers YTD Step 3: Manually calculate MOM and color red or green277
Subscriber Growth MOMOther = YouTube Subscribers
Total Subscriber Reach Monthly Impressio Increase MOM19,648
Interactions= FB: Likes, Shares & Comments; TW: Mentions, Retweets & Clicks
Unique Impressions YTD407,332
To update Engagement:
Step 1: Fill out month column by changing the column to the current month on the data sheet
Step 2: YTD, should update automaticallyChart should update automatically
Impressions= Number of people reached
Interactions = industry standard KPIs (mentions, shares, retweets etc.)
To update Conversions: (this is from Google Analytics and Bit.ly for secondary clicks)Step 1: Fill out content data on SocialData tab for leads, content and referrals
# Bit.ly Links Step 2: For Bit.l # created that month, go to account and create a new bundle for the month. Then go to bitmarks by date and add monthlStep 3: Change letter of column to the current month on the data sheet - data should update
Site Referrals Step 4: Click on chart and data/Source - Point to new column of data for the pie on SocialData SheeContact Us Clicks
Total Conversions% Conversions
Conversion = Contact Us Inquiry
Source: Facebook Insights, Twitter, XXXXX 2014 unfunnel.com
Q3 Q4 Q1 Q2 TOTALSJan. Feb. Mar. Apr. May Jun. Jul. Aug. Sept. Oct. Nov. Dec. Jul.
Social Media Overview Overall ReachAwareness: Subscribers (Overall) 2,084 2,125 2,158 2,167 2,186 2,202 2,226 2,245 2,255 19,648Awareness: Increase in Subscribers 33 41 27 22 24 23 40 44 23 277Awareness: Increase in Subscribers (2013) -Awareness: Subscribers (2012) 67 100 112 120 130 140 1,906 8 20Awareness: Increase in Subscribers (2012) #VALUE! 33 12 8 10 10 62 (1,898) 12 (1,824)Awareness: New Subscribers (2013 Target) 55 55 34 44 44 33 2 10 10 109,957Awareness: Total Impressions (Reach) 40,000 40,000 40,000 40,000 40,000 40,000 29,957 40,000 40,000
Engagement: Interactions (Overall) #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/AEngagement: %Engaged FB (2012) 14.00% [1]Engagement: %Engageds TW (2012) 0.03%Engagement: %Engaged LK (2012) 0.00%Engagement: Avrg. Interaction Per post (2012) #REF! #REF! #REF! #REF! #REF! #REF! 150 - - 3,575,000Engagement: Total Link Clicks (2012 N/A) - - - - - - - - - [2]Monetize: Total Leads (Overall) #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! - - -Monetize: % Conversion of Leads 0.0% 0.0% 35000.0% 26600.0%Content: Total # of Posts (2012) #REF! 16 35000.0% 61600.0%Content: Total # of Interactions (2012) 0 0 0 0 0 $ - 2407 0 0Monetize: Total Leads (2012) 0Monetize: % Conversion of Leads 0.0%Monetize: Total Leads (2013 Target) #REF! #REF! #REF! #REF! #REF! #REF! 4 #REF! #REF! $200,000Monetize: Total Leads (2013 YTD) 0 0 0 0 #REF! 0 0 0 0
Awareness (Impressions) Total by NetworkFacebook 4,800 10,000 10,800 27,100 28,500 14,181 15,800 16,200 20,200 147,581
Twitter 6,357 15,890 4,767 19,068 36,547 22,242 20,657 57,500 72,458 255,486
LinkedIn - - - 1,400 900 300 596 300 724 4,220
YouTube - - 16 17 12 - - -
Google+ - - - - - - -
Pinterest - - - - - - -
Tumblr - - - - - - -
Other - - - - - - - TOTAL Impressions
Total Impressions/Reach 11,157 25,890 15,583 47,585 65,959 36,723 37,053 74,000 93,382 407,332Engagement (Interactions)
Facebook InteractionsTotal Page Likes 467 485 496 482 496 506 532 550 552New Fans 10 18 11 17 14 10 25 25 8 YTDUnique users (fans and nonfans) 834 2,000 3,100 9,500 10,100 5,200 5,700 6,900 6,300 18,900Stories Created (Interactions) 41 144 120 406 224 220 343 480 390Post Reach 509 2,200 2,600 7,500 7,800 4,200 3,000 4,300 6,600People talking about This (PTAT) 28 102 84 308 172 184 149 397 297% Unique Users Engaged 16.0% 22.0% 13.0% 18.0% 13.0% 18.0% 19.0% 13.0% 12.0%Twitter InteractionsNew Followers 15 15 9 (3) 2 4 8 13 8Mentions 1 4 8Total Interactions (fav, retweets & replies, click - 1 - 1 4 4 6 124 227Followers 1,545 1,560 1,575 1,590 1,587 1,584 1,575 1,570 1,571% Engaged 0.00% 0.01% 0.00% 0.01% 0.01% 0.02% 0.03% 0.22% 0.31%LinkedIn InteractionsTotal Followers 72 80 87 95 103 112 119 125 132New New Followers 8 8 7 8 8 9 7 6 7Interactions - - - - - 1 2 - 1Clicks - - - 2 8 - 7 12 5Total Interactions - - - 2 8 10 9 18 6Engagement Rate 0.0% 0.0% 0.0% 2.1% 7.8% 8.9% 1.5% 14.4% 58.0%YouTube Video Views 3,781 3,800 3,390 3,407
Monetize (Leads)Website Traffic 0 0 0 0 0 0 328 350 264Twitter Mentions 0 0 0 0 0 5 0 0Articles and Blogs 0 0 0 0 0 2 0 2Campaign - Paid Media 0 0 0 0 0 0 0 0Total URL presence 0 0 0 0 0 335 350 266Total Leads 0 0% Conversion of Leads 0.0% 0.0%
ContentFacebook Posts 5 22 29 13 44 47Twitter Posts 4 10 3 33 33 10 16 38 47LinkedIn Posts - 4 4 2 8 26YouTube - 0 3 - - - -
-
Total Posts 4 50 8 59 69 25 16 90 120Total Interactions 41 145 120 407 228 225 351 604 618Avrg. Interaction Per Post 10.25 2.90 15.00 6.90 3.30 9.00 21.94 6.71 5.15
Referral ClicksTotal Clicks Sig Links (Referrals) 36 25 40Email Clients, Apps, Direct 20 55 36Twitter.com 14 45 28Facebook.com 14 72 39Linkedin.com 9 36 13Total Clicks (including 3rd party) 60 243 116 419Total Links YTD
Social Media Analytics (FY14)
Q3 Q4 Q1 Q2 TOTALSTotal Clicks YTD 100
Contact Us Links Clicked 14 12 4 30
New Bit.ly's created 18 46 6 7025
Social Media Analytics (FY14)
FACEBOOKPage Impressions: The total number of times any Facebook user (fan or non fan) could have potentially se
Users: The number of unique users (fans or non fans) that have seen an any content associated with your
Fan: The number of impressions generated by the people that have liked your page.User Post: The number of impressions generated from user posts to your wallPage Post: The number of impressions generated from comments on your Page posts.Mention: The number of impressions generated by people who have tagged your Facebook page in a post
Organic: The number of times your posts were seen in News Feeds or Tickers or on visits to your Page. ThViral: The number of impressions generated from a story published about your Page (aka from a Page PosPaid: The number of impressions generated from a Sponsored Story or Ad pointing to your Page.
New Fans: The number of new Facebook users that have liked your Page over the duration of your report.
'Unliked' Your Page: The number of Facebook users that have unliked your Page over the duration of your
Reach: The number of unique people who saw any content about that post. This will include both fans and
Engaged Users: The number of people who clicked anywhere in your post without generating a story plus t
Talking: The number of people who have created a story from this post. Stories are created when someone
Likes: The number of people who liked this post.
Comments: The number of people that commented on this post.
Shares: The number of people that have shared this post.
Engagement: Engagement is a ratio of engaged users to reach. As an example, a post with 4 engaged use
[1] John Joaquim:Hey Jude[2] John Joaquim:Change targets due to last few months results