Small Tips and Tricks : SharePoint Online – Getting the reports on queries – Top Queries, Abandoned queries, No result queries…

Hi All,

Greetings for the day!!!

Today small tip on how to get to know Top Queries performed / happened for my Site / Tenant, which queries are abandoned / which queries did not returned results…

Background :

• My manager asked me – how can we generate the following reports in SP site
  • Top queries by month
    • These queries are most popular search queries
    • A query is added to this report when it’s searched at least three times with a click on a result
  • Abandoned queries by month
    • Abandoned queries are popular search queries that receive low click-through
  • No result queries by month
    • popular search queries that returned no results
    • These queries are actually useful to improve the finding content

Since I was also not completely aware, looked into bit and found settings. So this small article.

We can generate these kind of reports at

• At SiteCollection level
• At Tenant level

Details / Steps

Generating Reports at Site Collection level

• Navigate to your site collection
• Click on Gear icon (right top corner) to open the “Settings” menu as shown in below fig
• Click on “Site information” link

• On click of “Site information” link from “Settings” menu, “Site Information” panel will open as shown in below fig
• From “Site Information” panel click on “View all site settings” link at bottom

• On click of “View all site settings” link we will be redirected to “settings.aspx” (_layouts/15/settings.aspx) page as shown in below fig
• In second column at bottom there is section “Microsoft Search” and link – “Configure search settings” as in below fig

• On click of link “Configure search settings” we will be redirected to “Microsoft Search” page (/_layouts/15/SiteAdmin.aspx#/) – https://knowledgejunction1.sharepoint.com/_layouts/15/SiteAdmin.aspx#/

• On “Microsoft Search” page we will have various reports
  • Impressions by result type as in below fig

• We have reports / result for
  • Top queries
  • No result queries
  • Abandoned queries

• We have an option to get the reports for duration – Past 31 days or Past 12 months as shown in below fig

Generating Reports at Tenant level

• From SharePoint admin center we could generate search reports at tenant level

Details / Steps

• Navigate to Microsoft 365 admin center – https://admin.microsoft.com/
• Next navigate to SharePoint admin center
  • From Microsoft 365 admin centers, from left pane
  • Admin centers
  • SharePoint
  • Microsoft 365 admin center >> Admin centers >> SharePoint

• From SharePoint admin center, navigate to “More features” from left side pane as shown in below fig

• On click of “More features” we will be navigating to classic features page as shown in below fig
• We are on classic SharePoint admin center page
• We will navigate to “Search” administration page
• Please click on “Open” button under Search box as shown in below fig

• We will be redirected to Search administration page – _layouts/15/searchadmin/TA_SearchAdministration.aspx
• On Search administration page we have various options available as shown in below fig

• Navigate to “View Usage Reports” – Search reporting page – /_layouts/15/reporting.aspx?Category=AnalyticsSearch

Thanks for reading !!! Please feel free to discuss / suggestions / share thoughts !!!

HAVE A GREAT TIME AHEAD !!! LIFE IS BEAUTIFUL 🙂