Ticket #707 (new New feature)

Opened 3 years ago

Last modified 19 months ago

Add a report: top flattened URLs

Reported by: matt Owned by:
Priority: major Milestone: Feature requests
Component: Core Keywords:
Cc: Sensitive: no

Description (last modified by matt) (diff)

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.).

Change History

follow-up: ↓ 2   Changed 3 years ago by matt

  • description modified (diff)

in reply to: ↑ 1   Changed 3 years ago by albass

  Changed 2 years ago by domtop

  Changed 2 years ago by matt

  • sensitive unset
  • summary changed from Add a report: top flattened URLs as well as existing report with automatical categorization of URLs by directory to Add a report: top flattened URLs

  Changed 19 months ago by matt

  • milestone changed from 4 - Piwik 1.0 - Stable release to Features requests - after Piwik 1.0
Note: See TracTickets for help on using tickets.