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:
- there seems to be a 10k row limit in mixpanel downloads.
- 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.
- 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.
Best answer by Muffaddal Qutbuddin
Here is a basic code to get you started.
from_date: "2019-07-31" ,
.groupBy(["name","properties.URL_PROPERTY_NAME_HERE" ], // breakdown by as many property as you want here.
Run the query and hit export to get the complete list of url.