A computer-implemented method of using Linear, DVR, and VOD video viewing activity data as input to a data translation processor which prepares that viewing activity for more efficient downstream processing by translating detailed values to aggregated values according to analyst defined translation rules in preparation for ingestion by a MapReduce Framework with the result that the MapReduce Framework needs to process less data in order to create analytical studies of second-by-second viewing activity for program, channel, house, device, viewer, demographic, and geographic attributes. The source data may be extracted from a database defined according to the Cable Television Laboratories, Inc. Media Measurement Data Model defined in “Audience Data Measurement Specification” as “OpenCable™ Specifications, Audience Measurement, Audience Measurement Data Specification” document OC-SP-AMD-101-130502 or any similar format. An analyst can use Hadoop to run more studies in less time with less hardware thus gaining greater insights into viewing activity at lower cost.