Adobe Campaign Standard

mmbb110 · 5/23/23

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.

david--garcia · 5/23/23

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.

mmbb110 · 5/24/23

Hi @david--garcia

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?

mmbb110 · 5/24/23

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.

david--garcia · 5/24/23

Indeed, so change the dimension to delivery and identify the attribute that contains the expiry date and apply the same logic.

mmbb110 · 5/24/23

@david--garcia

can you guide me on which one would be appropriate?

david--garcia · 5/24/23

Can you share a screenshot of where/how you are currently checking manually to see which deiveries expires in the future?

mmbb110 · 5/24/23

its actually showing in logs of the delivery.

this is what we want to pick up ahead of time.

mmbb110 · 5/25/23

Hi @david--garcia

could you please help me further on this.

david--garcia · 5/26/23

Hey I believe is the following

[delivery/scheduling/@validityDate]

mmbb110 · 5/28/23

Hi @david--garcia

that option looks like, is for the email sending validity period and not the actual DM expiry which I am looking for.

mmbb110 · 5/29/23

Hi @david--garcia

any help would be much appreciated.

david--garcia · 5/30/23

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

mmbb110 · 5/30/23

Hi @david--garcia

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.

david--garcia · 6/1/23

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

mmbb110 · 6/3/23

Hi @david--garcia

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.