Query for delivery logs and account activation date | Community
Skip to main content
V
vinay16
Level 4
January 19, 2022
Solved

Query for delivery logs and account activation date

  • January 19, 2022
  • 2 replies
  • 3014 views

I have been trying to filter the records based on few conditions and I'm stuck with 2 different things.

 

1. DateOnly ( event date of recipient delivery logs)  equal to DateOnly(DaysAgo(1))  and delivery code equal to "xyz" -- will this give records who were sent email labelled as "xyz" yesterday ? or this event date of recipient delivery logs also gets updated ? 

 

2. Is there anyway to get account activation date of a recipient? As of now, I can see registration date, creation date. 
       -- I have tried to search if I can pull off activation date. I can't find that entry

       -- Alternative approach, I found that activation email is sent out to the recipient but that one is transactional email. I have tried to fetch records based on "label" of that email but couldn't fetch any records. 

 

Can anyone help for these 2 things ?

 

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

1. EventDate is the date of the open or click. The contactDate is the day the email was SENT to the recipient. Try DateOnly ( contactDate )  equal to DateOnly(DaysAgo(1)) AND Delivery Label == "Delivery Label Name"

 

2. Transactional email logs are found on the archive event delivery logs table (nms:broadLogEventHisto). 

2 replies

david--garcia
david--garcia
Level 10
January 19, 2022

1- Will fetch deliveries whose delivery code is xyz (not delivery label), so if multiple deliveries happen to be configured with the same delivery code, it will pull records for them also.

2- There is no such thing as recipient activation date ootb, unless you add it as a custom field and setup a custom process to update the flag based on a particular action such as email confirmation, double optin, etc etc.

 

 

    V
    vinay16Author
    Level 4
    January 20, 2022

    Thank you for reply.

     

    Can you please confirm what will be the outcome of below?

     

    1 Recipient Delivery logs (@broadLog) exists such as

            DateOnly(event date of recipient delivery logs) equal to DateOnly(DaysAgo(1))

            Delivery code equal to "xyz"

     

    -- Will this give list of people who received email with delivery code "xyz" 1 day ago or will this give list of people who either opened or clicked on email with delivery code "xyz" 1 day ago?

    V
    vinay16Author
    Level 4
    January 26, 2022

    @david--garcia Can you please share your expertise for above queries ?

      David_Loyd
      Adobe Employee
      David_LoydAdobe EmployeeAccepted solution
      Adobe Employee
      January 20, 2022

      1. EventDate is the date of the open or click. The contactDate is the day the email was SENT to the recipient. Try DateOnly ( contactDate )  equal to DateOnly(DaysAgo(1)) AND Delivery Label == "Delivery Label Name"

       

      2. Transactional email logs are found on the archive event delivery logs table (nms:broadLogEventHisto). 

        V
        vinay16Author
        Level 4
        January 20, 2022

        Thank you for reply.

         

        So even if I use

         

        Recipient Delivery logs (@broadLog) exists such as

                DateOnly(event date of recipient delivery logs) equal to DateOnly(DaysAgo(1))

                Delivery code equal to "xyz"

         

        it depends on whether recipient has opened or clicked the email and it won't give the actual delivery date for comparison ? I need to use contact date ?

         

        Sorry for asking his again. I'm just trying to understand the difference. 

        V
        vinay16Author
        Level 4
        January 26, 2022

        @david_loyd Can you please share your expertise for above queries ?

        Terms & ConditionsAccessibility statement

        Loading footer...