Best practices for reporting on a high number of dynamic pages


Webtrends Analytics 8.x
Webtrends Analytics 9.x


Many organizations use dynamic pages for things like articles or news stories. As the high number of these pages can cause issues when it comes to the granularity and availability of Webtrends’ report data, the follow steps should be helpful in minimizing reporting and performance impacts related to the TopPages table limit.

The TopPages table is what a number of reports and features are based, most notably the Pages report, but also includes Entry/Exit Pages, Pathing reports, SmartView, and any custom reports that use URLs.


Instead of reporting on these pages in the Pages report, which can require large table increases that may not be feasible, it is recommended that a custom report is created that is based upon the dynamic parameters that define each page. For user-friendly reporting, choose to use a translation table that will convert the parameter names into the desired name/structure (for example URL, Page Title).

This implementation has the following benefits:

  • As there are no other reports that are dependent on the custom report, it becomes much more feasible to increase the table limits to the required levels. This stems from the fact that the impact upon profiles is much more minimal in relation to the same increases being performed on the TopPages table.
  • Since the TopPages table does not use Smart Limiting (also known as Smart Trimming), and one-dimensional custom reports do, this allows you to benefit from that functionality. Smart Limiting is an algorithm that uses the age, frequency, and relevance of activity data when deciding which records to include in the table. Smart Limiting allows Webtrends to include the most significant data and aggregate records with low relevance, storing them in the “other” category.