Select records created within last 30days | Community
Skip to main content
Level 5
July 23, 2024
Question

Select records created within last 30days

  • July 23, 2024
  • 1 reply
  • 907 views

Hi there,

 

I am creating a report with the targeting and filtering dimensions set to Delivery, aiming to obtain the counts of successful emails, opens, and clicks from indicators

 

However, I specifically want to see the opens and clicks for data where the rec_create_date from another table is within the last 30 days, and those records have received an email.

I used the targeting dimension as Delivery and the filtering dimension as Delivery and tracking logs, applying a condition where rec_create_date (columns from a customer table linked to the recipient table) is within the last 30 days. Despite this, I am still seeing the total counts of emails, opens, and clicks sent on each day within the last 30 days, rather than filtering by the recipients created within this period.

If 8 records were created in the last 30 days and have received an email, how can I get their tracking status, such as unique open/click percentage, not sent, and opt-out? Please advise

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Craig_Thonis
Adobe Employee
Adobe Employee
July 23, 2024

Hi Rvnth,

 

How is your workflow structured? It sounds like you are trying to do this all via a single query activity.

 

If this is the case, I'd recommend trying two separate queries (one on Delivery, the other on Tracking) and then performing a Union on the two with the 30-day constraint.

 

Regards,

Craig

rvnthAuthor
Level 5
July 23, 2024

Hi @craig_thonis ,

 

It has to be either an intersection or a union. Please confirm.

 

Currently, I am using the recipient as the target dimension and filtering on recipient delivery logs. When I added additional columns from Delivery > Indicators, it started fetching all the sent emails, not just the specific 8 records I tried to fetch from the broadlog query activity.

please suggest. Thank you in advance

Sukrity_Wadhwa
Community Manager
Community Manager
August 12, 2024

Hi @craig_thonis,

Can you please help @rvnth further here?
Thanks!

Sukrity Wadhwa