The table contains information about the potential of contacts (HCP) regarding the prescription of products and brands. It is used to analyze planned and actual indicators, as well as to compare potential with visit performance in Power BI.
| Field Name | Short Description |
|---|---|
| cp_brand_id | Identifier of the brand, linked to the reference table crm_preparation_dictionary_csv |
| cp_factcount | Actual number of prescribed products |
| cp_plancount | Planned number of products to be prescribed |
| cp_potential | Potential indicator (quantitative assessment of opportunities) |
| cp_prep_id | Identifier of the product, linked to the reference table crm_preparation_dictionary_csv |
| cp_task_id | Identifier of the visit, linked to the visit table crm_task_fact_v2_csv |