Yahoo! JAPAN Ads

Yahoo! JAPAN Ads Help

Create Item list file (Dynamic Ads for Display)

"Dynamic Ads for Display" in display ads requires uploading an item list file that includes your product information.

This page describes the requirements of the item list file.

Specifications of the item list file
Items in the item list
Note for creating an item list file

 

Note
"Dynamic Ads for Display" is available for specific advertisers. Customers who meet the following conditions cannot use this service.
-The campaign goal ”item list promotion” is not displayed on the campaign management tool when creating a campaign.
Tips

To create and upload the item list file, tools provided by Yahoo! JAPAN Ads partners are available.
For more details, ask our sales representatives.

Specifications of the item list file

Confirm the specification of the item list file as follows.

Items

Specifications

Character code

UTF-8 (no BOM), Shift JIS

Delimiter

Tab-separated (tsv)

Line feed code

LF, CRLF

File format

zip or tsv

File size

Up to 60 MB per upload
*Periodic upload in tsv format supports up to 150 MB per upload.

Sheet

The header on the first row, and product information after the second row.

Number of items

Up to 300,000 items

Number of uploads per day
All updates and partial updates are counted separately. You can upload up to 4 uploads each per day. Counting a failed uploading as one upload.
Note
  • Files with different character codes or line feed codes will cause file format errors and can't be uploaded.
  • Double-byte characters cannot be used in the file name.

Items in the Item list

Enter the header on the first row of the item list and product information on the second row of the list. Confirm the following Insertion Rules for the details of entry items on the item list file.
Dynamic Ads for Display - 1. Data feed (Item list) [Guidelines]

 
Tips

The item list file template is available on the "Tools" tab > "Item List" dialog on the Campaign Management Tool.
It will help you to avoid header errors and so on.
Click the "Update item list" button on the item list screen, then click "Download the template for upload" on the next screen.

Rules for entering item list files

Don't remove the header name. Don't enclose the header name with " " (double quotation marks)

You can't remove the header name on the item list file. For the unnecessary item, enter the header name on the first row and leave other rows blank. Don't enclose the header name with " " (double quotation marks).

Don't create multiple rows for the same item ID.

If multiple rows exist for one item ID, we cannot guarantee which row will be applied in the ad displayed.

Even if the item is displayed in the ad, it may not be displayed depending on the display format of the ad.

Some parts of ad creatives may be displayed.

Item names and item descriptions may be displayed partially on the ads.

Change URL when changing the image (the old image is cached).

When changing the image file on updating the item list, update the image URL itself. If you replace the image with the same image URL, the older image may be displayed on the ad.

When multiple prices are in the item list, the formatted sale price is used. The following order shows which price appears.

1. Formatted Sale Price (most prioritized)

2. Sale Price
3. Formatted Price
4. Price
*We recommend not to use "Sale Price" and "Price" when using "Formatted Sale Price" and "Formatted Price" and contrariwise.

Note
"Sale Price" and "Price" are displayed together with the words ($、円、(税込), etc.) set in the setting item "Prefix" or "Suffix" of the ads.

 

When neither the price prefix nor the suffix is set, "¥" (double-byte) is automatically inserted before the price as for the price information.

When changing (updating) the item list the timing to take effect varies between items.

When changing multiple items the former item and the changed item may be displayed in one ad. "Display setting" and "Stock information" are changed with priority.