There are several different ways you can export data from Analysis Workspace, depending on what set of data you want to analyze outside of the tool and who needs to receive the information. Exported data can be in the form of copied data, CSV or PDF files. A PDF is typically preferred if you want visualizations included in the file, while a CSV (or copied data) is preferred if you simply want plain-text data.
You can download a full project by going to Project > Download as PDF (or as CSV). The downloaded file contains all of the displayed (visible) tables and visualizations in the project. A PDF is typically preferred if you want visualizations included in the file, while a CSV is preferred if you simply want plain-text data.
For project downloads, keep in mind:
The right-click option Copy to clipboard lets you quickly copy data from Workspace and paste it elsewhere.
Additionally, the hotkey Ctrl+C
copies your selection to the clipboard. Once copied, you can go into another tool and paste the information (or hit Ctrl+V
).
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.
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 will export 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 will pause if you open a new browser tab. The download will cancel 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.
Question | Answer |
---|---|
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? | Copy visualization 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 |