Before Mixpanel can even attempt to solve that though, they first need to tackle multi-channel attribution. Right now GA and Adobe are the big players who tackle it, and GA only offers dynamic attribution (ie. the holy grail of attribution) in GA Premium (which costs $150k/yr).
If you want a standalone attribution platform you're left with options like VisualIQ, Convertro, Adometry, etc., all of which have recently been acquired by big players in the space.
So yes, I'd love to see Mixpanel answer the "why." However the first step is to truly answer the "where" question and until they add those tools, their model is still fully last touch, and therefore dated.
Of course even GA doesn't use its attribution modeling capabilities outside of the multi-channel/attribution reports, so they still have a ways to go too. The big difference is, those tools are available today for free.
That said, congrats to Mixpanel. They made huge strides in the event tracking approach that GA has since gone on to borrow, and that is what any modern web analytics platform looks at these days because it simply makes more sense.
They've got an elegant and, as far as I know, unique modeling approach that avoids the first-touch/last-touch/path-analysis pitfalls.
Also, would I need an ad server in place to properly attribute display or can they handle that on their own?
It's a unique approach in that they don't need a lot of granular attribution data, but instead use higher level aggregate data. As a result it's easier to integrate with all kinds of media campaigns.
You need to be able to provide impressions over time for your early funnel ads and conversions over time for your late funnel touchpoints. They use some econometric time series techniques to analyze and estimate the impact so you can focus on whats working.
GA's attribution tools are fun to play with, but at the end of the day they are still static models that don't evolve over time as they collect data.
They have these flows that chart the user's path through your site, so you can see where, when and why they dropped off where and when they did.
These are questions for the business, but I feel like Mixpanel could add so much more context. "We noticed that 'time to first interaction' has gone down with 'watched home page video'." That would at least be a clue.
MP has the data, but all of that analysis is manual (or was, last time I used it).