need help to get daily report | Community
Skip to main content
M
mmbb110
New Participant
May 23, 2023
Question

need help to get daily report

  • May 23, 2023
  • 2 replies
  • 4612 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

    M
    mmbb110Author
    New Participant
    June 26, 2023

    Hi @sukrity_wadhwa 

    could you please guide my issue towards some help.

    david--garcia
    david--garcia
    New Participant
    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.

     

     

    M
    mmbb110Author
    New Participant
    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?

    M
    mmbb110Author
    New Participant
    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.

     

    Terms & ConditionsAccessibility statement

    Loading footer...