march madness report_excel
TRANSCRIPT
BOOK MADNESSSocial Media Report
Overview & Goals• March 2, 2015 – April 7, 2015• Facebook, Instagram, Twitter
• Rule: Once a day per platform per person• Goals:
• Increase social media views• Increase engagement interactions• Build a stronger online presence
Facebook Page
Engagement0.00%
5.00%
10.00%
15.00%
20.00%
25.00%
Mar '14Feb '15Mar '15
Users0
500
1000
1500
2000
2500
3000
3500
4000
4500
Mar '14Feb '15Mar '15
Likes0
5000
10000
15000
20000
25000
30000
Mar '14Feb '15Mar '15
*6.94% decrease from March 20144.6% increase from February 2015
*2,894 increase from March 20141,250 increase from February 2015
*21,122 increase from March 2014193 increase from February 2015
Facebook Reach
Organic Reach
0
5000
10000
15000
20000
25000
30000
35000
40000
45000
Feb '15Mar '15
Monthly Difference Annual Difference
Total Reach
102000
104000
106000
108000
110000
112000
114000
Feb '15Mar '15
*11,692 increase in organic reach6,598 increase in total reach
Organic Reach
0
5000
10000
15000
20000
25000
30000
35000
40000
45000
Mar '14Mar '15
Total Reach
100000
105000
110000
115000
120000
125000
130000
135000
Mar '14Mar '15
*35,247 increase in organic reach20,383 decrease in total reach
Facebook Impressions
Organic Total0
50,000
100,000
150,000
200,000
250,000
300,000
Feb '15Mar '15
Monthly Difference Annual Difference
*46,895 increase in organic impressions5,347 increase in total impressions
*117,180 increase in organic reach869,312 decrease in total reach
Organic Total0
200,000
400,000
600,000
800,000
1,000,000
1,200,000
Mar '14Mar '15
Facebook Paid Reach & ImpressionsPaid Reach
Paid Reach0
20000
40000
60000
80000
100000
120000
140000
Mar '14Feb '15Mar '15
Paid Impressions
Paid Impressions0
200000
400000
600000
800000
1000000
1200000
Mar '14Feb '15Mar '15
*Paid impressions explains the huge drop in total reach & impressions between March 2014 and March 2015
Facebook Negative Feedback
Negative Feedback from Users0
20
40
60
80
100
120
Mar '14Feb '15Mar '15
• 0 negative feedback in March 2014• 58 negative feedback in February 2015• 112 negative feedback in March 2015
• The more we post, the more negative feedback we will get from users
• Hide• Hide All• Report Spam• Page Unlikes
Facebook Summary• Engagement has increased• Huge spike in Facebook users• No significant spike in Page Likes• Reach more significant than impressions
• (from February 2015 – March 2015)
• Paid reach and impressions dropped significantly• Negative feedback increased
Instagram Posts
avg like/media avg comment/
media
0
5
10
15
20
25
Mar '14Feb '15Mar '15
# of likes0
200
400
600
800
1000
1200
Mar '14Feb '15Mar '15
# of comments0
50
100
150
200
250
300
350
400
450
500
Mar '14Feb '15Mar '15
Instagram Followers
Followers gained from previous month0
10
20
30
40
50
60
70
80
Mar '14Feb '15Mar '15
*Follower gains are gained through outside engagements.
Follower Amount0
100
200
300
400
500
600
700
Mar '14Feb '15Mar '15
Instagram Summary
• Average likes decreased; overall # of likes increased• Average comments increased; overall # of comments increased• Book Madness increased engagement immensely
• Those that comment forget to like the photo • Amount of followers gained was independent from this project
• Must engage on “Discover” page and target hashtags
Yay
Twitter Impressions
Engagement Rate
Feb '15 Mar '150.00%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
7.00%
8.00%
9.00%
Week 1Week 2Week 3Week 4
Impressions
Feb '15 Mar '150
50
100
150
200
250
Week 1Week 2Week 3Week 4
*Steady increase in impressions until the increase in engagement (week 3)
Twitter Engagement
Retweets
Feb '15 Mar '150
5
10
15
20
25
Week 1Week 2Week 3Week 4
Favorites
Feb '15 Mar '150
5
10
15
20
25
30
35
40
Week 1Week 2Week 3Week 4
*Great increase in favorites and RTs
Twitter Summary• Increase in RTs, favorites, and post clicks• Engagement increased due to increased
interactions• Follower increase of 196 from February to
March• Campaign did not have much effect on
followers
Overall Summary• Facebook
• Engagement and reach increase• Instagram
• Engagement and comment increase• Decrease in av. Likes, BUT increase in # of Likes
• Twitter• RT and favorite increase• Slight increase in engagement
• Overall we saw an increase in engagement across all 3 platforms. #BookMadness was a success!