@mattab opened this Issue on January 20th 2021 Member

When creating an email report in the "CSV" format,
the CSV file uses "raw" column names, like this:

Visits Summary
nb_uniq_visitors,nb_visits,nb_actions,max_actions,nb_actions_per_visit,avg_time_on_site,bounce_rate
8068,8146,21495,291,2.6,00:03:23,60%

Here is the top of the CSV file:

Screenshot from 2021-01-26 12-37-29

Maybe it would be easier for most people If we added translateColumnNames=1 to the CSV report generator request,
so that the output would go to the more friendly format eg:

Visits Summary
Label,Unique visitors,Visits,Actions,Users,Maximum actions in one visit,Total time spent by visitors (in seconds),Bounces,Visits with Conversions 
Germany,1781,1788,4850,0,66,409926,1032,709,613,613

also it seems that even when downloading any report in Matomo it also sets translateColumnNames=1? (I've been trying but can't find a way to generate the CSV report with "raw" columns from the "Export this data" icon below reports. ). So doing this for email reports as well would maybe make it overall more consistent.

@hamburnyog commented on January 27th 2021

Hi, I would love to take a stab at this issue. I am learning how to contribute to open source and this looks like an amazing learning opportunity! Please let me know how can I start. 😄

@sgiehl commented on January 27th 2021 Member

@hamburnyog Happy to hear you want to contribute. How familiar are you with Matomo already?
The issue is about email reports, so the correct plugin to start would be the ScheduledReports plugin.
The reports are generated in the API, so guess that needs to be adjusted somehow. See https://github.com/matomo-org/matomo/blob/4.x-dev/plugins/ScheduledReports/API.php#L317

@hamburnyog commented on January 28th 2021

@hamburnyog Happy to hear you want to contribute. How familiar are you with Matomo already?
The issue is about email reports, so the correct plugin to start would be the ScheduledReports plugin.
The reports are generated in the API, so guess that needs to be adjusted somehow. See https://github.com/matomo-org/matomo/blob/4.x-dev/plugins/ScheduledReports/API.php#L317

TBH, I just found out about matomo but I did similar reporting tasks before. Thanks for this response, gonna read this.

Powered by GitHub Issue Mirror