Pulling Data out of Mixpanel

Are you using Data Pipelines, Zapier, APIs, etc to pull your data out of Mixpanel? Ask here!

  • 292 Posts
  • 551 Replies

292 Posts

StevenBaum
Mixpanel Product Manager
StevenBaumMixpanel Product Manager
posted in Pulling Data out of Mixpanel

New Mixpanel cohort sync destinations - comment for beta access

Hey Mixpanel community! We’re currently working to expand our offering of partner products we support for automated cohort delivery, and in this post we’d like to cover a few specifically - Insider and Kameleoon.(This post was previously used for beta access to MoEngage and Leanplum integrations). Using this connection, you’ll be able to supply Mixpanel Cohorts you’ve built to create targeting groups in these respective tools, combining analytics precision with campaign orchestration or experimentation design. Send the right message to the right audience with continuous cohort updates. We’re in the process of running a closed beta, so feel free to drop a comment below if you’d like to request access!

17
StevenBaum
Mixpanel Product Manager
1 year ago
StevenBaum
Mixpanel Product Manager
StevenBaumMixpanel Product Manager
published in Pulling Data out of Mixpanel

Data Pipelines FAQmpknowledgedrop

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 highlights some frequent scenarios our users encounter, along with explanations and troubleshooting. I tried to create a pipeline, but encountered an errorA few cases for errors during creation relate to trial pipeline expiration, authorization, and Google Groups. The Data Pipelines API is also a reference point for accepted parameters during pipeline creation. Below are some common errors. {"Error":"the account associated with this project has not purchased the Data Warehouse Export package. You can still use the one-time trial to test the pipeline."}The above error occurs when creating non-trial pipelines for a Mixpanel organization that does not have the Data Pipelines package enabled. Users may

34094
StevenBaum
Mixpanel Product Manager
1 year ago
K
kylemccollomNew Participant
asked in Pulling Data out of Mixpanel

Every time an event is triggered, I want to get a Slack notification

How can we pull that off with a Mixpanel alert and a Slack channel webhook? Right now, we can get summaries in a Slack channel on a Mixpanel report, but not get a notification every time an event happens.

0
L
5 days ago
I
iosdevFrequent Contributor
asked in Pulling Data out of Mixpanel

Default columns in Users -> Explore

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? 

10
A
7 days ago
M
mohitrameshNew Participant
asked in Pulling Data out of Mixpanel

Breaking down JQL query by day

Hello Folks,For the below mentioned query, If I am using “properties.$time” as a group by function it is showing me results at a time stamp level. If with the same setting I want to see these results at a day level what changes should I do to the query.function main() {  return Events({    from_date: '2022-08-19',    to_date:   '2022-08-21',    event_selectors:[{event: 'PDP_ViewProduct'}]  })  .groupBy(["properties.$time","properties.PDP_SKU","properties.PDP_RTSAvailable","properties.PDP_OfferText"], mixpanel.reducer.count());}

2
D
13 days ago
V
vbaswalNew Participant
asked in Pulling Data out of Mixpanel

Trail Pipeline Export AWS S3 Error

I am trying to create a trail pipeline to export the data to S3I am using Service Account Creds Create a Policy in my AWS account Create a role and attached the policy to it and Trusted the account 485438090326When I go about creating the trail pipeline, I receive an error which says"Error": "failed to verify permissions. AccessDenied: User: arn:aws:iam::485438090326:user/mixpanel-export is not authorized to perform: sts:AssumeRole on resource: arn:aws:iam:ap-south-1:<my-account-id>:role/mixpanel-s3-bucket-access-role\n\tstatus code: 403, request id: c8fa952a-0c1f-4f5b-96d4-5bcd7a0108b4" 

1
D
13 days ago
J
jamiesessionNew Participant
asked in Pulling Data out of Mixpanel

Filtering User Profiles page by User ID

On the user profiles page it doesn’t seem to be possible to filter the list by User ID. It’s possible to use Distinct ID but my users have multiple distinct ids and the user profiles page only seems to link one to the user for the filter.How can I filter so I can find my user by their user ID? Thanks

1
J
13 days ago
K
kmillsNew Participant
asked in Pulling Data out of Mixpanel

user icon colors

I am new to Mixpanel and trying to figure out what the significance of the different icon colors are.

2
A
14 days ago
Y
yotamooNew Participant
asked in Pulling Data out of Mixpanel

Identify Users who sent A but *not* B

Hey there,Suppose I want to detect if a user had sent event A but not event B, how would I go about doing it? A funnel seems to be the first thing that comes to mind, but it requires two events sent at least, while I only have one that I expect sent, A, and another not to be sent, B of course.  Would appreciate any suggestion. 

0
Y
15 days ago
R
ryan_xin_0715New Participant
asked in Pulling Data out of Mixpanel

Pull data without creating reports

We have a platform that users can create charts on it. We want to show users MixPanel reports of their charts, like number of views, etc, on our platform.So it is possible to do that without creating MixPanel reports for each of our users’ charts?Thank you!

0
R
26 days ago
B
brucearthurNew Participant
asked in Pulling Data out of Mixpanel

How can I access a users profile properties in JQL?

I am trying to use JQL to grab data to build a Power User Curve. I have the basics up and working, and now I need to filter out users who have joined recently, ideally less than a week ago.I see that there is a user profile property $ae_first_app_open_date, and I would like to use that, but it always seems to return “undefined” when I call that property. Can someone show me how to access that property within JQL? 

0
B
26 days ago
G
geghamNew Participant
asked in Pulling Data out of Mixpanel

JQL return objects limit

How can I increase return objects count in JQL. For example I have 500 objects to be returned, but t returns 294 , it is also depends on object property count, when I decrease return properties count, it returns more than 294 objects, but not all again?As I understand count is depends on object size. How can it be changed?

0
G
1 month ago
A
algu96New Participant
asked in Pulling Data out of Mixpanel

API Querying Report

Hi! I’m having an issue where querying an insight report I’ve saved only returns 3000 rows of data. I understand that Mixpanel limits the data it shows in an insights report but I know that my data contain more than 3000 rows. Will querying a saved report only show the limited data that viewable in the insights report? How can I extract all the data? Thank you!

2
A
1 month ago
N
navintirodkarNew Participant
asked in Pulling Data out of Mixpanel

Get data for last 7 days or last 30 days from JQL

How do i get data for last 7 days or last 30 days from JQL ?

1
F
1 month ago
K
KNKNew Participant
asked in Pulling Data out of Mixpanel

Count of all events in the last 1 year, grouped by event

Hello there!Mixpanel newbie here.I am interested in getting a count of all events sent to Mixpanel in the last 1 year, grouped by each event like so{ eventA: 100, eventB: 50, eventC: 200…..}I was looking for a function like groupByEvents similar to groupByUser but I dont think it exists.Any help is greatly appreciated. Regards,KNK

2
K
1 month ago
B
bxorcloudNew Participant
asked in Pulling Data out of Mixpanel

How to Offset results in JQL?

How to Offset results in JQL? So I have 100k plus data but it is returning only 1k data and I want to access the next results like around 1k-2k data to precess. How can we do that in JQL?

0
B
1 month ago
A
aiocinNew Participant
asked in Pulling Data out of Mixpanel

Finding duplicate user profiles to be able to run Identity Merge

Hi guys, I am looking into cleaning up duplicate profiles we currently have in MixPanel and I know this is possible with the $merge tool https://developer.mixpanel.com/reference/identities#identity-merge for event history and with the API module https://github.com/mixpanel/mixpanel_api#deduplicate-people-profiles for user profile data.However, I could not find an API endpoint where I can retrieve user profiles which have duplicate data so I can then merge them. I checked the query API but that is mainly focused on reports and the raw export API has a lot of event data that is not necessary for this purpose (the resulting data would be too big to handle).Can you please point me in the right direction to see how I can retrieve duplicate profiles so I can then execute the merge process? Thank you! 

2
B
1 month ago
D
Diana BrookNew Participant
asked in Pulling Data out of Mixpanel

Export Mixpanel events

Hi, I am writing a code (in python) that is counting users clicks and need to verify that events in Mixpanel were created. What do I need in order to approach to Mixpanel and retrieve created events to my IDE?Are events sent only in json format?What are the appropriate code steps for this kind of test?Thanks

1
N
Mixpanel Employee
2 months ago
K
kylejustinNew Participant
asked in Pulling Data out of Mixpanel

Extract UTM Parameters from URL using REGEX_EXTRACT

Hi!I am trying to extract the UTM parameters from the url property of Loaded a Page Event with a Custom Property. I am using REGEX_EXTRACT, however, I am not very familiar with the syntax of this function on Mixpanel. How can I do this?Here’s an example of what I need:Property - url: https://meetbit.io?utm_source=mixpanel&utm_medium=forum&utm_campaign=mixpanelforumCustom Property - current_utm_source: mixpanelThanks!

0
K
2 months ago
B
bramastavikanaNew Participant
asked in Pulling Data out of Mixpanel

limit fetch data on JQL

i want to create pagination on my server side using mixpanel but i cant find anywhere that JQL support limit or maybe i missed something, is there any way to fetch data with JQL using limit?

0
B
2 months ago
N
ntroncosoNew Participant
asked in Pulling Data out of Mixpanel

Invalid API endpoint for export

I am trying to test the export api and as far as I can tell, I am setting everything correctly. However, Postman keeps returning:{ "request": "/api/2.0/export?from_date=2022-07-28&to_date=2022-07-29&project_id=<project-id>", "error": "Invalid API endpoint"}I found another post with my exact issue: However, their solution was to add the project_id parameter, which you can see in the response above. Here is my postman config: I don’t know what else to check.

1
N
2 months ago
A
Andrew DuncanNew Participant
asked in Pulling Data out of Mixpanel

Custom property built-in example does not work

By “does not work” I mean it gives directions you can’t follow. My specific question is: how can I use this example?I was in the Create Custom User Property dialog, and chose the “Days since sign-up” example, which tells me to use the Date event property. But no event properties show up in the pop-up selector.Now, maybe event properties are excluded from the list because I am creating a custom user property. But then why is the example even there? The online docs hint at the difference, but don’t answer the very first question that comes to mind: Anyway, the comments explicitly say to mix user and event properties in the same equation:A good selection for the first property would be a user property that records the user's sign up date, and a good selection for the second property would be the "Date" event property.So how is this example supposed to work?

0
A
2 months ago
G
gunholNew Participant
asked in Pulling Data out of Mixpanel

Event is firing, but not showing in funnel

Hi. In my account, I can clearly see that a specific event which is named “onboarding payment success” is firing correctly (I can see it under Events). But in my funnel, it does not show any results.Anybody have any clue why?

1
L
Mixpanel Employee
2 months ago
K
kylejustinNew Participant
asked in Pulling Data out of Mixpanel

Count Cohort Increase/Decrease

When I create a cohort and plot it in a line chart, it shows a constant number (number of users in the cohort at the moment), with no increase/decrease whatsoever as the days pass. Is there a way to view these increases and decreases?

1
Jaz-CommunityManager
Mixpanel Community Team
2 months ago
V
vivianNew Participant
asked in Pulling Data out of Mixpanel

Track Session Duration

I would like to plot the total seconds (per user per week) spent on my app.My approach is the following:Does this make sense?

0
V
2 months ago
Community Terms of UseCookie settings