QUERY TRANSACTIONAL MESSAGE | Community
Skip to main content
B
bcollado1
Level 2
October 23, 2023
Solved

QUERY TRANSACTIONAL MESSAGE

  • October 23, 2023
  • 1 reply
  • 1284 views

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

 

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 ParthaSarathy

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

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
October 23, 2023

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

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    B
    bcollado1Author
    Level 2
    October 24, 2023

    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

     

    B
    bcollado1Author
    Level 2
    October 24, 2023

    or maybe could it be like this?

     

     

    Terms & ConditionsAccessibility statement

    Loading footer...