I.) Adjust the scraped spreadsheet data.
The data should be all ok it was scraped from a source, but please run through and double-check this data.
Should be ready in a few days, and available to seen as a arger sample.
a.) Artist, album, song.
artist album song youtube video wikipedia
(row 1) Snoop Dogg, Doggystyle, What's my name, research this, research this
(row 2) Snoop Dogg, Doggystyle, Gin and Juice, research this, research this
b.) Add-in these columns to the spreadsheet -
1.) Music video link in youtube (if available, not all songs will have music videos)
2.) Music video link in wikipedia (if available, it might not be not all music videos have wikipedia entries)
II.) Then search through youtube for the BEST music video available and add to spread sheet (add video).
Note: Not all songs will have music videos.
Note: You will want to do this artist by artist as it will be faster as you will see the related videos available on the right hand column of youtube.
Note: Take care to find the highest quality video available - no watermarks, lyrics added etc...
a.) Example - Youtube
e.g. [url removed, login to view] (snoop dogg what's my name?)
([url removed, login to view] has a list of 50)
(please no lyrics, and no watermarks on the videos please)
b.) Example - Wikipedia
Find a link to the music video (sometimes it has its own, sometimes it is in the song wiki) (add wiki link)
[url removed, login to view](Snoop_Doggy_Dogg_song)#Music_video
III.) Milestone structure:
a. Milestone after artists in the 1980s is done + first part of 1990s. (about 100 in 1980s, about 100 1990s)
b. Milestone after artists in the 1990s is done. (about 200 in 1990s)