Interactive estimates of media delivery and user interactions based on secure merges of de-identified records

Abstract

In one embodiment, a computer implemented method comprises receiving and storing in relational database tables in a secure data processing environment comprising one or more first virtual machine instances coupled to one or more first data stores, master data comprising records having first de-identified token values associated with health data and second data comprising records having second de-identified token values associated with historical media delivery data; in the secure data processing environment, executing one or more database table join operations to merge the master data and the second data to produce a joined table having records comprising third de-identified token values associated with the health data and the second data; receiving, using one or more virtual computing instances of a service provider environment, one or more filter specifications that define a target audience and a forecast request, and in real time in response to the forecast request: based on the one or more filter specifications, executing one or more queries to the joined table in the secure data processing environment; receiving, in the service provider environment, de-identified aggregated data that the secure data processing environment has generated based upon the one or more queries to the joined table; based on the de-identified aggregated data and second data, generating an estimate of media delivery reach; presenting the estimate of the media delivery reach to a user computer that is communicatively coupled to the service provider environment.