@mattab opened this Issue on July 2nd 2018 Member

Note: this issue may be automatically fixed once we solve: #12199 but not necessarily, so I'm opening a separate issue here.

To reproduce:

  • Open Acquisition > Search engines"
  • Below the "Search Engines" report, click "Export"
  • Click "Expand subtables"
  • Select format TSV or CSV

Got a file that looks like this:


Label | Visits | Actions | Maximum actions in one visit | Total time spent by visitors (in seconds) | Bounces
-- | -- | -- | -- | -- | --
Google | 14766 | 804764 | 27899 | 5104896 | 10005
Bing | 325 | 70127 | 28705 | 270106 | 201
Yahoo! | 195 | 6473 | 3567 | 54353 | 127
DuckDuckGo | 69 | 4012 | 1894 | 26083 | 43

Note:

  • This issue was also reported for a Custom Report. Exporting custom reports to CSV basically miss out on all the sub-dimension columns.
  • It may be the best solution to make "Expand subtables" the same behavior as "Flatten" for exported reports, where each dimension would be its own column: this should be addressed in #12199

For example an expected, instead an output that contains also all keywords, for each search engine, for example like this:


Label | Search Keyword | Visits | Actions | Maximum actions in one visit | Total time spent by visitors (in seconds) | Bounces
-- | -- | -- | -- | -- | --
Google | - | 14766 | 804764 | 27899 | 5104896 | 10005
Google | KWD1 | 100 | 804764 | 27899 | 5104896 | 10005
Google | KWD2 | 80 | 804764 | 27899 | 5104896 | 10005
Bing | - | 325 | 70127 | 28705 | 270106 | 201
Bing | KWD1 | 50 | 70127 | 28705 | 270106 | 201
Bing | KWD2 | 70 | 70127 | 28705 | 270106 | 201
Powered by GitHub Issue Mirror