Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

same color for recommend product

Avatar

Level 1

scenario : If the customer buys red products, we want to recommend red items.
So how to set recommend product color as same as recipient product color in adobe campaign client console 
??

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @mukeshpurushothaman ,

 

There can be many way to implement it. It depends on your data and use case.

For e.g. you can try the following steps: 

1. Create a new attribute "lastPurchasedItemColor" in recipient table.

2. In the product table, create a filed filed "colorOfProduct".

3. Create a workflow which may run every day, there your query order table to  get the last purchased product, from there you can insert the last purchased product color value in recipient field "lastPurchasedItemColor".

4. Create your business workflow in campaign where you can setup a link between recipient and product table based on lastPurchasedColor and other criteria ( for e.g. number of product/ Propensity to buy) and it will give you list of recommended product of same color. 

 

Thanks, 

Parvesh

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

Hello @mukeshpurushothaman ,

 

There can be many way to implement it. It depends on your data and use case.

For e.g. you can try the following steps: 

1. Create a new attribute "lastPurchasedItemColor" in recipient table.

2. In the product table, create a filed filed "colorOfProduct".

3. Create a workflow which may run every day, there your query order table to  get the last purchased product, from there you can insert the last purchased product color value in recipient field "lastPurchasedItemColor".

4. Create your business workflow in campaign where you can setup a link between recipient and product table based on lastPurchasedColor and other criteria ( for e.g. number of product/ Propensity to buy) and it will give you list of recommended product of same color. 

 

Thanks, 

Parvesh

Avatar

Community Advisor

Hello @mukeshpurushothaman , 

 

You can use enrichment activity to setup a link between recipient and productTable based on color. 

You need to setup 1 to N link, then you would get all product of same color. 

 

Note: You need to exclude the product which already purchased, If  you do not want to show this product.  otherwise you would get the same product again, because it has the same color.  

 

1. Add a enrichment activity and setup a link: 

   

Parvesh_Parmar_0-1683193430970.png

 

2.  Select the product scheme: 

Parvesh_Parmar_1-1683193664188.png

3. In the next screen, you can add condition based on color. 

 

You can use the enumeration for Product table as mentioned by @david--garcia in last comment. 

 

Thanks, 

Parvesh

 

 

 

 

Avatar

Community Advisor

Create an enumeration in your product's schema

 

  <enumeration basetype="byte" name="cusColorProfile">
    <value label="White" name="white" value="0"/>
    <value label="Yellow" name="yellow" value="1"/>
    <value label="Red" name="red" value="2"/>
    <value label="Blue" name="blue" value="3"/>
    <value label="Brown" name="brown" value="4"/>
    <value label="Purple" name="purple" value="5"/>
  </enumeration>

 

And a new attribute to assign enum.

 

    <attribute enum="<namespace>:<yourschema>:cusColorProfile" label="Color Profile" name="colorProfile" sqlDefault="0" type="byte"/>

 

 Each product must be assigned a color, however, by default they will be assigned White or 0, you can name it "Unassigned" or "Neutral"

 

In theory your orders/purchases will inherit/reference the product purchase colorProfile, hence, you could recommend products belonging to the same colorProfile, you may want to include additional conditions such as price range based on historical product purchases data.

 

I don't think you need to assign a color to your profile, but rather go through the order history / purchases to get the colorProfile of products purchased in the past. anyways, to learn how to create a link visit the following documentation video.

https://helpx.adobe.com/campaign/classic/how-to/links-between-tables-in-acv6.html