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

Transitions reports: export full data as XML/JSON #6032

Closed
MortenGalaxy opened this issue Aug 20, 2014 · 20 comments · Fixed by #18062
Closed

Transitions reports: export full data as XML/JSON #6032

MortenGalaxy opened this issue Aug 20, 2014 · 20 comments · Fixed by #18062
Assignees
Labels
c: Usability For issues that let users achieve a defined goal more effectively or efficiently. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone

Comments

@MortenGalaxy
Copy link

Today it's not possible to export data from the transitions map. An export to csv/excel would make sense.

@mattab mattab added this to the Short term milestone Aug 20, 2014
@GKinMD
Copy link

GKinMD commented Sep 5, 2014

This would be an excellent feature. I know this report is particularly important to one of my customers.

@gaumondp
Copy link

Export is good but "printing" is also an issue because of the "popover".

Would it make sense to also have a print function for those popover in general ?

@mattab
Copy link
Member

mattab commented Sep 18, 2014

@gaumondp absolutely, that's a very sensible idea. can you create an issue? A generic "Print" button on hover on the top bar eg. would be great (or simply when printing via browser). Maybe a custom print css?

@gaumondp
Copy link

Request #6248 added : "Make all Transitions or Row Evolutions popovers printable"

@mattab mattab changed the title Export transitions data Transitions: show links to API data exports of transitions data Oct 12, 2014
@mattab mattab added c: Usability For issues that let users achieve a defined goal more effectively or efficiently. and removed c: UI - UX (AngularJS twig less) labels Oct 12, 2014
@chriscollingridge
Copy link

It would also be useful (either in the UI or in an export) to see the full list of pages, rather than having only the top 5 pages before/after this page and everything else grouped in "Other".

@mattab mattab added the Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. label Apr 9, 2015
@mattab mattab modified the milestones: Mid term, Short term Apr 9, 2015
@Keelymim
Copy link

i really need this

@muehlburger
Copy link

I would also really need to export transitions!

@mattab mattab added duplicate For issues that already existed in our issue tracker and were reported previously. and removed Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. labels Dec 5, 2016
@mattab mattab modified the milestones: Long term, Mid term Dec 5, 2016
@mattab mattab removed the duplicate For issues that already existed in our issue tracker and were reported previously. label Dec 5, 2016
@mattab
Copy link
Member

mattab commented Mar 28, 2017

I reckon this is super important. One of the last places in Piwik which cannot be easily exported from the UI by one click is Transitions report.

When exporting transitions data we should export more than the 5 per group being displayed. By default maybe we could export 50 per group? (usually users need to export and see as much of the data as possible).

Be great if the export button can open the standard export data popover (which also shows the API export URL).

@mattab mattab removed this from the Backlog (Help wanted) milestone Mar 28, 2017
@mattab mattab added this to the Priority Backlog (Help wanted) milestone May 8, 2017
@mattab mattab changed the title Transitions: show links to API data exports of transitions data Transitions reports: export full data as CSV/JSON/etc Apr 12, 2019
@mattab mattab added the Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. label Apr 12, 2019
@mattab mattab removed this from the Priority Backlog (Help wanted) milestone Apr 12, 2019
@mattab mattab added this to the 3.13.0 milestone Apr 12, 2019
@mattab mattab modified the milestones: 4.1.0, 4.2.0 Oct 21, 2019
@samajammin
Copy link

Hey folks - any update on this? It's nearly 6 years later 😬

@mattab
Copy link
Member

mattab commented Oct 27, 2020

We get this question all the time, again today. @samajammin It's currently scheduled meaning we'll likely work on it in the next 6-9 months

@squidjam
Copy link

squidjam commented Sep 7, 2021

It's been almost a year now since the last message, any updates on this?

@Findus23
Copy link
Member

Findus23 commented Sep 7, 2021

I'm not up to date with this issue, but what exactly is the issue with the existing transitions API:

https://demo.matomo.cloud/index.php?module=API&action=listAllAPI&idSite=1&period=day&date=yesterday#Transitions

This should allow you to get all data you see in the transitions report as JSON.

https://demo.matomo.cloud/index.php?module=API&method=Transitions.getTransitionsForPageUrl&pageUrl=https://divezone.net/&idSite=1&period=day&date=yesterday&format=JSON&token_auth=anonymous

The only thing missing is CSV support, but that seems impossible as the data is not two-dimensional.

@squidjam
Copy link

squidjam commented Sep 7, 2021

It's on your documentation links, though.
https://developer.matomo.org/api-reference/reporting-api#Live

Also, it could be flattened, no?

@Findus23
Copy link
Member

Findus23 commented Sep 7, 2021

The documentation shows the same thing:
https://developer.matomo.org/api-reference/reporting-api#Transitions
(in fact it fetches it's data from a running Matomo instance)

But I'm not sure if there is one way it could be flattened. After all the JSON contains multiple different datasets, so the result would be multiple tables which aren't really easily displayed in a CSV.

@bx80 bx80 self-assigned this Sep 22, 2021
@tsteur
Copy link
Member

tsteur commented Sep 23, 2021

fyi @bx80 you might have seen there is also a what we call "row action" for transitions when you hover a page url:

image

It may not be trivial to load the visualisation there if we go with that and we could not add the export feature there for now in the popover if it gets too complicated. We could always have a different issue for that one. Where we definitely want it to work is the dedicated "Transitions" report.

@bx80 bx80 mentioned this issue Sep 26, 2021
11 tasks
@Chardonneaur
Copy link

Hi guys,
the title of the ticket indicates that the transition report will include a CSV export. I may be wrong but so far it is XML and JSON. Would it be possible to change the title of the support ticket?

@justinvelluppillai justinvelluppillai changed the title Transitions reports: export full data as CSV/JSON/etc Transitions reports: export full data as XML/JSON Oct 27, 2021
@niklasternstedt
Copy link

Can I in some way see which data is clustered as "others"?

@bx80
Copy link
Contributor

bx80 commented Mar 28, 2022

@niklasternstedt Thanks for asking, unfortunately data grouping is done by the database query so the items that make up the "others" group are not available to the visualization or export. It's outside the scope of this issue to change that, but do feel free to create a feature request 👍

Not sure if this is helpful to you, but the transitions API does support a parameter called limitBeforeGrouping which normally defaults to showing five transitions before grouping the rest as "others". If an API call was made with this parameter value set higher than the total amount of transitions then all transitions would be returned.
https://developer.matomo.org/api-reference/reporting-api#Transitions

@goochj03
Copy link

Had a customer asking about seeing the 'Others' row in transitions today "Is it possible where I can get the complete list of the "Others" in e.g., 'transitions' in the section "From internal pages". An export option would be handy but the API option above has worked as a solution.

@mattab
Copy link
Member

mattab commented Dec 14, 2023

Note the follow up issue that is opened is here: #18607

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
c: Usability For issues that let users achieve a defined goal more effectively or efficiently. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Development

Successfully merging a pull request may close this issue.