Viewing Compass Data Using MyInsights
- Browser (Lightning)
- iPad
- iPhone
Content creators can use MyInsights Studio to create a MyInsights page that embeds Compass patient data and aggregated prescription data at the HCP and product levels. For example, content creators can create a MyInsights page displaying total HCP prescriptions at the product level.
Prerequisites
- Ensure the CRM Data Engine Administration Console tab is visible in CRM.
- Ensure MyInsights is configured for end users
- Ensure a MyInsights Studio domain has been requested.
- Ensure the appropriate user profiles have MyInsights Studio deployment permissions
- Create a Standard User for Compass. Select the API Access check box.
- Define the cohort definitions for your Compass query.
- Create or load your Analytic Product Groups, based on the cohort definitions, to define your market and the associated products you plan to visualize in the data. This includes your company’s products and any competitor products you want to compare them to.
- Ensure each account for which you want to see data has a value in the VeevaID_vod or NPI_vod field on the Account object. The Veeva ID or NPI are required to match the CRM account to the Compass claim.
Integrating Compass Data with CRM
To integrate Compass data with CRM:
-
Create an integration user for CRM.
-
Grant the user the following permissions:
Object
OLS
Record Type
Field
FLS
Account
Read
n/a
- External_Id_vod
- id2_vod
- NPI_vod
- VeevaID_vod
Read
Analytics Product Group
Read
n/a
- External_Id_vod
- Parent_Product_Group_vod
- Company_Product_Group_vod
- Market_vod
Read
- Log into CRM as the CRM user.
- Select the CRM Data Engine Administration Console tab.
- Select Edit.
-
Enter the Compass User account credentials.
-
Select Connect. (Compass Instance ID is populated if the entered credentials are correct.)
-
Enter the CRM user account credentials.
-
Select Save. The Compass Instance ID is populated when the user information is saved.
-
Select Validate Credentials to verify the CRM user account credentials.
-
Log into the Compass Portal as the Compass user.
-
Define the query job in Compass. Ensure the following settings:
- Returned Records - select Exact Match
- Delivery Schedule - select Daily
- Time Frame for Qualification Criteria - enter dates from the 25 months prior to the current month, for example, From: 01/01/2021 To: 02/01/2023
- Time Frame for Returned Records - ensure the Return transactions for the same time frame used to identify qualified patients check box is selected
- Delivery Location - select CRM
- Time Frame for subsequent daily deliveries - select Last 3 months
To create a MyInsights page using Compass data:
-
Submit a support ticket requesting connection between MyInsights/MyInsights Studio and CRM Data Engine. The ticket must include the CRM org ID.
-
Download the MyInsights Studio Compass page template here.
-
Log into MyInsights Studio as the CRM user.
-
Import the MyInsights Studio Compass page template into MyInsights Studio.
-
Create a page using the template. Content creators can use the template as is to create a new page, or update the page as needed.
-
Deploy or publish the page.
Alternatively, content creators can create and deploy a custom MyInsights page that uses the queryDataEngine method and the getAlignedTerritories function. See the Veeva Javascript Library for more information.