Documentation

Updated Statistics Engine

In version 5.5.0.0.2.5, the statistics engine was updated with a new database table.

  • This table only tracks pages in view mode
  • The table records user agents
  • The userID, userAgent, and dashboard pages are all taken into account when the popularity is updated.
  • The resulting numbers, while not the same as google analytics, are much closer.
  • Until better data has been collected, the original PageStatistics table data is used. When enough clean data has been gathered, it will begin to be used.

Calculations

For those of you interested in the actual calculations, this is how each option works.

Most Popular

This is a simple calculation of adding up the page views for the specified time period.

Trending in the Last Week

This one is a bit more complicated:

  1. Get the total number of page views for the week
  2. Get the total number of page views last week
  3. For each page, calculate it's percentage of total page views for both this and last week
  4. Calculate the difference between percentage from this week and last week

Example 1: No relative change from week to week

  • Site gets 600 hits this week and 400 hits last week
  • Example Page gets 60 hits this week and 40 hits last week
  • This week (a): (60 page hits/600 site hits) = 10%
  • Last week (b): (40 page hits/400 site hits) = 10%
  • Page weight: ((10% (a) - 10% (b)) / 10% (b)) = 0%

Example 2: Page gets more relative hits this week

  • Site gets 600 hits this week and 400 hits last week
  • Example Page gets 80 hits this week and 40 hits last week
  • This week (a): (80 page hits/600 site hits) = 13.3%
  • Last week (b): (40 page hits/400 site hits) = 10%
  • Page weight: ((13.3% (a) - 10% (b)) / 10% (b)) = +.13%

Example 3: Page gets less relative hits this week

  • Site gets 600 hits this week and 400 hits last week
  • Example Page gets 40 hits this week and 40 hits last week
  • This week (a): (40 page hits/600 site hits) = 6.67%
  • Last week (b): (40 page hits/400 site hits) = 10%
  • Page weight: ((6.67% (a) - 10% (b)) / 10% (b)) = -.33%

Note:

Trending this week calculates based on this week page views vs the average of the last 2 weeks page views.

Trending last 2 weeks calculates based on the average of the last two weeks page views vs the average of the previous 3 week period page views.

Updating the Statistics

The statistics are updated via a job that does all of these calculations and then puts those numbers into page attributes. To update the statistics, re-run the 'Update Page Popularity' job from the dashboard.

There may be times that you get a SQL error when updating the statistic via the 'Update Page Popularity' job. If you get an error, just re-run the job again to fix the issue.