Custom Reports / Pivot table with selectable dimension #4776

Open
mattab opened this Issue Feb 27, 2014 · 7 comments

Comments

Projects
None yet
2 participants
@mattab
Member

mattab commented Feb 27, 2014

There are many cases where a Pivot table functionality would help get very powerful insights from the data.

This feature lets you create Pivot table, so for example you can see "For each Page URL, list all Referrers used" (each referrer is a new column in the Actions table). We need to add a new button to let user navigate through columns since there will be thousands of columns when Pivot table is enabled.

Pivot charts in GA are explained in this post and this one. See general overview

@anonymous-piwik-user

This comment has been minimized.

Show comment
Hide comment
@anonymous-piwik-user

anonymous-piwik-user Feb 28, 2014

from an analytics view point i think matching omnitures method of reporting multiple columns is more advantageous. i can provide screens if you like . i magine a year report broken down by month where each month was a row then each column coul be a metric like pv or uv or vistit.

another option would be compare 5 columms for 1 metric where each column was top results again broken down by a row for each month....

pics will help clarify, this would be 10 times more useful than a pivot table.

from an analytics view point i think matching omnitures method of reporting multiple columns is more advantageous. i can provide screens if you like . i magine a year report broken down by month where each month was a row then each column coul be a metric like pv or uv or vistit.

another option would be compare 5 columms for 1 metric where each column was top results again broken down by a row for each month....

pics will help clarify, this would be 10 times more useful than a pivot table.

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Apr 17, 2014

Member

@lesjokolat sounds interesting, feel free to link to attach a screenshot. Like to get feedback on this hard to implement, but powerful analysis tool!

Member

mattab commented Apr 17, 2014

@lesjokolat sounds interesting, feel free to link to attach a screenshot. Like to get feedback on this hard to implement, but powerful analysis tool!

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Dec 1, 2014

Member

we recently added Pivot table see in the API ref doc the parameters pivotBy and pivotByColumn but they're quite slow, so we could improve them sometime (post a comment if you use the pivotBy API parameters)

see also #6227

Member

mattab commented Dec 1, 2014

we recently added Pivot table see in the API ref doc the parameters pivotBy and pivotByColumn but they're quite slow, so we could improve them sometime (post a comment if you use the pivotBy API parameters)

see also #6227

@mattab mattab changed the title from Custom Reports, Pivot table feature for Piwik to Custom Reports / Pivot table with selectable dimension Mar 23, 2015

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Aug 20, 2015

Member

Example of an awesome Custom Report builder (the new one from google adwords)

report-editor-gif-draganddrop-draft-01

Member

mattab commented Aug 20, 2015

Example of an awesome Custom Report builder (the new one from google adwords)

report-editor-gif-draganddrop-draft-01

@mattab mattab added the Major label Aug 20, 2015

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Sep 22, 2015

Member

When we build this feature, we could re-use the Open source Data Explorer by Keen IO https://github.com/keen/explorer which provides a nice UI for building Custom Report.

Member

mattab commented Sep 22, 2015

When we build this feature, we could re-use the Open source Data Explorer by Keen IO https://github.com/keen/explorer which provides a nice UI for building Custom Report.

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Nov 3, 2015

Member

see also Custom Dimensions: making Custom Variables more powerful and easier to use #9129

Member

mattab commented Nov 3, 2015

see also Custom Dimensions: making Custom Variables more powerful and easier to use #9129

@mattab mattab modified the milestones: Mid term, Long term Dec 5, 2016

@mattab

This comment has been minimized.

Show comment
Hide comment
@mattab

mattab Dec 29, 2017

Member

Good news: we have now released the Custom Reports feature for Piwik!

Custom reports lets you choose which dimensions and metrics you want to see. You can combine multiple dimensions (up to 3) and as many metrics as you need.
The custom reports can be emailed to your partners or customers, and have their own menu entry in the Piwik report list. You can even setup advanced filters to further customise the reports.

Learn more about the power of Custom Reports in the user guide: https://piwik.org/docs/custom-reports/
or FAQ: https://piwik.org/faq/custom-reports/

This premium plugin can be purchased here: https://plugins.piwik.org/CustomReports

Member

mattab commented Dec 29, 2017

Good news: we have now released the Custom Reports feature for Piwik!

Custom reports lets you choose which dimensions and metrics you want to see. You can combine multiple dimensions (up to 3) and as many metrics as you need.
The custom reports can be emailed to your partners or customers, and have their own menu entry in the Piwik report list. You can even setup advanced filters to further customise the reports.

Learn more about the power of Custom Reports in the user guide: https://piwik.org/docs/custom-reports/
or FAQ: https://piwik.org/faq/custom-reports/

This premium plugin can be purchased here: https://plugins.piwik.org/CustomReports

@mattab mattab removed the Major label Dec 29, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment