Week 6

Management Summary Twitter

Twitter broadcasts live video content about sports, business, news and more. Shows are announced on the Twitter account @TwitterLive, where an animated GIF without any functionality informs the audience. There is no other guide or schedule available so far. Therefore, Twitter has tasked us to develop an online guide with a schedule for its shows. The main purpose is to provide a central website where users obtain an overview of upcoming and currently streamed live shows. The project solution is divided into two parts: Firstly, a python script extracts information of the shows from an excel file and transforms it into JavaScript code. Secondly, the implemented website displays the schedule based on this code. A schematic overview of this scenario is

All information about shows is collected in an excel file. Some of this information may be published to the users, others have to be hidden. In order to meet this requirement, the developed python script contains an algorithm which prepares data to be presented online. With the help of openpyxl, an open-source library, it iterates through the given excel file, finds upcoming shows and extracts relevant data. Furthermore, it automatically generates a

JavaScript file with necessary code to fill the schedule on the website. Every day, a Twitter employee will prepare the excel file, run the script and upload the generated JavaScript file onto the webserver. The website, which finally gives information to the users, is the main product of this project. Focus is laid on the handling and unctionality of the schedule itself. The implemented website provides with the following features:

Finding shows: All shows of the upcoming seven days are listed in chronological order by default. Users are able to sort it by show title and/or category. An implemented search bar allows searching the entire schedule for any terms.

Show times: The schedule displays the start of a show in Eastern Time by default. Users can customize the schedule to any time zone around the world. Furthermore, the website adds a tag, if a show is currently running or already over.

Watch a show: Every show is accessible by clicking on the title within the schedule. Users are then forwarded to the page where the show is broadcasted. Moreover, users can watch a show while searching the schedule. An embedded video next to the schedule broadcasts Stadium, a 24/7 stream.

SEO: The website is the basis to find every show via Google.

Format: The website is fully responsive.

The project was deployed to Twitter on Friday, October 13, 2017. It is now examined by several divisions of Twitter, before it will be publicly accessible. After a successful release, further work

can be done on measurability, reporting and analysis of click-through rates.