Yahoo! JAPAN Ads

Yahoo! JAPAN Ads Help

Create Item list file (Dynamic Ads for Display)

Dynamic Ads for Display in Display Ads (YDN) 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 Item list file

 

Note
Dynamic Ads for Display is available for specific advertisers. When available, Dynamic Ads for Display appears in the Item lists in the Tool tab.
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 code or line feed code will cause file format error 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 Item list and product information on the second row of the list. Confirm the following Insertion Rules for the details of entry items on Item list file.
Dynamic Ads for Display - 1.Data feed (Item list) [Guidelines]

 
Note
  • You can't delete column items in the item list file. When not using the column, enter only the header name in the first row and leave the rest of rows empty.
    Item set may not be displayed depending on the template of ads.
  • Some changes are made to column items on December 4, 2019. To use the latest Item list template, refer to the following Tips.
    Instead of Smartphone Destination URL that is deleted, use Smartphone Destination URL.
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.
* You can download after setting the item list name following the steps of "Set Item List Name."

◆Screen design of previous Campaign Management Tool:
Once after you set the Item list name with "Upload Item list" procedure, the template of the item list file became downloadable. Click "Download template for Item list" on the "Item Lists" screen.

◆Screen design of new Campaign Management Tool:
Click the "Update item list" button on the Item list screen, then click "Download the template for upload" on the next screen.

Note
When creating Item list file, please make sure the following rules:

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 as 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 part 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 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
If prefix or suffix is not set for the "Sale Price" and "Price," the price will not show on the ad.
*We recommend not to use "Sale Price" and "Price" when using "Formatted Sale Price" and "Formatted Price" and contrariwise.

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.