MixPanel CakePHP Component

Just added a quick MixPanel CakePHP Component to enable serverside event tracking via the new Analytics startup MixPanel.  If you are looking to add real time analyics to your CakePHP app, it doesn’t get any easier than this.

Download at GitHub

  1. Drop the mixpanel.php file into your /app/controllers/components directory.
  2. Add ‘Mixpanel’ to the Components Array in the controller you’d like to use the component in:
    var $components = array('Mixpanel');
  3. Set MixPanel project token:
    $this->Mixpanel->token = "124124121fasdfas1212";
  4. Call event tracker:
    $this->Mixpanel->track("Test Event", 'param1'=>$value1, 'param2'=>$value2);
  5. Head over to your Mixpanel dashboard and watch the realtime magic happen.

Download at GitHub

Before launch day: our analytic stack

The big day has come, and we finally released the Beta version of Viur for a selected few. This post describes what tools we used and how we used them.

Since day one we have a subscription form on the landing page to capture early adopters. This allowed us to have a good user pool to start working as soon as we had something to show. For this we used Mailchimp, which has a generous free tier and allows you to set up email campaigns and track opens and clicks among other things.

In the main site we use two awesome tools:

  • Google Analytics to track specific metrics (like bounce, exit rate,etc…), goals and specific events we trigger (we will talk more about this in a future post).
  • Heap Analytics to know how users interact with our site. Heap allows us to see what each specific user clicks and visits from the moment he enters the site. Setting up Heap is dead simple since it’s all done visually.

To track what users do inside the app we also use the mandatory Google Analytics and Mixpanel. We chose Mixpanel because it has a Java library that we could easily use with our server code and, like Heap, it allows us to know what each user did. It’s a good tool to keep an eye on what’s going on and to know who are your most and less active users, which allows you to engage them differently.

So, with all these analytic tools in place the worst part is to have a bunch of tabs open to control each one individually. That SaaS fragmentation problem is one of the pains we are solving: we allow people to explore, analyse and blend data in just one place. We are supporting Google Analytics and databases for now, but we are about to start integrating with other services like mixpanel and mailchimp. Then at the end of the day we only have to  look at a dashboard like this:

The Pirate Metrics of Eidos on MixPanel

Pirate Metrics ของลูกพี่ Dave McClure ได้กลายเป็นมาตรฐาน metric ของ startup ในปัจจุบันไปแล้ว ผมเดาเอาเองว่าเป็นเพราะมันทำให้เข้าใจภาพใหญ่ได้ง่ายดี อาจจะไม่ใช่สิ่งที่ดีที่สุดสำหรับทุกคน แต่ถ้าคุณจะทำ product อะไรซักตัว ผมว่าเป็นตัวเริ่มของการวัดผลที่ดี

เอาแบบสั้นๆ Pirate Metric นั้นมีเป็นเหมือน Sale Funnel ที่มีด่านอรหันต์ 5 ด่าน คือ ลูกค้ามาเจอเราได้อย่างไร ลูกค้าเจอแล้วเข้ามาใช้ไหม ใช้แล้วกลับมาใช้อีกไหม ลูกค้าจ่ายตังค์เราไหม และ ลูกค้าบอกต่อไหม

[เครดิตภาพจาก david-b]

เข้าใจว่าที่เขาเรียก Pirate Metric เพราะตัวย่อมันคือ AARRR! เหมือนเสียงร้องของโจรสลัด(ฝรั่ง) 

Keep reading

How Does Mixpanel Compare to Google Analytics?

Originally answered on Quora: What does Mixpanel do that Google Analytics is incapable of doing?


I’m answering this question from the perspective of a long time Mixpanel and Google Analytics customer. I use both of them concurrently in the development of a social game and have a fairly good understanding of the strengths and weaknesses of each tool. I’d summarize it this way: Google Analytics is the swiss army knife that can do almost anything (with some effort and a few regular expressions) while Mixpanel is a tool focused on visitor-level event engagement. As with many things in life, however, it’s not that simple. While I’ve used the API from both tools, I’m sharing an opinion based on experience with each of their web-based reporting interfaces. Click the link for my take on what Mixpanel does that Google Analytics can’t.

How Does Mixpanel Compare to Google Analytics?

More Insights, Less Data - a Proposal For Google Analytics (and Others)

At Hipmob we use both Google Analytics and Mixpanel. GA for general traffic stats, and Mixpanel for deep(er) business and user analytics and messaging. Both were unwieldy at first, but we’ve invested in both (more in Mixpanel) and have a good sense of how to use them.

PROBLEMS As a relative data noob, the way I use analytics goes: question pops in head > I search our data > find some answer > make some adjustment based on the answer > return a few weeks later to see the result. The main problem with this is that it’s tough to know what to track in the first place - oftentimes I find that I haven’t really been tracking some important thing.

To solve this, I’ve started reading several blogs - Segment.io, Kissmetrics, Hubspot are 3 examples. Sometimes this helps. More often than not though, the lesson learned is not generalize-able enough for me to assess how I can use it, or they’re stats are orders of magnitude bigger than ours, so our ability to test and come to analogous conclusions is far constrained. I chalk it up to learning lessons I’ll use in the future. Given that my answers are only as good as my questions, I’m in a bit of a bind as I suspect my questions aren’t that good.

At heart, my problem is not knowing what to ask in the first place. I suspect I’m not alone in this. We (all) get so much data that sometimes I see a problem or opportunity too late. To me, a problem or opportunity is any datapoint that varies significantly relative to the average variation in its dataset. For example, I’d like to know anytime a stat I track behaves in a surprising way. For example, if it increases more than 2 standard deviations from its weekly trailing average. Any behavior like this is worth paying attention to.


As your business grows and becomes more complex, the number of things you should watch grows much faster than your ability to pay attention to it. A system that tells you when there’s a surprise in your data would help you spot problems before they blew up, and take advantage of nascent opportunities.

I’m writing this in the hope that someone smarter or more experienced has encountered this problem - I’d love to know how you solved it. My proposal is twofold:

1.Weekly report - a weekly email displaying the top 10 movers across all my data. The biggest changes in terms of % from last week to this week, be they visitors, signups, keywords, conversions, anything that we measure.

Weekly Alert Email

2.Instant Alerts - an email sent anytime a datapoint breaches a preset threshold eg. 2 standard deviations the weekly trailing average. You’d be able to adjust the threshold and mute any particularly volatile stats but this would tell you anything that’s surprising even if it’s not something you initially knew was important.

To start, you’d want to watch your core analytics, but eventually you could apply this approach to everything in your business: changes in customer interaction, logs, etc. The main idea behind this is to have your data telling you when something is happening, rather than forcing you to look. Know something that does this already? Please email me at ayo@hipmob.com

Hacker News Discussion Here

Edit: Found a partial answer to this from Stephane Hamel over at Google+

If you go to “Intelligence Events” on the left panel (3rd down from the top) you’ll be able to create alerts across your entire data stack, sending you messages when your stats breach particular thresholds. Here’s a screenshot