Building a query with Signal

Signal can be found under the Engagement Reports in your Mixpanel project.

By default, Mixpanel will build a query to show how your top 50 (defined by event volume) events correlate with 2nd week retention in the last quarter for new users. This translates to, “How do my top events correlate with two week retention in the last quarter for new users?”

alt text

To write a new query with Signal, start by selecting which Events you would like to evaluate by choosing from the “Show Me How” dropdown.

Next, determine what your Goal Event will be. Your Goal Event can be a specific event with a frequency (users did Goal Event at least x number of times or exactly the number of times) or one of the retention events that Mixpanel provides. These events are:

  • 2nd week retention: Users doing a specific action or set of actions in your project and then returning to do anything within 2 weeks.

  • 3rd week retention: Users doing a specific action or set of actions in your project and then returning to do anything within 3 weeks.

  • 4th week retention: Users doing a specific action or set of actions in your project and then returning to do anything within 4 weeks.

  • 2nd month retention: Users doing a specific action or set of actions in your project and then returning to do anything within 2 months.

Finally, determine your time frame (minimum 60 days) for your query and the users that you would like to evaluate. It’s important to select a long enough timeframe that allows users to complete both the Event(s) you choose to evaluate as well as the Goal Event. It’s important to note that larger date ranges provide more data and thus more accurate correlations.

The time to convert, or how long a user has to convert to the goal event, will default to 30 days unless you have selected one of the retention events.

Choosing users is an important step as it will allow you to determine the type of users you will look at in your cohort. Mixpanel allows you to define your cohort by giving you the option of looking at “New Users” or “Any Users” and then filtering on an specific event frequency.

“New Users” are users who have completed their first event in your selected time frame. “Any Users” will look at any users in your Mixpanel project who have completed the event in your defined timeframe.

Let’s say you have a music streaming service and want to see how new users buying a song correlates with two month retention. You would select “Buy song” for the first event drop down, second month retention as your Goal Event and set your cohort to new users.

alt text