Add Data to Temporary Table

Avatar

Avatar

pavlinao8032150

Avatar

pavlinao8032150

pavlinao8032150

21-10-2016

Hello team,

I am trying to create the following split:

1047887_pastedImage_0.png

For this purpose, in the query activity I have my Targeting and Filtering Dimensions set to Recipients and filtered for those whose LTV is greater than 0.

I want to add the actual LTV to the temporary table so that I can make my split based on the value.

So, I click on Add data..., then Data linked to the filtering dimension.


Question:

Is there any difference in those two approaches?

1) Select "Data of the filtering dimension", then from the linked table Summary of purchases - Life Time Value

1047888_pastedImage_2.png

1047889_pastedImage_6.png

1047902_pastedImage_15.png

OR

2) Select "Data linked the filtering dimension", I see the linked table Summary of Purchases

1047891_pastedImage_10.png

1047896_pastedImage_11.png

1047898_pastedImage_14.png

1047897_pastedImage_13.png

According to my testing, no difference in the two approaches. Perhaps the first one is slightly faster to set up. Am I right?

Thanks for your help.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

21-10-2016

Hi Pavlina,

Since the two tables have a 1:1 linking between them, you should opt for the first method which is to pick Data of the filtering dimension.

This will create a JOIN query between two tables and hence will perform faster.

Second method should be used when you are planning to query on 1:N link.

Hope this helps.

Regards,

Vipul Raghav

Answers (0)