1. Is this structure appropriate for Mixpanel analytics?
Yes, Mixpanel supports sending event properties as arrays of objects (like your products array). According to the documentation, Mixpanel accepts arbitrary JSON as properties, including objects and lists. This means your structure is valid and can be ingested by Mixpanel for analysis. However, keep in mind that while you can send arrays of objects, some advanced features (like profile history) do not support object-type properties, and certain analyses may require you to flatten or extract values from these objects for easier aggregation or segmentation Docs: Events and Properties FAQ.
2. What's the correct custom formula to calculate total tax value across all sold units (taxValueLC × quantity for each product)?
Mixpanel’s custom properties feature allows you to create new properties using formulas, including mathematical operations like multiplication and addition Docs: Custom Properties. However, the documentation does not explicitly state support for iterating over arrays of objects and performing calculations like summing taxValueLC × quantity for each product in the array within a single event.
If you want to analyze total tax value across all sold units, the recommended approach is to calculate this value before sending the event to Mixpanel and include it as a separate numeric property (e.g., total_tax_value). This is because Mixpanel’s formula language is designed for combining scalar properties, not for iterating over arrays of objects within a property.
Summary:
- Your products array structure is supported by Mixpanel.
- To calculate total tax value across all sold units, pre-calculate the sum (taxValueLC × quantity for each product, summed across the array) and send it as a separate property with your event. Mixpanel’s custom properties do not natively support array iteration or aggregation within a single event property Docs: Custom Properties.
If you need to analyze or break down by product attributes, Mixpanel’s Cart Analysis feature can help, but for aggregate calculations like total tax value, pre-calculation is necessary Mixpanel Ecommerce Analytics.
