How to use this dashboard: DASHBOARD SOCIAL M
1. Score data manually in "Daily_Scoring_-_Oct2011" (October 201
2. Import segmented "Value per visitor"-data from analytics tool
3. Overview monthly in dashboard
4. Success!
Manually scored 1 time/day
Twitter Facebook
# Posts: 8 9
# Comments: 13 22
# Re-tweets/Shares: 14 19
# Favorite clicks/Likes/+1: 3 81
1. Conversion Rate 1.63 2.44
# Comments per post:
2. Amplification Rate 1.75 2.11
# Re-tweets/Shares per post:
3. Applause Rate
0.38 9.00
# Favorite clicks/Likes/+1 per post:
Imported data from analytics tool 1 time/
Twitter Facebook
4. Economic Value: 0.13 $ 3.72 $
Value per visitor:
Read more about the metrics: http://www.kaushik.net/avinash/best-social-media-metri
Sheet questions? erik.ohlen@mediaanalys.se
BOARD SOCIAL MEDIA METRICS
(October 2011)
1 time/day
Google+ Blog Youtube
4 3 4
5 22 5
7 3 3
19 16 28
1.25 7.33 1.25
1.75 1.00 0.75
4.75 5.33 7.00
m analytics tool 1 time/day
Google+ Blog Youtube
1.22 $ 1.43 $ 0.74 $
/avinash/best-social-media-metrics-conversation-amplification-applause-economic-value/
DAILY SC
Twitter Facebook
Tweets Comments Re-tweets Favorite clicks Posts Comments Shares
1-Oct
2-Oct 1 2 3 1 4 2
3-Oct 1 2 1
4-Oct
5-Oct 1 1 1 1 1 4
6-Oct
7-Oct 1 1 1
8-Oct 1 2 2
9-Oct
10-Oct 1 2 4
11-Oct
12-Oct 1 4 2 1
13-Oct
14-Oct
15-Oct 1 3 2
16-Oct
17-Oct 1 1 4
18-Oct 2 3 2 1
19-Oct
20-Oct
21-Oct 1 3 2
22-Oct
23-Oct 1 1
24-Oct
25-Oct
26-Oct 2 6 3
27-Oct
28-Oct
29-Oct
30-Oct
31-Oct
Total 8 13 14 3 9 22 19
DAILY SCORING of SOCIAL MEDIA METRICS
(October 2011)
book Google+ Blog
Likes Posts Comments Shares 1+ Posts Comments Share Clicks 1+/Likes
17 1 2 2 5 1 14 2 3
10
4
3 1 1 3 7
8
1 8 1 10
1 2 4
14
1 2 3
9
1 3
16
81 4 5 7 19 3 22 3 16
Youtube
Videos Comments Share Clicks 1+/Likes
1 3 2 15
1 2 1 9
1
1 4
4 5 3 28