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, please contact your Customer Success Manager to learn more about an Amazon S3 export solution. This S3 solution is only available for Growth and Enterprise accounts.
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.