Sunday, January 6, 2019

Social Media Content Analysis Spreadsheet


            The assignment enabled me to learn more about social media content analysis and the analytics methods to use. It was easy to identify the most trending posts as well as those performing poorly in various social media sites. I used instagram and Facebook as the basis of my analysis since there are many followers in the two sites. They are easy to navigate and share content making them reliable in tracking how a product fairs in the social media. As evident from the analysis, I noticed some interesting trends in regard to the number of likes, comments, views, and shares of the products posted online. The number of likes, shares, and views are comparable, but the number of comments is few in comparison to other three aspects. As such, many people do not provide effective product review by communicating their ideas about it. It would be important for the content marketing manager to have a more engaging customer service support to ensure that it gets feedback about their products other than relying only on the views, likes, and shares. Comments are more interactive and show the actual thoughts of a client on a product.

            Buhi should invest more in sharing pictures and videos on instagram since it attracts a massive following in comparison to Facebook. Visual representation of a product with or without description creates an image in a client’s mind and may in turn search for it where available. Some posts perform better than others in particular areas. For instance, in instagram, promotional videos perform better than mere products whether indoor or outdoor. For Facebook, there are specific durations when people are more active online than others especially over the midday breaks. A post can be shared and viewed more in Facebook, but has few comments beneath it which is an important trend to observe for an in-depth analysis. The quality of a caption also has an influence on how people interact with it since some posts were observed to do well than others on the basis of their quality.  

Appendix
Instagram analysis
Compare Categories
Total Likes
Comments
Views
Total Post
People indoor with product
                2,805
                               6
             3,500
                   4
People outdoor with product
                3,809
                            15
             4,702
                   6
Just product indoor
                7,809
                            18
             8,932
                 14
Just product outdoor
                6,114
                            21
             6,200
                 23
Image no product
                7,177
                            22
             9,004
                   3
Promotional video
             12,419
                            11
           14,000
                   9
Post Average
AVG Likes
AVG Comments
AVG Views
Total Post
People indoor with product
                   700
                               1
                 875
                   4
People outdoor with product
                   634
                               3
                 783
                   6
Just product indoor
557
                               1
                 638
                 14
Just product outdoor
                   266
                               1
                 270
                 23
Image no product
                2,392
                               7
             3,001
                   3
Promotional video
                1,380
                               1
             1,556
                   9



Facebook
Facebook
Compare categories
Total Likes
Shares
Comments
Views
Total Post
Time
Total Likes
Shares
Comments
Views
Total post
Image non promotional with link
55
37
4
54
4
12am
3
1
3
5
2
Image promotional with link
427
320
15
400
5
1am
5
0
2
2
3
Image non promotional no link
36
21
3
30
3
2am
6
2
4
4
4
Blog post promotional
458
134
47
454
10
3am
4
4
4
2
1
Blog post non promotional
89
26
28
80
3
4am
6
5
2
3
7
Promotional video
400
345
35
500
24
5am
3
3
2
4
3
6am
23
21
2
10
6
Post Average
AVG Likes
AVG Shares
AVG Comments
AVG Views
Total Post
7am
34
32
23
21
3
Image non promotional with link
14
10
1
14
4
8am
32
30
21
30
8
Image promotional with link
85
64
3
80
5
9am
56
40
21
24
3
Image non promotional no link
12
7
1
10
3
10am
34
23
10
9
6
Blog post promotional
45
13
4
45
10
11am
32
21
24
8
3
Blog post non promotional
29
8
9
26
3
12pm
56
43
26
32
6
Promotional video
16
14
1
21
24

1pm
100
94
25
23
1
2pm
213
154
100
121
4
Daily Average
AVG Likes
AVG Shares
AVG Comments
AVG Views
Total Post
3pm
43
32
32
26
6
Monday
4
9
1
10
2
4pm
32
23
32
30
7
Tuesday
5
4
3
62
4
5pm
78
54
26
29
3
Wednesday
6
6
2
5
2
6pm
45
32
26
37
9
Thursday
2
3
1
5
1
7pm
32
21
12
30
4
Friday
5
7
1
32
6
8pm
21
10
10
7
3
Saturday
10
8
4
65
2
9pm
21
2
9
6
5
Sunday
0
0
0
0
0
10pm
34
21
14
21
2
11pm
54
21
10
12
8
Day of week
total likes
shares
comments
views
Total post
Monday
8
18
2
20
2
Tuesday
20
16
12
248
4
Wednesday
12
12
4
10
2
Thursday
2
3
1
5
1
Friday
30
42
6
192
6
Saturday
20
16
6
130
2
Sunday
0
0
0
0
0

Sherry Roberts is the author of this paper. A senior editor at MeldaResearch.Com in custom nursing papers if you need a similar paper you can place your order from custom nursing essay.

No comments:

Post a Comment

Buy thesis Online for Cheap

We are keen on ensuring that, any time students Buy thesis Online papers from our website, they get good grades that align with their expec...