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

Aggregate data for multiple (groups) of websites #2541

Closed
mattab opened this issue Jul 5, 2011 · 5 comments
Closed

Aggregate data for multiple (groups) of websites #2541

mattab opened this issue Jul 5, 2011 · 5 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 Jul 5, 2011

Placeholder ticket for processing aggregated reports for multiple websites.

For example, API functions could accept idSite=1,2,3,4 to return "top keywords" for the websites 1,2,3,4. This would be a useful feature for large Piwik setups, where one customer would "own" several websites and would like to see aggregated stats for all his/her websites.

@anonymous-matomo-user
Copy link

The basic stats implementation could be similar to how "profiles" work in google analytics, so you could create, edit, assign and delete websites from groups at will, and view the main traffic numbers for each via the All Websites Dashboard. Adding individual or expand/collapse all functionality to that dashboard would also be helpful.

@mattab
Copy link
Member Author

mattab commented Jul 8, 2011

Some thoughts on this feature...

  1. Report aggregate
    a- Aggregate "numbers" like visits, actions, time on site, revenue, conversions, ecommerce orders, ecommerce cart abandoned.
    b- Aggregate "reports" like: Top keywords, top websites, visits per hour, top page URLs, page titles, ecommerce products, etc.

I assume that both aggregates are important/nice to have.

The algorithms to sum reports are more or less already there in the code (used for the "Date Range" feature for example).

The question remains regarding how to request reports.

  1. Requesting reports

We could allow to request the consolidated report for "all site in a group", "all sites for a user"... or we could at first, allow consolidated report of a comma separated list of IDs: &idSite=1,4,55,332 which users would build (by getting site IDs from a website group, or site ID for a given user).

  1. User Interface VS API
    Implementing in the API only is the first step.

Then, we could also somehow display the consolidated reports in Piwik UI, but maybe this is not needed in V1.

  1. Pre-processing reports?

We could maybe pre-process the reports, or we could simply wait until they are requested and then fetch all reports for each site in the request, and sum in real time. This should be fairly fast since there are no logs to run a query against (we assume that all individual website reports are themselves pre-processed).

I propose that at first we don't pre-process the "consolidated" reports. We can expect response time in the range of 1 second if requesting consolidated "Top Keywords" for around 10-20 websites.

@pebosi
Copy link
Contributor

pebosi commented Mar 7, 2013

Any updates on this?

@mattab
Copy link
Member Author

mattab commented Mar 11, 2013

@pebosi, no update

@mattab mattab added this to the Future releases milestone Jul 8, 2014
@mattab mattab closed this as completed Nov 27, 2014
@mattab mattab reopened this Dec 22, 2016
@mattab mattab added this to the Backlog (Help wanted) milestone Dec 22, 2016
@mattab
Copy link
Member Author

mattab commented Dec 22, 2016

Hello everyone!

Just to let you know: this powerful feature is now available as part of the Roll-Up Reporting premium plugin. Check it out & learn more here: https://plugins.piwik.org/RollUpReporting

@mattab mattab closed this as completed Jun 13, 2017
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

3 participants