Mixpanel’s Post

Transcript

Hi everyone. We are in our new office here in San Francisco and super excited to introduce our brand new warehouse connectors. This is Neil Herron's product design support at Mixpanel. This is Alex Coleman, he runs all of design and all the things that you love. And Tiffany has been working hard to bring the warehouse connective story to life with all of our amazing customers. So stay tuned for that. We're super pumped. This is, you know, this year for any of you who made it to MGSV in in San Francisco and London, we've talked about. All excited we are about this amazing milestone and the reason for that is, you know, for years we've been busy trying to bring all of your user stories to life and Mixpanel and answer any questions you have about the user outcomes that you've been trying to drive with your products. And this is a moment where we now get to go beyond the users and see how those things actually impact everything you care about in your business. And so Neil's got this awesome demo to be able to show you just how easy it is to get started And then from there you get to see all the reporting, the self-serve. Politics you've come to love, and Mixpanel you can now use to get value from all the data you have stored in your data warehouse. So can't wait for you to check it out. If you'd love it, please let us know. We'd love for Tiffany to capture more of the amazing stories that comes out of your use cases. Alright, you know, take it, take it away. The power of this release is that it lets you use Mixpanel to make strategic decisions and focus your team on business outcomes in addition to the user decisions and user outcomes that you already use mixed panel for. It works by bringing your business data that's in your warehouse into mixed panel to use alongside your track events. And there's some key benefits. So first of all, it's really quick to get set up because you're using data that you already have. The second thing is that you can really trust this data because it's coming from these systems of record and it's the data that's being managed by your data team in your warehouse and being unified and cleaned up and governed. And really critical aspect of this release is a feature called mirror mode. A mirror mode keeps mix panel perfectly In Sync with your warehouse data. Even updates and deletes that happen to this data are instantly reflected into Mixpanel. It lets you bring together. Or product data, the tracked events of usage in your product, how your users are interacting with it together with your business data and events like sales opportunities, support, ticket revenue, costs. So that you can start to see how the changes that you're making to your product are not just affecting your users engagement with the product, but broaden your view to how is that then impacting your business. So let's jump in and see just how easy it is to get set up in use. So what you do is point it at a warehouse and then point it at tables that are modeled into events or dimensions that you want to use in mixed panel. And you can see here that we will show you both the sort of purple is the mix panel, the events that are mixed panel, and the lava color here is your warehouse data. And they're perfectly In Sync. And they'll stay that way because of mirror mode once you have the data in. You can start using mixed panel and use the events from your warehouse just like any other events that mix panel. So you can use one of our templates. In in a few clicks, in a few seconds you can take. Events that you just loaded from your warehouse, this might be sign ups based on the transactional data and your your users table and your application database. And then maybe a value event like completed a purchase that comes from your payment system. And just like that, you've got advanced product analytics conversion retention. Yeah, in just in just a few seconds based on that, based on that data. So now let's go into some like ad hoc type questions that you might want to answer using next panel. So first of all. Imagine that you have a high level of support tickets and you're trying to reduce those by shipping a new tutorials feature. So. In the past, the engagement with your tutorials would be tracked in in Mixpanel and but your support tickets would be in a different system and in in in your warehouse. And if you wanted to stitch those two data sets together and answer that question, you would have to ask someone on your data team and they would have to wrangle the data and write some complex SQL queries. Whereas now because it's IMAX panel, you can just go and look at, OK, let's look at watch tutorial, let's look at. Support tickets. OK, And you can see right off the bat here, OK, as people started watching these tutorials support tickets to come down, you can even do advanced kind of behavioral correlation that would be, you know, really cumbersome, you know, window functions and things like that in SQL. So let's let's do a breakdown here. Where we can look at support tickets submitted by people broken down by. How how many tutorials they've watched? OK, so now you can see that. People who have not watched any tutorials zero times, they're still submitting a lot of support tickets, but people have even watched just one tutorial, submitting far fewer support tickets and and so on. As people watch more tutorials, they're spinning less tickets. So instead of having to go and do a lot of time consuming data analysis in your warehouse, you can answer these questions really, really quickly in Mixpanel. It's a great example of how you can see the impact beyond just product, but also on your support team. Let's look at an even more advanced use case. So. Imagine that you have tried a free returns promotion and you're wondering if that's driving more purchases. So you could set that up using your purchases data that you captured as events in your clickstream data in the app. The issue with that is it won't include things like refunds, cancellations, fraudulent transactions. And so you can see here the adjusted purchases in the warehouse that have been adjusted to account for all of those things. And this is where product analytics can diverge. Retract event stream data can diverge from your company source of truth data. And the issue with that is what what can happen is you would then go and look at here's the lift based on your event stream data and here's the lift based on the adjusted data. And so you might say that. That that feature had an 80% lift, but then your data team would run the analysis, say actually it was a 40% lift and you would have trust issues and now you won't. So that is just a quick run through of the types of things that you can do once you bring your product and business data together in mix panel. And we're super excited to show you more and also start loading customer data and getting into answering all the questions. That that you have. So if you schedule a call with us and bring someone who has access to your warehouse, we will get you up and running in 30 minutes and we're really excited to to do that. Thanks a lot. Alright, well there you have it. It is really that easy to get started in 30 minutes if you get stuck, have any problems. It's Neil at Mixpanel. You love it. I'm Amir at Mixpanel and would love nothing more than to share your stories. We can't wait to get your feedback. We have a lot of exciting stuff coming up in the next month. To show you just how much more you're gonna be able to get value out of all the data you bring into mixed panel. Thank you so much for watching and enjoy your analysis.