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

Filtering Dimension for efficient queries in ACS

Avatar

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 3
davidh2892249
Level 3

Likes

16 likes

Total Posts

131 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidh2892249
Level 3

04-02-2021

Hi there,

 

I have a data model with the following relationship

 

Profile 1 ---> n orders 1 --> n order items

 

In Adobe Campaign Classic there was the concept of "filtering dimension" which could be selected to filter your targeting dimension (usually recipients) using linked data, such as orders. And I understood this to be more efficient that "Orders exist such as"

 

Is there anything similar in ACS?

 

What is the most efficient way to target someone that has ordered a specific SKU other than starting with Profiles as the resource:

 

Orders exist such as:

   Order Items exist such as
       SKU = XXXX

 

I'm dealing with fairly large data sets in each of the tables, so keen for it to be as efficient as possible (but really needs to be done through the audiences/query builder for practical reasons)

 

Thanks in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 5
Employee
denisb91363072
Employee

Likes

8 likes

Total Posts

28 posts

Correct Reply

6 solutions
Top badges earned
Boost 5
Affirm 5
Boost 3
Boost 1
Affirm 3
View profile

Avatar
Boost 5
Employee
denisb91363072
Employee

Likes

8 likes

Total Posts

28 posts

Correct Reply

6 solutions
Top badges earned
Boost 5
Affirm 5
Boost 3
Boost 1
Affirm 3
View profile
denisb91363072
Employee

10-02-2021

Hi David,

 

Yes there is, it is on the Property tab of a Query activity

Now your data model should ensure you have the link to Profile available from Order and From Order Item (make sure you've got an index too), this will allow you to filter on Order Item and return the Profile as Target dimension. See sample of Query activity below

denisb91363072_0-1612961060429.png

 

The most efficient way to query is to start by the lowest end, aka Order Item in your case (or Order if you're not interested in products bought) and ensure your target Dimension is Profile. To ensure Profile is visible in the Targeting dimension, you would have to create a 0-1 or 1-1 link between the Filtering resource (Order or Order Item) and Profile.... Having a direct relation between Order Item and Profile is not natural but if you want efficiency, that's the way to go otherwise you'll have to traverse the Order to get the Profile which is not efficient at all

 

Hope this helps

 

Denis.