Hi Team,
I am looking for some help in getting a daily report of deliveries that are going to expire with the next 7days, I don't see any OOB feature available in ACS for this one.
can someone please guide me further on this.
In a workflow, drag a query activity, configure the properties to resource/target dimension "Campaign"
Use the following expression to look for campaigns ending in the future.
In the additional data add the labels and campaign details you require in the email report.
Then use this data to populate your email template and send the alert.
Views
Replies
Total Likes
Thank you for your assistance on this, instead of campaigns, I can use the target dimension as deliveries correct to filter out just the delivery labels?
Views
Replies
Total Likes
to elaborate my ask, currently when we set up deliveries , we prepare them in advance but they expire before deployment .
as the STR_NMSOPTION_DELIVERY_PENDING_CANCELDELAY is configured to 30 days, the clean up task cancels our deliveries and it is causing a problem.
so we are looking for a some report which can help us identify if there are any deliveries that are set to expire within the next 7 days.
Views
Replies
Total Likes
Indeed, so change the dimension to delivery and identify the attribute that contains the expiry date and apply the same logic.
Views
Replies
Total Likes
Views
Replies
Total Likes
Can you share a screenshot of where/how you are currently checking manually to see which deiveries expires in the future?
Views
Replies
Total Likes
its actually showing in logs of the delivery.
this is what we want to pick up ahead of time.
Views
Replies
Total Likes
Hey I believe is the following
[delivery/scheduling/@validityDate]
Views
Replies
Total Likes
that option looks like, is for the email sending validity period and not the actual DM expiry which I am looking for.
Views
Replies
Total Likes
any help would be much appreciated.
Views
Replies
Total Likes
Hi @mmbb110 that seems to be the correct attribute as per the conditions used to identify expired deliverused used by the database cleanup workflow https://experienceleague.adobe.com/docs/campaign-classic/using/monitoring-campaign-classic/data-proc... , the document is aimed at adobe campaign classic but I believe is the same method for ACS
Views
Replies
Total Likes
i tried using the attribute however it does not display any data in my preview for the query.
I am using as below,
the use case is, I have set up a workflow and prepared a DM , I then stopped the wkf and will schedule it to send at a later date.
I get my DM count in the query , however the preview of the attributes show no values.
please correct me if I am missing something.
Remove all the status filters first, and only leave status is equal to finished.
In your instance delivery settings you can deduct how long delivery resources can be available for and how long a delivery retry period can last, for my instance the resources are available by default for up to 2 months,meaning that my users can view the mirror link for up to 2 months before those are purged, and the message delivery duration is 5 days, meaning tha after 5 days my campaign will stop retrying to execute any soft error deliveries.
That seems to correlate with my validitydate column
Views
Replies
Total Likes
The validity column is aligning correct with the validity limit for a email content to be going out of ACS, the parameter I am looking for is for a scenario where the entire DM gets expired. once that happens you cannot do anything but need to recreate the DM.
Views
Replies
Total Likes
@david--garcia any further help if you can provide it would be great.
Views
Replies
Total Likes
Views
Replies
Total Likes
could you please guide my issue towards some help.
Views
Replies
Total Likes
Views
Likes
Replies