Table of Contents
Questions
- Can I export the raw event data for the events included in this chart instead of the chart results?
- How do I export a CSV of all occurrences of a specific event?
- How do I see the data that was pulled into this chart?
- Can I see event and user property values for every instance of this event in the last 30 days?
Answer
There is currently no way to export selected raw data for a chart or all data for selected events. Amplitude was built to perform large scale, complex analyses in app and because of this, being able to isolate and export event data in a SQL-like manner is not supported.
Alternatives
Export API
To export all values of an event and its event properties, you can export them via our Export API. This API will export all events across a certain time range and return them in JSON format. Once exported, there would need to be further work to extract the values of the specific events you're looking for.
If your data exceeds the size limitation of the Export API, consider using the self-service Amazon S3 Export option instead. See below for more details.
Query Add-on: Amplitude SQL / Snowflake ETL
There is an Amplitude SQL add-on where you could perform SQL-like queries in an Amplitude maintained Snowflake instance. For customers that have an existing relationship with Snowflake, Amplitude can also share data from an Amplitude-managed Snowflake account to a customer-managed Snowflake account. This add-on is only available for Growth and Enterprise accounts and would require an additional purchase on top of a paid plan.
Amazon S3 Export
Scholarship, Growth, and Enterprise accounts can export their data to Amazon S3. The Amazon S3 data destination allows teams to export their Amplitude data to an Amazon S3 bucket. This also enables users to analyze their Amplitude data alongside other organization sources of data that users might not have within Amplitude.