Add Data to Temporary Table

Avatar

Avatar
Validate 1
Level 2
pavlinao8032150
Level 2

Likes

6 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
pavlinao8032150
Level 2

Likes

6 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
pavlinao8032150
Level 2

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
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
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)