Need advice on how to get specific data in CJA workspace based on my data layer design and schema design

[MichaelJo13]

Hi All,

I'm capturing info about clicked on names. I'm also capturing info about 4 specific actions that can be associated with a specific name. Here is how this data is pushed:

adobeDataLayer.push({

        event: "personAction",

       personInfo: {

              personName: "Bobby", //mandatory

              favorited: 0, //non-mandatory

              unfavorited: 0, //non-mandatory

              moreInfo: 0, //non-mandatory

              shared: 0 //non-mandatory

      }

});

The thinking behind this is if a someone just clicks on a person's name, all the other properties are zero. This signifies that a name was clicked on by the user. If a user takes any other action, for example favorites a name, then the "favorited" property will have a 1. Only one of the non-mandatory fields will have a 1, at a given time. Here is my question. In the reporting, I want to have reports that show the names and instances of any of the non-mandatory properties. For example, a report that shows the names and instances of all names that were "favorited". Would I need to store the favorited name in a "favoriteName" field in my schema to achieve this or is there another way to achieve this without adding extra fields to my schema? 

Thanks!

[Harveer_SinghGi1 · Accepted solution]

Hi @MichaelJo13 ,

You can achieve this with the current ACDL design you have. What you need to do is track the personName as string in XDM and all other fields as integers. When you bring this data to CJA, you can run the report for personName and all other fields can be applied as metrics. So with single personName report you can associate all the user actions as metrics.

Cheers!

[MichaelJo13]

Thank you again! You are very helpful!