- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Delivery-> Delivery Scheduling -> Contact Date = is the date the email was sent to the recipient.
broadLogRcp -> Event Date = is the date of an Open or a Click.
broadLogRcp -> Url - > Type = Lets you pick between Opens or Clicks
If you use DateOnly(@eventDate) equal to DateOnly(DaysAgo(3)), this is only getting you that 1 day 3 days ago. If you want all records in the last 3 days DateOnly(@eventDate) is on or after DateOnly(DaysAgo(3))
If you are not sure of the event date, that can be an issue. You could potentially be using that date field incorrectly.
If you want to query people who have opened yesterdays email it would be like
1.Delivery Internal Name is equal to DM123456
2.Tracking logs exist such that
a.delivery/URL/Type = Open
b.logDate = DateOnly(@eventDate) is on or after DateOnly(DaysAgo(1))