In Yahoo! Japan, you can specify location targets in campaigns, and ad groups always inherit these targets. Yahoo! Japan doesn’t support device type (tablet and desktop) targeting, but you can target mobile devices by setting mobile bid modifiers at the campaign and ad group levels.
How to update campaigns and ad groups via bulksheet
The general process for updating campaigns and ad groups via bulksheet is as follows:
Download an editable report that contains the campaigns and ad groups you want to update.
Change the values in the bulksheet columns. See details and examples in the sections below.
Upload the bulksheet back into Search Ads 360.
Columns for location targets
The following bulksheet columns specify location targets for Yahoo! Japan campaigns:
- Excluded region
- Excluded metro
You can change the value in these columns to the following:
When you edit an existing campaign and leave a column empty, Search Ads 360 keeps the current setting as is (that is, an empty value means “do not change”). When you create a new campaign and leave these columns empty, the campaign targets all locations, which is the Yahoo! Japan default.
A list of Japanese prefecture (province) codes in the Region or Excluded region column or subprefecture codes in the Metro or Excluded metro column, each separated by a | (vertical bar).
To show your ads only in the Tokyo and Kyoto prefectures, specify JP-13 | JP-26 in the Region column. (These are the same province codes that Google Ads supports.)
To target the Akkeshi, Hokkaido subprefecture, specify JP-01-0002 in the Metro column. Yahoo! Japan defines the codes that you use to specify subprefectures.
To target all of Hokkaido except for the Otaru, Hokkaido subprefecture:
Specify JP-01 in the Region column.
Specify JP-01-0049 in the Excluded metro column.
Region Metro Excluded metro JP-13 | JP-26 | JP-01 JP-01-0002 JP-01-0049Subprefectures and excluded locations are not listed in the Search Ads 360 UI. Instead, the Targeting section (in campaign settings) displays a message that lists the names of the targeted prefectures and the number of non-managed targeted locations. From the preceding examples, the message would be: Locations: Tokyo, Kyoto, Hokkaido (also targets 2 non-managed locations). The number includes subprefectures and excluded locations.
Removes any previously specified geo codes from the column. For example, if you specify remove_content in the Region column, the campaign no longer targets prefectures. If you remove the geo codes from both location columns, the campaign returns the Yahoo! Japan default setting of targeting all locations.
For Yahoo! Japan ad groups only. Because Yahoo! Japan ad groups always inherit location targeting, the columns are read-only and always display (inherited).
The following bulksheet columns are read-only. They’re included in a bulksheet for consistency but aren’t relevant at the Yahoo! Japan campaign level. They always display the current targeting settings for the campaign. At the ad group level, the columns display the current targeting setting that the ad group is inheriting from the campaign:
- Effective region
- Effective metro
- Effective excluded region
- Effective excluded metro
The following bulksheet column specifies the bid adjustment for mobile devices:
- Mobile bid adjustment %
To set a mobile bid adjustment, enter a percentage to increase or decrease mobile bids:
- To increase bids on mobile devices, enter a percentage of up to 300%.
- To decrease bids on mobile devices, enter a negative percentage, to -100% (excluding -91% to -99%).
The column doesn't display (inherited) if the ad group is inheriting the setting from the campaign.