This repo contains a full analysis of YouTube's trending videos dataset to provide insights for Content Creators on YouTube and advertisers to make the most of their resources
The insights from this project were presented inside MicroStrategy Workstation. For quick access, a summary of insights & screen shoots is available in this Slide Deck
One of main objectives of this project was to support YouTubers and Sponsers to pressing questions.
- What is the best time to publish a video on YouTube?
- What is the most promising categories to create content for?
- Is there specific tags and keywords that might increase your views?
- What is the best channels to sponser on YouTube?
- What is the most promising categories to sponser?
- What videos stay longest in trending?
The product of this analysis is a Custom Dashboard
for YouTubers and Sponsers to allow them to feed the latest data to the system and be able to make optimal decisions.
The data analysed in this project are public data from Kaggle, based on the work of RISHAV SHARMA who is kindly using YouTube API to retrieve this data daily.
video_id | title | publishedAt | channelId | channelTitle | categoryId | trending_date | tags | view_count | likes | dislikes | comment_count | thumbnail_link | comments_disabled | ratings_disabled | description | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | s9FH4rDMvds | LEVEI UM FORA? FINGI ESTAR APAIXONADO POR ELA! | 2020-08-11T22:21:49Z | UCGfBwrCoi9ZJjKiUK8MmJNw | Pietro Guedes | 22 | 2020-08-12T00:00:00Z | pietro|guedes|ingrid|ohara|pingrid|vlog|amigos... | 263835 | 85095 | 487 | 4500 | https://i.ytimg.com/vi/s9FH4rDMvds/default.jpg | False | False | Salve rapaziada, neste vídeo me declarei pra e... |
1 | jbGRowa5tIk | ITZY “Not Shy” M/V TEASER | 2020-08-11T15:00:13Z | UCaO6TYtlC8U5ttz62hTrZgg | JYP Entertainment | 10 | 2020-08-12T00:00:00Z | JYP Entertainment|JYP|ITZY|있지|ITZY Video|ITZY ... | 6000070 | 714310 | 15176 | 31040 | https://i.ytimg.com/vi/jbGRowa5tIk/default.jpg | False | False | ITZY Not Shy M/V[ITZY Official] https://www.yo... |
2 | 3EfkCrXKZNs | Oh Juliana PARÓDIA - MC Niack | 2020-08-10T14:59:00Z | UCoXZmVma073v5G1cW82UKkA | As Irmãs Mota | 22 | 2020-08-12T00:00:00Z | OH JULIANA PARÓDIA|MC Niack PARÓDIA|PARÓDIAS|A... | 2296748 | 39761 | 5484 | 0 | https://i.ytimg.com/vi/3EfkCrXKZNs/default.jpg | True | False | Se inscrevam meus amores! 📬 Quer nos mandar al... |
3 | gBjox7vn3-g | Contos de Runeterra: Targon | A Estrada Tortuosa | 2020-08-11T15:00:09Z | UC6Xqz2pm50gDCORYztqhDpg | League of Legends BR | 20 | 2020-08-12T00:00:00Z | Riot|Riot Games|League of Legends|lol|trailer|... | 300510 | 46222 | 242 | 2748 | https://i.ytimg.com/vi/gBjox7vn3-g/default.jpg | False | False | Você se unirá aos Lunari e aos Solari em Targo... |
4 | npoUGx7UW7o | Entrevista com Thammy Miranda | The Noite (10/... | 2020-08-11T20:04:02Z | UCEWOoncsrmirqnFqxer9lmA | The Noite com Danilo Gentili | 23 | 2020-08-12T00:00:00Z | The Noite|The Noite com Danilo Gentili|Danilo ... | 327235 | 22059 | 3972 | 2751 | https://i.ytimg.com/vi/npoUGx7UW7o/default.jpg | False | False | Danilo Gentili recebe Thammy Miranda. Após pas... |