Object Array data interpretation in CJA Reporting

[Harveer_SinghGi1]

Hi All,

I wanted to understand if I send same field value in two different objects in and array with each of these objects containing other different fields, how does CJA interpret this data.

For example, if I sent an event to AEP which had an array field populated as below with a product id information,

{
  "products": [
    {
      "id": "prodID123",
      "count": 5,
      "type": "new"
    },
    {
      "id": "prodID123",
      "count": 3,
      "type": "old"
    }
  ]
}

How will this data be reported in AEP/CJA?

1. I'm assuming products.count against products.id value "prodID123" will show as 8, is that correct?
2. If I create a segment for events which had only one product in them, will this event qualify for it based on unique products.id value "prodID123" or will it not qualify because products field has two objects in it?
3. If I create a segment for events where products.type value is "new" and used it to fetch products.id data, will this return products.count as 5 against products.id value "prodID123" or will it return 8?

Thanks!

[Harveer_SinghGi1 · Accepted solution]

Anybody looking for answers to the questions I asked, I did my own testing and here is what I found,

1. products.count against products.id value "prodID123" shows as 8, CJA does aggregate on value level across events and array objects
2. Based on the unique products.id value, CJA treats it as one product only in the event, so a segment for event with one product will work with example data but segment for 2 or more products won't as it is one unique products.id value so only one product
3. A segment for products.type value is "new" (or "old") used to fetch products.id data will return products.count as 8 against products.id value "prodID123", this is where the issue occurs, there is no way to get separate counts for the products.type values.

Cheers!