Interactive Estimates of Media Delivery and User Interactions Based on Secure Merges of De-identified Records

One or more non-transitory computer readable storage media instructions which when executed using one or more computers cause the one or more computers to perform:

• 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, wherein each of the master data and the second data comprise references to healthcare providers (HCPs) in addition to de-identified token values based on patients;
• in the secure data processing environment, executing one or more database table join operations based on the references to the HCPs 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.

A distributed computer system comprising:

• a secure data processing environment comprising one or more first virtual machine instances coupled to one or more first data stores;
• a service provider data processing environment comprising one or more second virtual computing instances coupled to one or more non-transitory computer readable storage media instructions which when executed using one or more computers cause the one or more computers to perform:
• 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, wherein each of the master data and the second data comprise references to healthcare providers (HCPs) in addition to de-identified token values based on patients;
• in the secure data processing environment, executing one or more database table join operations based on the references to the HCPs 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.