Go back to Mixpanel Go to Mixpanel

Pulling Data out of Mixpanel

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

  • 59 Posts
  • 135 Replies

59 Posts

O
Ori New Participant

Automatic report generation
Solved

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

26 1
I
Rank
5 days ago
L
lennartk New Participant

How to export message/campaign-related data?
Solved

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

126 5
L
24 days ago
F
farhan New Participant

get all events as per user

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

56 1
Rank
1 month ago
R
rwr New Participant

getting all events correlating with a single distinct id
Solved

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

184 4
R
1 month ago
N
NHughes New Participant

Export Data Across All projects

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

61 1
Rank
1 month ago
A
amy.k New Participant

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

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

82 1
Rank
1 month ago
V
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?

70 1
Rank
2 months ago
T
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...

163 1
R
Rank
2 months ago
I
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...

73 1
Rank
3 months ago
M
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.

69 1
Rank
3 months ago
I
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...

85 5
W
4 months ago
L
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 &...

101 2
M
5 months ago
S
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?

71 1
O
5 months ago
K
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.

83 1
M
5 months ago
T
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...

73 3
J
5 months ago
A
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...

70 6
Rank
5 months ago
F
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...

84 1
F
5 months ago
D
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...

139 5
F
5 months ago
M
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...

70 1
E
Rank
5 months ago
M
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...

71 1
F
5 months ago
P
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...

102 2
P
5 months ago
T
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...

99 1
M
6 months ago
N
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

72 1
M
6 months ago
M
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...

74 2
M
6 months ago
M
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({...

99 1
E
Rank
6 months ago

Popular Tags

Latest Tweets