Skip to Content
Analytics Stories
book

Analytics Stories

by Wayne L. Winston
September 2020
Beginner to intermediate
528 pages
12h 33m
English
Wiley
Content preview from Analytics Stories

CHAPTER 36Predicting Game of Thrones TV Ratings

Hollywood moguls who underwrite TV shows and movies would love to be able to predict the TV show's ratings or a movie's revenues. It seems reasonable that the number of people searching the Internet for information on the show or movie in advance of its release should correlate well with the number of viewers of the TV show or the number of people paying to see the movie. Fortunately, Google Trends allows you to easily download into Excel information about the frequency of searches for any search term. In this chapter, we will show you how to use Google Trends and close the chapter by using Google Trends data to forecast the ratings of the premiere episode for multiple seasons of Game of Thrones (GOT).

What Does Google Trends Tell Us?

If you are interested in the search history for a particular term, you can go to Google Trends (trends.google.com/trends/) and type in one (or more) search terms and get the relative number of searches for that term for any time range going back to 2004. You can choose the desired location for the searches. (We chose the United States.) Choosing Custom Time Range From The Past 12 Months drop-down-list allows you to select any desired time range. If you choose a time range containing at most 90 days, then you can download a comma-separated value file (a file with a .csv extension) which contains a daily query index. When you open a .csv file, you may then save it as an Excel file. For a given region, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

People Analytics For Dummies

People Analytics For Dummies

Mike West
Lean Analytics

Lean Analytics

Alistair Croll, Benjamin Yoskovitz

Publisher Resources

ISBN: 9781119646037Purchase book