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
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 filters 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 filter (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.
If the Enforce Download data governance policy is turned on in the data view you are reporting on, any download (such as emailing or sharing pdfs) of Workspace projects will hash the data fields labeled as sensitive. You can still do analysis on these fields in Workspace, but if you try to email or otherwise share a project, the blocked fields will appear as empty in the .pdf or .csv file.
|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|