Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add a report: top flattened URLs #707

Open
mattab opened this issue May 13, 2009 · 0 comments
Open

Add a report: top flattened URLs #707

mattab opened this issue May 13, 2009 · 0 comments
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.

Comments

@mattab
Copy link
Member

mattab commented May 13, 2009

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Development

No branches or pull requests

1 participant