broadstart vs tsevent | Community
Skip to main content
H
hopeful_email_tracker
Level 2
June 28, 2022
Solved

broadstart vs tsevent

  • June 28, 2022
  • 1 reply
  • 1137 views

Hi All!

 

Another question for everyone, what are the primary differences between the nmsdelivery table's broadstart and the nmsbroadlogrcp table's event columns? As far as I understand it broadstart and broadend correspond to the datetime in which an email campaign is set to begin and end, whereas event is the date in which the email associated with the broadlogid is sent. Is that correct or are there other caveats/details to consider?

 

Thanks!

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 costa_n11

Hi @hopeful_email_tracker 

it's more or less what you describe, it's not really when the delivery will start (which is the Contact Date on the Delivery) than the actual start of the 1st messages sent and when the last message was sent.... Also, for broadend, I think retry will be into play on that date....

the date on the Delivery logs is the date when the message was sent.....note that f a message fail and succeed after 2 or 3 attempts, the event date will be the date of the last events that occur, aka the date of the last retry...

What use case would you have on these different dates?

Thanks

Denis

1 reply

C
Adobe Employee
costa_n11Adobe EmployeeAccepted solution
Adobe Employee
June 30, 2022

Hi @hopeful_email_tracker 

it's more or less what you describe, it's not really when the delivery will start (which is the Contact Date on the Delivery) than the actual start of the 1st messages sent and when the last message was sent.... Also, for broadend, I think retry will be into play on that date....

the date on the Delivery logs is the date when the message was sent.....note that f a message fail and succeed after 2 or 3 attempts, the event date will be the date of the last events that occur, aka the date of the last retry...

What use case would you have on these different dates?

Thanks

Denis

    H
    hopeful_email_trackerAuthor
    Level 2
    June 30, 2022

    Thanks for responding Denis! 

     

    The main use case is segmenting emails by month, quarter, etc. I'm trying to figure out which datetime data will provide the most accurate information regarding when a specific email (and from that I'm focusing on broadlogids) is sent. In looking at the data I see differences where a slew of emails all under the same deliveryid have the same broadstart datetime, but the emails have different event datetimes. As such I wanted to understand the difference here and find out which of the many indicators would provide what I'm looking for. So if you could shed any additional light on that or direct me to additional documentation I'd greatly appreciate it!

    C
    Adobe Employee
    costa_n11Adobe Employee
    Adobe Employee
    July 1, 2022

    Hi @hopeful_email_tracker,

    Event date on Delivery logs is the most accurate date for your use case.

    Thanks

    Denis

      Terms & ConditionsAccessibility statement

      Loading footer...