Public
Honored Contributor

How to get a list of the most viewed posts of all time?

I don't know any easy way of getting a list fo the most viewed posts of all time across our community. Khoros Analytics only produces data for 12 months at a time. I need 6 years. Google Analytics doesn't have the same limit, but unhelpfully but understandably considers posts with the same ID but different URL (from being moved) as different. This affects a lot of our posts as we have created new boards and moved a lot of posts as the community has grown. 

Any suggestions? Ideally we would use Khoros Analytics but I can't think of an easy way to "stitch" the data together...

Thanks,

Jason

 

Generic1.jpg

1 Reply 1
Honored Contributor

@JasonHill,

You can use below v2 API to get most viewed posts from community.

SELECT * FROM messages ORDER BY metrics.views DESC
.......
Expecting your Kudos and Accepted Solution to my replies.

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.