Excel or Google Spreadsheet:Automate Import of Video View Stats into Spreadsheet
We're looking to create a spreadsheet that will automatically pull view statistics from a list of video URLs. This list includes both YouTube Playlists and standalone URLs.
Simple examples of this functionality are described here: http://blog.fosketts.net/2012/04/1
A. As a user, I want to be able to input either a stand alone video URL (e.g. https://www.youtube.com/watch?v=ab
B. As a user, I must be able to enter URLs for YouTube, Vimeo, DailyMotion, MetaCafe, Yahoo! Videos, and MySpace.
C. As a user, I need to know: how many video views each video has.
D. As a user, it would be nice to know how many times a video has been shared, how many times a video has been "liked" or given a positive rating, and how many time a video has been "disliked" or given a negative rating.
E. As a user I'd like to be able to capture and summarize this data on a daily basis.
Demonstrable experience working with:
Excel Macros or Functions
Google Doc Functions