On This Page
Overview
Veeva Compass Prescriber allows you to pull projected prescriptions and procedures at the Prescriber and Zip level. Using Compass Prescriber, you can quickly visualize and pull Prescriber (HCP and HCO) level projected data or Zip level projected data for your products of interest.
Building a Prescriber Query
Getting Prescriber & Zip Projected Data involves the following:
- Products - Define your products of interest for your data deliverable
- Time Frame - Select your time frame for prescriber visualizations or your data deliverable
- Data Type - Define whether you would like Prescriber or Zip level projected data For Prescriber data, you also have the ability to filter your prescriber list based on prescriber volume or the top HCPs for your market and time frame of interest
- Delivery - Select the delivery format and location for your data deliverable.
- Review & Submit - Review the selected market, time frame, filters, and delivery prior to submitting your query.
Define Prescribers
The Define Prescribers step allows you to select products, a time frame, toggle between Prescriber or Zip level data, and filter your prescriber (HCP and HCO) list based on your market. For Prescriber level data, this step includes modules to visualize and filter by prescriber volume, or to view the list of top HCPs for your market.
To undo and/or redo actions that you have taken within this step, use the undo and redo buttons at the upper-right of the query area. You can also clear out your entire query by clicking on Clear All.
Select Products
To start building a query, select your products of interest. You may use the Code Searcher to search for specific codes, or you can choose to utilize a query template containing a list of predefined codes.
Once codes have been added to the product list, you may view the detailed list of codes by clicking the Expand button.
From the expanded code list, you can review and/or remove your added codes. Click on the Collapse button to close.
A summary of the products that you have added to your query are displayed in the Products section of the Filters.
Code Searcher
Code Searcher is used to search for specific products to add to your query. To use Code Searcher, click on the Code Searcher button (magnifying glass icon) within the Select Products pane.
From the Zip data page, you can also click on the “Add Products” button to use Code Searcher.
This will open the Product Code Searcher. Refer to Products for more information on how to search for and add products. Note that products are added at the brand-level for Compass Prescriber.
Templates
You can also add products to your query by using query templates. Templates can be created and managed in the Templates tab, or from a list of codes added to a query. See Query Templates for more information on creating and managing templates.
To add templates to your product list, click on the templates button (notepad icon) within the Select Products pane.
From the Zip data page, you can also click on the “Select a Template” button to add templates.
This will open a new window where you can select the template(s) you would like to add. To exit the window without applying any changes, click “Cancel”.
Use the search bar to search for a specific template. To preview the template, click on the template name. This will open a new window with the details of the codes in the template.
You can add a template by clicking on the + button next to the template name. You may add more than one template at a time. To deselect a template, click the - button.
Note that templates are compatible across all Compass products (including Compass Patient and Pathway). Some products that are supported in Compass Patient and Pathway are not supported in Compass Prescriber and Compass National. When adding a template that contains products that are not supported, a warning message will appear that the selected template contains unprojected products. This means that only the products that are supported in Compass Prescriber and Compass National will be added to the query.
Once you have finished selecting your templates, click Apply. This will apply all the selected templates and add the corresponding products. You may then refine your products as needed by adding or removing additional products via Code Searcher.
Time Frame
The Time Frame pane allows you to define the time frame of interest for the transactions. For example, you may be interested in seeing prescriber projected data from the last 24 months.
To select a time frame, select a value from the drop-down (Last 12 months, Last 24 months, Last 36 months).
By default, the time frame is set to Last 12 months. You can toggle the time frame at any time in the Define Prescribers step, or utilize a custom time frame in the Delivery step.
The months that will be provided in the query are displayed in the Time Frame section of the Filters.
Data Type
The Data Type pane allows you to specify whether you would like to receive projected data on a Prescriber or Zip level.
If Prescriber is selected as the Data Type, you will continue building your query in the Define Prescribers step and move on to applying module filters, if desired. Refer to “Module Filters” for more information on filtering prescribers based on volume.
If Zip is selected as the Data Type, you will be taken to the Zip data page where you can update your products and time frame if needed, select a delivery schedule and options, and submit your Zip data pull.
Note that you can switch between the Prescriber and Zip data types at any point using the toggle. Any selected products and time frame will be carried over. If any prescriber module filters were applied, they will be cleared out if the products or time frame is changed.
Module Filters
Prescriber Volume Module
Upon selecting at least one product and a time frame, a visualization of the prescriber volume distribution will be automatically generated. The prescriber volume visual displays the total prescriptions and procedures (Tx) or New Patients per prescriber, relative to the percentage of the total Tx/New Patient volume that those prescribers account for. In addition, the count of total HCPs and HCOs for the selected products and time frame is shown.
By default, the prescriber volume visual will show distribution for Tx. You can select the metric (Tx or New Patients) by using the “Metric” drop-down in the visual.
This visual is updated dynamically based on the products and time frame that are selected, and allows you to filter the prescribers provided in your query based on their Tx or New Patients volume.
For example, in the visual shown below, prescribers with a Tx volume that is greater than or equal to 820 (comprised of 2,389 HCPs and 351 HCOs) make up the top 50% of the total Tx volume for the selected products and time frame.
For the same set of products and time frame, prescribers with a Tx volume that is greater than or equal to 3,553 (comprised of 78 HCPs and 11 HCOs) make up the top 5% of the total Tx volume.
You can hover to explore the distributions of prescriber volumes and market percentages, and then click to move the point to another part of the graph.
You can also drag and drop the orange point to move it to another part of the graph.
Once you have determined the volume that you would like to use to filter your prescribers, click Apply.
This will filter your query to only return prescribers with total Tx or New Patients volume greater than or equal to your specified threshold. For example, if you filter on Tx ≥ 3,553, this means that only prescribers with 3,553 or more Tx across the selected brands and time frame will be returned.
You can update this filter at any time by moving the point, then clicking Apply again. Note that only one prescriber volume filter can be applied at a time, for either Tx or New Patients. You can also remove the filter by clicking on the trash can icon in the Filters pane.
By default, if no prescriber volume filter is applied, you will receive all prescribers with at least one transaction across the selected products and time frame.
Note that updating the products or time frame will clear out any applied prescriber volume filters, since the prescriber volume distribution is generated based on the current selections.
Top HCPs Module
The Top HCPs module allows you to see the top HCPs for your selected products and time frame, along with their treatment and patient volume. Using the Top HCPs module, you can answer key business questions such as:
- Who are the top writers in my market, and what is their treatment and patient volume?
- What specialties are my top writers?
- Where are my top writers located? You can also use this module to quickly search on and answer questions for specific HCPs of interest to support research and field activities.
Upon selecting products and a time frame, you can view the top prescribing HCPs by toggling to the Top HCPs module. This module displays HCPs treating with the selected products and as well as any relevant information, such as NPI, specialty, and location information, and their Tx and New Patient rank and volumes over the selected time frame. In addition, you can search for specific HCPs of interest by name or NPI.
You can also filter your data output by selecting a number of top HCPs and a metric to filter by, then clicking Apply. For example, you can specify that you want to receive the top 1,000 HCPs by New Patient volume in your output.
Applying a top HCPs filter will exclude HCOs from your data output. The top HCPs filter can be used in combination with filtering on prescriber volume in order to drill down to a smaller set of HCPs. If both a top HCP and prescriber volume filter are applied, the filter that returns the smaller set of HCPs will override. The count of the total HCPs above the filters pane indicates how many HCPs will be returned in the data pull based on all applied filters.
Note that updating the products or time frame will clear out any applied top HCP filters, since the HCP list is generated based on the current selections.
Once you are done defining your prescribers, click on “Pull Data” to move on to the Delivery step.
Delivery
The Delivery step allows you to select a delivery schedule, a time frame for the data, as well as to specify where the data will be delivered and in what format.
Delivery Schedule
Delivery Schedule allows you to select how often you would like your data delivered. The delivery schedule options for Compass Prescriber are:
- One Time - A one time pull provides a single delivery with the selected products, filters, and time frame.
- Monthly - A monthly job allows you to receive the latest set of projections on a recurring monthly basis. Monthly jobs are run on the 1st of each month, and will include projections up until the end of the latest available month. For example, a monthly job run on April 1, 2024 will include projections up until the end of February 2024. The following monthly job, run on May 1, 2024, will include projections up until the end of March 2024.
Time Frame
The Time Frame pane can be used to select a time frame for your data. Prescriber data is provided at a monthly level. By default, the time frame that will be used for the query is the selection from Step 1 in the Time Frame section.
For one time jobs, you can opt to receive data from a custom time frame rather than using the time frame selection from Step 1. Select the “Custom time frame” option, then use the month selectors to pick your desired time frame.
To add a starting month, type the three letter abbreviation for the month (e.g. Jan, Feb, Mar) or click the “mmm yyyy” or the calendar picker next to “From”.
After selecting the starting month, specify the ending month. To add an ending month, type or click the “mmm yyyy” or the calender picker next to “To”. Note that the From date must be before the To date.
For monthly jobs, you can opt to receive a rolling time frame of data (e.g. each monthly job will provide data from the most recent 12, 24, or 36 months) using the selection from Step 1, or a full refresh. Full refresh means that each monthly job will provide data from January 2022 to the latest available month.
Compass Prescriber has data available starting from Jan 2022, and the prior month’s projections are published on the 28th of each month. For example, April 2025 projection data will be made available on May 28, 2025.
Note that for Prescriber level queries, if a prescriber volume filter was applied and a custom time frame or full refresh is selected, the prescriber volume filter will apply to the custom or full refresh time frame rather than the time frame utilized to generate the visualization. This may impact the returned list of prescribers in your data output.
For example, if you filter on Tx ≥ 4,726 using the “Last 36 months” time frame, then update your custom time frame to be 6 months, the query will only return prescribers with Tx ≥ 4,726 in the selected 6 month window, which may result in fewer prescribers in your query results.
Delivery Options
Delivery Options allows you to select the data delivery location and format. The following delivery locations are currently available:
- SFTP is a Veeva-hosted secure file location which allows users to use an SFTP client (such as FileZilla or CyberDuck) to connect, navigate and download their data files
- Amazon S3 allows you to deliver your data files to Amazon S3. The Amazon S3 option is only available for users with a pre-configured Amazon S3 bucket. Refer to Setting up an Amazon S3 Bucket for more information on S3 bucket setup.
- Microsoft Azure allows you to deliver your data files to Microsoft Azure. The Azure option is only available for users with a pre-configured Azure container. Refer to Setting up a Microsoft Azure container for more information on Azure container setup.
- Veeva CRM allows users to deliver Veeva Compass Prescriber data directly to the field team, through powerful MyInsights content that is updated monthly. The Veeva CRM option is available for users with an active Veeva CRM MyInsights subscription. Note that CRM is only available for monthly data queries. Currently, one active monthly query can be sent to CRM MyInsights per customer.
- Vault CRM allows users to deliver Veeva Compass prescriber-level data directly to the field team, through powerful X-Pages content that is updated monthly. The Vault CRM option is available for users with an active Vault CRM X-Pages subscription. Note that CRM is only available for monthly data queries. Currently, one active monthly query can be sent to Vault CRM X-Pages per customer.
- Veeva Nitro is a data science and analytics platform that seamlessly integrates with Veeva Compass. Nitro provides faster access to your data, so you have your data ready for querying, visualizing and reporting. The Nitro option is only available for users with an active Nitro subscription.
- Portal Download allows business users without access to an SFTP location to download their data directly from the Portal in an Excel format. Note that each tab within the Excel file will be truncated at 600K rows.
You may refer to the SFTP section for instructions on how to access your data via the SFTP, and the Files and Format section for more information on the CSV and Excel delivery packages.
Schema Versions
For customers migrating schemas, Compass will maintain both the current retiring schema and the new enhanced schema in parallel for up to 12 months. Customers with a single schema may ignore this section.
Each schema version will have its own Delivery Package complete with version-specific Data Dictionaries and a version-specific API parameter. Migrating customers can select the data schema version as part of the Delivery Options.
This data schema version selection will be available when:
- Creating a new query
- Editing an existing scheduled query within the Job Manager, to change the job parameters to deliver in the V2 schema going forward
- Duplicating an existing scheduled query within Job Manager, to keep a version of the query delivering in the V1 schema and a new version of the query to deliver in the V2 schema in parallel
The ingestion updates may apply to new, removed, or changes to existing fields. Your Product Expert can provide the resources or support in transitioning to the new schema, including the Data Dictionaries for your impacted products and sample data in CSV and Parquet formats to test these changes before creating new queries. For more information please refer to New Schema Transition.
Once changes to support the new schema have been made and all existing queries have been modified to deliver in the updated schema, this schema selection will no longer be available. If needed, your Product Expert team can support you in the editing or duplicating of any existing scheduled jobs.
Submit
For Prescriber level data, once you have completed the Delivery step, click on Next to move on to the Review & Submit step. Review & Submit is the final step before the query is submitted for processing. This step allows you to confirm the details of your data pull prior to submission. To make changes to your market definition or applied filters, click on “Edit” below Define Prescribers.
To make changes to your schedule, time frame or delivery location, click on “Edit” below Delivery.
For both Prescriber and Zip level data, when you are ready to submit your query, click “Submit”.
Upon clicking “Submit”, a modal will appear for you to provide a name and select a license (if applicable) for your query, as well as manage sharing settings.
Note Query names can only consist of letters, numbers, underscores and spaces.
Sharing Settings
Sharing settings allow users to manage roles and access to jobs. These roles determine the user’s permissions (allowed actions) on the job. Roles can be assigned to individual users or groups. Users can also subscribe to job email notifications (e.g. job completion emails) via sharing settings.
By default, upon selecting a license, the user submitting the job is assigned as the Owner role, and any groups associated with the selected license are added to the Viewer role.
You can add additional users and groups to the sharing settings by searching in the “Share with users and groups” search bar, then clicking to select the user or group. The list of available users and groups will be filtered to those associated with the selected license.
By default, the newly added user/group will be assigned the Viewer role. To update the role for a user or group, click on the drop-down menu in the Role column. Note that to reassign another user as the Owner, you must submit the job first, then update the sharing settings in Job Manager.
The table below provides details of permissions that are available for each role.
You can also subscribe users or groups to receive email notifications related to the job, such as when the job completes or is cancelled. To subscribe a user or group to email notifications, select the “Email notifications” checkbox.
Note that for one time jobs, email notification settings can only be updated when the job is submitted or during processing.
You may preview the list of users in a group by hovering over the group name. To remove a user or group from sharing settings, click on the “-” button.
Submit Job
Once you have made any desired updates to sharing settings for the job, click on “Submit”. You can check the status of your job in the Job Manager as well as manage the sharing settings. Confirmation of the Query ID, Query Name & Delivery location will pop up once the data pull is successfully submitted. You can check the status of your data pull in the Job Manager.