System and method to improve dynamic multi-channel information synthesis
Some implementations provide a computer-implemented method that includes retrieving, from a customer relationship (CRM) database, data documenting exposures of healthcare professionals to information of healthcare products from more than one channels and at various time points; processing the retrieved data to model the exposure of each healthcare professional such that an effectiveness of each of the more than one channels for the particular healthcare professional is determined; retrieving, from a prescription database, data recording each healthcare professional prescribing healthcare products at various time points; longitudinally associating the processed data from the customer relationship database and the retrieved data from the prescription database such that a multi-channel CRM and prescription database is generated; and, determining a next healthcare professional to whom information of a particular healthcare product should be directed as well as a channel for the next healthcare professional to receive the information of the particular healthcare product.
1. A computer-implemented method, the method comprising:
associating, for each of a plurality of healthcare professionals, a plurality of first records and a plurality of second records into a longitudinal record based on anonymized information unique for each healthcare professional,
wherein the plurality of first records are from a customer relationship management (CRM) database, and indicate each of the plurality of healthcare professionals receiving information of a healthcare product from a plurality of channels, and
wherein the plurality of second records are from a prescription database, and show prescription records of each healthcare professional for the healthcare product;
determining, for each of the plurality of healthcare professional and based on the longitudinal record, an individual effect when information of the healthcare product is received from a channel, and a combined effect from the plurality of channels,
wherein the individual effect has a magnitude decreasing after the information of the healthcare product is received, and
wherein the combined effect on the healthcare professional is a summation of individual effects from the pluralities of channels;
displaying, on a user interface, a dynamic ranking of the healthcare professionals based on the combined effect, wherein a map presented on the user interface graphically displays each of the dynamically ranked healthcare professionals at a location on the map relative to a location of the user;
in response to a user selecting a healthcare professional from the dynamic ranking, displaying, on the user interface, a lineup of the plurality of channels for the healthcare professional to receive the information of the healthcare product, based on the individual effects through the plurality of channels; and
scheduling a communication with the healthcare professional through a channel chosen by the user such that the information of the healthcare product is directed thereto.
2. The method of claim 1 , wherein determining the combined effect comprises determining the individual effect of each of the plurality of channels in a channel-specific manner as the plurality of first records at the CRM database and the plurality of second records at the prescription database are being updated.
3. The method of claim 1 , wherein determining the combined effect comprises determining the individual effect of each of the plurality of channels as exponentially decreasing at a channel specific rate according to an elapsed time since the healthcare professional received information of the healthcare product, which channel-specific rate is determined, at least in part, by the plurality of second records at the prescription database.
4. The method of claim 1 , wherein determining the combined effect comprises consolidating the individual effect of each of the plurality of channels to generate the combined effect of the plurality of channels for each healthcare professional.
5. The method of claim 1 , wherein determining the combined effect comprises correlating each instance in which the healthcare professional received information of the healthcare product with the prescription records of the healthcare product by the healthcare professional such that prescription records of the healthcare professional are consolidated; and redundant prescription records are combined.
6. The method of claim 1 , wherein displaying the dynamic ranking comprises:
based on the combined effect determined from the associated first and second records, generating, for each healthcare professional, a current score for directing information of the healthcare product to the healthcare professional; and
ranking the healthcare professionals according to the current scores for directing information of the healthcare product.
7. The method of claim 6 , further comprising:
based on the combined effect determined from the associated first and second records, and at a subsequent time point, generating, for each healthcare professional, an updated combined effect for directing information of the healthcare product to the healthcare professional; and
ranking the healthcare professionals according to the updated combined effect for directing information of the healthcare product to each healthcare professional.
8. The method of claim 1 , wherein displaying the lineup of the plurality of channels comprises:
determining, for each channel, a current individual effect for directing information of the healthcare product to the healthcare professional.
9. The method of claim 8 , further comprising:
subsequently determining, for each channel, an updated individual effect for directing information of the healthcare product to the healthcare professional.
10. A computer system in communication with database systems, the computer system comprising at least one processor, wherein the at least one processor is configured to perform operations of:
associating, for each of a plurality of healthcare professionals, a plurality of first records and a plurality of second records into a longitudinal record based on anonymized information unique for each healthcare professional,
wherein the plurality of first records are from a customer relationship management (CRM) database, and indicate each of the plurality of healthcare professionals receiving information of a healthcare product from a plurality of channels, and
wherein the plurality of second records are from a prescription database, and show prescription records of each healthcare professional for the healthcare product;
determining, for each of the plurality of healthcare professional and based on the longitudinal record, an individual effect when information of the healthcare product is received from a channel, and a combined effect from the plurality of channels,
wherein the individual effect has a magnitude decreasing after the information of the healthcare product is received, and
wherein the combined effect on the healthcare professional is a summation of individual effects from the pluralities of channels;
displaying, on a user interface, a dynamic ranking of the healthcare professionals based on the combined effect, wherein a map presented on the user interface graphically displays each of the dynamically ranked healthcare professionals at a location on the map relative to a location of the user;
in response to a user selecting a healthcare professional from the dynamic ranking, displaying, on the user interface, a lineup of the plurality of channels for the healthcare professional to receive the information of the healthcare product, based on the individual effects through the plurality of channels; and
scheduling a communication with the healthcare professional through a channel chosen by the user such that the information of the healthcare product is directed thereto.
11. The computer system of claim 10 , wherein determining the combined effect comprises determining the individual effect of each of the plurality of channels in a channel-specific manner as the plurality of first records at the CRM database and the plurality of second records at the prescription database are being updated.
12. The computer system of claim 10 , wherein determining the combined effect comprises determining the individual effect of each of the plurality of channels as exponentially decreasing at a channel specific rate according to an elapsed time since the healthcare professional received information of the healthcare product, which channel-specific rate is determined, at least in part, by the plurality of second records at the prescription database.
13. The computer system of claim 10 , wherein determining the combined effect comprises consolidating the individual effect of each of the plurality of channels to generate the combined effect of the plurality of channels for each healthcare professional.
14. The computer system of claim 10 , wherein determining the combined effect comprises correlating each instance in which the healthcare professional received information of the healthcare product with the prescription records of the healthcare product by the healthcare professional such that prescription records of the healthcare professional are consolidated; and redundant prescription records are combined.
15. The computer system of claim 10 , wherein displaying the dynamic ranking comprises:
based on the combined effect determined from the associated first and second records, generating, for each healthcare professional, a current score for directing information of the healthcare product to the healthcare professional; and
ranking the healthcare professionals according to the current scores for directing information of the healthcare product.
16. The computer system of claim 15 , wherein the operations further comprise:
based on the combined effect determined from the associated first and second records, and at a subsequent time point, generating, for each healthcare professional, an updated combined effect for directing information of the healthcare product to the healthcare professional; and
ranking the healthcare professionals according to the updated combined effect for directing information of the healthcare product to each healthcare professional.
17. The computer system of claim 10 , wherein displaying the lineup of the plurality of channels comprises:
determining, for each channel, a current individual effect for directing information of the healthcare product to the healthcare professional.
18. The computer system of claim 17 , wherein the operations further comprise:
subsequently determining, for each channel, an updated individual effect for directing information of the healthcare product to the healthcare professional.
19. A computer-readable medium comprising software instructions that, when executed by a computer, causes the computer to perform operations of:
associating, for each of a plurality of healthcare professionals, a plurality of first records and a plurality of second records into a longitudinal record based on anonymized information unique for each healthcare professional,
wherein the plurality of first records are from a customer relationship management (CRM) database, and indicate each of the plurality of healthcare professionals receiving information of a healthcare product from a plurality of channels, and
wherein the plurality of second records are from a prescription database, and show prescription records of each healthcare professional for the healthcare product;
determining, for each of the plurality of healthcare professional and based on the longitudinal record, an individual effect when information of the healthcare product is received from a channel, and a combined effect from the plurality of channels,
wherein the individual effect has a magnitude decreasing after the information of the healthcare product is received, and
wherein the combined effect on the healthcare professional is a summation of individual effects from the pluralities of channels;
displaying, on a user interface, a dynamic ranking of the healthcare professionals based on the combined effect, wherein a map presented on the user interface graphically displays each of the dynamically ranked healthcare professionals at a location on the map relative to a location of the user;
in response to a user selecting a healthcare professional from the dynamic ranking, displaying, on the user interface, a lineup of the plurality of channels for the healthcare professional to receive the information of the healthcare product, based on the individual effects through the plurality of channels; and
scheduling a communication with the healthcare professional through a channel chosen by the user such that the information of the healthcare product is directed thereto.
20. The computer-implemented method of claim 1 , wherein the dynamic ranking rearranges an order of the healthcare professionals such that the healthcare professional with the highest combined effect becomes the highest ranked healthcare professional as the CRM database and the prescription database are being updated.
21. The computer-implemented method of claim 1 , further comprising:
in response to the user selecting an additional healthcare professional from the dynamic ranking on the user interface, displaying, on the user interface, a lineup of the plurality of channels for each of the healthcare professional and the additional healthcare professional to receive the information of the healthcare product, the lineup for each of the healthcare professionals showing the individual effects from the plurality of channels.