Excel or Google Spreadsheet:Automate Import of Video View Stats into Spreadsheet

Excel or Google Spreadsheet:Automate Import of Video View Stats into Spreadsheet

Cancelled

Job Description

SUMMARY
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.

EXAMPLES
Simple examples of this functionality are described here: http://blog.fosketts.net/2012/04/19/automatically-import-youtube-vimeo-viewer-statistics-google-docs-spreadsheets/
http://thedataday.wordpress.com/2011/06/05/tip-how-to-google-docs-as-a-scraper-tool/

FUNCTIONAL REQUIREMENTS
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=abc) or a Playlist (e.g. https://www.youtube.com/playlist?list=xyz) from which I want to accumulate view statistics.

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.

EXPERIENCE DESIRED
Demonstrable experience working with:
Excel Macros or Functions
Google Doc Functions
YouTube API