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

need help to get daily report

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

     

     

    M
    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?

    M
    mmbb110Author
    Level 9
    May 30, 2023

    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-processing/database-cleanup-workflow.html?lang=en#cleanup-of-expired-deliveries , the document is aimed at adobe campaign classic but I believe is the same method for ACS

     

     


    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.

      M
      mmbb110Author
      Level 9
      June 26, 2023

      Hi @sukrity_wadhwa 

      could you please guide my issue towards some help.

      Terms & ConditionsAccessibility statement

      Loading footer...