A method and apparatus for collection and analysis of oil rig activity is described. The method includes collecting wellsite data from a plurality of sources, including real-time data sources and macroscopic reports. In certain embodiments, the collected data may be standardized based on templates specifying data format and presentation. Additionally, the data may be automatically corrected by using data error lists that identify algorithms for diagnosing and correcting errors in the data. Data collected from multiple sources may be time-aligned so that data from different sources may be correlated together by time. In certain embodiments, time aligning the data may include adjusting manually-logged timestamps for events in macroscopic reports based on real-time data. In this way, heterogeneous data from a plurality of sources may be homogenized. Optionally, the homogenized data may be used as inputs for wellsite data analysis or to produce various types of quality reports.