Solved

Download breakdown data from insight

  • 13 October 2020
  • 4 replies
  • 226 views

Hi I want to download list of something that is a property of an event, say images linked to image uploaded. in insight i can only see the aggregated data so i’m using the breakdown by image to get the list of image. now the issues that i’m facing are:

  1. there seems to be a 10k row limit in mixpanel downloads.
  2. even if the number is less than 10k, the number shown in aggregated data is always higher from the number of rows in the downloaded file.
  3. the rows in breakdown seems to be filtered. for example when i’m using 2 step breakdown, 1- image 2- feedback, as soon as the number of images starting to increase (even if not crossing 10k) the rows seems to get filtered by only showing positive feedback. this is just an example. the rows are getting filtered for so many cases.

please help me as to how to solve it.

Thanks

icon

Best answer by Muffaddal Qutbuddin 19 June 2021, 09:06

Hello @swati115553344  You can use JQL to download all the URLs. 

Here is a basic code to get you started.

 

 function main(){
return Events({
from_date: "2019-07-31" ,
to_date:"2019-08-21",
event_selectors:[{event:"UPLOADED_EVENT_HERE"}]

})
.groupBy(["name","properties.URL_PROPERTY_NAME_HERE" ], // breakdown by as many property as you want here.
mixpanel.reducer.count());
}

 

Run the query and hit export to get the complete list of url.

View original

4 replies

Userlevel 6
Badge +3

 

I confirmed that you were working with out support team on this question, but in case anyone else is facing a similar scenario I wanted to pass the information along:

The limitation on exports is there to help keep the interface performant, that said, there are a few options to help you use this feature:

  • In the Insights report, 1 breakdown has a limit of 10K cardinality (a maximum of 10k rows returned in the result) and the cardinality limit will get lower and lower with more breakdowns added - this will cause fewer rows to render in the result. However, it avoids performance issues such as longer loading time or potential crash in the browser. 

If you are able to filter your data into sections, this would help offset the 10k limit. 

 

It doesn’t work anymore. are there any changes?

Userlevel 3
Badge +2

Hello @swati115553344  You can use JQL to download all the URLs. 

Here is a basic code to get you started.

 

 function main(){
return Events({
from_date: "2019-07-31" ,
to_date:"2019-08-21",
event_selectors:[{event:"UPLOADED_EVENT_HERE"}]

})
.groupBy(["name","properties.URL_PROPERTY_NAME_HERE" ], // breakdown by as many property as you want here.
mixpanel.reducer.count());
}

 

Run the query and hit export to get the complete list of url.

is there any direct or non-query way? like earlier we could just append ?limit=x# (x=number of rows) in the url of the report. but now that doesn’t work for some reason

Reply


Mixpanel