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

From Analytics Practicum
Jump to navigation Jump to search
Line 50: Line 50:
 
<br>
 
<br>
 
<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 Source</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 Source</font></div>==
 
</div>
 
</div>
  
<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>
 
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:
 
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:
Line 74: Line 73:
  
 
<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: 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 align="left">
+
</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>
 
<!---------Enter Text Here ------->
 
<!---------Enter Text Here ------->
Line 85: Line 85:
  
 
<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">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>
<div align="left">
+
 
<div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: normal; line-height: 1em;">
+
<div style="width:96.5%;">
 
<font>
 
<font>
 
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.
 
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.
Line 106: Line 106:
 
</font>
 
</font>
 
</div>
 
</div>
</div>
 
<br/>
 

Revision as of 13:30, 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 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.