Amanda's avatar
Amanda
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Amanda's Netflix Data

This report shows my watch data on Netflix from when I joined through November 5th.  eyJrIjoiNDY4ZWQ5ODUtNjEwNi00OWMxLWE1ZDEtOWQwZDc4MzdlNDkzIiwidCI6IjcyZjk4OGJmLTg2ZjEtNDFhZi05MWFiLTJkN2NkMDExZGI0...
Entertainment
Amanda's avatar
Amanda
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

In their account settings, they have a "Viewing Activity" button, which is what I used. It takes you to a page where you can download your entire viewing history as a csv. It's actually a lot easier than it used to be. I used to have to keep clicking "show more" until it all loaded and copy/paste the results out :)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Amanda!

Yes I downloaded my Viewing Data from Netflix. But that .csv file just had two columns: 'Title' and 'Date'. 

As I had few records, I manually entered the Genre and Duration fields. (But that's not the most optimal solution to do it right?)

I was wondering how you got the '#of Times Watched","Genre" and "Time Watched(min) data for your report.

Below is the snippet of the report that I prepared.

 

  • Amanda's avatar
    Amanda
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    For that I used this API since Netflix won't give you that information: https://www.omdbapi.com/

     

    IMDB and Netflix don't always use the same name for shows and movies so I did need to do some data cleansing to get everything to align perfectly.