A computer-implemented method of using video program viewing activity data as input to an aggregation engine built on the Hadoop MapReduce framework which calculates second-by-second video viewing activity for Linear, DVR, and VOD program level viewing including measuring trick play activity with results aggregated to the analyst's choice of program, program airing, channel, house attributes, device attributes, geographic area, demographic attributes, viewing date, or any combination of these fields, for each second of program content represented in the video program viewing data. 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-I01-130502 or any similar format. These metrics provide detailed data needed to calculate information on customer viewing behavior that can drive business decisions for service providers, advertisers, and content producers.