Introducing much better segmentation

The images in this post are out of date.

Segmentation today is even better – properties can be strings, numbers, booleans, dates, or lists

See it in action here: https://mixpanel.com/segmentation/


Today we are announcing a new feature called Segmentation that will enable you to analyze your data retroactively and perform even more complex data analysis then ever before--of course it's all in real-time. This is a huge step towards our overall goal: To help the world learn from its data.

Screen_shot_2011-07-20_at_1

To get to segmentation click on the new segmentation icon on the left hand side where events, retention, funnels and the rest of the icons are.

Segmentation is extremely flexible and therefore it's often tough to describe which problems it may solve because it solves so many. To help introduce this new feature we'll go over some simple use-cases that, hopefully, will excite you.

1. The ability to intersect and drill down on more than one segment.

Ad_campaign

A really simple example is if you have an ad campaign on Facebook and you would like to understand the demographic of users who ultimately purchase. Here we're curious and filter on users who have seen a specific ad campaign that we've created and are only female purchasers. More importantly we are curious to see the age distribution or breakdown of that type of customer.

This is extremely powerful because not only are you seeing deep insights into your data but you're doing it in real-time on potentially a large set of data. It's generally a pain to wait to see the result of a question you have about your data because as marketers or analysts we generally ask our questions iteratively until we have that "Ah ha!" moment.

Keep in mind that Ad Campaign, Gender, and Age are defined by us. You can define any segments you'd like. For example, if you were a social game you could define character type, source, and item purchased instead.

2. Analyze data that is numeric

Friends_invited

Segmentation now accepts any kind of data that may be numerical. If you know the number of invites a user may send during their sign up process to increase virality of your product, you can now see a statistical distribution of that. This is extremely powerful and helps you understand your virality. In general, an average may not be truthful enough.

Other examples of numeric data you can send us: age, page load time, number of items selected in a list, anything with money involved, coins or credits, etc.

We also support true/false values and have plans to support dates soon which will let you ask questions such as "Everyone who signed up after this date."

3. Completely retroactive

If it wasn't already apparent this type of analysis is fully retroactive. You do not need to define any queries/questions up front as we will look back at data you've already sent us and analyze that.

We believe iterative data analysis is what our customers want and is a great way to find insights in your data.

Community Tip : Addiction Best Practices

This Community Tip will illustrate how to interpret Mixpanel’s Addiction Report. We’ll walk through some best practices and methods for using the Addiction report to analyze your users’ behavior with an eye towards actionable insights. Our Retention report shows the portion of your customers or customer cohorts who engage with your application. Mixpanel’s Addiction Report takes it to the next level and analyzes the minimum number of hours or days your users engage with your app. How to interpret an Addiction Report The first column of the Addiction report displays the number of users in the cohort displayed on that row, just like our First Time and Recurring Retention reports. In the screenshot below, it means that 6,054 unique users fired an “App Open” event on February 1st. Each of the buckets (column headings) to the right indicate how many hours in day, days in a week, or day...

Updates to segmentation: See your top events & compare events too

We've made Segmentation a whole lot better, and we're excited to share all the updates we've made: See an overview of your top events We've made it possible to see an overview of the highest volume events that your users take in your app. It can help you see spikes in your data, and it's just a convenient way to get a snapshot of how things are going. Compare trends more easily Comparing two or more different events is now possible, so you can analyze the correlation between events. Just click the compare menu option after picking the first event. Plot your data in logarithmic scale It can often be tough to compare two trends if one event or segment dwarfs another or if your app takes off and creates a big spike in your metrics because the big differences in scale make it hard to see what's going on. With a logarithmic scale, you'll be able to compare and correlate...

Community Tip: Incremental Super Properties

This Community Tip will outline how to create incremental super properties using our JavaScript SDK, so you can keep a tally of how often a user takes specific actions on your site or in your app and then segment any event by count. What Makes A Super Property So Super? Before we dive in to incremental super properties let’s have a quick reminder of what super properties are. Super properties are client-side properties that are automatically attached to every event that a user sends to your Mixpanel project. They make working with Mixpanel data much more convenient because they act as global properties that are omnipresent in all your events (given that the cookie is not cleared). Some examples of information that you may want to attribute to every event are ad campaign, signup date, or paid account type, etc. It’s important to note that super properties are only for events , not...

Making one-time notifications better

Today we launched a major enhancement to our notifications dashboard that will give you more power over your one-time notifications. Previously a one-time notification meant sending a message to the wind. While useful for notifying, they couldn't be edited, cancelled, or analyzed after the fact. No longer - now one-time notifications are at your beck and call: The new notifications dashboard gives you a clear view of what one-time notifications are in flight and allows you to cancel them or even change their contents before they send. You can now view sent, opened, and conversion statistics for one-time and recurring notifications through the same analytics page: Our goal behind these changes is to better unify the notifications product and expand what you can do with it in the process. We give you better tools, you make better things happen. With that in mind, happy notifyi...

Formulas: Calculating with numeric values

When it comes to Mixpanel products, we’re all about constantly making improvements that our users have asked for. Regarding the formulas report, one thing we’ve had numerous requests for is the ability to add numeric values into a formula. Well Mixpanellers, ask and ye shall receive: The most basic and useful application of this is a formula where you would like to see percentage values rather than decimals. In our case, let’s look at a common event and take the number of mobile occurrences divided by total occurrences: As you can see, the x-axis values are calculated as decimals between 0 and 1. In order to transform the values in this chart into percentages, all we have to do is multiply the numerator by 100: And there you have it, a simple addition to formulas that greatly increases their flexibility. For more use cases and ideas, get in touch with our extremel...

How Fleksy Fell In Love With Data By Using Mixpanel

This is a guest blog post by Derek, Fleksy's Head of Product Marketing I have a confession: there was a time when data and I didn’t get along. I’m a brand marketing guy at heart, and my data-related technical skills are limited. Luckily, I have pretty good instincts. For years, I often viewed heavy data-diving as an aggravating drain on my time. Interpreting data? No problem. Manipulating it? Big problem. I would spend hours slicing data on Google Analytics, Flurry or other tools in every way possible, but more often than not I couldn’t find the key insight I really wanted. The only way I could extract meaningful insights was to task a database engineer/analyst to manipulate raw data to fit my needs. If I needed to make a quick decision, I had no choice but to trust my gut. At Fleksy, we’re building the fastest and most fun keyboard app in the world, and we’re iterating rap...

Community Tip: Tracking First-time Users

This community tip outlines how to track the first time a user visits your website or app so you can measure your metrics in terms of new versus existing users. First-Time Users First-time users are defined as any user who arrives at your website or app for the first time - you have never seen this user before. It is important to know who is a first time user versus a returning user in terms of measuring your metrics – How do first-time users convert through sign up? What is first-time versus returning user retention? What traffic source do my first-time users come from? Answering these questions will give you valuable product insight not readily available by looking at all users simultaneously. By measuring first-time users you can get a granular view into what your users are doing when they have never used your website or app before. You may find user experience insights that yo...

Community Tip: Importing People Profiles from other email tools

This Community Tip will outline how to import your external mailing lists into Mixpanel People profiles . Are you a marketing guru that depends on a certain monkey-related e-mail tool or other email marketing service providers? Mixpanel makes it easy to import these users' email addresses, names, unsubscribe status, and other details as People properties into your Mixpanel project. You can then use these details as targeting criteria to group users and send them tailored messages to increase the likelihood of a response or downstream action. Impress your users by demonstrating how well you really know them! Most mailing tools allow you to export your users to a CSV. A little manipulation will optimize this CSV for importing into your Mixpanel project. No code required! 1) Add a $distinct_id column The first property that you will want to consider is $distinct_id . You can ass...

Opening our pitch deck that helped us get our $865M valuation

Today, we're going to open-source the pitch deck that led to our $65M round and the $865M valuation for the company. So many people have helped us either directly or indirectly along our journey that we'd like pay it forward to other startups who aren't sure how to get started as they go out to raise money for the first time. When Tim and I first went to go pitch our company to investors in 2009 (right after the recession hit), we hopped on the Caltrain, rode our bikes down Sand Hill Road, and talked to 10 investors who all categorically told us "No." A few of them even wanted to replace the CEO of our company (we didn't know who would be CEO yet!). At that time, we hadn't quite realized we even needed an official pitch deck. And when we did build a deck, we had no idea how to construct one intelligently. We really struggled. This is not perfect for all companies; you may need so...