need help to get daily report | Community
Skip to main content
Level 9
May 23, 2023
Question

need help to get daily report

  • May 23, 2023
  • 2 replies
  • 4618 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

david--garcia
Level 10
May 23, 2023

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.

 

 

mmbb110Author
Level 9
May 24, 2023

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?

mmbb110Author
Level 9
May 24, 2023

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.

 

mmbb110Author
Level 9
June 26, 2023

Hi @sukrity_wadhwa 

could you please guide my issue towards some help.