For Flat List and Hierarchy reports with 50,000 row limits, you can generate a downloadable CSV file that contains up to 1 million rows of sortable data and over a million rows of unsortable data.
Note: You can enable extended data download on Flat List and Hierarchy Standard reports for your Client ID by contacting Acoustic Support. Extended data download is not available for the following Standard reports: Cross Sold Products reports and the Marketing Channel Acquisition reports (Marketing Top Converter, Marketing Channel Venn, Visitor Stream, and Converter Stream reports). Additionally, extended data download is not available for the Marketing Channel and Marketing Program reports because these reports have no row limit.
Reports with up to 50,000 rows can be exported by selecting the XLSX, PDF, PNG, TABLEAU, and the standard CSV formats. Reports that exceed the 50,000 row threshold can only be exported by selecting the extended CSV report format.
You can choose the extended CSV report file option for any supported Flat List or Hierarchy report, regardless of how many rows are in the report. For example, if you have 30 rows in your report on the UI after applying a filter, 30 rows display in the Digital Analytics UI, while the extended CSV file contains all rows originally available in the report.
The extended CSV report file is available for download for seven days after the report has been generated. After seven days, if you want to obtain the extended CSV file, you must run the report again.
If your report has already been configured and generated without this option, you can edit the report configuration to include the extended CSV option. You must then run the report again.
A Flat List/Hierarchy report displayed in the Digital Analytics interface is limited to 50,000 rows. If your report results contain fewer rows, the extended CSV report file is the same size as the regular CSV report file.To export reports as extended CSV files:
- Enable Extended data download on Standard reports for your Client ID by contacting Acoustic Support.
- Download the extended CSV file by selecting the Export > Extended CSV option from the Actions menu on the Standard report.
Ad hoc reports
- Enable Extended data download on an ad hoc report by selecting the Extended data download option in the Generate Report modal when you generate the report.
- Download the extended CSV file by selecting the Export > Extended CSV from the Actions menu on the report.