please help ,me here
how can we find last delivery sent to all rceipients in adobe campaign via delivery table or broadlogrcp table?
please help what condition we can put in which ytable aand get that data?
Hi @shrutii ,
In Query,
Select targeting and filtering dimension as nms:recipient.
In filtering condition of the query, give, Recipient delivery logs (broadLogRcp) exists and click on finish and save the workflow.
Open the query again > Add data > data linked to the filtering dimension >next> data linked to the filtering dimension > select 'Recipient delivery log (broadLogRcp) [one to many orange link] >next>
data collected: limit the line count
Doubles to keep: 1
>Next>
In Sorting window, select broadLogRcp Event date and select descending as Yes, and in data to extract, select broadLogRcp's primary key and it's event date.
Run the workflow. You will be getting all the recipients who had received delivery earlier and their last delivery received date.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.