Hi @hopeful_email_tracker,Event date on Delivery logs is the most accurate date for your use case.ThanksDenis

Hi @hopeful_email_tracker it's more or less what you describe, it's not really when the delivery will start (which is the Contact Date on the Delivery) than the actual start of the 1st messages sent and when the last message was sent.... Also, for broadend, I think retry will be into play on that date....the date on the Delivery logs is the date when the message was sent.....note that f a message fail and succeed after 2 or 3 attempts, the event date will be the date of the last events that occu...

Hi @kapilKochar As for documentation on subscription, I don't think there is one but I would more or less duplicate the nms:subscription data schema, adapt to use the new entity (B)The most complex part would be to replicate the methods such as Subscribe/Unsubscribe which you would certainly use in your preference centre if it is provided by ACC....You will have to write a JS Library for these functions... ThanksDenis

Hi @kapilKochar You can create an unique index with your 2-3 fields if required, the trick will be that anytime you want to reconcile using these 3 fields, you would have to ensure you use the fields in the Join clause in the same order than in the index definition otherwise the index won't be used... For custom sequence, you could look at the documentation https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/data-model/data-model-best-practices.html?lang=e...

Hi @kapilKochar If you look at the Target Mapping configuration you will see a series of field you can set to manage the standrd exclusion it is done via DenyListIn your B data schema, you must allow to capture these fields and of course you need to have a field to capture the email address. For ease, you could name these fields same as in nms:recipient The new entity has its own Delivery, Exclusion, and Tracking Logs schema as expected. DESIGN CAUTION:1- Avoid to have a composite fields as a PK...

Hi @JC_JGPLC ToastData table is a Postgres mechanism to store data when data block size exceed a certain size (typical 8KB), since Adobe store large chunks of HTML, it contains mostly information related to Delivery.This is an internal Postgres table and I would not worry to much about it.As you know ACS clears data following its retention policy (usually 6 months). this will not clear much on the Toast Data table. though...What's the size of your Delivery table? IF you have a large volume of de...

Hi @MartinViking You are probably hitting a very unusual scenario on that one as it's very rare to have 2 digit separators in file and the product seems to not support it very well......You could ask the file provider to supply a file with a single digit separator. I found out that pipe | works in most cases.... If a column can potentially hold the pipe (|) character within its value, you will need to use a Double Quote as String separator, meaning that the file will look like the following"colu...

Hi @parmeshwarr3905 My suggestion was more ACC oriented, but would work in ACS too. In ACS, the standard KPI Sharing workflow does not include transactional messages, so you would have to replicate it for transactional messages, certainly doable in ACS too.ThanksDenis

Hi @UserForAdobeCampClass Recipient Tracking Logs is holding the Open (and click) information. As part of the records, you have the user agent the open occur and in the user agent you would have the relevant information, (information is stored in entity nms:userAGent).... You can check the standard report "Breakdown on Open" which will give you hints of devices.Sadly with the new privacy policies by browser and mobile app, you might start to see a load of "Unknown" indicating most likely that th...

Hi @MartinViking For workflows activities, you've got the Audit features available under Administration \ Audit folderFor login, it is available in Experience Cloud Admin Console if you use IMS otherwise, it would be available in the logins.log file for native user login, in the instance directory , this would require some JS script to read the file and extract the information....Hope this helps,ThanksDenis