Discussions

Insight: How to get latest date by contact

MikaelBMikaelB Posts: 1
edited August 11 in Developer Tools

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.

Post edited by Unknown User on
Tagged:

Answers

  • Ioana CovaliIoana Covali Posts: 3 Green Ribbon

    Hello,

    Here is an idea: Create a report in Insight with all these fields (Unique_ID, DATETIME, EMAIL_ADDRESS, STATUS1, STATUS2), and change the formula for DATETIME. Click on the gear right next to your DATETIME field -> Select edit formula -> Embed the default content you have there into a MAX() function. The result should look like this: MAX("Contacts"."Contact Custom Object"."DATETIME").

    Note: In the formula editor, if you click on f(...), you will find various functions. The MAX() function is in the Aggregate folder.

Sign In or Register to comment.