QUERY TRANSACTIONAL MESSAGE

[bcollado1]

Hi,

I want to create a query with the following conditions: all users who have received the transactional message "registration3" but did not open it.

I have created this one you can see below but it always comes to zero results and I do not knowwhy as I look into the delivery and it has interactions... 😞

Can someone help me to find the mistake? Thanks in advance 🙂

Kind regards,

B

[ParthaSarathy · Accepted solution]

Hi @bcollado1 ,

In Query, Select Targeting dimension and Filtering dimension as nms:broadLogEventHisto

Filtering Condition:

Right click the Folder > Properties > Copy the internalName.

Consider the internal name is DM930

@status equal to sent

AND

[delivery/folder/@name] equal to DM930

AND
trackingLog Do not exist such as

[delivery/folder/@name] equal to DM930

[bcollado1]

Hi,

thank you very much for your help 🙂

One last question about it, if I want to leave this workflow executing everyday, I want to add to the query the following: users created one day ago as I want to send them an email 24h after their creation.

Is this way ok?

Thank you very much as always 🙂

Kind regards,

B

[bcollado1]

or maybe could it be like this?

[ParthaSarathy]

@bcollado1 , you can try as

DateOnly(@eventDate) equal to DateOnly(DaysAgo(1))

[bcollado1]

Thank you very much!!! 🙂

have a good day and kind regards