Difference between revisions of "ANLY482 AY2017-18T2 Group30 Facebook Video"

From Analytics Practicum
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 9: Line 9:
 
{|style="background-color:#5A6B96; color:#5A6B96; width="100%" cellspacing="0" cellpadding="10" border="0" |
 
{|style="background-color:#5A6B96; color:#5A6B96; width="100%" cellspacing="0" cellpadding="10" border="0" |
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="14%" | [[ANLY482_AY2017-18_T2_Group_30|<font color="#FFFFFF" size=3><b>HOME</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18_T2_Group_30|<font color="#FFFFFF" size=3><b>HOME</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="14%" | [[ANLY482_AY2017-18T2_Group30 About Us |<font color="#FFFFFF" size=3><b>ABOUT US</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18T2_Group30 About Us |<font color="#FFFFFF" size=3><b>ABOUT US</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="14%" | [[ANLY482_AY2017-18T2_Group30 Project Overview |<font color="#FFFFFF" size=3><b>PROJECT OVERVIEW </b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18T2_Group30 Project Overview |<font color="#FFFFFF" size=3><b>PROJECT OVERVIEW </b></font>]]
  
|style="font-size:88%; border-left:1px solid #347cc4; border-right:1px solid #347cc4; text-align:center; border-bottom:1px solid #347cc4; border-top:1px solid #347cc4;" width="14%" |[[ANLY482_AY2017-18T2_Group30 Data Analysis |<font color="#347cc4" size=3><b>PROJECT FINDINGS</b></font>]]
+
|style="font-size:88%; border-left:1px solid #347cc4; border-right:1px solid #347cc4; text-align:center; border-bottom:1px solid #347cc4; border-top:1px solid #347cc4;" width="12.5%" |[[ANLY482_AY2017-18T2_Group30 Data Analysis |<font color="#347cc4" size=3><b>EDA</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="14%" | [[ANLY482_AY2017-18T2_Group30 Project Management |<font color="#FFFFFF" size=3><b>PROJECT MANAGEMENT</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18T2_Group30 Business Objectives |<font color="#FFFFFF" size=3><b>BUSINESS OBJECTIVES </b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="15%" |[[ANLY482_AY2017-18T2_Group30 Documentation | <font color="#FFFFFF" size=3><b>DOCUMENTATION</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" | [[ANLY482_AY2017-18T2_Group30 Project Management |<font color="#FFFFFF" size=3><b>PROJECT MANAGEMENT</b></font>]]
  
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="15%" |[[ANLY482_AY2017-18_Term_2 | <font color="#FFFFFF" size=3><b>MAIN PAGE</b></font>]]
+
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" |[[ANLY482_AY2017-18T2_Group30 Documentation | <font color="#FFFFFF" size=3><b>DOCUMENTATION</b></font>]]
 +
 
 +
|style="font-size:88%; border-left:1px solid #ffffff; border-right:1px solid #ffffff; text-align:center; background-color:#347cc4; " width="12.5%" |[[ANLY482_AY2017-18_Term_2 | <font color="#FFFFFF" size=3><b>MAIN PAGE</b></font>]]
 
|}  
 
|}  
 
</center>
 
</center>
Line 47: Line 49:
 
<!---------------END of sub menu ---------------------->
 
<!---------------END of sub menu ---------------------->
 
<br>
 
<br>
<div align="center">
 
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Source</font></div>
 
</div>
 
  
<div align="left">
+
==<div style=" width: 96.5%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Source</font></div>==
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
+
 
 +
<div style="width:96.5%;">
 
<font>
 
<font>
 
For data files from Facebook Insights Data Export (Video Post), the sponsor provided exported data from different periods of the year, with different metric tabs in Excel format.  The tabs included are:  
 
For data files from Facebook Insights Data Export (Video Post), the sponsor provided exported data from different periods of the year, with different metric tabs in Excel format.  The tabs included are:  
Line 62: Line 62:
 
</div>
 
</div>
  
<div align="center">
+
 
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Preparation</font></div>
+
==<div style=" width: 96.5%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Preparation</font></div>==
<div style="width:90%;">
+
 
</div>
+
<div style="width:96.5%;">
 
<div align="left">
 
<div align="left">
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
+
[[File:Fbvideo clean1.PNG|FB Clean 1|700px]]
<font>
+
[[File:Fbvideo clean2.PNG|FB Clean 2|700px]]
<!---------Enter Text Here ------->
+
[[File:Fbvideo clean3.PNG|FB Clean 3|700px]]
</font>
 
 
</div>
 
</div>
 
</div>
 
</div>
  
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 22px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Exploratory Data Analysis</font></div>
+
==<div style=" width: 96.5%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Exploratory Data Analysis</font></div>==
</div>
+
 
 
<div align="center">
 
<div align="center">
 
[[File:Dailyviews.png|Video Views for first 30 days|1000px]]
 
[[File:Dailyviews.png|Video Views for first 30 days|1000px]]
 
</div>
 
</div>
<div align="center">
+
 
<div align="left">
+
<div style="width:96.5%;">
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
 
 
<font>
 
<font>
The diagram abve demonstrates the number of views for a video from Day 1 to Day 30. It would be interesting to note which are the videos that have more views than the upper whisker for each day. These videos would be termed as high-performance videos. Most of the views are generated within the first two days and view count would decrease significantly from day 3 onwards.  
+
The diagram above demonstrates the number of views for a video from Day 1 to Day 30. It would be interesting to note which are the videos that have more views than the upper whisker for each day. These videos would be termed as high-performance videos. Most of the views are generated within the first two days and view count would decrease significantly from day 3 onwards.  
  
 
In subsequent analysis, we aim to categorize videos into different topics so that we will have an understanding of which topics that are popular amongst the Singapore population. The current bar chart just displays the ranking of videos in a descending order with its respective video tags. The video viewership demographics shows the type of audience that has viewed the video.
 
In subsequent analysis, we aim to categorize videos into different topics so that we will have an understanding of which topics that are popular amongst the Singapore population. The current bar chart just displays the ranking of videos in a descending order with its respective video tags. The video viewership demographics shows the type of audience that has viewed the video.
 
</font>
 
</font>
</div>
 
 
</div>
 
</div>
  
Line 93: Line 90:
 
[[File:Weekday views2.png|Weekday views|1000px]]
 
[[File:Weekday views2.png|Weekday views|1000px]]
 
</div>
 
</div>
<div align="left">
+
 
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
+
<div style="width:96.5%;">
 
<font>
 
<font>
 
Graph on the left shows the number of videos that were posted across the week. We can observe that more videos were posted across the weekday from Monday to Thursday, followed by a decrease in videos posted from Friday to Sunday.  
 
Graph on the left shows the number of videos that were posted across the week. We can observe that more videos were posted across the weekday from Monday to Thursday, followed by a decrease in videos posted from Friday to Sunday.  
Line 100: Line 97:
 
A graph on the right shows the average number of views per weekday. Views are generally higher on Monday and viewership would decline across the week, with an exception on Friday, where viewership has a slight spike followed by a decrease towards Sunday. This is a striking contrast against graph on the left and proved our hypothesis false. Our team believes that viewership count is perpetuated by other circumstances other than the amount of videos posted.
 
A graph on the right shows the average number of views per weekday. Views are generally higher on Monday and viewership would decline across the week, with an exception on Friday, where viewership has a slight spike followed by a decrease towards Sunday. This is a striking contrast against graph on the left and proved our hypothesis false. Our team believes that viewership count is perpetuated by other circumstances other than the amount of videos posted.
 
</font>
 
</font>
</div>
 
</div>
 
 
 
<div align="center">
 
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Final Application: Learning Dashboard</font></div>
 
</div>
 
<div align="left">
 
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
 
<font>
 
<!---------Enter Text Here ------->
 
</font>
 
</div>
 
</div>
 
 
 
</div>
 
</div>

Latest revision as of 13:26, 10 April 2018

APex Logo.PNG


HOME ABOUT US PROJECT OVERVIEW EDA BUSINESS OBJECTIVES PROJECT MANAGEMENT DOCUMENTATION MAIN PAGE
Facebook Post Facebook Video Youtube Instagram Blog Post


Data Source

For data files from Facebook Insights Data Export (Video Post), the sponsor provided exported data from different periods of the year, with different metric tabs in Excel format. The tabs included are:

  1. Lifetime Post Total Impression/Reach/Views
  2. Geographic Views
  3. Demographic Views
  4. Lifetime Post Toal Views by (page_owned / Shared)


Data Preparation

FB Clean 1 FB Clean 2 FB Clean 3

Exploratory Data Analysis

Video Views for first 30 days

The diagram above demonstrates the number of views for a video from Day 1 to Day 30. It would be interesting to note which are the videos that have more views than the upper whisker for each day. These videos would be termed as high-performance videos. Most of the views are generated within the first two days and view count would decrease significantly from day 3 onwards.

In subsequent analysis, we aim to categorize videos into different topics so that we will have an understanding of which topics that are popular amongst the Singapore population. The current bar chart just displays the ranking of videos in a descending order with its respective video tags. The video viewership demographics shows the type of audience that has viewed the video.

Weekday views

Graph on the left shows the number of videos that were posted across the week. We can observe that more videos were posted across the weekday from Monday to Thursday, followed by a decrease in videos posted from Friday to Sunday. (Hypothesis 1)Hence we would assume that viewership would have the same trend across the same period of time. However, this doesn't seem to be the case. A graph on the right shows the average number of views per weekday. Views are generally higher on Monday and viewership would decline across the week, with an exception on Friday, where viewership has a slight spike followed by a decrease towards Sunday. This is a striking contrast against graph on the left and proved our hypothesis false. Our team believes that viewership count is perpetuated by other circumstances other than the amount of videos posted.