Are you using Data Pipelines, Zapier, APIs, etc to pull your data out of Mixpanel? Ask here!
Mixpanel's Data Pipelines team works with all kinds of users to supply event and user data to various warehouse and storage platforms. Through these conversations, we've seen a set of common questions ranging topics like timestamps, data transformations, and warehouse behaviors. This article highlig...
Every week, we will release tips to help you get the most out of Mixpanel. Want to see more? Click here to see other #mpknowledgedrop articles. A few weeks ago my colleague Cherise asked for help pulling a list of all her annotations in Mixpanel’s internal Mixpanel project. After working on thi...
Every week, we will release tips to help you get the most out of Mixpanel. Want to see more? Click here to see other #mpknowledgedrop articles. Have you heard about our integrations? Well guess what, in Mixpanel you can sync your Cohorts with Facebook Ads or Google Ads, and Iterable for powerful t...
Every week, we will release tips to help you get the most out of Mixpanel. Want to see more? Click here to see other #mpknowledgedrop articles. To get started, the not so great news is that cohorts are not supported directly in JQL. The parameter "filter_by_cohort" is an option available on our...
I know we can customize the columns we see, but there’s a default set of columns that appear when I use Explore and I have to change them up each time. Is there any way to change the defaults?
Hello, I was able to create data pipelines via the API. Everything worked, so I canceled them in order to set up new ones with a slightly different configuration. Now, when I try to set up the pipeline, I receive the following error:$ curl https://data.mixpanel.com/api/2.0/nessie/pipeline/create \-u...
Through our MixPanel implementation, I’m able to go in and see which model drone people are using when they fly with our software. I also found a way to export a snapshot of THAT day. However, I want to see that report broken down by day for the past 30 or 90 days so I can generate a “racing bar ch...
How would I use regex/custom fields to extract only the hour portion of a date value?So for example if I want to group by the 9am, 10am hours rather than Mixpanel’s default behavior with the ‘hour’ selector of grouping by hour AND day, how would I do this?Thanks in advance
I am using JQL to build a report and I am receiving event names not as shown in the mixpanel dashboard but in raw format. Is it possible to get the display names instead of original event names?
Hi, How can I completely uninstall the unity package from a project. A tried to delete everything related to mixpanel but when I try to start the project again, Unity gets stuck on Script Compile. Best,
I am currently running an LMS on Thinkific. One of the concerns we have is a user sharing their account. On Thinkific’s FAQ page, it says: “You can also use our Mixpanel integration for monitoring student activity. This integration makes login sharing even easier to spot. You'll be able to see wheth...
I have setup a trial data pipeline to push our data into an AWS Redshift DWH. It would be great to hear some use cases from the community where they are seeing real value in doing this. The cost of running the DWH could add up fast - so, interested to see examples where they add this data to other d...
Hello, I have integrated my Mixpanel and google ads account - but when I export my cohort the users show as 0 and then I receive this whitelist message below (picture attached) anyone had similar problems?
Hey there, I’m having some issues counting different types of events within one JQL query. My goal is to have an output with a bunch of columns with the user properties (email, country etc) concatenated with columns counting the total number of specific events each user did. It seems to mostly work...
As an example- can the below event (User shared) be connected to the specific user_properties of that user-group so that I can double-click the last stage of the funnel to see all the user_properties of the users who reached the end of funnel?
I would like to: Add custom property. Get value of that property using REST API. How can I do this?
Hi everyone, I am trying to automate a weekly export to CSV using integromat. First step is trying to verify the data using postman. It is a relatively simple report. Basically user logins for a specific org broken down by email id. When I test using postman, im not sure how I would add the fil...
I am trying to use JQl to get a breakdown of how much our users use our feature x number of months since the first started using it. What I’ve gotten so far: let month = '0'; function main() { return Events({ from_date: "2015-06-06", to_date: "2020-07-06", }) .groupByUser(function(sta...
Hi there! I want to add a filter to my JQL query below, to pull only users where the Frist_seen property is undefined. So far it looks like I’m getting all users, event when the property has a value (a timestamp). Can anyone help me see what need to fix? Thanks! function main() { /...
We are looking to make an API call to poll a cohorts feature (Meeting certain property and event conditions) and retrieve a list of user IDs in real time. Our aim is to use those user IDs for our internal messaging service. Is this use case possible? Amplitude (who we are with currently),...
I am hitting a brick wall here with trying to return one record with event count per user, per day, per event name. I can successfully return one record with event count per user per day, but I cannot get it to add in the grouping level for the event name property, it just returns a null value. He...
Hi I would like to sync aggregate data (filtered by “last 30 days” or “Current Month to date” to Salesforce. Besides Zapier has anyone successfully done this? Use case: I track number of searches made in our platform per user or if I track number of logins per user. How can I inject this information...
Hi! Our team wants to connect to Mixpanel and download all users data. We receive full data per each user, and it is ok, but Mixpanel didn't let us to download all users, is there some limit? Do we need to purchase an additional plan? We’re not on a free plan now. Thanks!
Hello, I'm trying to run this query: function main() { return join( Events({ from_date: "2020-04-10", to_date: "2020-06-10" }), People(), { type:'inner', selectors:[{event:"[Login] Log in success"}] }) .groupByUser(function(state, events){ return...
In the Users tab I can see the list of my users, they have a registered "Name" property, but in the list I can see anything but that, all the names are empty. Is there a solution to that or is it a bug?
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
