Q&A

Have questions about using Mixpanel? Check out the categories below

2232 Posts

S
samurai2000New Participant
asked in Data Management

How to escape values like " in custom property function parameters?

We are attaching an attribute to our events that can contain runtime data in which we cannot control the structure beforehand. It is an attribute called custom_data which contains data from various sources dynamically combined into a JSON object. For basic insights reports it is possible to use the “CONTAINS” operator to search for the presence of a value and build custom events based on that. A sample for the value for the attribute “c_data” could be: {"session_running":false,"is_virtual_event":false,"is_aggregated":true,"product_type":"variant","origin":"home_page","role":"merchant","is_profile":true,"entitlements":"starter_tier"} For some reports we would like to extract certain attributes and values using the Custom property functionality. However it is not possible to parse the regex into the function as it contains the quotation mark which breaks the syntax of the function editor. Is there a way to escape the input so that i can pass the quotation mark into the function? I did no

1
B
6 hours ago
F
Frans-L
asked in Data Management

How to get the last element of the list property

Hey!If I have list property that has items such as [item1, item2, item3, .. itemX], how could I get the last one?With custom property I can pick the first item easily: List[0].I can also fetch the length of the list: LEN(List)However, MixPanel doesn’t seem to allow this: List[Len(List) - 1)So, how could I select the last element from the list property?Regards,Frans

3
B
7 hours ago
S
ShrutiAgniNew Participant
asked in Data Management

Filters | Add condition on the events

Hello, Which filter can be used to get the list of users whose phone number ends with “123”?

3
mrais
13 hours ago
M
marcuascNew Participant
asked in Sending Data to Mixpanel

Problems with json data in mixpanel

Hi,I’ve been trying to implement mixpanel in our webshop.I want to send information about the product the users buy.Event property as a stringevent property json-formatThe information is sent as a JSON array with information about the product. But in mixpanel the array is parsed as a string.Anyone know how I can access the properties e.g itemType, price etc.?

0
M
20 hours ago
L
LouNew Participant
asked in Building Analysis Reports

How to track inactive users?

We’ve recently set up Mixpanel and how have about 2 weeks data to work with. We want to track inactive users by seeing which users have no logged in within the last 3 weeks. It seems that a user must have logged in since we set up Mixpanel for us to check if they have been inactive, is there a way around this so that we can see all our users who have not logged in?  

3
R
3 days ago
J
justine_massiNew Participant
asked in Data Management

Apply User properties to Events

Hi mixpanel community!We were wondering if we could apply properties added client-side to server-side events, such as location, OS, browser, screen, etc.For context:We have opted for an approach that is mostly server-side. All events are tracked in the backend, but since server-side tracking doesn’t give us access to all the mixpanel default properties (such as location, OS, browser, etc.), we thought that we might be able to use the .identify function in the frontend and then apply these properties to our server-side events.For instance, after adding mixpanel.identify in the frontend:If I look at an event that is tracked client-side, I’ll see all the default properties show up for that event Now, in the same session and for the same user, if I look at an event that is tracked server-side, no properties will show upWe know that we can specify the IP address in the server-side event to get the location, but that doesn’t include all the other goodies, so we were wondering if there was a

0
J
3 days ago
N
nedpalmerNew Participant
asked in Sending Data to Mixpanel

Assigning Users to multiple Groups?

Couldn’t figure this out from previous threads -  The majority of our users belong to a single group (e.g John Smith is working at Diamond Wealth). However, we allow our customers to grant product access to their customers - in which case users may sometimes belong to multiple groups (for example, John Smith granted access to Jane Fonda for the Diamond Wealth platform, but Jane Fonda was also granted access to the Moneymakers’ platform, which are another customer of ours).Since I want to be able to group users like Jane Fonda per the group they belong to (Diamon Wealth, Moneymakers etc...), and given the possibility of them belonging to multiple groups - what would be the best way to model this? Can we assign multiple group ids to a single user?

1
A
3 days ago
K
KevinPriceWardNew Participant
asked in Sending Data to Mixpanel

Using PHP SDK tracking, client side properties missing

Hi all,I’m integrating Mixpanel into a WordPress/Woocommerce site and I’m occasionally using Javascript to track events and occasionally using the PHP SDK – depending on where in my code is logical to place the Event tracking. I’m finding that with the Javascript tracking I get a lot of client side properties automatically set on the Event such as Country/City/Browser/Screen size and so on, but using the PHP SDK I don’t get any of these. I’m interrogating the $_COOKIE super global and getting the $distinct_id and setting that when pass the PHP Event as well as the $device_id – but this doesn’t seem to set those properties to the same as the Javascript ones for the same user like I thought it would.Am I missing something here?Thanks in advance for any help!Kevin

1
K
4 days ago
A
app_analytics_rocksBrainy
asked in Data Management

Unbounded retention going up

 Hey guys! So the unbounded retention (currently “now and after”) represents the number of users that did an event on a particular time bucket or after. So how is it possible that the retention for N+1 day is higher than Retention in day N?

2
O
5 days ago
M
Matt-CollctivNew Participant
asked in Building Analysis Reports

cumulative line total completely different from pure total

Hi all, loving mixpanel so far. Just come across what seems to be a bit of a bug? I don’t think it’s me. I have two views on the exact same data. Ones a cumulative line graph, the other is just a metrics total of the same thing, i.e it should just show the end data points of the cumulative lines. the orange metric is correct for both, the purple cumulative line seems to randomly add on 30 for no reason?The criteria for both is identical. I duplicate the graph and change the view from metric to line graph cumulative and I randomly get 30 more unique users for the same data point. 

0
M
5 days ago
M
macabeusNew Participant
asked in Data Management

How to know if there is a chart relying on some event?

I need to update an event, and I would like to know if there is a chart relying on its properties, that also would need to be updated.But how to know it? Is there some feature on the dashboard to list all charts that consume a specific event?

0
M
5 days 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
G
gmit08New Participant
asked in Building Analysis Reports

View all hidden events

How can I view a list of all events including hidden events? The only way I see to currently see Hidden Events is to know what the event title is and start typing the name here. 

1
U
5 days ago
E
ehudeNew Participant
asked in Data Management

Filter events by prefix?

Hi, Does anyone know if it is possible to get events by prefix?For example i would like get all the events that started with “Clicked” or “Viewed” in my case. Thanks

2
S
5 days ago
G
GuillaumeDNew Participant
asked in Data Management

How can I delete multiple reports at once ?

Hi,I would like to know if it’s possible to delete several reports & dashboards at the same time rather than having to do it manually one by one?Many thanks 

9
W
6 days ago
K
KevinPriceWardNew Participant
asked in Sending Data to Mixpanel

Problem with integration - no events

Hi,I’m trying to integrate mixpanel in a WordPress/Woocommerce website on a local development url, I’ve written a simple JS module:import mixpanel from 'mixpanel-browser';export default { init() { function init(debug){ let prod = '4x4tyres.co.uk'; let staging = '4x4tyres.chapterserver2.co.uk'; let prod_token = '4f646eb24be013b5273c0337f96cddc3'; let staging_token = 'b76dd3d520d350b37753163f13a5bd77'; let dev_token = '43a7ff1776945bcd5a8d7024aa18f5d9'; if(window.location.hostname.toLowerCase().search(prod) >= 0){ console.log('init mixpanel prod'); mixpanel.init(prod_token, {debug: debug}); }else if(window.location.hostname.toLowerCase().search(staging) >= 0){ console.log('init mixpanel staging'); mixpanel.init(staging_token, {debug: debug}); }else{ console.log('init mixpanel dev'); mixpanel.init(dev_token, {debug: debug}); } } window.mixpanel = function(){ return mixpanel; }

0
K
6 days ago
F
fintechdeveloper24New Participant
asked in Data Management

How to work around the limit of 500 distinct ids per user?

First some quick context: we are a payments API company. Merchants integrate with our API to allow their customers to select paying with us at checkout. Upon the user selecting to pay with us we inject an iFrame into the merchant’s website or mobile app that renders our payment flow. Only after rendering this iFrame do we show users the option to proceed with the payment if they already have an account, or to sign up if they are a new user.I want to track when a new payment is initiated (i.e. when a user first enters our flow). We are doing server-side tracking, so due to the fact that the user is always anonymous when a payment is initiated, we generate a UUID as the distinct id for this anonymous user. However, since a new iFrame is created for every new payment, it’s impossible to re-use this UUID across sessions. A potential solution I found is to call https://developer.mixpanel.com/reference/create-identity with the anon_id being the generated UUID and the identified_id being our

3
X
6 days ago
J
JaehyeonNew Participant
asked in Strategy and Planning

Which plan should I purchase with which MTU plan when over 100k MTU in the free plan

Hello. I have an inquiry about the free plan.If the number of events exceeds 100k mtu, should I select and purchase 100k of a paid plan (ex. growth plan)?And, is access restricted only to reports after an account exceeds the free quota? Thanks.

1
Jaz-CommunityManager
Mixpanel Community Team
6 days ago
K
KevinPriceWardNew Participant
asked in Strategy and Planning

Woocommerce basic setup

Hi all,I’m completely new to mixpanel and am moving from GA. I’m the developer for a WordPress/Woocommerce shop that specialises in tyres and wheels - https://4x4tyres.co.uk. This site is based on a custom theme derived from the roots/sage starter theme, so as such I as the dev have full control over all aspects of the site.I would like first of all to track interactions with our tyre and wheel search widgets on the site and gather data about which tyre and wheel searches convert best. So for tyres for example I need to gather data such as the size tyre searched AND whether the search resulted in a sale. And then I would need to look at this data across all my visitors and over time to get an idea of what the highest converting tyre searches are and how this changes over time. Just to note as well, most of the visitors and sales on the site are from guest users - i.e. they don’t have accounts or log in. Some do, it’s just the majority don’t.So to facilitate the above requirement - what

0
K
6 days ago
G
GonzaloNew Participant
asked in Data Management

UTM_source "undefined"

We are receiving the utm parameters tracked by default (utm_source, utm_medium, utm_campaign, etc). But most of the “utm_source” that we are receiving are "undefined". I can´t find how to fix it, does anybody experienced the same problem and know how to solve this problem?Thanks!   

3
2
6 days ago
A
addisonlynchNew Participant
asked in Admin and Settings

Searching UI by Distinct ID

What is the best way to filter the users view by a non-canonical distinct ID in the UI? The API allows me to identify a user using any distinct ID in the cluster, but if I search by a non-canonical distinct ID in the UI, the user does not show up. For event filters, I can use the hidden property Distinct ID Before Identity (I filter by Distinct ID OR Distinct ID before identity), but this property does not seem to be exposed when filtering users.  

0
A
7 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
A
addisonlynchNew Participant
asked in Sending Data to Mixpanel

Handling User Identity considering OAuth logins/signups

Hello, We have a mobile (React Native) app where we would like to follow a user from their anonymous state through authentication. I have been reading up on best practices for Identity/Merge but still have one issue I can’t seem to get past. In the ideal world we would like to handle everything in the frontend. When a user signs up, we call “alias”, set a bunch of super properties / properties from the frontend. Then, any time the user logs in, we call “identify”. However, our app also allows OAuth login via Google/Apple. How do we handle the cases where a user attempts to “Create an Account” via OAuth from our login page or “Login” via OAuth from our create account page? All of this logic is handled by the OAuth provider and our app may not know if either of these are the case. Is it OK to put the same logic in the createAccount and login calls in our frontend? E.g. for Login, we may call “alias” after it has already been called once. Thank you! 

0
A
8 days ago
H
harrys_ecNew Participant
asked in Data Management

User ID data

Hi  I am trying to get a list of all user IDs in my project using matillion into our Snowflake database. There are two ways to do this :Using Mixpanel query in matillion: But I can only see data selection as Export and it does not allow other data sources. Is this something to do with my setup? USing Mixpanel API: I dont know what API I can use for it .  I just need user ID, Last Name or Name and email. 

0
H
8 days ago
J
julio3090New Participant
asked in Sending Data to Mixpanel

Stop tracking session event after specific action

Hi, we have doubts about whether it’s possible to stop tracking a user session after a specific action has been triggered. We need this because we use a process of impersonation in our app and we don’t want to track these sessions performed by us, this will alter our user’s metrics. Is there any way to do that? Thanks!

4
R
10 days ago
Community Terms of UseCookie settings