Difference between revisions of "ANLY482 Team wiki: 2015T2 TeamROLL Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
(Created page with "<!--Header Start--> {|style="background-color:#F5F5F5; color:#ffffff; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | style="pad...")
 
 
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
<!--Logo-->
 +
<div style="padding-bottom:25px;"> [[File:T(eam)ROLL.png|350px|center]] </div>
 +
 
<!--Header Start-->
 
<!--Header Start-->
 
{|style="background-color:#F5F5F5; color:#ffffff; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 
{|style="background-color:#F5F5F5; color:#ffffff; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 
| style="padding:0.3em; font-size:100%; background-color:#F5F5F5;  border-bottom:0px solid #F5F5F5; text-align:center; color:#000" width="10%" |
 
| style="padding:0.3em; font-size:100%; background-color:#F5F5F5;  border-bottom:0px solid #F5F5F5; text-align:center; color:#000" width="10%" |
 
   
 
   
[[Image:teamroll_home.gif|30px|link=ANLY482 Team wiki: 2015T2 TeamROLL]] &nbsp;
+
[[Image:teamroll_home.png|40px|link=ANLY482 Team wiki: 2015T2 TeamROLL]] &nbsp;  
 
[[ANLY482 Team wiki: 2015T2 TeamROLL |<font color="#000000" size=2><b>HOME</b></font>]]
 
[[ANLY482 Team wiki: 2015T2 TeamROLL |<font color="#000000" size=2><b>HOME</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;  
| style="padding:0.3em; font-size:100%; background-color:#E0E0E0;  border-bottom:0px solid #3D9DD7; text-align:center; color:#000" width="10%" |  
+
| style="padding:0.3em; font-size:100%; background-color:#F5F5F5;  border-bottom:0px solid #3D9DD7; text-align:center; color:#000" width="10%" |  
[[Image:teamroll_dance.gif|30px|link=ANLY482 Team wiki: 2015T2 TeamROLL About Us]] &nbsp;
+
[[Image:teamroll.png|30px|link=ANLY482 Team wiki: 2015T2 TeamROLL About Us]] &nbsp;
[[ANLY482 Team wiki: 2015T2 TeamROLL About Us|<font color="#0091EA" size=2><b>ABOUT US</b></font>]]
+
[[ANLY482 Team wiki: 2015T2 TeamROLL About Us|<font color="#000000" size=2><b>ABOUT US</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="padding:0.3em; font-size:100%; background-color:#E0E0E0;  border-bottom:0px solid #3D9DD7; text-align:center; color:#000" width="12%" |  
 
| style="padding:0.3em; font-size:100%; background-color:#E0E0E0;  border-bottom:0px solid #3D9DD7; text-align:center; color:#000" width="12%" |  
[[Image:teamroll_overview.png|30px|link=ANLY482 Team wiki: 2015T2 TeamROLL Project Overview]] &nbsp;
+
[[Image:teamroll_this.png|40px|link=ANLY482 Team wiki: 2015T2 TeamROLL Project Overview]] &nbsp;  
 
[[ANLY482 Team wiki: 2015T2 TeamROLL Project Overview |<font color="#0091EA" size=3><b>PROJECT OVERVIEW</b></font>]]
 
[[ANLY482 Team wiki: 2015T2 TeamROLL Project Overview |<font color="#0091EA" size=3><b>PROJECT OVERVIEW</b></font>]]
 +
 +
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 +
| style="padding:0.3em; font-size:100%; background-color:#F5F5F5;  border-bottom:0px solid #3D9DD7; text-align:center; color:#000" width="12%" |
 +
[[Image:teamroll_analysis.png|30px|link=ANLY482 Team wiki: 2015T2 TeamROLL Data Analysis]] &nbsp;
 +
[[ANLY482 Team wiki: 2015T2 TeamROLL Data Analysis |<font color="#000000" size=2><b>DATA ANALYSIS</b></font>]]
  
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
Line 26: Line 34:
 
[[ANLY482 Team wiki: 2015T2 TeamROLL Documentation | <font color="#000000" size=2><b>DOCUMENTATION</b></font>]]
 
[[ANLY482 Team wiki: 2015T2 TeamROLL Documentation | <font color="#000000" size=2><b>DOCUMENTATION</b></font>]]
 
|}  
 
|}  
 +
 
<!--Header End-->
 
<!--Header End-->
 +
<!--Sub-Navigation-->
 +
{| style="background-color:white; color:white ; border:0px solid #4690cd; margin-left: auto; margin-right: auto;" width="1080px" height=50px cellspacing="0" cellpadding="0" valign="top"  |
 +
 +
| style="padding:0 .3em;  solid #000000;  padding: 10px; text-align:center; background-color:#daeeff; border-right:0px solid #4690cd; " width="33%" | [[ANLY482 Team wiki: 2015T2 TeamROLL Project Overview| <font face = "Arial" color="#3C2415"><b>Description</b></font>]]
 +
 +
| style="padding:0 .3em;  solid #000000;  padding: 10px; text-align:center; background-color:white; border-right:0px solid #4690cd; " width="33%" | [[ANLY482 Team wiki: 2015T2 TeamROLL Project Overview/Description| <font face = "Arial" color="#3C2415"><b>Methodology</b></font>]]
 +
 +
| style="padding:0 .3em;  solid #000000;  padding: 10px; text-align:center; background-color:white; border-right:0px solid #4690cd; " width="33%" | [[ANLY482 Team wiki: 2015T2 TeamROLL Project Overview/Technology| <font face = "Arial" color="#3C2415"><b>Technology </b></font>]]
 +
 +
<!--| style="padding:0 .3em;  solid #000000;  padding: 10px; text-align:center; background-color:white; border-right:0px solid #4690cd; " width="33%" | [[ANLY482 Team wiki: 2015T2 TeamROLL Project Overview/Limitations| <font face = "Arial" color="#3C2415"><b>Limitations</b></font>]] -->
 +
|}
 +
 +
<!--END OF Sub-Navigation-->
 +
<br>
 +
<div align="left">
 +
==<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">About SGAG</font></div>==
 +
<div style="border-left: #E1F5FE solid 12px; padding: 0px 30px 0px 18px; ">
 +
<div style="text-align: justify;"> SGAG is one of Singapore's leading local humour content creators. Distributing their creative content through multiple platforms, including popular social media sites, an online website, and a mobile app, the team at SGAG creates quality content daily to engage and entertain Singaporeans. With the goal to make "every Singaporean's day a better one", the company was founded in 2012 by two Singapore Management University undergraduates. As of today, SGAG has since gained a loyal following and have reached out to more than 300 000 Facebook users and 120 000 Twitter users, in addition to at least 200 000 users through other social media platforms, mobile apps and websites. Looking forward, SGAG aims to achieve greater growth and reach among their customers, especially for their target customers of Singaporean youths, working adults and young families between the ages of 18 to 34 years old.
 +
</div>
 +
</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">Project Motivation</font></div>==
 +
<div style="border-left: #E1F5FE solid 12px; padding: 0px 30px 0px 18px; ">
 +
<div style="text-align: justify;"> SGAG’s motto is “to make readers laugh at least 5 times a day, 365 days a year”. As such, SGAG places emphasis on the quality of their 5 daily posts, to ensure that readers will find their posts humorous with a local twist, a good-natured piece of fun without any intention to hurt. Much of their content focuses on a funny stereotype of everyday Singaporean life which locals are able to identify with. <br>
 +
Although SGAG has been very successful thus far, it also recognises that the online content space is very competitive, with newer players such as "SMRT Feedback" joining in the fray to generate local humour content. As such, SGAG needs to evaluate and improve their content strategy to ensure they stay entertaining and engaging to their audience.
 +
 +
 +
</div>
 +
</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">Business Questions</font></div>==
 +
<div style="border-left: #E1F5FE solid 12px; padding: 0px 30px 0px 18px; ">
 +
<div style="text-align: justify;">
 +
In a nutshell, SGAG's business questions are: <br>
 +
# How can we drive audience growth through our creative content? <br>
 +
# What are the characteristics of a “great” post which appeals to our audience? <br>
 +
SGAG has so far thrived on an intuitive understanding of their customer's content preferences. However, they do not have a concrete or clear picture of the kinds of attributes which they can work on to make a specific post a "great" one.
 +
They hope that this project will utilise their rich pool of historical data to derive actionable insights into the concerns above, and offer recommendations how SGAG can improve their content creation strategy.
 +
 +
</div>
 +
</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">Analytical Objectives</font></div>==
 +
<div style="border-left: #E1F5FE solid 12px; padding: 0px 30px 0px 18px; ">
 +
<div style="text-align: justify;">
 +
Taking into account the analytical problems faced, we aim to: <br>
 +
<b> Page-level Data </b><br>
 +
(i) Identify the trend in lifetime total likes <br>
 +
* Based on the net change in count <br>
 +
(ii) Identify the better performing posts <br>
 +
* Based on daily total reach and number of daily engaged users<br>
 +
(iii) Identify the composition in lifetime total likes <br>
 +
* Based on gender and age group <br>
 +
<b> Post-level Data </b><br>
 +
(i) Identify the better performing posts and weak performing posts<br>
 +
* Based on clustering engagement level (number of negative feedback against number of likes) <br>
 +
(ii) Identify the time-series patterns (time of day) for post reach<br>
 +
* Based on hour of the day and number of post reach <br>
 +
(iii) Determine relationship between engagement level and the characteristics of a picture post
 +
* Based on the relationship between the number of likes and picture design
 +
** Picture design is based on the number of description lines, characters used (e.g. Animals, Foreign celebrities) and the number of frames
 +
(iv) Determine relationship between engagement level and the topics discussed <br>
 +
* Based on post topics and number of likes
 +
</div>

Latest revision as of 23:09, 17 April 2016

T(eam)ROLL.png

Teamroll home.png   HOME

 

Teamroll.png   ABOUT US

 

Teamroll this.png   PROJECT OVERVIEW

 

Teamroll analysis.png   DATA ANALYSIS

 

Teamroll mgmt.png   PROJECT MANAGEMENT

 

Teamroll doc.png   DOCUMENTATION

Description Methodology Technology


About SGAG

SGAG is one of Singapore's leading local humour content creators. Distributing their creative content through multiple platforms, including popular social media sites, an online website, and a mobile app, the team at SGAG creates quality content daily to engage and entertain Singaporeans. With the goal to make "every Singaporean's day a better one", the company was founded in 2012 by two Singapore Management University undergraduates. As of today, SGAG has since gained a loyal following and have reached out to more than 300 000 Facebook users and 120 000 Twitter users, in addition to at least 200 000 users through other social media platforms, mobile apps and websites. Looking forward, SGAG aims to achieve greater growth and reach among their customers, especially for their target customers of Singaporean youths, working adults and young families between the ages of 18 to 34 years old.

Project Motivation

SGAG’s motto is “to make readers laugh at least 5 times a day, 365 days a year”. As such, SGAG places emphasis on the quality of their 5 daily posts, to ensure that readers will find their posts humorous with a local twist, a good-natured piece of fun without any intention to hurt. Much of their content focuses on a funny stereotype of everyday Singaporean life which locals are able to identify with.

Although SGAG has been very successful thus far, it also recognises that the online content space is very competitive, with newer players such as "SMRT Feedback" joining in the fray to generate local humour content. As such, SGAG needs to evaluate and improve their content strategy to ensure they stay entertaining and engaging to their audience.


Business Questions

In a nutshell, SGAG's business questions are:

  1. How can we drive audience growth through our creative content?
  2. What are the characteristics of a “great” post which appeals to our audience?

SGAG has so far thrived on an intuitive understanding of their customer's content preferences. However, they do not have a concrete or clear picture of the kinds of attributes which they can work on to make a specific post a "great" one. They hope that this project will utilise their rich pool of historical data to derive actionable insights into the concerns above, and offer recommendations how SGAG can improve their content creation strategy.

Analytical Objectives

Taking into account the analytical problems faced, we aim to:
Page-level Data
(i) Identify the trend in lifetime total likes

  • Based on the net change in count

(ii) Identify the better performing posts

  • Based on daily total reach and number of daily engaged users

(iii) Identify the composition in lifetime total likes

  • Based on gender and age group

Post-level Data
(i) Identify the better performing posts and weak performing posts

  • Based on clustering engagement level (number of negative feedback against number of likes)

(ii) Identify the time-series patterns (time of day) for post reach

  • Based on hour of the day and number of post reach

(iii) Determine relationship between engagement level and the characteristics of a picture post

  • Based on the relationship between the number of likes and picture design
    • Picture design is based on the number of description lines, characters used (e.g. Animals, Foreign celebrities) and the number of frames

(iv) Determine relationship between engagement level and the topics discussed

  • Based on post topics and number of likes