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?
Solved
View all instances of an event and it's properties without using the API?
Best answer by Saish Redkar
Hey
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.
+10Hey
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.
Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills
Reply
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.