{"id":178,"date":"2017-04-02T16:53:37","date_gmt":"2017-04-02T16:53:37","guid":{"rendered":"https:\/\/www.harepoint.com\/Blog\/?p=178"},"modified":"2019-02-26T13:16:22","modified_gmt":"2019-02-26T13:16:22","slug":"sharepoint-web-analytics-custom-fields","status":"publish","type":"post","link":"https:\/\/www.harepoint.com\/Blog\/sharepoint-web-analytics-custom-fields\/","title":{"rendered":"Custom fields from AD or SharePoint User Profile in Analytics reports"},"content":{"rendered":"\n

Since the version 16.1.0.0 of HarePoint Analytics for SharePoint 2016<\/b><\/a> and version 15.6.0.0 of HarePoint Analytics for SharePoint 2013<\/b><\/a>, the new great feature is available: now it is possible to include any custom fields from Active Directory or SharePoint User Profile, so that you can have those fields displayed in reports, as well as you can filter or group reports by that fields easily. This makes HarePoint Analytics reports even more flexible and informative. A large set of brand new reports can be created using this functionality. Below you can find a brief description of how to configure and how to use this new feature.<\/p>

Enabling data collection for custom fields<\/h2>\n

There is a large number of fields available both in Active Directory and in SharePoint User Profile. It is important to note that by default, HarePoint Analytics is only collecting data for some basic fields (such as Department, City, Title, E-Mail, etc) and not collecting data for any other fields until they are selected in the settings.<\/p>\n

That is, data collection for a custom field starts after the field is selected, and stops when this field is removed from the settings.\nIn order to manage the data collection for the custom fields, go to Central Administration \u2013 Monitoring \u2013 HarePoint Analytics settings \u2013 Data collection from additional fields<\/b>:<\/p>\n\n

<\/p>\n\n

By default, no custom fields are selected:<\/p>\n\n

<\/p>\n\n

To add a new field, click New \u2013 Add new data source<\/b>:<\/p>\n\n

<\/p>\n\n

A form will open, where you can select any field either from Active Directory<\/b> or from SharePoint User Profile<\/b>:<\/p>\n\n

<\/p>\n\n

In this example, we are adding Manager<\/b> and Office<\/b> fields from User Profile:<\/p>\n\n

<\/p>\n

<\/p>\n\n

Now, both fields are displayed in a list, and (which is especially important) data collection for them has now started:<\/p>\n\n

<\/p>\n\n

Note<\/b>: consider to include only the necessary fields, to prevent excessive database growth. For more details, refer to HarePoint Analytics Admin Guide<\/a>.<\/p>\n\n

Using custom fields in reports<\/h2>\n\n

Viewing, sorting and grouping<\/b><\/p>\n\n

Immediately after the fields have been selected in HarePoint Analytics settings, they become available in reports. These fields, however, are not displayed in a data grid by default, so you would need to enable them using Fields<\/b> button on a ribbon:<\/p>\n\n

<\/p>\n\n

As you can recognize, the two newly added fields are at the end of the list<\/b>:<\/p>\n\n

<\/p>\n\n

Select these checkboxes, then click Apply<\/b>, and the custom fields are now displayed in a data grid:<\/p>\n\n

<\/p>\n\n

Note<\/b>: the data in these fields will appear only after the data processing is completed. This depends on the schedule of HarePoint Analytics timer jobs. With the default schedule, the data will appear on the next day.<\/p>\n

The columns for custom fields act as any other regular column in HarePoint Analytics report, so you can do the following:\n