- 3,675,605 Users
- 11,591 Discussions
- 18,508 Comments
Insight: How to get latest date by contact
In eloqua insight, using cdo data to get latest date status by contact.
Rows are updated to cdo data as events trigger for contact. So one contact can have multiple events with UNIQUE_ID and DATETIME.
QUESTION: How to get latest row for all contacts( EMAIL_ADDRESS ) in insight analysis, so we can get the latest statuses checked.
CDO columns are UNIQUE_ID, DATETIME, EMAIL_ADDRESS, STATUS1, STATUS2.