View all instances of an event and it's properties without using the API?

Hey all, we’re trying to figure out the best way to access all instances of an event and its properties. We can currently see the values in a dropdown list and select them, but we that’s the only way we seem to have access to the data. Is there another view that I’m missing or a way to export this data as a CSV so we can manage it elsewhere?

Find more posts tagged with

Event

Accepted answers

Saish Redkar

Hey aptlt

Afaik, we can only extract all the events and their associated properties using Govern or Taxonomy API and not the values for each of the properties. I had submitted a feature request on similar lines here.

The crude and painful way will be to chart out each event and group by the associated properties and then export the csv.

Another approach is exporting ( 1, 2 ) all your project event data to a warehouse and then running a custom SQL query to get the distinct values of your event properties.

Let me know if I have interpreted your use case correctly. Hope this helps.

All comments

Saish Redkar

Hey aptlt

The crude and painful way will be to chart out each event and group by the associated properties and then export the csv.

Another approach is exporting ( 1, 2 ) all your project event data to a warehouse and then running a custom SQL query to get the distinct values of your event properties.

Let me know if I have interpreted your use case correctly. Hope this helps.

Quick Links

Unanswered Questions

Import data from one amplitude account to another
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
@amplitude/plugin-web-vitals-browser build fails on CRA v4 (react-scripts@4.0.3)
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Question about Amplitude Export API Data Delay
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Retrieve via the API users based on a user property
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!
400 Status Code Error When Loading "Page Viewed: Cart" Data
Hi, I’m trying to create a chart in Amplitude using the Page Viewed: Cart event, measured as Uniques, over the past 7 days. However, I keep getting this error on the graph: "An error occurred while loading your data. (400 status code)" Other events seem to load fine, so it looks specific to this event or configuration. Has…