Email reports with a CSV file: use friendly column names eg. "Visits" instead of "nb_visits" #17122

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:

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.

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. 😄

@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 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.