same color for recommend product | Community
Skip to main content
M
mukeshpurushothaman
May 4, 2023
Solved

same color for recommend product

  • May 4, 2023
  • 2 replies
  • 934 views

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 ??

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Parvesh_Parmar

    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

    2 replies

    Parvesh_Parmar
    Community Advisor
    Parvesh_ParmarCommunity AdvisorAccepted solution
    Community Advisor
    May 4, 2023

    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

    Parvesh Parmar – Adobe Community Advisor https://www.linkedin.com/in/parvesh-parmar/
      M
      mukeshpurushothamanAuthor
      May 4, 2023

      Hello @parvesh_parmar, 

       

      May I how to link Recipient and product table ?

      Parvesh_Parmar
      Community Advisor
      Parvesh_ParmarCommunity Advisor
      Community Advisor
      May 4, 2023

      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: 

         

       

      2.  Select the product scheme: 

      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

       

       

       

       

      Parvesh Parmar – Adobe Community Advisor https://www.linkedin.com/in/parvesh-parmar/
        david--garcia
        david--garcia
        Level 10
        May 4, 2023

        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

          Terms & ConditionsAccessibility statement

          Loading footer...