The results of running the SQL query (and the optional R script) can be downloaded any time as CSV or Excel file for further analysis in other tools or archival:
To download the results as CSV use the "Download CSV" function from the report drop down menu or from the results section in the query editor.
From the Report editor:
Note: The CSV always contains the "raw" tabular data that are the result of the query execution. Note that the subsequent visualisation step may further process / interpret the data (such as the use of 'Cumulative' on y axis series of line/bar charts), so to achieve the same results on the raw data in e.g. Excel, some further calculations/processing may be necessary.
Downloading Unlimited CSV
On the Pro and Business plans, you can also enable the options to download "Unlimited" CSV. The results are not limited, as usual to the 5000/10000 rows, but only in the size of the resulting CSV - 250MB on the Pro plan and 2GB on the Business plan.
The number of rows in the resulting file is:
- Only limited by the file size, in case there is no LIMIT clause in the report query
- Limited by the explicit LIMIT clause in the query, if present - e.g. LIMIT 500000 would result in 500000 rows to be in the output (unless this would exceed the file size limit)
This is optional function per-report, and can be turned on for any specific report via this option in the Advanced tab of the Report settings (open via the gear icon in the report editor top-right corner):
Which then reveals a new option in the dropdown of that report:
That allows to generate and download the complete CSV: