When shoudl you use flat list of event properties vs object arrays?

Thanks Dan. The key question is indeed “what is the downside?” of using object arrays.  I think it’s very clear cut when you know there will be multiple objects within it. Otherwise it’s not possible to effectively model is with flat properties.  E.g

products: [{
        product_id: 1,
        name: 'Shirt',
        category: 'Clothing',
        price: 12.60,
      },
      {
        product_id: 99,
        name: 'Soap',
        category: 'Beauty',
        price: 1.99,
      }
]

The question as pointed out in my OP is when you know there will always be only one product/object in the event like

product: [{
        product_id: 1,
        name: 'Shirt',
        category: 'Clothing',
        price: 12.60,
      }
]

That said, I like your point you made:

...appears in the Amplitude UI as, for example, “{} products”….the squiggly brackets are a nice giveaway to the ens user that this opens up to reveal this nested data.

So without any downside, this seems like a great reason to do it.  In other analytics products that don’t support nested properties, I always hated needing to use property naming to assert their relationship. e.g.

        product_id: 1,
product_name: 'Shirt',
product_category: 'Clothing',
product_price: 12.60

While it works, it makes browsing properties a bit of a nightmare. 

Does anyone know of any downside in doing this?

@dangrainger Quick question on this.. what type do you set a property to be if you want it to be an object array?

I assume “array” but then what do you set the item to be?  String?  Definitely not intuitive.

I’ve just left that alone, it defaulted to “Any” as the Type for us. That property will grab the full string of the “plan” object array you create...but when you turn on the splitting it’ll create properties for the nested variables (so probably things like plan.id, plan.name, etc in your case)….it’s these variables where I’ve changed the Types to match the value format passed to them.

Thanks.  It’s so odd you can’t turn on property splitting from the onset and have to wait for data to come in. Since splitting isn’t retroactively applied it makes this to be a timing probkem

You could put that to Amplitude as a feature request…

https://help.amplitude.com/hc/en-us/requests/new

Way ahead of you 😉