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

Exported API datasets do not contain "Unique visitors" or "Unique entrances" or "Unique exits" metrics for URL folders #9483

Closed
mattab opened this issue Jan 8, 2016 · 0 comments
Labels
answered For when a question was asked and we referred to forum or answered it.
Milestone

Comments

@mattab
Copy link
Member

mattab commented Jan 8, 2016

Problem description

For URL folders eg. domain.com/folder/*, when exporting the dataset in CSV such as: http://demo.piwik.org/index.php?module=API&method=Actions.getEntryPageUrls&format=TSV&idSite=7&period=day&date=yesterday&expanded=1&translateColumnNames=1&language=en&token_auth=anonymous&filter_limit=100

In this file, we notice that "Unique visitors" or "Unique entrances" or "Unique exits" metrics columns are empty for a particular set of rows.

  • For all rows that are for a Page URL folder domain.com/folder/* then the "Unique" metrics are not found
  • For all rows that are for actual Page URLs domain.com/page then the "Unique" metrics are correctly processed.

Why is there missing metric for page URLs folders?

The reason the metrics are removed is because Piwik does not process them. How could we get the "Unique visitors" who visited for example domain.com/folder/* ? if we summed the "Unique visitors" of all pages within this folder, we would not get the "Unique visitors" but a sum of unique visitors, which is completely different.

Therefore Piwik cannot process

Workaround?

A possible workaround would be to use &flat=1 in the URL so that all URLs are flattened. Then all "Unique" metrics will be displayed since all rows in the dataset will be for actual page urls.

Example: http://demo.piwik.org/index.php?module=API&method=Actions.getEntryPageUrls&format=TSV&idSite=7&period=day&date=yesterday&expanded=1&translateColumnNames=1&language=en&token_auth=anonymous&filter_limit=100&flat=1

@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Jan 8, 2016
@mattab mattab added this to the 2.16.0 milestone Jan 8, 2016
@mattab mattab closed this as completed Jan 8, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

1 participant