Appendix - Bulksheet data for Yahoo! Japan accounts

Last update: 2023-11-29
  • Created for:
  • User

You can download data for Yahoo! Japan accounts in bulk but can’t upload or post bulksheets to the ad network.

Available data fields

TIP

The following table is wide. If necessary, use the scrollbar at the bottom of the table to view the full contents. You can also optionally temporarily hide the table of contents or the right pane by clicking Hide left pane at the top of the left pane or Hide right pane at the top of the right pane.

Field Campaign Ad Group Keyword Text Ad Campaign Location Target Description
Platform n/a n/a n/a n/a n/a (Included in generated bulksheets for information purposes) The ad platform. Required unless each row includes an "AMO ID" for the entity.
Acct Name Required/Optional Required/Optional Required/Optional Required/Optional Required/Optional The unique name that identifies an ad network account. Required unless each row includes an "AMO ID" for the entity.
Campaign Name Required Required Required Required Required The unique name that identifies a campaign for an account.
Campaign Budget Required: Create

Optional: Edit or delete
n/a n/a n/a n/a A daily spending limit for the campaign, with or without monetary symbols and punctuation. This value overrides but can’t exceed the account budget.
Delivery Method Required: Create

Optional: Edit or delete
n/a n/a n/a n/a How quickly to show ads for the campaign each day:
  • Standard (Distributed) (the default for new campaigns): To spread your ad impressions across the day.
  • Accelerated: To display your ads as often as possible until your budget is reached. As a result, your ads may not appear later in the day.
Mobile Bid Adjustment Optional Optional n/a n/a n/a Whether to bid for ads on mobile devices, at either the campaign level or the ad group level:
  • To use the existing mobile bid adjustment, leave this blank.
  • To not bid for ads on mobile devices, enter -100.
  • To bid for ads on mobile devices using the same bid as ads on desktop and tablet devices (0% difference), enter 0. For new campaigns, you can also leave this blank.
  • To bid for ads on mobile devices using a different bid, enter the percentage by which to increase or decrease bids. The value can be from -90 to 300.
If you exclude a device at the campaign level, you can’t override the exclusion at the ad group level.

Notes:
  • Ad groups inherit the campaign-level settings, but you can override them.
  • If you assign the campaign to an optimized portfolio, then the optimization capability automatically determines the base keyword-level bid to help the portfolio meet its objective. The ad network then adjusts the bid as specified for mobile ads.
  • If you assign the campaign or ad group to an optimized portfolio:
    • The optimization capability automatically determines the base keyword-level bid to help the portfolio meet its objective. The search network then adjusts the bid as specified for mobile ads.
    • If the portfolio is configured to “Auto-optimize Bid Adjustment Values,” then the optimization capability changes bid adjustments at the ad group level as long as the ideal value that it calculates falls within the minimum and maximum values specified in the portfolio setting and the ad group doesn’t exclude bidding for mobile ads.
Location n/a n/a n/a n/a Optional A geographical location at which to place ads for the campaign. For cities, use the format “<City>, <Prefecture>” (such as Adachi, Tokyo). To exclude a location, prefix the location with a minus sign (-). If you don’t enter specific values for the campaign, then all locations are targeted.
Location Type n/a n/a n/a n/a Required/Optional (Required when you target specific locations) Whether the specified locations are of the type Prefecture or City.
Ad Group Name n/a Required Required Required n/a An ad group name that is unique within the campaign. The maximum length is 50 characters.
Max CPC n/a Optional Optional n/a n/a The maximum cost per click (CPC), which is the highest amount to pay for an ad click on the search network, with or without monetary symbols and punctuation. You can set values for ad groups and keywords. The default for a new keyword is inherited from the ad group level.
Keyword Optional / n/a Optional / n/a Required n/a n/a The keyword string. Yahoo! Japan keywords and match types are mutable, which means you can edit them without deleting the existing keyword.

To exclude a keyword at the ad group or campaign level, set the Match Type to “Negative.” If the row includes the ad group name, then the keyword is excluded for the ad group. If the row doesn’t include the ad group name, then the keyword is excluded for the entire campaign.
Match Type Optional / n/a Optional / n/a Optional: Create

Required/Optional: Edit or delete
n/a n/a The keyword matching option for the keyword: Broad (the default for new keywords), Exact, Phrase, *Negative Broad, or Negative Exact. Define negative keywords at the campaign level or ad group level. Yahoo! Japan keywords and match types are mutable, which means you can edit them without deleting the existing keyword.

A value for either the match type or keyword ID is required only to edit a keyword with multiple match types.
First Page Bid n/a n/a n/a n/a n/a (Included in generated bulksheets for information purposes) The bid required to place an ad on the first page of the search results. This value isn’t posted to the ad network.
Quality Score n/a n/a n/a n/a n/a (Included in generated bulksheets for information purposes) The current quality score that the ad network has assigned to the keyword. This value isn’t posted to the ad network.
Ad Name (Yahoo JP) n/a n/a n/a Optional: Create

Required/Optional: Edit or delete
n/a The unique name that identifies the ad image within an ad group. The maximum length is 50 characters. Required unless you use the AMO ID or Ad ID for the row.
Creative Preferred Devices n/a n/a n/a Optional n/a The device types on which you prefer to display the ad: All (the default) or Mobile. For Mobile, the ad network tries to display the ad to mobile device users rather than desktop or tablet users. Otherwise, it displays the ad on any device type.

Only administrators and Adobe account manager users can edit this setting.
Ad Title n/a n/a n/a Required n/a The headline of the ad. The maximum length is 30 single-byte or 15 double-byte characters. Changing the ad copy deletes the existing ad and creates a new one.
Ad Title 2 n/a n/a n/a Required / n/a n/a (Extended text ads only) A second headline. The maximum length is 30 characters or 15 double-byte characters. Changing the ad copy deletes the existing ad and creates a new one.
Description Line 1 n/a n/a n/a Required n/a The body of the ad. For extended text ads, the maximum length is 80 single-byte or 40 double-byte characters. Changing the ad copy deletes the existing ad and creates a new one.
Description Line 2 n/a n/a n/a Required n/a (Standard text ads only) The second line of the ad body. The maximum length is 38 single-byte or 19 double-byte characters. Changing the ad copy deletes the existing ad and creates a new one. Note: Yahoo! Japan Ads no longer allows the creation and editing of standard text ads.
Creative Type n/a n/a n/a Optional n/a The ad format:
  • Text (the default for new ads): Text ads that may be displayed on computers, tablets, and smartphones.
  • Mobile: Deprecated.
Display URL n/a n/a n/a Required / n/a: Create

Optional / n/a: Edit or delete
n/a (Existing standard text ads only; read-only) The URL displayed in the ad. The maximum length is 255 single-byte or 127 double-byte characters. In addition, the domains of the display URL and the landing page URL must be the same. Note: Yahoo! Japan Ads has deprecated the creation and editing of standard text and extended text ads.
Display Path 1, Display Path 2 n/a n/a n/a Optional / n/a n/a (Extended text ads only; optional) Text that’s added to the display URL that is automatically extracted from the final URL. It’s preceded in the URL by a forward slash (/). A path can’t contain forward slash (/) or newline (\n) characters. The maximum length is 15 characters or 7 double-byte characters.

To insert an ad customizer, use the following formats, where Default text is an optional value to insert when your feed file doesn’t include a valid value:
  • Google Ads: {CUSTOMIZER.AdCustomizerName:Default text}, such as {CUSTOMIZER.Discount:10%}
  • Microsoft® Advertising: {CUSTOMIZER.Attribute name:Default text}, such as {CUSTOMIZER.Discount:10%}
For example, if Display Path 1 is “deals,” then the display URL would be &lt;display URL&gt;/deals, such as www.example.com/deals.
Base URL/Final URL n/a n/a Optional Required n/a The landing page URL to which end users are taken when they click your ad, including any append parameters configured for the campaign or account. Base/final URLs at the keyword level override URLs at the ad level and higher.
Destination URL n/a n/a n/a n/a n/a (Included in generated bulksheets for information purposes; not posted to the ad network) For accounts with destination URLs, this URL is the URL that links an ad to a base URL/landing page on the advertiser’s website (sometimes via another site that tracks the click and then redirects the user to the landing page). It includes any append parameters configured for the Search, Social, & Commerce campaign or account. If you generated tracking URLs, this is based on the tracking parameters in your account settings and campaign settings. If you appended ad network-specific parameters, they may be replaced with the equivalent parameters for Search, Social, & Commerce.

For accounts with final URLs, this column shows the same value as the Base URL/Final URL column.

Destination URLs at the keyword or placement level override URLs at the ad level.
Tracking Template Optional Optional Optional Optional Optional (Optional) The tracking template or tracking URL, which specifies all off-landing domain redirects and tracking parameters and also embeds the final/landing page URL in a parameter. Use the parameter !{lpurl} to indicate the landing page URL. Example: {lpurl}?source={network}&id=5 or http://www.trackingservice.example.com/?url={lpurl}?source={network}&id=5 to include a redirect.

You can optionally add third-party redirects and tracking.

For Adobe Advertising conversion tracking, which is applied when the campaign settings include “EF Redirect” and “Auto Upload,” Search, Social, & Commerce automatically prefixes its own redirect and tracking code when you save the record.

The tracking template at the most granular level overrides the values at all higher levels. For example, if both the account settings and the keyword settings include a value, the keyword value is applied.
Campaign Status Optional: Create or edit

Required: Delete
n/a n/a n/a n/a The display status of the campaign: Active (the default for new campaigns), Paused, Ended (existing campaigns only), or Deleted (existing campaigns only).
Ad Group Status n/a Optional: Create or edit

Required: Delete
n/a n/a n/a The display status of the ad group:  Active, Paused, or Deleted (existing ad groups only). The default for new ad groups is Active. To delete an active or paused ad group, enter the value Deleted.
Keyword Status n/a n/a Optional: Create or edit

Required: Delete
n/a n/a The display status of the keyword: Active, Deleted (existing keywords only), Disapproved (not editable), Paused (existing keywords only), or Pending (not editable). The default for new keywords is Active. To delete a keyword, enter the value Deleted.
Ad Status n/a n/a n/a Optional: Create or edit

Required: Delete
n/a The display status of the ad: Active (the default for new ads), Deleted (existing ads only), Disapproved (not editable), Paused, or Pending (not editable). The default for new ads is Active. To delete an ad, enter the value Deleted.
Location Status n/a n/a n/a n/a Optional The status of the location target: Active or Deleted (existing locations only). The default for new locations is Active. To delete an active location, enter the value Deleted.
[Advertiser-specific Label Classification] Optional Optional Optional Optional Optional (Named for an advertiser-specific label classification, such as “Color” for a label classification called Color) A value for the specified classification that is associated with the entity. You can include only one value per classification per entity (such as “red” for the “Color” label classification for Campaign A). The maximum length is 100 characters, and the value can include ASCII and non-ASCII characters.

Label classifications and their label values are applied to all child components; new components that are added later are automatically associated with the label.

The classification name and the classification value aren’t case-sensitive.
Constraints Optional Optional Optional Optional n/a A constraint that’s assigned to the entity. You can assign only one constraint per entity.

Constraints are inherited by child entities, so you don’t need to enter values for child entities unless you want to override the inherited values.
Campaign ID n/a: Create

Required/Optional: Edit or delete
Optional Optional Optional n/a The unique ID that identifies an existing campaign. In CSV and TSV files, it must be preceded by a single quote (').[1] Required only when you change the campaign name, unless the row includes an “AMO ID” for the campaign.
Ad Group ID n/a n/a: Create

Required/Optional: Edit or delete
Optional Optional n/a The unique ID that identifies an existing ad group. In CSV and TSV files, it must be preceded by a single quote (').[1:1] Required only when you change the ad group name, unless the row includes an “AMO ID” for the ad group.
Keyword ID n/a n/a n/a: Create

Required/Optional: Edit

Required: Delete
n/a n/a The unique ID that identifies an existing keyword. In CSV and TSV files, it must be preceded by a single quote (').[1:2] Required only when you edit or delete the keyword, unless the row includes a) sufficient property columns to identify the keyword or b) an “AMO ID.”
Ad ID n/a n/a n/a n/a: Create

Required/Optional: Edit or delete
n/a The unique ID that identifies an existing ad. In CSV and TSV files, it must be preceded by a single quote (').[1:3] For responsive search ads, either the Ad ID or AMO ID is required to edit or delete ad data. For all other entity types, the AMO ID is required only when you change the ad status, unless the row includes a) sufficient ad property columns to identify the ad or b) an “AMO ID.” However, if you include neither the Ad ID nor AMO ID, and the ad property columns match multiple ads, then the status for only one of the ads changes.

Note: If you edit a) ad property columns except Status for an existing ad or b) any data for a responsive search ad, and you include neither the Ad ID nor AMO ID, then a new ad is created, and the existing ad isn’t changed.
AMO ID n/a: Create

Optional: Edit or delete
n/a: Create

Optional: Edit or delete
n/a: Create

Optional: Edit or delete
n/a: Create

Optional: Edit or delete
n/a (In generated bulksheets) An Adobe-generated unique identifier for a synced entity. For responsive search ads, the AMO ID is required to edit or delete ads unless you include the Ad ID. To edit data for all other entity types with an AMO ID, the AMO ID is required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.
EF Error Message n/a n/a n/a n/a n/a (Included in generated bulksheets for information purposes) Placeholder for displaying error messages from Search, Social, & Commerce regarding data in the row; error messages are included in EF Errors files. This value isn’t posted to the ad network.
SE Error Message n/a n/a n/a n/a n/a (Included in generated bulksheets for information purposes) Placeholder for displaying error messages from the ad network regarding data in the row; error messages are included in SE Errors files. This value isn’t posted to the ad network.

  1. Excel converts large numbers to scientific notation (such as 2.12E+09 for 2115585666) when it opens the file. To view digits in the standard notation, select any cell in the column and click inside the formula bar. ↩︎ ↩︎ ↩︎ ↩︎

On this page