Segmentation

Is it possible to do data segmentation, like it is done with ASI slots in commercial packages. I think Google does it this way too.

I am coming to realize that segmentation and custom segments are critical to any major analytics provider. I am a developer and would love to help develop a plugin to help out … I’m just trying to figure out how it would work so I know where to start.

Any ideas?

The first thing I would suggest is to look at use cases. Are these pre-built / ad hoc queries, or something you would summarize daily to plot in an evolution graph?

Then decide whether or not it makes sense – a core principle of analytics is “action”. For example, knowing how many people from Canada using Firefox on Linux visited my home page from a Google search result during the Monday lunch hour may be more a curiosity than an actionable item.

Look at core/Piwik.php. The database schema is currently there. The complexity/performance of queries will determine whether the current schema will suffice or if a schema update necessary.

vipsoft suggestions are first things to think about. Codewise, one solution would be to refactor a bit the existing archiving code and make the few SQL aggregating queries accept a “dimension” (segment) parameter(s). This would map to a GROUP BY in these queries (well, one more GROUP BY to the existing list of GROUP BY fields). See the following file as an example. http://dev.piwik.org/trac/browser/trunk/pl…ferers.php#L153

If you are serious about building this feature, please know that this is not trivial at all, that this would require extensive communication with the Piwik team and many reviews to get accepted to the core. Of course, this would be an amazing feature.

Happy New Year! If you are still using Piwik and interested in the awesome new feature of “Creating a Custom Segment in Piwik and apply to reports in Real time!” we need YOUR help, with a little or big donation at: http://crowdfunding.piwik.org/custom-segments-editor/

This will allow to dynamically add or edit, a new set of rules for example “Show all visitors from USA and using Firefox and using Google”. This will be done via a simple to use interface. See screenshots and more info here: http://crowdfunding.piwik.org/custom-segments-editor/

We are crowd funding the future of Piwik and this feature in particular. With your help we can do it.

Thanks

Matthieu

Happy New Year! If you are still using Piwik and interested in the awesome new feature of “Creating a Custom Segment in Piwik and apply to reports in Real time!” we need YOUR help, with a little or big donation at: http://crowdfunding.piwik.org/custom-segments-editor/

This will allow to dynamically add or edit, a new set of rules for example “Show all visitors from USA and using Firefox and using Google”. This will be done via a simple to use interface. See screenshots and more info here: http://crowdfunding.piwik.org/custom-segments-editor/

We are crowd funding the future of Piwik and this feature in particular. With your help we can do it.

Thanks

Matthieu