4 Replies Latest reply on Dec 8, 2017 3:52 PM by Jon Tehero

    Sample CSV for Adobe target

    wvrt19693273

      Hi Team,

       

      Could you please provide me a sample csv file for Adobe target.

       

      Regards,

      Swarnendu

        • 1. Re: Sample CSV for Adobe target
          ameliaw95025277 Adobe Employee

          Hi Swanendu, thanks for your question! Check out the Adobe Target Documentation article on Downloading Data in a CSV File - this might have some helpful information for you. Feel free to reach out here if you have any other questions. Hope this helps!

          • 2. Re: Sample CSV for Adobe target
            wvrt19693273 Level 1

            Hi Team,

            I am talking about the data feed file which we need to upload in the below mentioned page.

             

             

            It will be helpful for me if you provide me a sample copy of the file which will be acceptable in this site.

             

            Regards,

            Swarnendu

            • 3. Re: Sample CSV for Adobe target
              wvrt19693273 Level 1

              Hi Team,

               

              Apologies, I was not specific about the issue. Please find below more details.

               

              I am trying to create a csv feed file but not sure about the data required to prepare this file. That will be uploaded to SFTP and consumed/processed by feed engine processor at you end. This is to enable smarter merchandising online and for product recommendations. The functionality opens up opportunity to cross-sell and up-sell product and provide better product recommendations to drive conversions.

               

              Please find below sample csv data fields:

              - Accommodation type

              - Accommodation name
              - Accommodation ID
              - Accommodation URL
              - Accommodation image
              - Accommodation price
              - Accommodation discount
              - Accommodation rating
              - Accommodation review rating
              - Site name
              - Site ID
              - Site URL
              - Site image
              - Site price
              - Site review rating
              - Site region location

              • 4. Re: Sample CSV for Adobe target
                Jon Tehero Adobe Employee

                Hello,

                 

                I've taken the fields you indicated and added them our a sample csv download file.

                ## 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.accommodationType,entity.accommodationName,entity.accommodationID,entity.accommodationURL,entity.accommodationImage,entity.accommodationPrice,entity.accommodationDiscount,entity.accommodationRating,entity.accommodationReviewRating,entity.siteName,entity.siteID,entity.siteURL,entity.siteImage,entity.sitePrice,entity.siteReviewRating,entity.siteRegionLocation
                sampleEntityId-01,,,,,,,,,,,,,,,,,,,,,,,,
                sampleEntityId-02,,,,,,,,,,,,,,,,,,,,,,,,
                

                 

                 

                The first nine columns on the left need to be in that exact order. All other columns (custom columns) can be in whatever order you prefer.

                 

                Each row MUST have an entity.id. All other values are optional. More details can be found here: Uploading Entities to Recommendations

                 

                I hope that helps.

                1 person found this helpful