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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Add Data to Temporary Table

pavlinao8032150
Level 2
Level 2

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.

1 Accepted Solution
Vapsy
Correct answer by
Employee
Employee

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

View solution in original post

1 Reply
Vapsy
Correct answer by
Employee
Employee

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

View solution in original post