Leverage Feed for recommendation based on Category Affinity in Personalization | Community
Skip to main content
JyotiSharmaV
Community Advisor
JyotiSharmaVCommunity Advisor
Community Advisor
October 18, 2023
Solved

Leverage Feed for recommendation based on Category Affinity in Personalization

  • October 18, 2023
  • 1 reply
  • 1837 views

Hi, I am new to building up recommendation activities in Target. I have gone through all the documentation given in Experience League and followed it well. However, one problem I am facing is with the feeds which is an important step to run recommendations. I think the best possible way for us is CSV format to feed product data to Target. However, I am unable to understand the fields in the CSV file format that I downloaded from Target. Here is the sample I am pasting for reference.

## RECSRecommendations Upload File

 

 

 

 

 

 

 

 

 

 

## RECS''## RECS'' indicates a Recommendations pre-process header. Please do not remove these lines.

 

 

 

 

 

 

 

 

 

 

## RECS

 

 

 

 

 

 

 

 

 

 

## RECSUse this file to upload product display information to Recommendations. Each product has its own row. Each line must contain 19 values and if not all are filled a space should be left.

 

 

 

 

 

 

 

 

 

 

## RECSThe last 100 columns (entity.custom1 - entity.custom100) are custom. The name 'customN' can be replaced with a custom name such as 'onSale' or 'brand'.

 

 

 

 

 

 

 

 

 

 

## RECSIf the products already exist in Recommendations then changes uploaded here will override the data in Recommendations. Any new attributes entered here will be added to the product''s entry in Recommendations.

 

 

 

 

 

 

 

 

 

 

## RECSentity.id

entity.name

entity.categoryId

entity.message

entity.thumbnailUrl

entity.value

entity.pageUrl

entity.inventory

entity.margin

entity.custom1

entity.custom2

 

Can you suggest what these fields mean? Does this need a developer to be involved in accomplishing this? What is the best practice/method for feed?

FieldsDescription
## RECSentity.id?
entity.name 
entity.categoryId 
entity.message 
entity.thumbnailUrl 
entity.value 
entity.pageUrl 
entity.inventory 
entity.margin 
entity.custom1 
entity.custom2 
entity.custom3 
entity.custom4 
entity.custom5 
entity.custom6 



    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 Gokul_Agiwal

    Okay, @gokul_agiwal  that means column before entity.custom1, .... are mandatory right?

     

    Also, you missed answering my one question twice about the CSV URL. Where and How to create that feed CSV link?


    HI @jyotisharmav 

    This is the link which shows all steps to create a feed. 

    1 reply

    Gokul_Agiwal
    Community Advisor
    Gokul_AgiwalCommunity Advisor
    Community Advisor
    October 19, 2023

    Hello @jyotisharmav 

    Here the Entities refer to the items you want to recommend. Entities can include products, content (like articles, images, videos etc). 

    So as per CSV format you can mapped the Product information like below 

     

    entity.name Product .name 
    entity.categoryId Product.categoryID
    entity.message Product.message
    entity.thumbnailUrl Product.thumbnailURL
    entity.value Procut.value
    entity.pageUrl  Product.pageURL

     

    And more on you can include upto 100 custom attribute. 

    Here is the more information on Entities for you and Video to watch.

     

     

      JyotiSharmaV
      Community Advisor
      JyotiSharmaVCommunity AdvisorAuthor
      Community Advisor
      October 23, 2023

      Hey @gokul_agiwal , the hyperlink for Entities is not working. The video link you shared just tells how to create a feed but not the CSV file that will go in it. If possible Can you fill the First Row as an example till "entity.custom1" for my reference as it's a little unclear? 

      ## RECSentity.id?
      entity.name 
      entity.categoryId 
      entity.message 
      entity.thumbnailUrl 
      entity.value 
      entity.pageUrl 
      entity.inventory 
      entity.margin 
      entity.custom1

       

      Also, Regarding the URL link in the CSV upload what exactly is that? How to create that feed CSV link and where?

        Gokul_Agiwal
        Community Advisor
        Gokul_AgiwalCommunity Advisor
        Community Advisor
        October 23, 2023

        Hi @jyotisharmav  - Here you go as sample record and the link for the page - 

         

        Below table is like 1 record in your CSV file  ..

        entity.id 67833
        entity.name 
        GIANTS VS ROCKIES 5/12
        entity.categoryId 
        BASEBALL, GIANTS, SF BAY AREA
        entity.message 
        /help/baseball/giants-tix/giantsvrockies5.12.2000-67833
        entity.thumbnailUrl 
        /help/baseball/giants-tix/giants-136px.gif
        entity.value 15.99
        entity.pageUrl 
        /help/baseball/giants-tix/giantsvrockies5.12.2000-67833
        entity.inventory 1
        entity.margin 12.00
        entity.custom1 Sports

         

        Basically you need to connect with your IT team who can provide you all product related database as per your project alignment. 

         

        Hope this helps.  

          Terms & ConditionsAccessibility statement

          Loading footer...