Is there a way to populate a filter on an insight via a CSV
Is there a way to populate a filter on an insight via a CSV
Is there a way to populate a filter on an insight via a CSV
Hi Mark N., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
There isn’t anything in the provided docs that describes a way to directly upload a CSV to populate a filter list in an Insights report.However, there are a few CSV-based features that can indirectly give you filterable properties: 1. Lookup Tables
- You can upload a CSV as a Lookup Table and map it to an existing event or user property in Lexicon or within a report.[Lookup tables; Upload lookup table]
- Once mapped, the Lookup Table columns appear as additional properties that you can use as filters/breakdowns in Insights.[Use lookup table]2. Bulk updating users via CSV, then filtering by that property
- You can upload a CSV to bulk-update user profiles with a new property (e.g. inCohort="yes"), and then filter or cohort on that property in reports.[Cohort via CSV]3. Google Sheets → Mixpanel
- The Sheets ⇔ Mixpanel extension lets you import events/users/groups from a sheet/CSV, so any columns you upload become properties that can be filtered on.[Google Sheets]The docs do not show a feature to upload a CSV that simply becomes a dropdown list of filter values in Insights without going through one of the mechanisms above.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Hey Ansh A., sure appreciate the help. Imagine you have a bunch of events and each has a custom property cityID or something similar. I want to take a csv of a list of cityIDs and filter for events where the cityID of the event matches up to one of the items in my list. So if I have events from New York , Austin, and Chicago, but my CSV only has New York and Austin in it, we don't want to see any events with Chicago as the value associated with the cityID property
Got it. Yea, you can do this using Lookup tables. Super easy to do. Here's a quick documentation on it: https://docs.mixpanel.com/docs/data-structure/lookup-tables Lemme know if you need further help.