I was just browsing the Accesslog and saw over 100,000 hits on node/1000 from Wikipedia, but the node_counter table shows less than 1,000 views total. Why do the referrals from Wikipedia not count? I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
No, no Boost. We do have eAccelerator, but that shouldn't do anything to Apache. Statistics are very important to the Marketing team that are paying for this. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Brian Vuyk <brian@brianvuyk.com> To: development@drupal.org Sent: Wed, November 17, 2010 5:22:26 PM Subject: Re: [development] Accesslog and Node_counter Are you possibly using boost or another caching function which avoids Apache for some requests? On 10-11-17 03:51 PM, nan wich wrote: I was just browsing the Accesslog and saw over 100,000 hits on node/1000 from Wikipedia, but the node_counter table shows less than 1,000 views total. Why do the referrals from Wikipedia not count?
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
Jr.
You don't have cacherouter on there or any other fast_pagecache implementing modules, do you? Jamie Holly http://www.intoxination.net http://www.hollyit.net On 11/17/2010 7:53 PM, nan wich wrote:
No, no Boost. We do have eAccelerator, but that shouldn't do anything to Apache. Statistics are very important to the Marketing team that are paying for this.
/*Nancy*/
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------------------------------------------------ *From:* Brian Vuyk <brian@brianvuyk.com> *To:* development@drupal.org *Sent:* Wed, November 17, 2010 5:22:26 PM *Subject:* Re: [development] Accesslog and Node_counter
Are you possibly using boost or another caching function which avoids Apache for some requests?
On 10-11-17 03:51 PM, nan wich wrote:
I was just browsing the Accesslog and saw over 100,000 hits on node/1000 from Wikipedia, but the node_counter table shows less than 1,000 views total. Why do the referrals from Wikipedia not count? I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well.
/*Nancy*/
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
3 thoughts. 1. Are you using a CDN like akamai? 2. I'm not sure if {node_counter} is tied to a cron run in statistics.module. If it is the 'discard access logs older than' might be the cause of your problem. 3. Why not use Google Analytics or webalizer or similar? On Wed, Nov 17, 2010 at 8:05 PM, Jamie Holly <hovercrafter@earthlink.net>wrote:
You don't have cacherouter on there or any other fast_pagecache implementing modules, do you?
Jamie Hollyhttp://www.intoxination.net http://www.hollyit.net
On 11/17/2010 7:53 PM, nan wich wrote:
No, no Boost. We do have eAccelerator, but that shouldn't do anything to Apache. Statistics are very important to the Marketing team that are paying for this.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------ *From:* Brian Vuyk <brian@brianvuyk.com> <brian@brianvuyk.com> *To:* development@drupal.org *Sent:* Wed, November 17, 2010 5:22:26 PM *Subject:* Re: [development] Accesslog and Node_counter
Are you possibly using boost or another caching function which avoids Apache for some requests?
On 10-11-17 03:51 PM, nan wich wrote:
I was just browsing the Accesslog and saw over 100,000 hits on node/1000 from Wikipedia, but the node_counter table shows less than 1,000 views total. Why do the referrals from Wikipedia not count?
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
No cdn. The data is there in accesslog, so it has not been deleted yet. They use Coremetrics. But they want (close to) real time data in the site itself. It must have something to do with the referrer. Accesslog records without a referrer URL seem to count. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: David Stoline <unncola@gmail.com> To: development@drupal.org Sent: Wed, November 17, 2010 8:32:45 PM Subject: Re: [development] Accesslog and Node_counter 3 thoughts. 1. Are you using a CDN like akamai? 2. I'm not sure if {node_counter} is tied to a cron run in statistics.module. If it is the 'discard access logs older than' might be the cause of your problem. 3. Why not use Google Analytics or webalizer or similar? On Wed, Nov 17, 2010 at 8:05 PM, Jamie Holly <hovercrafter@earthlink.net> wrote: You don't have cacherouter on there or any other fast_pagecache implementing modules, do you?
Jamie Holly http://www.intoxination.net http://www.hollyit.net
On 11/17/2010 7:53 PM, nan wich wrote: No, no Boost. We do have eAccelerator, but that shouldn't do anything to Apache. Statistics are very important to the Marketing team that are paying for this.
Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Brian Vuyk <brian@brianvuyk.com>
To: development@drupal.org Sent: Wed, November 17, 2010 5:22:26 PM Subject: Re: [development] Accesslog and Node_counter
Are you possibly using boost or another caching function which avoids Apache for some requests?
On 10-11-17 03:51 PM, nan wich wrote: I was just browsing the Accesslog and saw over 100,000 hits on node/1000 from Wikipedia, but the node_counter table shows less than 1,000 views total. Why do the referrals from Wikipedia not count?
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
Jr.
You could try http://drupal.org/project/google_analytics_counter -- but of course, that will by definition give you smaller page view counts (only what Google Analytics records, i.e. no bot accesses etc.) Tomáš (vacilando) On Thu, Nov 18, 2010 at 04:12, nan wich <nan_wich@bellsouth.net> wrote:
No cdn. The data is there in accesslog, so it has not been deleted yet. They use Coremetrics. But they want (close to) real time data in the site itself.
It must have something to do with the referrer. Accesslog records without a referrer URL seem to count.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------ *From:* David Stoline <unncola@gmail.com> *To:* development@drupal.org *Sent:* Wed, November 17, 2010 8:32:45 PM
*Subject:* Re: [development] Accesslog and Node_counter
3 thoughts.
1. Are you using a CDN like akamai? 2. I'm not sure if {node_counter} is tied to a cron run in statistics.module. If it is the 'discard access logs older than' might be the cause of your problem. 3. Why not use Google Analytics or webalizer or similar?
On Wed, Nov 17, 2010 at 8:05 PM, Jamie Holly <hovercrafter@earthlink.net>wrote:
You don't have cacherouter on there or any other fast_pagecache implementing modules, do you?
Jamie Hollyhttp://www.intoxination.net http://www.hollyit.net
On 11/17/2010 7:53 PM, nan wich wrote:
No, no Boost. We do have eAccelerator, but that shouldn't do anything to Apache. Statistics are very important to the Marketing team that are paying for this.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------ *From:* Brian Vuyk <brian@brianvuyk.com> <brian@brianvuyk.com> *To:* development@drupal.org *Sent:* Wed, November 17, 2010 5:22:26 PM *Subject:* Re: [development] Accesslog and Node_counter
Are you possibly using boost or another caching function which avoids Apache for some requests?
On 10-11-17 03:51 PM, nan wich wrote:
I was just browsing the Accesslog and saw over 100,000 hits on node/1000 from Wikipedia, but the node_counter table shows less than 1,000 views total. Why do the referrals from Wikipedia not count?
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
First, the customer has a dread fear of GA (I don't know why). Secondly, this is not to display a hit counter on the page, it's for various reports about the authors and their departments. Those reports can be filtered on a date range, and they would like to have a page view counter that can be filtered on that date range. The data is in accesslog, so it has not yet been deleted, and it obvious that Drupal has seen these hits, so Apache has not deflected them. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Tomáš Fülöpp On Thu, Nov 18, 2010 at 04:12, nan wich <nan_wich@bellsouth.net> wrote: No cdn. The data is there in accesslog, so it has not been deleted yet. They use Coremetrics. But they want (close to) real time data in the site itself.
It must have something to do with the referrer. Accesslog records without a referrer URL seem to count. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
Jr.
________________________________ From: David Stoline <unncola@gmail.com>
To: development@drupal.org Sent: Wed, November 17, 2010 8:32:45 PM
Subject: Re: [development] Accesslog and Node_counter
3 thoughts. 1. Are you using a CDN like akamai? 2. I'm not sure if {node_counter} is tied to a cron run in statistics.module. If it is the 'discard access logs older than' might be the cause of your problem. 3. Why not use Google Analytics or webalizer or similar?
On Wed, Nov 17, 2010 at 8:05 PM, Jamie Holly <hovercrafter@earthlink.net> wrote:
You don't have cacherouter on there or any other fast_pagecache implementing modules, do you?
Jamie Holly http://www.intoxination.net http://www.hollyit.net
On 11/17/2010 7:53 PM, nan wich wrote: No, no Boost. We do have eAccelerator, but that shouldn't do anything to Apache. Statistics are very important to the Marketing team that are paying for this.
Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Brian Vuyk <brian@brianvuyk.com>
To: development@drupal.org Sent: Wed, November 17, 2010 5:22:26 PM Subject: Re: [development] Accesslog and Node_counter
Are you possibly using boost or another caching function which avoids Apache for some requests?
On 10-11-17 03:51 PM, nan wich wrote: I was just browsing the Accesslog and saw over 100,000 hits on node/1000 from Wikipedia, but the node_counter table shows less than 1,000 views total. Why do the referrals from Wikipedia not count?
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
Jr.
You could try http://drupal.org/project/google_analytics_counter -- but of course, that will by definition give you smaller page view counts (only what Google Analytics records, i.e. no bot accesses etc.)
No. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Jamie Holly <hovercrafter@earthlink.net> To: development@drupal.org Sent: Wed, November 17, 2010 8:05:40 PM Subject: Re: [development] Accesslog and Node_counter You don't have cacherouter on there or any other fast_pagecache implementing modules, do you? Jamie Holly http://www.intoxination.net http://www.hollyit.net On 11/17/2010 7:53 PM, nan wich wrote: No, no Boost. We do have eAccelerator, but that shouldn't do anything to Apache. Statistics are very important to the Marketing team that are paying for this.
Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: Brian Vuyk <brian@brianvuyk.com>
To: development@drupal.org Sent: Wed, November 17, 2010 5:22:26 PM Subject: Re: [development] Accesslog and Node_counter
Are you possibly using boost or another caching function which avoids Apache for some requests?
On 10-11-17 03:51 PM, nan wich wrote: I was just browsing the Accesslog and saw over 100,000 hits on node/1000 from Wikipedia, but the node_counter table shows less than 1,000 views total. Why do the referrals from Wikipedia not count?
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
Jr.
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well.
Another idea: in case you're already using Google Analytics, and need a cache-proof solution, there's also the Google Analytics API module (http://drupal.org/project/google_analytics_api), which allows you to access Analytics data remotely. Pro: it's off-loaded from your own server. Contra: it's not real-time. The Google Analytics Counter module (http://drupal.org/project/google_analytics_counter) is based on this API and might already nearly do what you need. -- Stefan Kudwien Drupal Consulting
A) We do not use Google Analytics at all - it is not an option (we do use Coremetrics). B) The GAC modules uses the node_counter table. I need to be able to see the number of reads on all nodes with term 18 for the month of September, 2010. Or for the second quarter of the year, or last week. Or that were written by user/234. The node_counter table simply does not have the granularity to do that; it has reads today and total reads forever. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Stefan M Kudwien <mail@stefankudwien.com> To: development@drupal.org Sent: Thu, November 18, 2010 9:35:28 AM Subject: Re: [development] Accesslog and Node_counter
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well.
Another idea: in case you're already using Google Analytics, and need a cache-proof solution, there's also the Google Analytics API module (http://drupal.org/project/google_analytics_api), which allows you to access Analytics data remotely. Pro: it's off-loaded from your own server. Contra: it's not real-time. The Google Analytics Counter module (http://drupal.org/project/google_analytics_counter) is based on this API and might already nearly do what you need. -- Stefan Kudwien Drupal Consulting
Hi Nancy I've come in late here but have you considered piwik? http://piwik.org http://drupal.org/project/piwik Lee On Thu, 18 Nov 2010 09:13:03 -0800 (PST), nan wich <nan_wich@bellsouth.net> wrote:
A) We do not use Google Analytics at all - it is not an option (we do use Coremetrics). B) The GAC modules uses the node_counter table. I need to be able to see the number of reads on all nodes with term 18 for the month of September, 2010. Or for the second quarter of the year, or last week. Or that were written by user/234. The node_counter table simply does not have the granularity to do that; it has reads today and total reads forever. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: Stefan M Kudwien <mail@stefankudwien.com> To: development@drupal.org Sent: Thu, November 18, 2010 9:35:28 AM Subject: Re: [development] Accesslog and Node_counter
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well.
Another idea: in case you're already using Google Analytics, and need a cache-proof solution, there's also the Google Analytics API module (http://drupal.org/project/google_analytics_api), which allows you to access Analytics data remotely. Pro: it's off-loaded from your own server. Contra: it's not real-time.
The Google Analytics Counter module (http://drupal.org/project/google_analytics_counter) is based on this API and might already nearly do what you need.
-- Stefan Kudwien Drupal Consulting
They are adamnant on Coremetrics, but that is not the point, which is that node_counter and accesslog disagree. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: "contact@rowlandsgroup.com" <contact@rowlandsgroup.com> To: development@drupal.org Sent: Thu, November 18, 2010 2:48:12 PM Subject: Re: [development] Accesslog and Node_counter Hi Nancy I've come in late here but have you considered piwik? http://piwik.org http://drupal.org/project/piwik Lee On Thu, 18 Nov 2010 09:13:03 -0800 (PST), nan wich <nan_wich@bellsouth.net> wrote:
A) We do not use Google Analytics at all - it is not an option (we do use Coremetrics). B) The GAC modules uses the node_counter table. I need to be able to see the number of reads on all nodes with term 18 for the month of September, 2010. Or for the second quarter of the year, or last week. Or that were written by user/234. The node_counter table simply does not have the granularity to do that; it has reads today and total reads forever. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: Stefan M Kudwien <mail@stefankudwien.com> To: development@drupal.org Sent: Thu, November 18, 2010 9:35:28 AM Subject: Re: [development] Accesslog and Node_counter
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well.
Another idea: in case you're already using Google Analytics, and need a cache-proof solution, there's also the Google Analytics API module (http://drupal.org/project/google_analytics_api), which allows you to access Analytics data remotely. Pro: it's off-loaded from your own server. Contra: it's not real-time.
The Google Analytics Counter module (http://drupal.org/project/google_analytics_counter) is based on this API and might already nearly do what you need.
-- Stefan Kudwien Drupal Consulting
Nancy, Access log is separate from node_counter, but they're both controlled by core statistics.module. Maybe you didn't have the 'statistics_count_content_view' variable enabled at some point? Or, if you're using a module like http://drupal.org/project/statistics_advanced, it won't always count every page load since it keeps the node_counter as 'unique' views. Dave Reid dave@davereid.net On Wed, Nov 17, 2010 at 2:51 PM, nan wich <nan_wich@bellsouth.net> wrote:
I was just browsing the Accesslog and saw over 100,000 hits on node/1000 from Wikipedia, but the node_counter table shows less than 1,000 views total. Why do the referrals from Wikipedia not count?
I ask because we are increasingly needing to get view counts per day, not just total. I can easily add a hook_nodeapi('view') to count from today, but wanted to get historical counts as well.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
participants (8)
-
Brian Vuyk -
contact@rowlandsgroup.com -
Dave Reid -
David Stoline -
Jamie Holly -
nan wich -
Stefan M Kudwien -
Tomáš Fülöpp (vacilando.org)