Need advice on how to get specific data in CJA workspace based on my data layer design and schema design | Community
Skip to main content
Level 4
February 12, 2025
Solved

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

  • February 12, 2025
  • 2 replies
  • 477 views

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!

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Harveer_SinghGi1

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!

2 replies

Harveer_SinghGi1
Adobe Champion and Community Advisor
Harveer_SinghGi1Adobe Champion and Community AdvisorAccepted solution
Adobe Champion and Community Advisor
February 12, 2025

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!

Level 4
February 12, 2025

Thank you again! You are very helpful!