Exclude records based on the event date of Broadlog | Adobe Higher Education
Skip to main content
Level 5
May 20, 2024
Répondu

Exclude records based on the event date of Broadlog

Hi Team, 

I wanted to exclude records where the rec create date of feature schema is less than then broad log event date. There was a join between recipient schema and feature schema. First I tried querying the recipient delivery logs by keeping rcipient as target dimension and then later added one more query activity and selected temporary schema as the previous broadlog query activity which is giving me 0 records. Please suggest on how to get the records where the event date is greater than the rec_create_date of feature schema. Thank you in advance. Please can you make me understand how the below query activities why it was fetching 0 records
 

 

 

I tried something as below by using the filtering dimension as feature schema & targeting dimension as recipient. Will this fetch me the correct amount of records.

 

Ce sujet a été fermé aux réponses.
Meilleure réponse par Craig_Thonis

Hi rvnth,

If possible, I might suggest using a different field other than the event date. The event date field is subject to asynchronous events, which can update the date. So even if the workflow returns the desired results initially, you may see some irregularities in the results.

1 commentaire

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeRéponse
Adobe Employee
May 20, 2024

Hi rvnth,

If possible, I might suggest using a different field other than the event date. The event date field is subject to asynchronous events, which can update the date. So even if the workflow returns the desired results initially, you may see some irregularities in the results.