Select records created within last 30days
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