I’m reading the documentation of mixpanel and everything points towards being able to being able to associate a group profile property to a lookup table such as a product that a group profile has as a property, and joining that to a lookup table but nowhere in the ui for building reports is that an option.
Specifically I have a property in my group profile called ‘product’ and I have a lookup table with matching keys but when I’m attempting to associate them the UI never gives me the option to “map to a lookup table” on the group profile property
Best answer by ian
For group profiles, you wouldn’t utilize lookup tables at add additional properties. Instead, you can upload new group profiles (still using a csv!) with the new properties on each group. You want to ensure that the first column is titled $group_id, and the additional columns are the new group properties you want added. If a group property already exists, it won’t change unless the value is different.
You can find the guideline to import group profiles here.