Pulling Data out of Mixpanel

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

  • 265 Posts
  • 505 Replies

265 Posts

tejashree.vaze
tejashree.vazeNew Participant
asked in Pulling Data out of Mixpanel

Time based reports

I want to generate a report which will allow me to check activities of the users at a particular time. However, I need to club together the hours of days for multiple days. What I mean is, on the X-axis of the report, I should be able to see the hours of a day (ranging 1-24), and on the Y-axis should be the count of all events. Can anyone provide me inputs on this?   In the above chart, I want to club together all the events that happened between, say 8.00 am and 9.00 am for the last 30 days.

1
anca
Mixpanel Customer Success
1 year ago
H
harsh
asked in Pulling Data out of Mixpanel

How to change default type(JSON) to csv while taking data using api

I want to get csv file after hitting the api,by default i am getting json format.Could anyone tell what changes do i need to make for the given example.   curl https://mixpanel.com/api/2.0/jql \ -u ce08d087255d5ceec741819a57174ce5: \ --data-urlencode params='{"from_date":"2016-01-01", "to_date": "2016-01-07"}' \ --data-urlencode script='function main(){ return Events(params).groupBy(["name"], mixpanel.reducer.count()) }'

5
stephanie
2 years ago
E
Mixpanel Employee
evanmossMixpanel Employee
published in Pulling Data out of Mixpanel

Get a List of all the Annotations You’ve Created in Mixpanel Using NodeMPKnowledgeDrop

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 this together, we figured that users in QBQ might be curious about this as well!  Here’s the series of steps I thought through that can help you pull this list.   Note: this will require using an undocumented API, and we can’t guarantee backwards compatibility moving forward.   First, I checked our documented API for pulling annotations from a specific project here.  Unfortunately the data returned from the API looks like so:   { "annotations":[ {"date": "2014-05-23 00:00:00", "project_id": 23880, "id": 148, "description": "Launched v2.0 of product"}, {"date": "2014-05-29 00:00:00", "project_id": 23880, "id": 150, "description": "Streamlined registration process"} ], "error": false}   A

2440
E
Mixpanel Employee
2 years ago
F
fivetrandev
asked in Pulling Data out of Mixpanel

Mixpanel API for EU Region

Hi Mixpanel team,   In your documentation it details that we should be using api-eu to fetch data for the EU region.  We tried fetching this for one of our customers that recently migrated to the EU, but are getting a 401 error. Does the customer need to generate new credentials for the EU API?    Furthermore, we use jql to get the data and there’s nothing mentioned in the documentation about which which api we should hit to get the EU data. Would you be able to provide us with more insight here?    Thanks!    Colin 

1
stephanie
2 years ago
O
OriNew Participant
asked in Pulling Data out of Mixpanel

Automatic report generation

Hi,   Is there any option to automatic generate a report from Mixpanel? For example- I have created an ‘insight’ data table, and I want to export it automatically every day

1
ian
Mixpanel Employee
2 years ago
L
lennartk
asked in Pulling Data out of Mixpanel

How to export message/campaign-related data?

Hello, We’re investigating how we can retrieve campaign/message labels from API exports. For example, when exporting raw events, we get references to messages in the `properties.message_id` or `properties.campaign_id`. When in the Mixpanel Dashboard, we can see those campaigns/messages by navigating to the Messages & Experiments > Message/Campaign subtab. Selecting a specific message or campaign will show the label of said object. My question is; how can we export this label together with the ID separately? Is this possible? I.e. a separate endpoint or a manual export? We need the labels as human-readable reference points (which is why the IDs themselves are unfortunately not enough). Thanks a lot in advance.

5
L
2 years ago
prachi
prachiMixpanel Alum
published in Pulling Data out of Mixpanel

New Mixpanel Integrations (Facebook Ads, Google Ads and Iterable)MPKNOWLEDGEDROP

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 targeting for your advertising and marketing campaigns.    Create lookalike audiences based on Mixpanel data to target similar users via ads, or create comprehensive campaigns with laser-focused targeting based on user behavior - all at no additional cost.  Just enable the toggle in the Integrations tab, then choose the cohorts you want to sync and you're good to go! Take a look at the picture below to help discover our integrations.   How to find our integrations in Mixpanel  Stay tuned for more in-depth knowledge drops on our integrations in the following weeks!

6120
prachi
2 years ago
F
farhan
posted in Pulling Data out of Mixpanel

get all events as per user

i want to get all events as per user, can you please help me with this

1
stephanie
2 years ago
R
rwr
asked in Pulling Data out of Mixpanel

getting all events correlating with a single distinct id

Hello! I’m wondering if anyone can advice me on how to use the mixpanel api to get all events coorelating with a single event id. I have figured out how to get all distinct ids in a date range, butI’m having a hard time querying all events associated with an id.  I’m wondering also, if that might provide me with any data that is not included already in the explore user tab. 

4
R
2 years ago
N
NHughesNew Participant
posted in Pulling Data out of Mixpanel

Export Data Across All projects

@stephanie is there a way to export across all projects in an organization, either via lexicon or API? 

1
stephanie
2 years ago
A
amy.kNew Participant
asked in Pulling Data out of Mixpanel

How do I get all events to show up in breakdown?

I have a search field in my website and I want to track the search terms people use and how many times. So if someone searches “product” twice, I want to see that word with 2 searches. Similarly, if 3 people search for “product” I want to see that word with 3 more searches. I am able to drill down on an individual user to see those details, but my report is not showing all searches. I’ve attached a screen grab where you can see there are 15 Toolkit search events, but there were 105 events. What do I need to do with my Report setup to see all of those searches?  

1
stephanie
2 years ago
V
vicdavies01New Participant
asked in Pulling Data out of Mixpanel

7 day and 30 day retention from Product Benchmark Report 2019

Hi, I've just read the 2019 product benchmark report - it mentions 7 day and 30 day retention as key metrics. Any thoughts about if that's first time /recurring/ addiction retention?

1
stephanie
2 years ago
T
thomas077New Participant
asked in Pulling Data out of Mixpanel

filter_by_cohort in Python

Hello,  I’m attempting to create a JSON file of user emails based on cohort. I’ve attempted two separate solutions. First, I tried simply building a POST request to the engage endpoint (here’s a simplified version): endpointURL=#API KEY:@mixpanel.com/api/2.0/engagecohort_id=12345queryParams={'filter_by_cohort':{"id":cohort_id}, 'output_properties':["$email"]}response=requests.post(url=endpointURL, params=queryParams) The problem is, this encodes the special characters, so when I send the request it fails with “error: “invalid parameter: filter_by_cohort””. When I manually build the request in Postman, it works, but the percent escape characters break the request when I build it in my script.  My alternative solution was trying to use the mixpanel_api feeding in the same query parameters, but it similarly fails with an Invalid parameter error.  Is there another potential solution? Or, are there at least potential updates that allow the API to handle encoded URLs?  Thanks!

1
R
Mixpanel Engineering
2 years ago
I
ivanmuniz2
asked in Pulling Data out of Mixpanel

One dashboard for only one user

We need to share dashboards with our client´s employees. Is there a way to share only one dashboard with only one employee?I assume we´d need to create a Team like "Client´s employees" with consumer role but I can´t assign only one dashboard to one cosumer account.I also know that I can send dashboards to a external users but sometimes the properties´ names look cut on the email and if the user click on "view dashboard" he needs to create an account that head to create a new project so the experience is pretty poor.Thanks!

1
stephanie
2 years ago
M
miluska-ariasNew Participant
asked in Pulling Data out of Mixpanel

Error in downgrade

Can someone please help me with an error in payment and then with the downgrade, i can't find a chat or someone from support.

1
stephanie
2 years ago
I
ichbin
asked in Pulling Data out of Mixpanel

JQL $session_start is not an event

Hi Mixpanel,I would like to generate jql query based on this : here is JQL query : params = {   type : 'unique',   email_is_set: '( defined (properties["$email"]))',   email_is_not_set: '( not defined (properties["$email"]))',   events : [{event: "$session_start" }] }; var groupKeys = [mixpanel.numeric_bucket('event.time', mixpanel.daily_time_buckets)] function main() {   var collection = join(     Events({       from_date: "2019-10-01",       to_date: "2019-10-12",       event_selectors: params.events,     }),     People(),     {       type:"left",       selectors:[{selector:' defined (user["$email"]) '}]     }   )   if (params.type == 'total')     return collection     .groupBy(groupKeys, mixpanel.reducer.count());   else if (params.type == 'unique')     return collection     .groupByUser(groupKeys, mixpanel.reducer.null())      .groupBy([mixpanel.slice('

5
W
2 years ago
L
lennartk
asked in Pulling Data out of Mixpanel

How to join user profile and event data from the API?

Using the Mixpanel API, we can export raw events using the 'Event Export API' (https://data.mixpanel.com/api/2.0/export) and user profile data through https://mixpanel.com/api/2.0/engage.What I would like is a reference (a foreign key field of some sorts) on every raw event to the user who 'performed' or 'caused' this event. This is supported in the interface of Mixpanel itself, but I can't seem to find out how to get this from the API. Thanks in advance!

2
M
2 years 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.

1
M
2 years ago
T
telefuel
asked in Pulling Data out of Mixpanel

Retention Question (Regarding Mixpanel's 2017 Retention Benchmarks)

Hey everyone!In Mixpanel's 2017 Product Benchmark Report, as cited in their "What Is A Good App Retention Rate" blog post, they cite 8-week retention rates of 20% as average, and ~35% as "elite".I'm curious if anyone knows if these numbers map to "First time" retention (tracking new user cohorts over time), or "Recurring" retention (tracking retention of loyal users) in Mixpanel?Asking because these two numbers (First Time Retention vs Recurring Retention) are VERY different for my product, and would mean we're either well below average, or actually quite elite!Let me know guys! Thanks!

3
J
2 years ago
A
arshia93
asked in Pulling Data out of Mixpanel

How can I measure funnel with varies funnel steps?

Hey guys,There is a way to enter the information needed for the first step of the booking funnel on the landing page header, but there is also an option on the bottom of the page to enter that same information on a seperate page.For example:Option 1Home page (enter address)Sign upCheckoutOption 2Home pageLocation (enter address)Sign upCheckoutI want to measure results based on either funnel steps, so I can track funnel steps for either flow. I'd rather follow Option 1 to get funnel results and skip the Location page. Thanks.

6
stephanie
2 years ago
F
farhan
asked in Pulling Data out of Mixpanel

We want to export users data along with all the events as per user, does anyone have any idea how can i get it??

We have written below JQL query but it's not working can you please help us with this..var params = { from_date: '2019-06-13', to_date: '2019-06-14'}function main() { var peopleCollection = People(); var collectionEvents = Events({ from_date: params.from_date, to_date: params.to_date }) .joinByuser(function(collectionEvents, peopleCollection) { var array = Array(); for (var i = 0; i < peopleCollection.length; i++) { for (j = 0; j < collectionEvents.length; j++) { if (peopleCollection[i].distinct_id == collectionEvents[j].distinct_id) { array.map[collectionEvents[j]]; } } } return eventarray } );}

1
F
2 years ago
D
daner06
asked in Pulling Data out of Mixpanel

JQL show events from a user custom field

I would like to get the list of events based on a user custom field named "Company ID". How do I write this JQL query?I tried this but didn't work:function main() { return Events({ from_date: '2019-05-08', to_date: '2019-05-30', }) People(), { type:"inner", selectors:[{selector: 'properties["company_id"] == "0cd2eaf.....df1326ca"'}] }}

5
F
2 years ago
M
michaelmaNew Participant
asked in Pulling Data out of Mixpanel

JQL Error: Uncaught exception RangeError: Invalid time value

Hello all,I am presently writing a JQL query to join a group of Events with People, and then group by an array of keys. One of those keys happens to be time, as you can see below:function main() { var collection = join( Events({ from_date: '2019-09-01', to_date:   '2019-09-03', event_selectors: [{event: 'Page Viewed'}] }), People({ user_selectors: [] }), {type:'left'}) return collection.groupBy(mixpanel.multiple_keys(['properties.User Id', 'properties.Organisation Id', function(event) {return (new Date(event.time)).toISOString().split('T')[0];}]), mixpanel.reducer.count()) } Which gives me the following error:Stack trace: RangeError: Invalid time value    at Date.toISOString (<anonymous>)    at <anonymous>:13:150I've noticed that:1) The error persists even when I toggle to other join types.2) The error disappears if I remove the join operation with People and just leave events. But I would like to keep the join op

1
E
Mixpanel Employee
2 years ago
M
miles-mNew Participant
asked in Pulling Data out of Mixpanel

Activity Feed data and JQL

I'm trying to compile a data point from my Users inside their Activity Feed. There's an 'event' called Product Scanned that expands into many more specific data points of which I'm looking only for Product Name. Now I could manually copy+paste 800 times for each User but I'm wondering if I have to use JQL to target the 'event' of Product Scanned but I don't know how to access the specific properties inside it or whether I have to use JQL at all. Any help is appreciated, thanks.

1
F
2 years ago
P
piotrk
asked in Pulling Data out of Mixpanel

Rate limits on API usage from report?

Some time ago I wrote a complex report using the Mixpanel Platform API (https://mixpanel.com/help/platform) and ran it directly on Mixpanel (via https://mixpanel.com/report/...). When I try to run it now it goes part-way, then API requests start failing with rate-limiting 429 error codes. I seem to remember that rate limits were not enforced for reports running on mixpanel.com itself -- is that no longer the case? Thanks.

2
P
2 years ago
Community Terms of UseCookie settings