Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

how can we find last delivery sent to all rceipients in adobe campaign via delivery table or broadlogrcp table?

Avatar

Level 4

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

ParthaSarathy_0-1692596126681.png

 

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.

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

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.

ParthaSarathy_0-1692596126681.png

 

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.

Avatar

Level 4

Hi Parth,thank you for reply but i need last modified date means i need only last date on which delivery is being sent to receipent,,,please help, how caan i get only last date on which delivery (max )is being sent to receipent, earlier ones i dont want

Avatar

Level 4

HI @ParthaSarathy 

Hi Parth,thank you for reply but i need last modified date means i need only last date on which delivery is being sent to receipent,,,please help, how caan i get only last date on which delivery (max )is being sent to receipent, earlier ones i dont want

NOTE: i DONT NEED all delivery sent to one receipient earlier

i only need LAST delivery sent to one receinpt

 

WHAT IS THE actiivty or setup i have to do now for getting ONLY last delivery received DATE  for each receipeint???????/

Avatar

Community Advisor

@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.

ParthaSarathy_1-1692596273107.png

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]

ParthaSarathy_2-1692596434017.png

data collected: limit the line count

Lines to Retrieve: 1

ParthaSarathy_3-1692596515922.png

(Ignore Filtering window, click next)

In Sorting window, select broadLogRcp Event date and select descending as Yes

ParthaSarathy_4-1692596600102.png

 

In data to add, select broadLogRcp's primary key and it's event date. You can also select [delivery/@label]ParthaSarathy_5-1692596671592.png

 

Run the workflow and right click the Query's output transition and select 'display the target'..

ParthaSarathy_6-1692596903102.png

 

As you had selected 'Event date' in sorting, and selected Descending as 'Yes', in output of query, you will receive the latest delivery received by recipient (Last delivery sent to a recipient) with its event date (date of delivery received)