Hi @DishaSharma , Refer to the following link for more information. https://helpx.adobe.com/campaign/classic/how-to/compute-aggreates-in-acv6.html

Hi @god_prophet , There are multiple ways of achieving this. Using a workflow, you can query the broadlogRcp schema or the custom delivery log schema (if you created one) and then take the count of messages that were sent. 

Hi @DishaSharma , Refer to the below documentation for the same. https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/targeting-activities/subscription-services.html?lang=en

Hi @god_prophet , The SMS content of the delivery will be saved in the xml field in the delivery. However, the SMS content will not be personalized. Personalized SMS content is not saved in Adobe Campaign.  

Hi @Fabrice01 , The offer can be created in multiple representations.  Based on how the offer is used, you can add the offer content in JSON or HTML format. Hence the banner could be added as an HTML for example and then displayed in the required application.

Hi @Fabrice01 , Since offer decision rules follow pql syntax, you could explore using pql functions like currentDayOfWeek() = 1 for referring to Monday. Hence irrespective of any other conditions, the offer becomes eligible only on Monday. 

Just one call out, reaction event seems to work only for Email and Push. It does not seem to work with custom actions. Hence usage of reaction activity might not work.  The customer can use profile update activity to update the count of emails or SMS sent for the week if all custom actions are consi...

Hi @ShashiCh, PQL by definition works on individual profile-level data and not at a dataset level.However, what you are referring to is sorting the data at a dataset level and then applying data split. Hence pql will not be able to support it. You can consider using a data distiller to create a new ...

Hi @Sanjana12 , Refer to this post for making the data type of id from 32-bit to 64-bit integer. This will increase the value.Raise a support ticket with Adobe as changing the ootb schemas sequence needs to be done with care.

Hi @saurabh99, You can perform a Cartesian join using an enrichment activity. In this case, you can join the product schema with itself using the condition as 1=1 i.e., both the source and target values are hard coded as 1. This will yield additional records where the linked data is all blank. You c...