Popular Post

Debayo Graham asked on July 29, 2014 00:08

Hi is there a way I can configure a repeater or some web part to display popular post. I guest popular post could be define as post visited most frequently

kentico 8

Correct Answer

Debayo Graham answered on July 29, 2014 00:11

I am trying to get this working for the Blog Post Document Type

0 votesVote for this answer Unmark Correct answer

Recent Answers

Yehuda Lando answered on July 29, 2014 06:33

I did this with a custom query repeater, and using this query (you have to add it to your document type):

SELECT TOP 5 NodeAliasPath, Logo, Name, ProfileText, SUM(HitsCount) as Hits 
FROM Analytics_Statistics, Analytics_DayHits, View_Ativ_Firms_Joined 
WHERE StatisticsSiteID = 1 AND StatisticsCode='pageviews' AND 
StatisticsID = HitsStatisticsID AND StatisticsObjectID = NodeID AND 
NodeAliasPath LIKE N'/AliasPath/%' AND ClassName = 'ativ.firm'
GROUP BY NodeAliasPath, Logo, Name, ProfileText
ORDER BY Hits DESC

1 votesVote for this answer Mark as a Correct answer

Debayo Graham answered on July 29, 2014 17:26

Do i have to enable web analytics??

0 votesVote for this answer Mark as a Correct answer

Martin Danko answered on July 30, 2014 07:22

Hi Debayo,

As you can see, the SQL query is pulling the data from the Web Analytics related tables, so the answer is yes, you need web analytics functionality to get it working, otherwise there won't be any data you can use to generate this statistic.

Best regards, Martin

0 votesVote for this answer Mark as a Correct answer