Sample CSV for Adobe target | Adobe Higher Education
Skip to main content
December 5, 2017
解決済み

Sample CSV for Adobe target

  • December 5, 2017
  • 4 の返信
  • 5474 ビュー

Hi Team,

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

Regards,

Swarnendu

このトピックへの返信は締め切られました。
ベストアンサー JonTehero

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.

4 の返信

Amelia_Waliany
Adobe Employee
Adobe Employee
December 5, 2017

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!

December 7, 2017

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

December 7, 2017

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

JonTeheroAdobe Employee回答
Adobe Employee
December 8, 2017

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.

New Member
September 19, 2024

Thank you for your reply. It worked for me as well.