Hi Mixpanel Community,
I have a regular requirement from Mixpanel users in my company : They would like to export and update Mixpanel data in Excel. They use excel dashboards where they gather multiple sources of data (and among them mixpanel) and what I provided to them for the moment is a list of multiple reports they have to "csv export" every week to update their excel dashboard, with a lot of copy/paste and manual work.
It's quite time consuming and I'm looking for some way to automate the process as much as possible. Does anyone know a way to export / update multiple mixpanel reports in an Excel file ? Like a plugin or a way to call the API directly in excel ? Or a way to directly export a dashboard from mixpanel ?
Best answer by michaelsuiter
for instance, i would have an excel doc called "dashboards" that would built visualizations from a data set that has a pathway to a different excel doc called "mixpanel_data". then you could use this cron job script idea from
does this make sense? if this works could make it a pretty automated process