I wanted to share what I'm currently working on for work in the hopes that it might be useful for someone. I just started at a new company a couple of months ago and after going through my onboarding I realised a lot of work can be done more efficient if we implement Mixpanel across our different platforms. After a month or so we managed to create a pretty good data structure with events and properties for our most important metrics and some nice-to-have details for funnels, segmentations and measuring campaign performance in relation to retention & engagement metrics.
Of course, now I need to share this data with my team which is around the globe and working in different markets. So judging by what other systems they use I decided to use Geckoboard due to it's integrations, UI and "feel". Cyfe was cheaper, but damn it's ugly and it caused me too many frustrations...
Every dashboard is different because every company is different, makes sense, right? We wanted to display our core metrics and establish projections for the whole month and display how close we are to reaching our goals.
This is easier said then done, and ofcourse we need to find some workarounds to achieve this.
Due to Mixpanel being fully integrated, it was easy to grab and display the events I wanted with the proper segmentation. What was a bit harder is to see how can we put this number into perspective and motivate people to reach their goals.
Most of the custom widget magic happens in spreadsheets, so I tried to import the data from Mixpanel first into GoogleSpreadsheets and have it updated automatically. After some awkward failed attempts I stumbled on Melissa's js script and it's saved my ass.
Grab Segmentation Data from Mixpanel and dump in Spreadsheets: https://github.com/melissaguyre/mixpanel-segmentation-google-spreadsheets
This allows you to:
- grab data for any event and property
- trigger running the code daily or even every minute
- stop manually import/export stuff all the time
I've mentioned that we need to include projections as well. The projections are calculated by establishing an daily average in the current month and multiplying by the number of days in the current month. Some formulas really came in handy for this:
Get today's date
day in this month:
days remaining this month (not including today):
H3=EOMONTH( TODAY() , 0) - TODAY()
days past including today
The result is something like this:
Next on the to-do list, is to get the result of a formula into the dashboard...