Hi All,

After a bit of advice here (am relatively new to Umbraco).

I'm trying to show a list of most viewed pages for a project I am currently working on. After doing a bit of research it seems that there is no "counter" for pages included in the core.

There was mention in a few posts to just use Google Analytics API. This is not an issue and pretty easy to do. And adding a custom property on a document type is not an option as from what I understand I would need to publish the page every time I want to increment the counter.

So, I have created my own database table for storing "views" against a node (using Entity Framework 6) and this is working fine.

However, I would really like to have access list of Umbraco.Web.Models.DynamicPublishedContent objects with all of it's properties available, etc.

Where I am getting stuck is what to do next.

Is there a recommended way to pull out a list of DynamicContent joined to my custom database table in order to show the most viewed content that was created / published in the last X days?

Or, am I going about this the wrong way?

Any direction / feedback would be much appreciated.

Thanks.