How can I use Mixpanel Datasets?

Mixpanel Datasets allow product teams to query and visualize data from external sources quickly.

Without having to export and join any of your data, you can use Mixpanel’s simple interface to get instant answers to your sales, support and product questions. No need to bother your analytics or data science teams and no need to write complicated SQL queries.

Mixpanel offers codeless out-of-the-box Dataset connectors for Salesforce and Zendesk. Advanced users can utilize the datasets API to import custom data if additional information or connections are desired.

Questions that can be answered today in Mixpanel with Salesforce Datasets include:

  • What is the total value of all currently active contracts?
  • What are the common contract durations? Are they changing year over year?
  • Which salespeople have won the most opportunities by dollar value?
  • What percent of opportunities are we winning? Per salesperson?

The Salesforce connector will import the following events into your Salesforce Dataset as soon as you establish a connection: Task created, Task performed, Campaign sent, Opportunity task performed, Opportunity task created, Account task performed, Account task created, Opportunity created, Opportunity closed, Contract created, Contract activated, Contract ended, Contract started.

Questions that can be answered today in Mixpanel with Zendesk Datasets include:

  • How long do different types of support tickets take to be solved?
  • What custom fields are associated with the longest resolution times?
  • Which organizations submit the most tickets per month?
  • What is the average number of replies per ticket? Per agent?

The Zendesk connector will import the following events into your Zendesk dataset: Ticket created, Ticket assigned, Ticket solved, Ticket closed, Ticket reopened.

Related: How do I enable Datasets in Mixpanel?