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
- Top queries by month
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 🙂
You must log in to post a comment.