Expand my Community achievements bar.

SOLVED

Merge Adobe Audience list and ACM schema query

Avatar

Level 1

Hi,

 

I have imported a Audience segment from AAM to profiles and target list. I did add the segment list into one of my campaign query selection criteria. on top of that I am adding a impression logic from proposition table which is ACM OOTB schema. If I click preview data I could not be able to see the data once I combine the the list and the query. I am getting an error Element group is unknown. XTK170036 unable to parse expression.

Pls let me know if we can combine the list and the query. 

 

Thanks

Ramanan S

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Ramanansathiaseelan ,

probably not in one node.

You should create one node for the list, one for the query and then use Intersection/Union node depending what you further need.

Other way bbe to do everything in one SQL node.

 

Regards,

Milan

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

Hi @Ramanansathiaseelan ,

probably not in one node.

You should create one node for the list, one for the query and then use Intersection/Union node depending what you further need.

Other way bbe to do everything in one SQL node.

 

Regards,

Milan

Thanks for your response. But this one I am not doing via workflow. I am adding this in offer campaign under eligibility criteria and edit query section. I am not able to edit and add the next query once I added the list from profiles and targets.

Avatar

Community Advisor
Hi @Ramanansathiaseelan, now is more clear. Well, you may use a workflow like preparation to define the final list (intersection between query and initial AA list) which can be selected in offer engine eligibility always. Workflow will just keep that list up to date if scheduled periodicaly. Regards, Milan
Hi Milan, Thanks I got it. But I would like to add the frequency logic to suppress the audience after they see the campaign 3 times and click on 1 time. If we setup this through workflow and I don't think this can be done as real time. I need to schedule the workflow to update the audience list and suppress them based on the disposition. Also the new target audience will flow from AA to ACM everyone hour. That also needs to be considered.