Go back to Mixpanel Go to Mixpanel

New post
Login

Pulling Data out of Mixpanel

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

53 Posts
121 Replies

When you subscribe we will email you when there is a new topic in this category

53 Posts

Recently active

Most replies Most views Newest first

thomas077 New Participant

filter_by_cohort in Python

Solved

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...

0 59 1

4 days ago

ivanmuniz2 New Participant

One dashboard for only one user

Question

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...

0 7 1

1 month ago

miluska-arias New Participant

Error in downgrade

Question

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.

0 2 1

1 month ago

vicdavies01 New Participant

7 day and 30 day retention from Product Benchmark Report 2019

Question

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?

0 3 0

1 month ago

ichbin New Participant

JQL $session_start is not an event

Question

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: "$s...

0 3 5

2 months ago

lennartk New Participant

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

Question

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 &...

0 6 2

2 months ago

sim New Participant

Track how many times a user looks at a page before he/she takes a specific action

Question

We have an app where we track the actions of logged in users. We want to know how many times a user looked at a specific item (each item is on a separate page) before the user pressed one of the 5 action buttons. How can we do that?

0 4 1

2 months ago

kmills New Participant

user icon colors

Question

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

0 3 1

2 months ago

telefuel New Participant

Retention Question (Regarding Mixpanel's 2017 Retention Benchmarks)

Question

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" re...

0 5 3

2 months ago

arshia93 Frequent Participant

How can I measure funnel with varies funnel steps?

Question

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 2Hom...

0 2 6

2 months ago

farhan New Participant

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

Question

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_da...

0 4 1

2 months ago

daner06 New Participant

JQL show events from a user custom field

Question

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:&q...

0 2 5

3 months ago

michaelma New Participant

JQL Error: Uncaught exception RangeError: Invalid time value

Question

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...

0 1 1

3 months ago

miles-m New Participant

Activity Feed data and JQL

Question

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...

0 2 1

3 months ago

piotrk New Participant

Rate limits on API usage from report?

Question

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 t...

0 6 2

3 months ago

tonioo New Participant

User profile deletion using API

Question

Dear all,I'm trying to delete user profiles using the API because my account is currently over quota. I'm using the official Python client (https://developer.mixpanel.com/docs/python) to issue delete requests but it looks like they're ignored by Mixpanel. Even after sending deletion req...

0 6 1

3 months ago

nandhakumar New Participant

how do i know whether the data is imported after using import api?

Question

i have used mixpanel import api to import user profile from one project to another.but i dont know how to check whether the data is imported or not

0 5 1

3 months ago

mpcomm1 New Participant

Can't pass date range into MP.api.jql()

Solved

Goal: I'd like to pass a date range into a JQL query in my Platform app.Issue: JQL request failsAttempt 1var dateRange = { from_date: moment().subtract(30, 'days').format('YYYY-MM-DD'), to_date: moment(), }; console.log('dates', dateRange); // logs obj with properly...

0 5 2

4 months ago

mpcomm1 New Participant

JQL Filter By Cohort

Solved

Goal: I'd like to filter my JQL query in my platform app request by passing in a cohort.Issue: JQL request fails. Unsure where and how to add filterMP.api.jql(function main() { return join(Events({ from_date: "2019-01-01", to_date: "2019-09-01", }), People({...

0 2 1

4 months ago

arpit-tudip New Participant

JQL : Average number for an action/event fired with respect to users

Question

Hello,I am trying to get average number for an action/event fired by all active users.I tried something like this. But it's not working. Can anyone suggest a way to find a way to calculate number of user within the same query so that it can be used to calculate the average.function main() { va...

0 2 1

4 months ago

cpellows Frequent Contributor

Appcues --> Mixpanel Integration

Question

Has anyone tried to build a custom API between Mixpanel and other Products? We self host Mixpanel thus most pre built API does not work and I was wondering for others that self host how they have navigated integrating Mixpanel with other products?

0 1 1

5 months ago

sisrani New Participant

Retrieve People Properties on the client side programatically?

Question

Hello:There are certain people properties that I'm storing on MixPanel that I'd like the ability to retrieve from MixPanel programmatically using Swift. For instance, if I'm storing the user's birthday as a people property, I'd like a way to retrieve that data later on. Is this p...

0 3 1

5 months ago

admurray New Participant

Python2.7 posting to user in Mixpanel - Not sure what I am doing wrong

Question

Hi Everyone,I am having some trouble adding data to a Mixpanel user. I am hoping I can get some guidance here.I am trying the following, however when I go into the mixpanel I don't see any of this information online. What am I doing wrong. I don't get any error. I am fairly confident of the...

0 7 1

5 months ago

cuongnd New Participant

JQuery: extract date from datetime

Question

Hi,I need to extract $last_seen to date dd/mm/yyyy. I export raw data. Please help improve my JQL.my JQL:function main() { return join( Events({ from_date: "2019-01-01", to_date: "2019-07-30", }), People(), {type:'inner'} ) //just return a single object per us...

0 1 1

5 months ago

mikesnare New Participant

Is it possible to retrieve the current MTU value via any API?

Solved

As stated in the subject, I'm wondering if there is some way to pull our MTU value via any API? It would be nice if we could avoid overages automatically by simply stopping our MP tracking when we get close.

0 5 4

5 months ago

Page 1 / 3

Badges

scottk has earned the badge Creative
michael has earned the badge Clever
robin has earned the badge Helpful
cherise has earned the badge Helpful
stephanie has earned the badge Helpful

Show all badges

Sign up

Already have an account? Login

Username *

E-mail address (Private) *

First Name

(Private)