Interactive estimates of media delivery and user interactions based on secure merges of de-identified records
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, 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.
1 . A computer-implemented method comprising:
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.
2 . The computer-implemented method of claim 1 , further comprising generating the estimate of media delivery reach as an estimate of one of: media delivery reach to the target audience; an estimate of a number of interactions the target audience may take with delivered media; an estimate of a number of behaviors the target audience may perform after viewing deliver media.
3 . The computer-implemented method of claim 1 , the second data comprising any one or more of: advertising data; media data; individual data; demographic data; historical digital advertising data comprising any of media deliveries or impressions, opportunities, or clicks; television ACR data.
4 . The computer-implemented method of claim 1 , further comprising:
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;
the master data comprising first records having first de-identified token values associated with health data;
the second data comprising second records having second de-identified token values associated with demographic data;
third data comprising third records having third de-identified token values associated with historical media delivery data comprising one or more of television ACR data, impressions, opportunities, and clicks;
executing the one or more database table join operations to merge the master data, the second data, and the third data to produce the joined table having records comprising fourth de-identified token values associated with the health data, the demographic data, and the historical media delivery data.
5 . The computer-implemented method of claim 1 , further comprising receiving the master data from one or more data sources separate from the secure data processing environment.
6 . The computer-implemented method of claim 1 , the joined table comprising records having first de-identified token values associated with demographic data and health data for one or more of: clinical medical data, prescription data specifying drug prescriptions, and/or medical claims data.
7 . The computer-implemented method of claim 1 , the master data comprising a single dataset or one or more decentralized data sets that combine to create a federated dataset.
8 . The computer-implemented method of claim 3 , the demographic data comprising one or more of demographic segments, gender, and age and geographic location data of an individual, the geographic location data including but not limited to an address, latitude-longitude (lat-long) data, GPS coordinates, DMA (designated marketing area), ZIP code, city, county, or another geographical unit.
9 . The computer-implemented method of claim 1 , further comprising transmitting the one or more filter specifications that define a target audience to one or more targets for activation that serve media to cause presentation of a targeted media delivery on a computer associated with members of the target audience.
10 . The computer-implemented method of claim 9 , the one or more filter specifications being transmitted with instructions for use by one or more of an advertising exchange, media server and/or media and advertisement display channel.
11 . The computer-implemented method of claim 1 , further comprising receiving historical digital media delivery data and/or opportunities data from an advertising, data, and media platform or system; receiving demographic data from a demographic data service provider separate from the service provider environment; calling a third-party token service to generate the second de-identified token values for the demographic data to associate the second de-identified token values with demographic segments, and to generate the third de-identified token values for the historical media delivery data that associates third de-identified token values with one or more of media deliveries or impressions, opportunities, and clicks; programmatically copying the demographic data and historical media delivery data to a first data store in the secure data processing environment.
12 . The computer-implemented method of claim 1 , further comprising receiving historical digital media delivery data and/or opportunities data from an advertising, data, and media platform or system; receiving demographic data from a demographic data service provider separate from the service provider environment; generating the second de-identified token values for the demographic data to associate the second de-identified token values with demographic segments, and generating the third de-identified token values for the historical media delivery data that associates third de-identified token values with one or more of media deliveries or impressions, opportunities, and clicks; programmatically copying the demographic data and historical media delivery data to a first data store in the secure data processing environment.
13 . The computer-implemented method of claim 1 , further comprising generating and displaying a graphical user interface that is programmed to receive input from the user computer specifying filter attributes for one or more of: for health data by diagnosis, prescription drug use or procedure, for healthcare system interactions such as in-office healthcare provider visitations or telehealth visitations, for health insurance coverage, for health insurance providers, for genetic information, for survey responses, for geography, for demographic attributes, for ad opportunities, for media deliveries or impressions, for ACR, for diagnosis codes, for prescription drug codes, and for procedure codes, by publisher, by media owner, by media and advertising platform, by data provider.
14 . The computer-implemented method of claim 11 , the advertising, data, and media platform or system being programmed for generating instructions for ranking media deliveries or impressions based upon one or more of target procedure codes, target diagnosis codes, counts of unique patients, or estimated numbers of media deliveries or impressions; generating instructions for submitting bids for purchasing media deliveries or impressions based upon the ranking of the media deliveries or impressions.
15 . The computer-implemented method of claim 1 , the master data comprising records having first deidentified token values associated with health data.
16 . The computer-implemented method of claim 1 , the master data comprising records having first deidentified token values associated with any of: medical clinical codes comprising any of International Statistical Classification of Diseases and Related Health Problems (ICD) codes, Current Procedural Terminology (CPT) codes, Healthcare Common Procedure Coding System (HCPCS) codes, J codes, or National Drug Code (NDC) codes for prescriptions, or LOINC codes for laboratory tests.
17 . The computer-implemented method of claim 1 , further comprising:
receiving a query that specifies one or more filter criteria;
based on the one or more filter criteria, and based on de-identified aggregated statistics data and historical media delivery data from an advertising, media, or data platform or system, generating an updated estimate of a number of media deliveries or impressions that the advertising, media, or data platform or system can deliver to the target audience or an updated estimate of a number of interactions the target audience may take with delivered media or an updated estimate of a number of behaviors the target audience may perform after viewing deliver media;
presenting the updated estimate and the de-identified aggregated statistics data to the user computer.
18 . The computer-implemented method of claim 1 , further comprising forecasting the delivery of digital content such as digital advertisements, optionally including data specifying a distribution or counts of potential media deliveries or impressions, clicks, or other interactions, or delivery of digital advertisements to one or more specified media channels, applications, or websites, by publisher, by media owner, by media or advertising platform, or by data provider.
19 . The computer-implemented method of claim 1 , further comprising:
based on de-identified aggregated statistics data and historical media delivery data from an advertising, media, or data platform or system, generating:
two or more estimates of numbers of media deliveries or impressions that the advertising, media, or data platform or system can deliver to two or more different target audiences that match the health data, or
two or more estimates of numbers of interactions that two or more target audiences that match the health data may take with delivered media, or
two or more estimates of numbers of behaviors that two or more target audiences that match the health data may perform after viewing deliver media;
presenting the two or more estimates and the de-identified aggregated statistics data to the user computer concurrently.
20 . The computer-implemented method of claim 1 , wherein the references to HCPs comprise codes of a claims coding system that identify the HCPs.
21 . 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.
22 . The one or more non-transitory computer readable storage media of claim 21 , further sequences of instructions which when executed cause performing: generating the estimate of media delivery reach as an estimate of one of: media delivery reach to the target audience; an estimate of a number of interactions the target audience may take with delivered media; an estimate of a number of behaviors the target audience may perform after viewing deliver media.
23 . The one or more non-transitory computer readable storage media of claim 21 , the second data comprising any one or more of: advertising data; media data; individual data; demographic data; historical digital advertising data comprising any of media deliveries or impressions, opportunities, or clicks; television ACR data.
24 . The one or more non-transitory computer readable storage media of claim 21 , further comprising:
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;
the master data comprising first records having first de-identified token values associated with health data;
the second data comprising second records having second de-identified token values associated with demographic data;
third data comprising third records having third de-identified token values associated with historical media delivery data comprising one or more of television ACR data, impressions, opportunities, and clicks;
executing the one or more database table join operations to merge the master data, the second data, and the third data to produce the joined table having records comprising fourth de-identified token values associated with the health data, the demographic data, and the historical media delivery data.
25 . The one or more non-transitory computer readable storage media of claim 21 , the joined table comprising records having first de-identified token values associated with demographic data and health data for one or more of: clinical medical data, prescription data specifying drug prescriptions, and/or medical claims data.
26 . The one or more non-transitory computer readable storage media of claim 21 , further comprising:
based on de-identified aggregated statistics data and historical media delivery data from an advertising, media, or data platform or system, generating:
two or more estimates of numbers of media deliveries or impressions that the advertising, media, or data platform or system can deliver to two or more different target audiences that match the health data, or
two or more estimates of numbers of interactions that two or more target audiences that match the health data may take with delivered media, or
two or more estimates of numbers of behaviors that two or more target audiences that match the health data may perform after viewing deliver media;
presenting the two or more estimates and the de-identified aggregated statistics data to the user computer concurrently.
27 . The method of claim 1 , wherein the references to HCPs comprise codes of a claims coding system that identify the HCPs.
28 . 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.
29 . The distributed computer system of claim 28 , further comprising sequences of instructions which when executed cause performing: generating the estimate of media delivery reach as an estimate of one of: media delivery reach to the target audience; an estimate of a number of interactions the target audience may take with delivered media; an estimate of a number of behaviors the target audience may perform after viewing deliver media.
30 . The distributed computer system of claim 28 , the second data comprising any one or more of: advertising data; media data; individual data; demographic data; historical digital advertising data comprising any of media deliveries or impressions, opportunities, or clicks; television ACR data.
31 . The distributed computer system of claim 28 , further comprising sequences of instructions which when executed cause performing:
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;
the master data comprising first records having first de-identified token values associated with health data;
the second data comprising second records having second de-identified token values associated with demographic data;
third data comprising third records having third de-identified token values associated with historical media delivery data comprising one or more of television ACR data, impressions, opportunities, and clicks;
executing the one or more database table join operations to merge the master data, the second data, and the third data to produce the joined table having records comprising fourth de-identified token values associated with the health data, the demographic data, and the historical media delivery data.
32 . The distributed computer system of claim 28 , the joined table comprising records having first de-identified token values associated with demographic data and health data for one or more of: clinical medical data, prescription data specifying drug prescriptions, and/or medical claims data.