broadstart vs tsevent

[hopeful_email_tracker]

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!

[Denis_Bozonnet · Accepted solution]

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

[hopeful_email_tracker]

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!

[Denis_Bozonnet]

Hi @hopeful_email_tracker,

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

Thanks

Denis