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.”
Setting 1Create: Required
Edit: Required depending on rules

Enter one of the following values:

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

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

Setting 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.”
Setting 1Edit: Required

Enter one of the following values:

  • PC
  • Smartphone
  • Tablet

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

Setting 2-Leave blank.
Setting 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).”
Setting 1Edit: Required depending on rulesEnter one of the following values:
  • Android
  • iOS
Setting 2-Leave blank.
Setting 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).”
Setting 1Edit: Required depending on rulesEnter one of the following values:
  • Web
  • App
Setting 2-Leave blank.
Setting 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.”
Setting 1Edit: Required depending on rules

Enter the OS version.

Example
  • iOS:11.0
  • Android:8.0
Setting 2-Leave blank.
Setting 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
Enter “Geographic.”
Setting 1Create: Required
Edit: Required depending on rules

Enter the delivery location.

Example
Kawasaki-ku, Kawasaki-shi, Kanagawa-ken
Setting 2-Leave blank.
Setting 3-Leave blank.
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.”
Setting 1Edit: Required depending on rulesEnter one of the following values:
  • Male
  • Female
  • Unknown
Setting 2-Leave blank.
Setting 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.”
Setting 1Edit: Required depending on rulesEnter one of the following values:
<New age groups>
  • 15-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
Setting 2-Leave blank.
Setting 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.”
Setting 1Create: Required
Edit: Required depending on rules
Enter one of the following values:
  • Affinity
  • In-market
Setting 2Create: Required
Edit: Required depending on rules

Enter the audience category name.

Example
Likes shopping
Setting 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.”
Setting 1Create: Required
Edit: Required depending on rules
Enter search keyword, search keyword list name, or search keyword list ID.
Example
Automotive keywords
Setting 2-Leave blank.
Setting 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.”
Setting 1Create: Required
Edit: Required depending on rules
Enter the audience list name or audience list ID.
Setting 2-Leave blank.
Setting 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.”
Setting 1Create: Required
Edit: Required depending on rules

Enter the site category name.

Example
News/domestic
Setting 2-Leave blank.
Setting 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.”
Setting 1Create: Required
Edit: Required depending on rules
Enter the placement list name or placement list ID.
Setting 2-Leave blank.
Setting 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”
Setting 1Create: Required
Edit: Required depending on rules
Enter the content keyword, content keyword list name or content keyword list ID.
Setting 2-Leave blank.
Setting 3-Leave blank.
Bid adjustment rateCreate: optional
Edit: optional
Enter a value in the following range:
-90 to 100

View this page in Japanese