Heartbeat measures the health

media channe
3.50
Subscriber Interaction Conversation Relevance Avg. Pot. Rea

3.00

2.50

2.00

1.50

1.00

0.50
 3.50

Subscriber Interaction Conversation Relevance Avg. Pot. Rea

3.00

2.50

2.00

1.50

1.00

0.50

0.00
Jan Feb Mar Apr May Jun Jul

Conversation Releva
Jan Feb Mar Apr
Interactions/Activity
1.76 2.74 2.81 2.32

Avg. Pot. Reach per A

Jan Feb Mar Apr
Reach/Activity 669.83 949.27 1012.32 816.56

Network Activity
 Jan Feb Mar Apr
Interaction/Subscribers
0.02 0.02 0.02 0.01

Nilsson Consulting is a young Paris based Social CRM boutique age

companies are facing with customers that are increasingly more info

Nilsson Consulting provides Social CRM consulting services, social

measurement as well as custom client workshops and trainings. Rea
[email protected]

Social Media Metrics Dashboard by Joakim Nilsson is licensed under a Creative C

the health of your owned Social
dia channels
1200.00
vance Avg. Pot. Reach per Activity (2nd X-axis)

1000.00

800.00

600.00

400.00

200.00
 1200.00

vance Avg. Pot. Reach per Activity (2nd X-axis)

1000.00

800.00

600.00

400.00

200.00

0.00
Jun Jul Aug Sep Oct Nov Dec

ersation Relevance
May Jun Jul Aug Sep Oct Nov Dec

2.62 2.62 3.11 2.46 2.97 3.19 3.00 2.70

ot. Reach per Activity

May Jun Jul Aug Sep Oct Nov Dec
880.82 926.49 858.86 833.84 872.81 802.91 540.48 483.53

etwork Activity
 May Jun Jul Aug Sep Oct Nov Dec
0.01 0.01 0.02 0.01 0.02 0.02 0.02 0.02

al CRM boutique agency specialised in solving the problems today’s

ncreasingly more informed, empowered and demanding.

lting services, social media monitoring services, analytics &

ps and trainings. Read more on http://joakimnilsson.com or email

nsed under a Creative Commons Attribution-NoDerivs 3.0 Unported License

1200.00

1000.00

800.00

600.00

400.00

200.00
1200.00

1000.00

800.00

600.00

400.00

200.00

0.00
nse
 Need help with Social media analytics and ROI? E-mail me directly [email protected] or rea
http://www.joakimnilsson.com

Data Input Sheet, insert all your social media

here
450
Activity Interactions Subscribers (2nd X-axis) Reach (2nd X-axis)

400

350

300

250

200

150
400

350

300

250

200

150

100

50

0
1 2 3 4 5 6 7 8 9 10

1. Activity, all the things that you’ve published on your social networks
Channel Activities WS Jan Feb Mar Apr May Jun Jul Aug Sep
Blog #nr of posts 4 5 6 3 7 7 7 7 7 7
Facebook page #nr of published activities 2 9 8 9 8 9 8 7 6 9
Google+ page #nr of published activities 2 12 12 8 8 9 8 8 7 8
Twitter profile #nr of tweets, RTs, replies 1 9 5 4 5 6 7 8 9 6
Pinterest boards #nr of pins 3 7 4 5 6 1 3 4 5 6
Youtube channel #nr of video uploads 5 2 3 2 1 1 1 1 1 1
Total 44 38 31 35 33 34 35 35 37

Jan Feb Mar Apr May Jun Jul Aug Sep

20 24 12 28 28 28 28 28 28
Weighted Result 18 16 18 16 18 16 14 12 18
(Graphs are based on these 24 24 16 16 18 16 16 14 16
9 5 4 5 6 7 8 9 6
numbers)
21 12 15 18 3 9 12 15 18
10 15 10 5 5 5 5 5 5
Total: 102 96 75 88 78 81 83 83 91

2. Interaction, all the things that your subscribers have published

Channel Interactions WS Jan Feb Mar Apr May Jun Jul Aug Sep
Blog #nr of comments 5 1 2 0 3 3 3 3 3 3
Blog #nr of social shares 4 6 5 4 4 4 4 4 4 4
Facebook page #nr of people talking about this 3 34 56 45 34 34 34 34 34 56
Google+ page #nr of +1’s 2 4 5 4 7 7 7 7 7 7
Google+ page #nr of comments 2 1 2 2 2 2 6 7 2 2
Google+ page #nr of shares 2 2 1 4 3 3 3 3 3 3
Twitter profile #nr of mentions, RT’s 1 23 31 29 34 34 34 78 34 34
Pinterest boards #nr of repins 2 2 3 2 1 1 1 1 1 1
Youtube channel #nr of likes 1 6 4 5 2 2 2 2 2 2
Youtube channel #nr of dislikes -1 1 0 2 1 1 1 1 1 1
Youtube channel #nr of favorites 3 1 0 0 0 0 0 0 0 0
Youtube channel #nr of comments 4 0 2 1 2 2 2 2 2 2
Youtube channel #nr of shares 2 0 0 0 1 1 1 1 1 1
Total 81 111 98 94 94 98 143 94 116

Jan Feb Mar Apr May Jun Jul Aug Sep

5 10 0 15 15 15 15 15 15
24 20 16 16 16 16 16 16 16
102 168 135 102 102 102 102 102 168
8 10 8 14 14 14 14 14 14
2 4 4 4 4 12 14 4 4
Weighted Result
4 2 8 6 6 6 6 6 6
(Graphs are based on these 23 31 29 34 34 34 78 34 34
numbers) 4 6 4 2 2 2 2 2 2
6 4 5 2 2 2 2 2 2
-1 0 -2 -1 -1 -1 -1 -1 -1
3 0 0 0 0 0 0 0 0
0 8 4 8 8 8 8 8 8
0 0 0 2 2 2 2 2 2
Total: 180 263 211 204 204 212 258 204 270

3. Reach, an estimation of how many people could have seen your published a
Channel Reach WS Jan Feb Mar Apr May Jun Jul Aug Sep
Blog #nr of unique visitors 10 456 325 657 362 362 362 362 362 362
Facebook page #nr of unique people reached 1 678 876 987 567 345 987 567 345 345
Twitter profile #nr of potential people reached 1 45600 56099 45677 45677 45677 45677 45677 45677 56789
Google+ page #nr of potential people reached 3 2365 6745 3465 4756 3475 4635 3485 4384 3493
Pinterest boards #nr of impressions 2 4000 5000 5000 3000 3456 4566 4343 2345 3234
Youtube channel #nr of video views 5 478 134 459 345 345 345 456 345 345
Total 53577 69179 56245 54707 53660 56572 54890 53458 64568

Jan Feb Mar Apr May Jun Jul Aug Sep

Weighted Result
(Graphs are based on these
numbers)
 4560 3250 6570 3620 3620 3620 3620 3620 3620
Weighted Result 678 876 987 567 345 987 567 345 345
(Graphs are based on these 45600 56099 45677 45677 45677 45677 45677 45677 56789
7095 20235 10395 14268 10425 13905 10455 13152 10479
numbers) 8000 10000 10000 6000 6912 9132 8686 4690 6468
2390 670 2295 1725 1725 1725 2280 1725 1725
Total: 68323 91130 75924 71857 68704 75046 71285 69209 79426

4. Subscribers, the size of your network in unique individuals

Channel Subscribers WS Jan Feb Mar Apr May Jun Jul Aug Sep
Blog #nr of subscribers 8 20 21 23 25 25 29 29 34 35
Facebook page #nr of page likes 2 2345 2367 2456 2567 2600 2700 2800 2900 3000
Twitter profile #nr of followers 2 1098 1234 1300 1345 1345 1345 1345 1345 1345
Google+ page #nr of ppl who has circles you 5 567 600 700 780 800 810 845 890 900
Pinterest boards #nr of followers 3 456 457 458 567 678 678 789 890 980
Youtube channel #nr of channel subscribers 5 5 6 7 17 17 17 17 17 17
Total 4491 4685 4944 5301 5465 5579 5825 6076 6277

Jan Feb Mar Apr May Jun Jul Aug Sep

160 168 184 200 200 232 232 272 280
Weighted Result 4690 4734 4912 5134 5200 5400 5600 5800 6000
(Graphs are based on these 2196 2468 2600 2690 2690 2690 2690 2690 2690
2835 3000 3500 3900 4000 4050 4225 4450 4500
numbers) 1368 1371 1374 1701 2034 2034 2367 2670 2940
25 30 35 85 85 85 85 85 85
Total: 11274 11771 12605 13710 14209 14491 15199 15967 16495

Social Media Metrics Dashboard by Joakim Nilsson is licensed under a Creative Commons Attribution-NoDerivs 3.0 Unp
on.com or read more at

media metrics

100000
Reach (2nd X-axis)

90000

80000

70000

60000

50000

40000
 90000

80000

70000

60000

50000

40000

30000

20000

10000

0
10 11 12

rks
Oct Nov Dec YTD Total
7 7 7 77
 12 14 20 119
7 9 10 106
7 8 14 88
5 7 8 61
1 4 5 23
39 49 64 474

Oct Nov Dec YTD Total

28 28 28 308
24 28 40 238
14 18 20 212
7 8 14 88
15 21 24 183
5 20 25 115
93 123 151 1144

Oct Nov Dec YTD Total

3 3 3 30
4 4 4 51
67 89 102 619
7 7 7 76
2 2 2 32
3 3 3 34
34 34 34 433
1 1 1 16
2 2 2 33
5 1 1 16
0 0 0 1
2 2 2 21
 1 1 1 9
131 149 162 1371

Oct Nov Dec YTD Total

15 15 15 150
16 16 16 204
201 267 306 1857
14 14 14 152
4 4 4 64
6 6 6 68
34 34 34 433
2 2 2 32
-5 2 2 26
0 -1 -1 -11
8 0 0 11
8 8 76
2 2 2 18
297 369 408 3080

published activities
Oct Nov Dec YTD Total
362 362 362 4696
676 887 908 8168
45677 45677 45677 569581
4954 3294 3243 48294
3223 2344 5677 46188
678 345 345 4620
55570 52909 56212 681547

Oct Nov Dec YTD Total

 3620 3620 3620 46960
676 887 908 8168
45677 45677 45677 569581
14862 9882 9729 144882
6446 4688 11354 92376
3390 1725 1725 23100
74671 66479 73013 885067

Oct Nov Dec YTD Total

37 40 45 363
3100 3150 3200 33185
1345 1345 1345 15737
1000 1200 1234 10326
990 1000 1234 9177
17 17 17 171
6489 6752 7075 68959

Oct Nov Dec YTD Total

296 320 360 2904
6200 6300 6400 66370
2690 2690 2690 31474
5000 6000 6170 51630
2970 3000 3702 27531
85 85 85 855
17241 18395 19407 180764

NoDerivs 3.0 Unported License