pirsch-analytics / pirsch

Pirsch is a drop-in, server-side, no-cookie, and privacy-focused analytics solution for Go.
https://pirsch.io
GNU Affero General Public License v3.0
918 stars 42 forks source link

Adding Event metadata to CSV exports #287

Closed romainmenke closed 1 year ago

romainmenke commented 1 year ago

We would like to export Event metadata to CSV for further analysis. Is this already possible and are we overlooking this?

If not yet possible we would very much like to have this feature :)

We understand that this isn't trivial because there is no easy/logical way to convert any meta data to CSV columns.

Kugelschieber commented 1 year ago

Hi Romain, it's not supported by our CSV export yet, but you can take a look at the API:

https://docs.pirsch.io/api-sdks/api#events https://docs.pirsch.io/api-sdks/api#listing-events

We'll take a look, maybe we find a nice way to support it on the export.

romainmenke commented 1 year ago

Good to know that there is a manual way to extract the data when needed 🙇

And thank you for considering this feature request!

Kugelschieber commented 1 year ago

Here is a simple example using curl: https://gist.github.com/Kugelschieber/43876968d3f029d7d5a31c23a6f27b21

Let me know if you need an example for events.

Kugelschieber commented 1 year ago

Closing this. CSV isn't a good format to store hierarchical data. The best option is to use the API and extract what's needed.

We might provide an exporter like this one in the future: https://github.com/pirsch-analytics/export