There are several ways to export data from Analysis Workspace. The method you choose depends on what set of data you want to analyze and who needs to access it.
Exported data can be in the form of copied data, CSV, or PDF. A PDF is typically preferred if you want visualizations included in the file. CSV and copied data is preferred if you simply want plain-text data.
Do either of the following, depending on what format you want to download the project in:
PDF: Select Project > Download PDF.
Choose this option if you want the downloaded file to contain all the displayed (visible) tables and visualizations in the project.
CSV: Select Project > Download CSV.
Choose this option if you want plain-text data.
(Conditional) If you chose to download a PDF, a message is shown after the project is ready to be downloaded. Click Download.
For project downloads, keep in mind:
The right-click option Copy to clipboard lets you quickly copy data from Workspace and paste it in a third-party tool.
You can use the hotkey
Ctrl+C to copy your selection to the clipboard, then use
Ctrl+V to paste it into a third-party tool.
The right-click option Download data as CSV allows you to download a table of data or the data source of any visualization as a CSV.
From the header of any table or visualization, right-click and choose Download data as CSV. This downloads the displayed data in the table or the underlying data source for a visualization as a CSV.
Note: the Map visualization does not support this option.
Within a table, right-click and choose Download selection as CSV. Only the selection is downloaded with this option, as opposed to the full, displayed table.
If you want to analyze more than the visible 400 rows of data in a table, right-click the table header or any row and select Download items as CSV (Dimension name). This option exports up to 50,000 dimension items (based on the table sort) for the selected dimension, with filters and segments applied. If you chose this option from the top of the table, the first dimension in the table will be exported. While no limits are enforced in the freeform table, it is recommended that the Download items option be used in tables with less than 20 columns to ensure optimal performance.
If your dimension exceeds 50,000 items, download the file with different sort metrics applied or apply a filter. For example, sort descending by Visits in one download and then ascending by Visits in a second download. This tip can help you retrieve longer-tail items.
You can multi-task within the project and even navigate to a new Workspace project in the same tab while the download is in progress. The download pauses if you open a new browser tab. The download is canceled if you leave Workspace completely or close the browser tab.
Features of the table will be applied to the downloaded file as follows:
In the example above, Page items are downloaded with the panel segment (New Visitors Customers) and components above (Marketing Channel = Email) applied as filters, and the components below (Mobile Device Type) removed from the downloaded CSV.
As the file downloads, you will see an informational notification with the progress. At any time, you can cancel the download by clicking Cancel download. Closing the toast will not cancel the download.
Once the file completes, you will see a completion notification and the file will download to your browser.
If you request more than one download at a time, you will receive a notification that each additional download will be queued until the prior download completes.
|Why is my downloaded PDF one page?||Workspace does not paginate downloaded PDFs at this time.|
|Can I export more than 50,000 items with the “Download items as CSV” option?||While each download can contain up to 50,000 dimension items, you can change the sort of your table to retrieve longer tail items, or apply a filter to download more specific items.|
|What does Copy visualization do?||Unlike Copy data to clipboard or Copy selection to clipboard, the Copy visualization right-click option is not an export option. It allows you to copy a visualization or panel from one place in Workspace to another. For example, from one panel to another in the same project, or from one project to another project. Intra-linking video|