I am not aware of an OOTB feature to export the Most Popular Items search query to excel.

How may this be achieved?


Per my knowledge you may need to do it manually with PowerShell.

In Microsoft.Office.Server.Search.Analytics namespace, there is a method “UsageAnalytics.GetAnalyticsItemData” which can help to “Retrieves aggregated usage data for a specified item for a specified event type”.

You may use it as a start point.

| improve this answer | |
  • Thanks Jerry - I was hoping to find a simpler way. – garvon-77 Dec 2 '19 at 3:14
  • @garvon-77 As another option, you may need to call search REST API to get the results for most popular items. Reference link for custom code:sharepointpals.com/post/… – Jerry_MSFT Dec 2 '19 at 6:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.