Properties in Query

[Kunal_BabasahebDe]

Hi team
In a query, there is a properties tab, and after clicking on it, an Additional Column window appears. Can you advise how it works? The General Parameters section shows Data Collected and Lines to Retrieve, and the output result also changes after making changes there. Also, when I open, I can see columns to create as 3 when I change it query result changes.

I am trying to query below - Recipients who did not open any delivery in the last 7 days. I want to filter recipients who didn’t open an email in the last 7 days.

Kindly help me understand how it works, preferably with an example. and what is the best practice to follow with use cases.

[ParthaSarathy]

Hi @Kunal_BabasahebDe ,

In Query, select targeting and filtering dimension as recipient and have the below filtering condition:

trackingLog do not exist such as

DateOnly(@logDate) on or after DateOnly(DaysAgo(7))

You can refer this document for details regarding 'Add data'

[Kunal_BabasahebDe]

Hi @ParthaSarathy 

Thank you for helping with my query. However, my doubt concerns the Properties tab. After clicking on it, an Additional Column window appears. Can you advise how it works? The General Parameters section shows "Data Collected" and "Lines to Retrieve," and the output result changes after making adjustments there. Additionally, when I open it, I can see that the number of columns to create is three, and when I change it, the query result also changes.

Kindly help me with an eg.

[Kunal_BabasahebDe]

Hi @ParthaSarathy ,

Kindly help for above question.