How to export a report with all columns formatted correctly?

Support & Bugs
1

Hi all,

I’m in the Acquisition / Campaigns standard report page. I’m trying to export my Campaign Names report (using the icon at the bottom of the table). However when I do this, no matter what options I select, all the data is in the first column and not correctly assigned across columns. Does anyone know what settings I need to adjust for this to export in a format I can use?

Thank you,

2

Hi @khanson
What is your version of Matomo?
How did you configure your export?
On my device, I had to select TSV instead of CSV for my spread sheet to understand well the generated file:

image
image1050×373 7.42 KB

From:

Downloaded file:
https://demo.matomo.cloud/index.php?module=API&format=TSV&idSite=1&period=day&date=2023-04-04&method=MarketingCampaignsReporting.getName&expanded=1&translateColumnNames=1&language=en&token_auth=anonymous&force_api_session=1&filter_limit=10

3

I’ll give TSV a go and report back, thank you.