Yahoo! JAPAN Ads

Yahoo! JAPAN Ads Help

File specification for importing (targeting)

To import targeting settings using the Display Ads (Auction) management tool, create a CSV in the following specifications.
Targeting (day of week/hours)
Targeting (device)
Targeting (device: OS)
Targeting (device: platform)
Targeting (device: OS version)
Targeting (geographic)
Targeting (gender)
Targeting (age)
Targeting (audience category)
Targeting (search keyword)
Targeting (audience list)
Targeting (site category)
Targeting (placement)
Targeting (content keyword)

Tips
Multiple targeting settings can also be combined into a single CSV file for importing.
Explanation
The “Create-Edit” column in the following table stands for the following actions:
  • Required: You must specify the item.
  • Optional: You can specify as an option. When you specify, the item is created or updated.
  • Unnecessary: The item won't update if you specify.
  • Unavailable: You will get an error if you specify.
  • Required depending on settings: You must specify depending on other items or higher-level settings.
  • Optional depending on settings: You can specify depending on other items or higher-level settings.

Targeting (day of week/time of day)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameCreate-EditDescription
Ad group IDCreate: Required
Edit: Required
Enter the ad group ID.
SettingCreate: Required
Edit: Optional

Enter one of the following values:

  • On
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeCreate: Required
Edit: Required
Enter “Day of week/time of day.”
Value 1Create: Required
Edit: Required depending on rules

Enter one of the following values:

  • Monday
  • Tuesday
  • Wednesday
  • Thursday
  • Friday
  • Saturday
  • Sunday
Value 2Create: Required
Edit: Required depending on rules

Enter a start time in the following range:
0-23

Value 3Create: Required
Edit: Required depending on rules
Enter a start time in the following range:
1-24
Bid adjustment rateCreate: Optional
Edit: Optional
Enter a value in the following range:
-90 to 100

Targeting (device)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameEditDescription
Ad group IDEdit: RequiredEnter the ad group ID.
SettingEdit: RequiredEnter one of the following values:
  • On
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeEdit: RequiredEnter “Device.”
Value 1Edit: Required

Enter one of the following values:

  • PC
  • Smartphone
  • Tablet

“PC” cannot be entered if the campaign goal is “app promotion.”

Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rateEdit: OptionalEnter a value in the following range:
-90 to 100

Targeting (device: OS)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameEditDescription
Ad group IDEdit: RequiredEnter the ad group ID.
SettingEdit: Required

Enter one of the following values:

  • On
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeEdit: RequiredEnter “Device (OS).”
Value 1Edit: Required depending on rulesEnter one of the following values:
  • Android
  • iOS
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rate-Leave blank.

Targeting (device: platform)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameEditDescription
Ad group IDEdit: RequiredEnter the ad group ID.
SettingEdit: RequiredEnter one of the following values:
  • On
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeEdit: RequiredEnter “Device (platform).”
Value 1Edit: Required depending on rulesEnter one of the following values:
  • Web
  • App
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rate-Leave blank.

Targeting (OS version)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameEditDescription
Ad group IDEdit: RequiredEnter the ad group ID.
SettingEdit: Required

Enter one of the following values:

  • On
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeEdit: RequiredEnter “Device (OS version).”
Available only if the campaign goal is “app promotion.”
Value 1Edit: Required depending on rules

Enter the OS version.

Example
  • iOS:11.0
  • Android:8.0
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rate-Leave blank.

Targeting (geographic)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameCreate/EditDescription
Ad group IDCreate: Required
Edit: Required
Enter the ad group ID.
SettingCreate: Required
Edit: Required
Enter one of the following values:
  • On
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeCreate: Required
Edit: Required

When you specify the locations, enter "location (name)."
When you specify the radiuses, enter "location(radius)."

Tips

You can continue using a column name "Location" that appeared on the previous download files instead of "Location (name)."

Value 1Create: Required
Edit: Required depending on rules

When you specify locations, enter location names (prefectures, cities, wards, and districts).

Example
Kawasaki-ku, Kawasaki-shi, Kanagawa-ken

When you specify radiuses, enter latitude and longitude. Place "|" between latitude and longitude.

Example
79.456789|123.456789
Value 2Create: Required
Edit: Required depending on rules

When you specify locations, leave this column blank.
When you specify radiuses, enter the radius in kilometers.

Example
3
Value 3Create: Required
Edit: Required depending on rules

When you specify locations, leave this column blank.
When you specify radiuses, enter descriptions.

Example
Tokyo Garden Terrace
Tips

When your CSV file (Shift-JIS) contains the following characters, you may get errors or garbled characters.

  • Platform dependent characters (①, (株), I, 髙, etc.)
  • Non-Japanese characters (non-Japanese kanji, Hangul characters, etc.)
  • To download or import CSV files using the "CSV import file," use the "UTF-8" character code.
  • If you must use Shift-JIS characters due to your environment, remove characters that may cause an error.
Bid adjustment rateCreate: Optional
Edit: Optional
Enter a value in the following range:
-90 to 100

Targeting (gender)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameEditDescription
Ad group IDEdit: RequiredEnter the ad group ID.
SettingEdit: RequiredEnter one of the following values:
  • On
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeEdit: RequiredEnter “Gender.”
Value 1Edit: Required depending on rulesEnter one of the following values:
  • Male
  • Female
  • Unknown
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rateEdit: OptionalEnter a value in the following range:
-90 to 100

Targeting (age)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameEditDescription
Ad group IDEdit: RequiredEnter the ad group ID.
SettingEdit: RequiredEnter one of the following values:
  • On
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeEdit: RequiredEnter “Age.”
Value 1Edit: Required depending on rulesEnter one of the following values:
<New age groups>
  • 18-19
  • 20-24
  • 25-29
  • 30-34
  • 35-39
  • 40-44
  • 45-49
  • 50-54
  • 55-59
  • 60-64
  • 65-69
  • 70 or more
  • Unknown
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rateEdit: OptionalEnter a value in the following range:
-90 to 100

Targeting (audience category)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameCreate/EditDescription
Ad group IDCreate: Required
Edit: Required
Enter the ad group ID.
SettingCreate: Required
Edit: Required

Enter one of the following values:

  • On
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeCreate: Required
Edit: Required
Enter “Audience category.”
Value 1Create: Required
Edit: Required depending on rules
Enter one of the following values:
  • Affinity
  • In-market
Value 2Create: Required
Edit: Required depending on rules

Enter the audience category name.

Example
Likes shopping
Value 3-Leave blank.
Bid adjustment rateCreate: Optional
Edit: Optional
Enter a value in the following range:
-90 to 100

Targeting (search keyword)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameCreate/EditDescription
Ad group IDCreate: Required
Edit: Required
Enter the ad group ID.
SettingCreate: Required
Edit: Required

Enter one of the following values:

  • On
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeCreate: Required
Edit: Required
Enter “Search keyword.”
Value 1Create: Required
Edit: Required depending on rules
Enter search keyword, search keyword list name, or search keyword list ID.
Example
Automotive keywords
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rate-Leave blank.

Targeting (audience list)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameCreate/EditDescription
Ad group IDCreate: Required
Edit: Required
Enter the ad group ID.
SettingCreate: Required
Edit: Required
Enter one of the following values:
  • Allow
  • Exclude
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.
When the campaign goal is “Item list promotion,” you can't reset by specifying “Reset targeting specified for targeting type.”

TypeCreate: Required
Edit: Required
Enter “Audience list.”
Value 1Create: Required
Edit: Required depending on rules
Enter the audience list name or audience list ID.
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rate-Leave blank.

Targeting (site category)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameCreate/EditDescription
Ad group IDCreate: Required
Edit: Required
Enter the ad group ID.
SettingCreate: Required
Edit: Required

Enter one of the following values:

  • On
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeCreate: Required
Edit: Required
Enter “Site category.”
Value 1Create: Required
Edit: Required depending on rules

Enter the site category name.

Example
News/domestic
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rateCreate: Optional
Edit: Optional
Enter a value in the following range:
-90 to 100

Targeting (device: placement)

*The following item names are for descriptive purposes only. Download the latest template.

Item (column) nameCreate/EditDescription
Ad group IDCreate: Required
Edit: Required
Enter the ad group ID.
SettingCreate: Required
Edit: Required

Enter one of the following values:

  • Allow
  • Exclude
  • Off
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeCreate: Required
Edit: Required
Enter “Placement.”
Value 1Create: Required
Edit: Required depending on rules
Enter the placement list name or placement list ID.
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rate-Leave blank.

Targeting (content keyword)

Item (column) nameCreate/EditDescription
Ad group IDCreate: Required
Edit: Required
Enter the ad group ID.
SettingCreate: Required
Edit: Required

Enter one of the following values:

  • On
  • Reset targeting specified for targeting type

“Reset targeting specified for targeting type” is a value to reset all targeting settings specified in the “Type” column to the default values. Even if you specify values in other rows, the targeting resets.

TypeCreate: Required
Edit: Required
Enter “content keyword”
Value 1Create: Required
Edit: Required depending on rules
Enter the content keyword, content keyword list name, or content keyword list ID.
Value 2-Leave blank.
Value 3-Leave blank.
Bid adjustment rateCreate: optional
Edit: optional
Enter a value in the following range:
-90 to 100

View this page in Japanese