Difference between revisions of "ANLY482 Team wiki: 2015T2 TeamROLL Data Anlysis/Page"
| Line 50: | Line 50: | ||
<div style="padding-bottom:25px;"> [[File:teamroll_page1.png|600px|center]] </div> | <div style="padding-bottom:25px;"> [[File:teamroll_page1.png|600px|center]] </div> | ||
From the months January to December 2015, there is an increasing trend in number of lifetime total page likes. The sharpest increase are in June with 9658 likes, and September with 8923 likes. We hypothesize that this can attributed to content created for two very popular events during the same time period: the Southeast Asian Games (June), and Singapore's General Election (September). | From the months January to December 2015, there is an increasing trend in number of lifetime total page likes. The sharpest increase are in June with 9658 likes, and September with 8923 likes. We hypothesize that this can attributed to content created for two very popular events during the same time period: the Southeast Asian Games (June), and Singapore's General Election (September). | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Exploratory Data Analysis: Female Age Group Demographics</font></div>== | ==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Exploratory Data Analysis: Female Age Group Demographics</font></div>== | ||
| Line 67: | Line 59: | ||
<div style="padding-bottom:25px;"> [[File:teamroll_page5.png|600px|center]] </div> | <div style="padding-bottom:25px;"> [[File:teamroll_page5.png|600px|center]] </div> | ||
Similarly, we see an increasing trend in the number of page like among SGAG's male audience. Also, SGAG has also had most success in reaching to their target group of 18-34 year old males, with the age range of 25-34 years old showing greatest growth for the year 2015. | Similarly, we see an increasing trend in the number of page like among SGAG's male audience. Also, SGAG has also had most success in reaching to their target group of 18-34 year old males, with the age range of 25-34 years old showing greatest growth for the year 2015. | ||
| + | |||
| + | ==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Time Series Analysis: Net change (%) in daily lifetime total likes</font></div>== | ||
| + | <div style="padding-bottom:25px;"> [[File:teamroll_page2.png|600px|center]] </div> | ||
| + | We conducted time series analysis to identify the days with an influx in the number likes and unlikes throughout the year (2015). From the graph obtained, we have identified 4 days that have performed substantially well in comparison to 95% of the data gathered. <br> | ||
| + | We have identified posts with higher than average reach published on the 4 days identified:<br> | ||
| + | 1) Published on 9th February: A photo post with the following topics: transport, carpark problems, inconsiderate drivers, uncanny coincidence and bad parking.<br> | ||
| + | 2) Published on 25th March: 2 videos posts on Mr. Lee Kuan Yew(LKY) with the following topics: words of wisdom, relationships, marriage, LKY tribute and uniting Singaporeans.<br> | ||
| + | 3) Published on 10th June (*highest peak): A video post on Southeast-Asia Games with the following topics: diving fails, friendship, humor. A photo post with the following topics: relationships, chemistry and puns. <br> | ||
| + | 4) Published on 28th October: A video post on Parkour with the following topics: sports and cool stunts. A photo post with the following topics: Minister of Transport, train breakdown and funny typo. <br> | ||
| + | From the posts identified, we can see that the audience are more inclined towards topics relating to transport and major events such as SEA Games and mr LKY’s death. | ||
| + | On the other hand, the posts with higher than average reach published on the weaker performing days are:<br> | ||
| + | 1) Published on 17th March: A link post with the following topics: troll, NDP, holiday, false alarm. A photo post with news on LKY’s deteriorating health. <br> | ||
| + | 2) Published on 18th March: Lack of post updates. 3 posts made; either textual facebook status update or links. <br> | ||
| + | 3) Published on 17th December: A photo post with the following topics: food, mushroom, mop, gross, unhygienic, household chores. Another photo post with the following topics: politics, against foreign manual workers. <br> | ||
| + | From the posts published on weaker performing days, we can see that audience are less receptive towards negative news such as the deteriorating health of Mr. LKY, a fraud post related to national day, and a post against foreign manual workers. | ||
| + | |||
| + | |||
| + | ==<div style="background: #2196F3; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:24px; border-left: #0D47A1 solid 32px;"><font color="white">Rate of Engaged Users</font></div>== | ||
| + | <div style="padding-bottom:25px;"> [[File:teamroll_page3.png|600px|center]] </div> | ||
| + | We see that the rate of engaged users generally shows a decreasing trend. Rate of engaged users is the proportion of users who engaged with the SGAG Facebook Page (=daily page engaged users / daily total reach). It is thus interesting to note that although SGAG has earned an increasing number of page likes, this has not necessarily translated into greater audience response and engagement. Thus, SGAG's content generation still needs to enable audience to become more engaged | ||
| + | |||
| + | |||
<br> | <br> | ||
<br> | <br> | ||
In <b>conclusion</b>, we note that SGAG has been successful in communicating to the 25 to 34 years old as seen from the consistent increasing trend in both male and female segments. On the other hand, there is a lack of significant growth from those who are 18 to 24 years old. In order for SGAG to continue generating greater growth and reaching out to their target audience, contents posted are recommended to better cater to those within the age group of 18 to 24 years old as well. | In <b>conclusion</b>, we note that SGAG has been successful in communicating to the 25 to 34 years old as seen from the consistent increasing trend in both male and female segments. On the other hand, there is a lack of significant growth from those who are 18 to 24 years old. In order for SGAG to continue generating greater growth and reaching out to their target audience, contents posted are recommended to better cater to those within the age group of 18 to 24 years old as well. | ||
Revision as of 13:43, 18 April 2016
ROLL.png)
| Data Cleaning | Page-Level Analysis | Post-Level Analysis |
Contents
Exploratory Data Analysis: Lifetime Total Likes
From the months January to December 2015, there is an increasing trend in number of lifetime total page likes. The sharpest increase are in June with 9658 likes, and September with 8923 likes. We hypothesize that this can attributed to content created for two very popular events during the same time period: the Southeast Asian Games (June), and Singapore's General Election (September).
Exploratory Data Analysis: Female Age Group Demographics
We see that SGAG has indeed successfully reached out to their target group, which audience members of ages 18-34, forming the bulk of their female audience. In terms of growth rate, the segment with ages 25-34 has shown the greatest growth forming the majority of age group by the last quarter of 2015. This is probably because SGAG's content resonated most with this group of audience members.
However we have to note that the audience member between 13 to 17 years old have shown a decrease in viewership.
Exploratory Data Analysis: Male Age Group Demographics
Similarly, we see an increasing trend in the number of page like among SGAG's male audience. Also, SGAG has also had most success in reaching to their target group of 18-34 year old males, with the age range of 25-34 years old showing greatest growth for the year 2015.
Time Series Analysis: Net change (%) in daily lifetime total likes
We conducted time series analysis to identify the days with an influx in the number likes and unlikes throughout the year (2015). From the graph obtained, we have identified 4 days that have performed substantially well in comparison to 95% of the data gathered.
We have identified posts with higher than average reach published on the 4 days identified:
1) Published on 9th February: A photo post with the following topics: transport, carpark problems, inconsiderate drivers, uncanny coincidence and bad parking.
2) Published on 25th March: 2 videos posts on Mr. Lee Kuan Yew(LKY) with the following topics: words of wisdom, relationships, marriage, LKY tribute and uniting Singaporeans.
3) Published on 10th June (*highest peak): A video post on Southeast-Asia Games with the following topics: diving fails, friendship, humor. A photo post with the following topics: relationships, chemistry and puns.
4) Published on 28th October: A video post on Parkour with the following topics: sports and cool stunts. A photo post with the following topics: Minister of Transport, train breakdown and funny typo.
From the posts identified, we can see that the audience are more inclined towards topics relating to transport and major events such as SEA Games and mr LKY’s death.
On the other hand, the posts with higher than average reach published on the weaker performing days are:
1) Published on 17th March: A link post with the following topics: troll, NDP, holiday, false alarm. A photo post with news on LKY’s deteriorating health.
2) Published on 18th March: Lack of post updates. 3 posts made; either textual facebook status update or links.
3) Published on 17th December: A photo post with the following topics: food, mushroom, mop, gross, unhygienic, household chores. Another photo post with the following topics: politics, against foreign manual workers.
From the posts published on weaker performing days, we can see that audience are less receptive towards negative news such as the deteriorating health of Mr. LKY, a fraud post related to national day, and a post against foreign manual workers.
Rate of Engaged Users
We see that the rate of engaged users generally shows a decreasing trend. Rate of engaged users is the proportion of users who engaged with the SGAG Facebook Page (=daily page engaged users / daily total reach). It is thus interesting to note that although SGAG has earned an increasing number of page likes, this has not necessarily translated into greater audience response and engagement. Thus, SGAG's content generation still needs to enable audience to become more engaged
In conclusion, we note that SGAG has been successful in communicating to the 25 to 34 years old as seen from the consistent increasing trend in both male and female segments. On the other hand, there is a lack of significant growth from those who are 18 to 24 years old. In order for SGAG to continue generating greater growth and reaching out to their target audience, contents posted are recommended to better cater to those within the age group of 18 to 24 years old as well.
