The company "Rating for All" is engaged in measuring viewership percentages (rating) for broadcasts on television channels in Israel. The company is interested in a system that will help collect viewership data for programs and commercials from a representative sample of households. It should be noted that the company is not interested in data on the viewing habits of non-family households, such as students sharing an apartment.
For each household, the system maintains the following information: serial number, last name, full address, and telephone number. Additionally, data for family members should be stored, including their first and last names (if different from the households last name). Also, the age and gender of each family member should be known. To maintain privacy, the company "Rating for All" opts to avoid recording the identity numbers of family members. Instead, each family member is identified by the householders serial number and their family members number, assigned in ascending order within each household.
Every household is equipped with "viewing meters", electronic devices transmitting information about viewers' characteristics and the broadcast being watched. A viewing meter is assigned to only one household and can be identified by its serial number. The number of viewing meters corresponds to the number of televisions in the household. In exceptional cases, the company "Rating for All" may transfer viewing meters from one television to another, even between different households. In these cases, there is no need to keep a history of the televisions for each viewing meter. The company also requests information about the televisions in each household, including the manufacturer's name (in free text) and screen size (in inches).
The viewing meter records every action of watching a broadcast by the family members, who are responsible for indicating (with a remote control) when they start and finish watching. The system saves information about the viewer (who is watching) and the broadcast (what is being watched). The system categorizes television broadcasts into programs and commercials, assigning a serial number to each for unique identification. Unusual notes, such as interruptions due to news reports, can be saved for each broadcast.
For programs, the system saves the title, language, duration (in minutes), and intended audience classification (>8, >12, >15, >18, G). For commercials, it records the title, advertiser name, duration (in minutes), whether it is sponsored or not, and whether it is part of a campaign or not. Both programs and commercials can be broadcast on different channels. To comprehensively document the viewing experience, it is imperative to store information about the specific channel on which a family member watched the broadcast. This includes the channel's number, name, and classification (government channel, central niche channel, broadcast channel, or other).
The company employs several content employees responsible for updating broadcast data and channels. Customer acquisition and retention personnel are responsible for updating households and their content as needed. An external company named "Filtration" is responsible for determining households at the beginning of every three years and transferring their details and personal information in each household to "Ratings for All" using XML. When importing the XML file into the system, the status of households removed from the sample is updated to "inactive."
After receiving household details, equipment personnel contact each new household and gather information about the televisions they possess. Based on this information, equipment personnel configure viewing meters for the new households according to the number of televisions in each household. The equipment personnel can assign devices that are not associated with any household or order new devices as needed. Device orders are placed through the supplier system, but once the devices are received, their serial numbers must be stored in the "Ratings for All" system by the equipment personnel.
Every quarter, the system generates a viewership data report. The report gets the channel number and displays the viewership percentages for each of its programs, indicating the percentage of people who watched the program among the total potential viewers from active households. This report presents the channel details followed by the details of the different programs in descending order of viewership percentages. The report is dispatched to the content employees and, upon generation, is additionally archived in JSON format and forwarded to the Second Authority for Television and Radio (a separate file for each channel).