search

matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.67k stars 2.62k forks source link

A new RAW Data export format that is Flat and has one row for each action: one row for each page view, each goal conversion... #22531

Open Chardonneaur opened 3 weeks ago

Chardonneaur commented 3 weeks ago

Hi team,

Currently if we take the visit log report, actions and orders are arrays. As a result, it is impossible to create custom reports without coding. The idea would be to have an option in order to make this report flat so that each action and each item become a single row for each.

sgiehl commented 3 weeks ago

But would it be helpful if you have tons of entries like <action1>, <action2>,.... or <order1>, <order2>,.... The available entries would then differ from record to record, which might not be more usable than now. 🤔

Chardonneaur commented 3 weeks ago

@sgiehl visually, it will looks like this https://youtu.be/q1PEiJT1qOE and solve big problems for data analysts.

mattab commented 2 weeks ago

@Chardonneaur i've just renamed the issue. Hopefully your intent is captured in this new title?

Chardonneaur commented 2 weeks ago

@mattab yes, as far as all the data are getting displayed in a flat format, i am fine with it. This simple change will significantly increase the user experience.

Chardonneaur commented 2 weeks ago

@mattab closing this ticket is a big thing, because typically for Google Looker Studio end users, it allows them to get exactly what they want.