Is it possible to report on pages not accessed or visited in a certain time frame?

Gabe R asked on January 31, 2020 22:46

Is it possible to report on pages not accessed or visited in a certain time frame?

Kentico allows you to report on pages that were modified in a specific time frame, but how about pages that were viewed/accessed? Essentially, we are looking to find pages that have no (or very little) traffic, and Google Analytics is not well suited to this.

Thanks!

Recent Answers


Dat Nguyen answered on February 1, 2020 14:26 (last edited on February 1, 2020 15:08)

The Reporting application does have a subset of Web Analytics reports which include page views reports (which produces a table with the pages having the most views), but not reports on unvisited pages. You can try creating the kinds of report you need by cloning the page views reports and adjusting the queries and layout to suit you.

Let's take the Page Views Monthly report and do the following to create a Least visited pages report:

  1. Find the Page Views - Monthly report in the Reporting application > Web Analytics > Page Views.
  2. Clone the report using the Clone report button above the report list pane.
  3. In the modal dialog that pops up, change the name to "Least visited pages report" and change the report code name appropriately. Click the Clone button.
  4. Switch to the General tab, find the Layout field. Then remove the existing controls by simply deleting the text in the field.
  5. Find the Tables dropdown field, select "table" from the dropdown.
  6. Click the ellipses by the New button to bring up more actions, and then click Clone. A modal dialog opens.
  7. Give the cloned table object a new unique name and codename and click the Clone button. The modal closes.
  8. Now select the cloned table object in the Tables dropdown field.
  9. Click the ellipses by the New button to bring up more actions, and then click Edit.
  10. In the Query field of the modal dialog, remove DESC from any OrderBy clauses you find. This will cause the query to return pages with the least views first.
  11. Click Save and Close.
  12. Now click the Insert button by the Tables dropdown field. This will insert the cloned table into the layout.
  13. Click Save.
  14. Go to the View tab to view the new report. Adjust the time period as needed.

There you have it. Keep in mind, this only works for Portal engine sites.

EDIT: Unfortunately, this report doesn't include pages with zero hits. But you can make that happen by making adjustments to the SQL query.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.