How to get page visit count from access log

Question

I need to display the list of pages(nodes & terms) from access log. I enabled drupal core statistics module.

The view result should include

1. Page title.
2. Total number of distinct pages($view->total_rows).
3. Total views result($view->result).
4. Individual visit count of pages ().

I created a view and a template. I am getting points #1,#2 & #3 in my view. But #4 is missing.

I checked access log table in DB, but didn't found the column for page view count. How can get the missing point in my view?

Answer 1

You just need to enable Drupal this core module "STATISTICS", after enabling this, go to your view and in view's "Add fields" section

1. Click add
2. Select "Content statistics: Total views"

This will give you the total number every single page has been viewed.

Answer 2

1. Module Visitors

You may want to consider the Visitors module. As mentioned on its project page, it provides a block containing:

• Total Visitors.
• Unique Visitor.
• Registered Users.
• Last Registered User.
• Published Nodes.
• Your IP.

At this time there is no integration with the Views module ... yet. All reports created today use the theme function. Such views integration is being considered though, i.e. in the format of some out-of-the-box example, similar to the view delivered with the charts module.

2. Module Forena

If you'd want to "roll your own cookies" (i.e. some report that perfectly fits your custom requirements), then you might want to consider the Views integration of the Forena module. Here is a relevant excerpt about that from its project page:

Use Views with Forena to create additional more complicated layouts than can typically be created using views. Forena provides a views rowstyle plugin that lets you use a Forena report to format the output of a view.

For an example of such custom report, created with Forena, start from the statistics (summary info) of the Watchdog Statistics, as in this Watchdog Statistics sample. Note the red numbers to the right of the table, which are actually hyperlinks that can be used as drill-down reports. I.e. if you click on any of them (like the "2" for "Page not found"), you get a details report about (in this case) the 2 specific records related to the "Page not found"). More details about this specific case can be found in comment #2 of issue 2337327. Obvious, I didn't really do any effort to beef up the look-and-feel of that report, like background, etc.

3. Other modules

Modules related to Visitors contains some other modules available, which might be considered as a possible alternative (or maybe 'addition'?), such as the Views Watchdog module.

Disclosure: I'm maintainer of the Visitors module, and co-maintainer of Charts and Forena,
I hope this does not violate the site's policy on self-promotion.