Difference between revisions of "ANLY482 AY2017-18T2 Group30 Youtube"

From Analytics Practicum
Jump to navigation Jump to search
Line 75: Line 75:
 
<div align="center">
 
<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: 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:90%;">
 
</div>
 
 
<div align="left">
 
<div align="left">
 
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
 
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;">
 
<font>
 
<font>
 
<!---------Enter Text Here ------->
 
<!---------Enter Text Here ------->
 +
<p>No data preparation is required.</p>
 
</font>
 
</font>
 
</div>
 
</div>
Line 109: Line 108:
 
</div>
 
</div>
 
<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">Notes</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>
 
<br/>
 
 
</div>
 

Revision as of 12:20, 27 February 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 YouTube(Watch Time), the sponsor provided exported data for Watch Time, with different metric tabs in Excel format. The tabs included are:

  1. Video
  2. Geography
  3. Date
  4. Subscription Status
  5. Youtube Product
  6. Device Type
  7. Subtitles and CC
  8. Video Information Language


For data files from YouTube(Demographics), the sponsor provided exported data for watch time for different Demographic, with different metric tabs in Excel format. The tabs included are:

  1. Viewer Age
  2. Viewer Gender


For data files from YouTube(Traffic Sources), the sponsor provided exported data for watch time from different traffic source type

Data Preparation

No data preparation is required.

Exploratory Data Analysis

As seen in the chart below, majority of viewers (>70%) fall into the age category of 18-34. Slightly over 10% of viewers fall into the age categories of 13-17 and 35-44 each as well, with less than 5% of views who are above 54.

449 × 520px

Across all the age groups, there is always a larger percentage of female audience except for those 35 and older. The disparity is especially obvious in the 18-24 category, with almost twice as many female viewers.

589 × 548px

Despite differences in views for age and gender, there are no significant differences observed for the average duration (in minutes), which is around 4-5 minutes.

775 × 687px

All of the above findings are consistent with that of Facebook Videos.