Does anyone aware of using RMixpanel
library, if yes. How can we export mixpanel data using this library and export it into csv or xlsx format.
It would be great if any author or maintainer of this library can guide us through all functions of this useful library using small-small examples.
Mixpanel can export both events and user data. The event data that is exported using the schematized export pipeline is the same data exported from the Raw Data Export API. The user data that is exported using the schematized export pipeline is the same data exported from the Query API Engage Endpoint.
To export the event data, you can use Mixpanel's export API (https://developer.mixpanel.com/docs/exporting-raw-data#section-export-api-reference). You can export all events connected to a user by passing their distinct_id as part of the “where” parameter.
Export data to a text file by saving itGo to File > Save As. Click Browse. In the Save As dialog box, under Save as type box, choose the text file format for the worksheet; for example, click Text (Tab delimited) or CSV (Comma delimited).
To download Insights, Funnels, and Retention reports, click the "..." icon on the upper right corner of each report.
The function profilesJson2RMatrix
provides a method for converting JSON to R matrix. You can then write the the object using write.csv
function.
Checkout the github page for a working example of using this page: https://github.com/ploner/RMixpanel
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With