Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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