View and export KPI data (GDPR)

View KPI data for contact, lead, and opportunity using system views, and export the data to an Excel file. The KPI data is stored in the following entities:

  • Contact KPI Items
  • Lead KPI Items
  • Opportunity KPI Items


This topic is applicable only for the Relationship Analytics feature.

License and role requirements

License Dynamics 365 Sales Premium
More information: Dynamics 365 Sales pricing
Security Role System Administrator or Sales Manager
See Predefined security roles for Sales

View KPI data

You can use the system views for these entities or create your own views to view the data.

  1. Go to Advanced Find.
  2. In the Look for list, select the record type as one of the entities mentioned earlier.
  3. Select a system view from the Use Saved View list or create a new view. View KPI data
  4. Specify the columns to include in the view by selecting Edit Columns, and then selecting the columns to display.
  5. Select Results to view the data.

For detailed information about using Advanced Find, see Create, edit, or save an Advanced Find search

After viewing the results, you can export data to Microsoft Excel, if required. You can do so by selecting the export to Excel option from the command bar.

Export data to Microsoft Excel

For more information about exporting data from Dynamics 365 Sales to excel, see Export data to Excel

Can't find the options in your app?

There are two possibilities:

  • You don't have the necessary license or role to perform the steps.

  • Your organization might be using a custom app and hence the site map and UI will be different. Check with your administrator for the exact steps. The steps described in this documentation are specific to the out-of-the-box Sales Hub or Sales Professional app.

See also

Embedded Intelligence and GDPR