Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

Eliminate quarantine emails up front

Avatar

Level 1

How can I join to the Address table to identify the quarantines so I can eliminate them from the population prior to the delivery?

 

The way the workflow is currently written, we read an imported table that contains the recipient ID, change dimension to recipient table, then eliminate quarantines. I'm not finding the correct join method to get to the Status field in the Address table. Every way I've tried ends in Status 4 cannot be resolved. Thanks.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @n235ps ,

After changing the dimension to recipient (Recipient as Targeting dimension), try the below workflow logic,

ParthaSarathy_6-1693982535657.png

 

 

Enrichment:

Add data > a link >
Link type: Define a link whose target may not exist in database
Link Target: Database schema
target schema: nms:address

ParthaSarathy_1-1693981904350.png

Next > Use a simple join,

If you are performing Email campaign,

Source expression: [target/@email]

Destination expression: @address

ParthaSarathy_2-1693982040423.png > Finish

 

Whereas, if you do SMS campaign, select source as [target/@mobilePhone]

 

Save the workflow, open 'Enrichment' activity again, Edit additional data > add [address/@status] in output columns.

ParthaSarathy_3-1693982199148.png

 

Split:

General tab > configure as below

ParthaSarathy_4-1693982284451.png

 

Subsets tab > select 'Add a filtering condition' radio button > Edit >

@status EQUALS TO Quarantine

ParthaSarathy_5-1693982379677.png

 

Connect delivery to the complement transition of Split activity.

So all the quarantine records will be eliminated prior to the delivery.

 

 

 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi @n235ps ,

After changing the dimension to recipient (Recipient as Targeting dimension), try the below workflow logic,

ParthaSarathy_6-1693982535657.png

 

 

Enrichment:

Add data > a link >
Link type: Define a link whose target may not exist in database
Link Target: Database schema
target schema: nms:address

ParthaSarathy_1-1693981904350.png

Next > Use a simple join,

If you are performing Email campaign,

Source expression: [target/@email]

Destination expression: @address

ParthaSarathy_2-1693982040423.png > Finish

 

Whereas, if you do SMS campaign, select source as [target/@mobilePhone]

 

Save the workflow, open 'Enrichment' activity again, Edit additional data > add [address/@status] in output columns.

ParthaSarathy_3-1693982199148.png

 

Split:

General tab > configure as below

ParthaSarathy_4-1693982284451.png

 

Subsets tab > select 'Add a filtering condition' radio button > Edit >

@status EQUALS TO Quarantine

ParthaSarathy_5-1693982379677.png

 

Connect delivery to the complement transition of Split activity.

So all the quarantine records will be eliminated prior to the delivery.