The current default Piwik behaviour works fine for most websites: categorizing pages into categories based on the / directory separator.
However when doing analytics, it is often very useful to find out in a glande what are the best actual URLs overall, rather than seeing an aggregate per directory.
We could build a report listing the best URLs overall, flattened.
eg. current report is (and will still exist as):
trac/ 110 views
index 10 views
ticket/ 60 views
10 50 views
5 10 views
wiki/ 40 views
page1 35 views
page2 5 views
The new flattened report would be:
trac/ticket/10 50 views
trac/wiki/page1 35 views
trac/index 10 views
trac/ticket/5 10 views
trac/wiki/page2 5 views
Each entry would link to the URL of the page.
To build this, we can either add this table to be processed at summarization (more disk usage and slower archiving, but faster stats querying), or process it in real time by loading all the data recursively from all tables/subtables in the Pages>Actions table and sort (less disk usage and no overhead at archiving, but potentially slow stats querying for a site with hundreds of sub categories, which leads to hundreds of select in the archive tables + unzip + load in memory + sort, etc.).