Most Visited Pages

Brendon McCarthy asked on October 21, 2014 21:32

I have a modified version of the default "Articles" web part/widget that displays pages from a custom page type. I'd like to add a clause orders the pages/documents by most visited.

Recent Answers

Virgil Carroll answered on October 21, 2014 23:59

Here you could either write a custom SQL query and look into the Analytics tables to calculate this information:

Or you will probably have to look at leveraging CMS.WebAnalytics.dll methods to accomplish this with code.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on October 22, 2014 14:21

My suggestion would be similar to what Virgil mentioned, use a custom query. You can create this query within SSMS for testing reasons and then create a custom query in the Articles page type within Kentico. Then on your page, add a Custom Query Repeater and select the query you created on the Articles page type and you're set. No custom code, it can all be managed within the Kentico UI.

0 votesVote for this answer Mark as a Correct answer

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