Yahoo! JAPAN Ads

Yahoo! JAPAN Ads Help

File specification for importing (campaign, ad group, ad)

To upload your campaign, ad group, or ad in the Campaign Management Tool, create a CSV in the following specifications.

Campaign
Ad group
Ad

Tips
  • When you enter "remove" in the "remove" column on the importing file, all items (columns) will be removed with or without any entry.
Explanation
The “Create-Edit-Remove” 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.

Campaign

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

Item (column) nameCreate-Edit-RemoveDescription
Campaign ID-Create: Unavailable
-Edit: Required
-Remove: Required
Enter this column when you edit or remove a campaign.
Leave this column blank when you create a new campaign.
Campaign name-Create: Required
-Edit: Optional
-Remove: Unavailable
Enter the campaign name.

Status

-Create: Required
-Edit: Optional
Remove: -Unavailable

Enter one of the following values:

  • On
  • Off
Campaign goal-Create: Required
-Edit: Unnecessary
-Remove: Unavailable

Enter one of the following values:

  • Website traffic
  • Video view
  • App promotion
  • Conversions
  • Item list promotion

*The available campaign goals vary depending on the account you are using.

Campaign start date-Create: Required
-Edit: Required depending on settings
-Remove: Unavailable

Enter the campaign start date in one of the following formats:

  • 2019/09/24
  • 2019-09-24
  • 20190924

*Required when you set the campaign start time.

Campaign start time-Create: Optional
-Edit: Optional
-Remove: Unavailable

Enter the campaign start time in 24-hour format. You can enter by the minute. Enter in one of the following formats:

  • 08:05
  • 0805
Campaign end date-Create: Required depending on settings
-Edit: Required depending on settings
-Remove: Unavailable

Enter the campaign end date in one of the following formats:

  • 2019/09/24
  • 2019-09-24
  • 20190924

*Required when you set the campaign end time.

Campaign end time-Create: Optional
-Edit: Optional
-Remove: Unavailable

Enter the campaign end time in 24-hour format. You can enter by the minute. Enter in one of the following formats:

  • 08:05
  • 0805
Daily budget-Create: Required
-Edit: Optional
-Remove: Unavailable
Enter a number between 100 and 300,000,000.
*When your bid strategy is CPV, the minimum amount is 1,000.
Campaign bid strategy-Create: Required
-Edit: Optional
-Remove: Unavailable

Enter one of the following values:

  • Manual bidding (CPC)
  • Manual bidding (CPV)
  • Manual bidding (vCPM1000回のインプレッション(表示)でかかったコストです。)
  • Auto bidding (tCPA)
  • Auto bidding (Maximize conversions)
  • Auto bidding (Maximize clicks)
  • Auto bidding (Maximize video vies)

Learn more about “Bid strategy.”

Campaign bid/target-Create: Required
-Edit: Optional
-Remove: Unavailable

Enter a campaign bid/target in single-byte numbers.
The following ranges are available for the “Campaign bid strategy.”

  • Manual bidding (CPC): 1-50,000
  • Manual bidding (CPV): 100-1,000,000
  • Manual bidding (vCPM): 1-100,000
  • Auto bidding (tCPA): 1-100,000
    Tips
    Don't let the bid exceed your campaign daily budget.
Frequency cap (level)-Create: Optional
-Edit: Optional
-Remove: Unavailable

Enter one of the following values:

  • Campaign
  • Ad group
  • Ad
  • None

When you don't set a frequency cap, use the following settings:
Level: None
Period: None
Frequency: (Leave blank)

Frequency cap (period)-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

Enter one of the following values:

  • Day
  • Week
  • Month
  • None

When you don't set a frequency cap, use the following settings:
Level: None
Period: None
Frequency: (Leave blank)

Frequency cap (impressions)-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

Enter a single-byte number between 1 and 100.

When you don't set a frequency cap, use the following settings:
Level: None
Period: None
Frequency: (Leave blank)

Conversion ID-Create: Optional 
-Edit: Optional
-Remove: Unnecessary

Enter the ID of the conversion setting that is used for optimizing autobidding.

  • Conversion ID and conversion group ID can't be specified at the same time. Specify any of the two items.
  • When you leave conversion ID and conversion group ID as a blank, or put them "0" (zero), the conversion setting of the account (only the setting "Include in conversions") will be used for optimizing.
Conversion ID group-Create: Optional 
-Edit: Optional
-Remove: Unnecessary
Enter the ID of the conversion group that is used for optimizing autobidding.
  • Conversion ID and conversion group ID can't be specified at the same time. Specify any of the two items.
  • When you leave conversion ID and conversion group ID as a blank, or put them "0" (zero), the conversion setting of the account (only the setting "Include in conversions") will be used for optimizing.
App name-Create: Required depending on settings
-Edit: Unnecessary
-Remove: Unavailable
Enter the app name.
This column is required when the campaign goal is “app promotion.”
App OS-Create: Required depending on settings
-Edit: Unnecessary
-Remove: Unavailable

Enter one of the following values:

  • iOS
  • Android

This column is required when the campaign goal is “app promotion.”

App ID/package name-Create: Required depending on settings
-Edit: Unnecessary
-Remove: Unavailable

Enter the following according to the app OS:

  • iOS: App ID
  • Android: Package name

This column is required when the campaign goal is “app promotion.”

Tracking URL

-Create: Optional -Edit: Optional -Remove: Unavailable

Enter the tracking URL.

 

Custom parameter

-Create: Optional -Edit: Optional -Remove: Unavailable

Enter the custom parameter.
When setting multiple URLs, you can divide by "|" symbol.
Example

{_aaa}=111|{_bbb}=222

Ad measurement tool (SKAdNetwork)

-Create: Optional -Edit: Optional -Remove: Unavailable

When the campaign goal is "app promotion" AND the target is iOS, enter the tool.

Remove-Create: Unavailable
-Edit: Unavailable
-Remove: Required
Enter “Remove” in the data row to remove data.
Leave this column blank when you don't remove the element.
*You can remove YDN campaigns.

Ad group

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

Item (column) nameCreate/Edit/RemoveDescription
Campaign ID-Create: Required
-Edit: Required
-Remove: Required
Enter the campaign ID.
This column is required when creating, updating, or removing the ad group.
Ad group ID-Create: Unavailable
-Edit: Required
-Remove: Required
Enter this column when you edit or remove an ad group.
Leave this column blank when you create a new campaign.
Ad group name-Create: Required
-Edit: Optional
-Remove: Unavailable
Enter the ad group name.
Status-Create: Required
-Edit: Optional
-Remove: Unavailable

Enter one of the following value:

  • On
  • Off
Ad group bid/target-Create: Required
-Edit: Optional
-Remove: Unavailable

Enter a campaign bid/target in single-byte numbers.
The following ranges are available for the “Campaign bid strategy.”

  • Manual bidding (CPC): 1-50,000
  • Manual bidding (CPV): 100-1,000,000
  • Manual bidding (vCPM): 1-100,000
  • Auto bidding (tCPA): 1-100,000

When you enter “Apply campaign setting,” the campaign settings apply.

Tips
Don't let the bid exceed your campaign daily budget.
Item set-Create: Optional depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable
Enter the item set name.
This column is available when the campaign goal is “Item list promotion.”

Tracking URL

-Create: Optional
-Edit: Optional -Remove: Unavailable

Enter the tracking URL.

Custom parameter

-Create: Optional
-Edit: Optional -Remove: Unavailable

Enter the custom parameter. When setting multiple parameters, you can divide by "|" symbol.

Example

{_aaa}=111|{_bbb}=222

Remove-Create: Unavailable
-Edit: Unavailable
-Remove: Required
Enter “Remove” in the data row to remove data.
Leave this column blank when you don't remove the element.

Ad

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

Item (column) nameCreate/Edit/RemoveDescription
Campaign ID-Create: Required
-Edit: Required
-Remove: Required
Enter the campaign ID.
This column is required when creating, updating, or removing an ad.
Ad group ID-Create: Required
-Edit: Required
-Remove: Required
Enter the ad group ID.
This column is required when creating, updating, or removing an ad.
Ad ID-Create: Unavailable
-Edit: Required
-Remove: Required
Enter this column when you edit or remove an ad.
Leave this column blank when you create a new campaign.
Media ID-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

Enter the ID of the image or video to display in the ad.
This column is required for the following ad types:

  • Responsive (image)
  • Responsive (video)
  • Banner (image)
  • Banner (video)
Ad name-Create: Required
-Edit: Optional
-Remove: Unavailable
Enter the ad name.
Status-Create: Required
-Edit: Optional
-Remove: Unavailable

Enter one of the following value:

  • On
  • Off
Ad type-Create: Required
-Edit: Optional
-Remove: Unavailable

Enter one of the following value:

  • Text
  • Responsive (image)
  • Responsive (video)
  • Banner (image)
  • Banner (video)
  • Dynamic display
  • Carousel (image)

The available ad types vary depending on campaign goals.
Learn more about “Create ads.”

Title-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

Enter the ad title.
This column is required the following ad types:

  • Text
  • Responsive (image)
  • Responsive (video)
  • Carousel (image)
Description1-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

Enter Description 1 for the ad.
This column is required the following ad types:

  • Text
  • Responsive (image)
  • Responsive (video)
  • Carousel (image)
Description2-Create: Optional depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

Enter Description 2 for the ad.
This column is available when the ad type is “text.”

Button-Create: Optional depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

Enter one of the following value in Japanese:
*Buttons are available in Japanese. See the translation in parenthesis for your reference.

  • もっとみる (See more)
  • 詳しくはこちら (Learn more)
  • お申込はこちら (Join)
  • ご購入はこちら (Purchase)
  • ご予約はこちら (Reserve)
  • ご登録はこちら (Subscribe)
  • 今すぐチェック (Check now)
  • 今すぐ申込む (Sign up now)
  • 今すぐ購入 (Buy now)
  • 今すぐ予約 (Book now)
  • 今すぐ登録 (Subscribe now)
  • 資料請求 (Request information)
  • お問い合わせ (Need support?)
  • 体験する (Experience)
  • 物件をみる (Visit a real estate property)
  • ダウンロード (Download)
  • インストール (Install)

This column is required for the following ad types:

  • Text
  • Responsive (image)
  • Responsive (video)
  • Carousel

When you don't specify “もっとみる” applies.

Advertiser indication-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

Enter the advertiser's indication.
This column is required for the following ad types:

  • Text
  • Responsive (image)
  • Responsive (image)
  • Carousel
Example
Yahoo!
Destination URL-Create: Unavailable
-Edit: Unavailable
-Remove: Unnecessary

Creating and editing are not available.
When setting any value, an error occurs.

Display URL-Create: Unavailable
-Edit: Unavailable
-Remove: Unnecessary

・For the destination URL format:
   Creating and editing is not available.
・For the final URL format:
   Specifying this URL is unnecessary. The display URL is automatically generated.

When the campaign goal is “App promotion,” set the URL matching the app OS in the campaign. Depending on the app OS in the upper-level campaign, one of the following values applies.
iOS: itunes.apple.com
Android: play.google.com

Final URL

-Create: Required  -Edit: Optional depending on conditions
-Remove: Unnecessary

Enter the URL of the page displayed when clicked on the ad.

For the ad type "Dynamic Ads for Display", set the URL of the page displayed when clicked on the logo image. This information can be set when selecting the final URL format type.

Smartphone final URL

-Create: Optional depending on conditions
-Edit: Optional depending on conditions -Remove: Unavailable

Enter the smartphone final URL.

For the ad type "Dynamic Ads for Display", set the URL of the page displayed when clicked on the logo image.
This information can be set when selecting the final URL format type.

Display URL format

-Create: Required

-Edit: Optional depending on conditions
-Remove: Unavailable.

Enter any of the following values. ・Domain only ・Up to the first directory For the campaign goal "app promotion", set "Domain only". When selecting the final URL format type, this information is required.

Tracking URL

-Create: Optional depending on conditions
-Edit: Optional depending on conditions
-Remove: Unavailable

Enter the tracking URL. You can set this information when selecting the final URL format type.

Custom Parameter

-Create:
Optional depending on conditions
-Edit: Optional depending on conditions
-Remove: Unavailable

Enter the custom parameter.

When entering multiple parameters, you can divide by "|" symbol.

You can set this information when selecting the final URL format type.

Example

{_aaa}=111|{_bbb}=222

Price prefix-Create: Optional depending on conditions
-Edit: Optional depending on conditions
-Remove: Unavailable

Enter the price prefix.

Example
¥, $

This column is available for Dynamic Ads for Display.

Price suffix-Create: Optional depending on conditions
-Edit: Optional depending on conditions
-Remove: Unavailable

Enter the price suffix.

Example
million JPY

This column is available for Dynamic Ads for Display.

Ad base color-Create: Optional depending on conditions
-Edit: Optional depending on conditions
-Remove: Unavailable

Enter the ad base color.

Example
#FFFFFF

This column is available for Dynamic Ads for Display.

Media ID (logo1)-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

Enter the ID of the logo image in the ad.
This column is required for the following ad types:

  • Dynamic ads for display
  • Carousel

This column is optional for the following ad types:

  • Responsive (image)
  • Responsive (video)
Media ID (logo2)-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable
Enter the ID of the logo image to display in the ad.
This column is required when the ad type is “Dynamic Ads for Display.”
Media ID (logo3)-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable
Media ID (video thumbnail)-Create: Required depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable
Enter the image ID for the video thumbnail to display in the ad.
This column is required when the ad type is “Responsive (video)” and "Banner (video)."
Third-party script tag src attribute URL-Create: Optional
-Edit: Optional
-Remove: Unavailable
Enter the third-party script tag src attribute URL.
Impression beacon URL-Create: Optional
-Edit: Optional
-Remove: Unavailable

Enter the impression beacon URL.

*You can put multiple URLs separated by a vertical "|".

Viewable impression beacon URL-Create: Optional
-Edit: Optional
-Remove: Unavailable

Enter the viewable impression beacon URL.

*You can put multiple URLs separated by a vertical "|".

Viewing beacon URL (start)-Create: Optional
-Edit: Optional
-Remove: Unavailable

Enter the URL for tracking video viewing data.

*You can put multiple URLs separated by a vertical "|".

Viewing beacon URL (3 seconds)-Create: Optional
-Edit: Optional
-Remove: Unavailable
Viewing beacon URL (10 seconds)-Create: Optional
-Edit: Optional
-Remove: Unavailable
Viewing beacon URL (25%)-Create: Optional
-Edit: Optional
-Remove: Unavailable
Viewing beacon URL (50%)-Create: Optional
-Edit: Optional
-Remove: Unavailable
Viewing beacon URL (75%)-Create: Optional
-Edit: Optional
-Remove: Unavailable
Viewing beacon URL (complete)-Create: Optional
-Edit: Optional
-Remove: Unavailable
Destination URL (campaign banner)-Create: Optional depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

To show campaign banner in the Dynamic Ads for Display, enter the URL of the page appears after the ad click.
*This setting is available for Dynamic Ads for Display.

Media ID (campaign banner 600_500)-Create: Optional depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

To show a campaign banner in the Dynamic Ads for Display, enter the image ID of the campaign banner.

Specify image in 600x500 pixels

Media ID (campaign banner 600_600)-Create: Optional depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

To show a campaign banner in the Dynamic Ads for Display, enter the image ID of the campaign banner.

Specify image in 600x600 pixels

Media ID (campaign banner 600_80)-Create: Optional depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable

To show a campaign banner in the Dynamic Ads for Display, enter the image ID of the campaign banner.

Specify image in 600x80 pixels

Media ID (campaign banner 600_1200)-Create: Optional depending on settings
-Edit: Optional depending on settings
-Remove: Unavailable
To show a campaign banner in the Dynamic Ads for Display, enter the image ID of the campaign banner.

Specify image in 600x1,200 pixels

Remove-Create: Unavailable
-Edit: Unavailable
-Remove: Required
Enter “Remove” in the data row to remove data.
Leave this column blank when you don't remove the element.

Media ID (Carousel card 1-10)

-Create: Required depending on setting
-Edit:
Optional depending on settings -Remove: Unavailable

For carousel ad, enter the media ID to set to the carousel card.

Title (Carousel card 1-10)

-Create: Required depending on settings
-Edit:
Optional depending on settings -Remove: Unavailable

For carousel ad, enter the title to set to the carousel card.

Description (Carousel card 1-10)

-Create: Required depending on settings
-Edit:
Optional depending on settings -Remove: Unavailable

For carousel ad, enter the description to set to the carousel card.

Destination URL (Carousel card 1-10)

-Create: Required depending on settings
-Edit:
Optional depending on settings -Remove: Unavailable

For carousel ad, enter the destination URL to set to the carousel card.
*This item is available only when editing existing ads in the destination URL format.

Final URL (Carousel card 1-10)

-Create: Required depending on settings
-Edit:
Optional depending on settings -Remove: Unavailable

For carousel ad, enter the final URL to set the carousel card. When selecting the final URL format type, this information is required.

Smartphone final URL (Carousel card 1-10)

-Create: Required depending on settings
-Edit:
Optional depending on settings -Remove: Unavailable

For carousel ad, enter the smartphone final URL to set the carousel card. When selecting the final URL format type, this information is required.

View this page in Japanese