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

Filtering Dimension - Segmentation

Avatar

Level 2

Hello,

is there any difference in the following two approaches when creating segmentation that should show the last 3 transactions for each recipient:

1) Targeting dimension: Recipients

     Filtering dimension: Recipients

     Add data...Data linked to the filtering dimention

or

2) Targeting dimension: Recipients

     Filtering dimension: History of transactions

     Add data...Data of the filtering dimention

Regards,

Pavlina

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hi Pavlina,

Both approaches are correct.

Major difference will be the type of SQL query generated in background.

Option two will generate a JOIN query which is far more effective when it comes to working on huge volumes.

Hope this helps. If you find the answer to be correct, please mark it as the correct answer so that others can benefit out of it.

Regards,

Vipul Raghav

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

Hi Pavlina,

Both approaches are correct.

Major difference will be the type of SQL query generated in background.

Option two will generate a JOIN query which is far more effective when it comes to working on huge volumes.

Hope this helps. If you find the answer to be correct, please mark it as the correct answer so that others can benefit out of it.

Regards,

Vipul Raghav