Yahoo! JAPAN Ads

Yahoo! JAPAN Ads Help

Campaign Editor for Yahoo! Display Ads helps you set up your ads. You can import the following elements:

  • Campaigns
  • Ad groups
  • Ads
  • Targeting settings
  • List data
  • Image files (images, logo images, video thumbnails)
  • Labels
Tips
Note
When you import the setting values of targetings, the setting will be replaced by each ad group (it removes the existing setting under the ad group, then overwrite with the new setting). Therefore, you need to enter settings that you don't change in the importing file with updating settings.

There are two ways to upload your data.

Upload CSV (or TSV) files

Available files

  • CSV file downloaded from the Campaign Editor
  • Template file downloaded from the Campaign Management tool
  • CSV (or TSV) file you created
Tips

Import data in the file

Steps
  1. Prepare a CSV (or TSV) file.
  2. From the menu bar, click "Import."
  3. Select “Import from CSV.”
  4. Click "Select."
    Tips
    You can upload (import) your lists, images, logos, video thumbnails, and labels from the common library.
     

    You can import "list", "image, logo, video thumbnail", "label" from Common Library.
    ・List :
     Click the "Import list data" on the menu of Common Library view, then select "Import from CSV".
    ・Image, logo, video thumbnail :
     Click the "Import image" on the menu of Common Library view, then select "Import from CSV".
    ・Label
     Click the "Import label" on the menu of Common Library view, then select "Import from CSV".

  5. In the "Select File" section, click "Browse."
    Tips
    You can download the template file (CSV) that can be used for importing, by click on the "Download Import Template (CSV)".
  6. Select the character encoding.
    Tips
    To apply the character encoding automatically detected, select it manually.
  7. Click "Preview."
  8. Make sure the data and column names match.
    • If they don't match, click the column name and select the correct one
    • To not to import, click "Do not import."
  9. Set other columns.

    (1) Import options
    Select how you want to import your data.
    ・Edit existing data based on name: When no existing names match, create a new one.
    ・Edit existing data based on ID: When no existing IDs match, create a new one.
    ・Add as new: Create all-new elements while not editing the existing data.
    (2) Columns
    The required items for each element appear.
    Tips
    • Selected columns appear in bold letters.
    • Not-selected columns appear in gray letters.
    • When you select the same columns, red letters appear.
  10. Click "Import."
  11. Check the errors and the available elements.

    (1) Check error details
    You can download the errors and the details in the CSV.
    (2) Number of import data
    The number of data that are or aren't available appears.
  12. Click "OK."
  13. The "Display Status" of the new data becomes “Edited.”
    If there is an error, its status becomes “Invalid.”
  14. Upload the data in the Campaign Editor to the Campaign Management Tool.
    To complete updating your ads, you must upload ads created in the Campaign Editor to the Campaign Management Tool. Learn more about_Upload data.

Upload text data

You can import text data in the clipboard. Paste it to the Campaign Editor.

Tips
Clipboard temporarily saves text data, etc. on your PC. You can import a part of your data on the CSV without creating an import file.
Steps
  1. Prepare text data.
  2. From the menu bar, click "Import."
    *The menu varies for creating data.
  3. Select “Text” from the menu to import text data.
  4. Copy text data and click "Paste from clipboard."
    *Keyboard short cut (Ctrl and V) is also available.
  5. Make sure the data and column names match.
    • If they don't match, click the column name and select the correct one. Make sure the pasted content and column names match.
    • To not to import, click "Do not import."
      You can edit the text data on this dialog.
  6. Set other columns.

    (1) Import options

    Select how you want to import your data.

    ・Edit existing data based on name: When no existing names match, create a new one.
    ・Edit existing data based on ID: When no existing IDs match, create a new one.
    ・Add as new: Create all-new elements while not editing the existing data.

    Note

    When selecting "Edit existing data using ID field as key", you can edit existing data on settings of campaign, ad group and ad by using each ID as key. Items other than campaign, ad group and ad can be edited and newly created by using name as key even when selecting "Edit existing data using ID field as key".


    (2) Columns
    The required items for each element appear.

    Tips
    • Selected columns appear in bold letters.
    • Not-selected columns appear in gray letters.
    • When you select the same columns, red letters appear
    (3) Download importing template
    You can download the template to be used for importing on Campaign Editor. Use this importing template when you create text data that you prepare on the step1.
  7. Click "OK."
  8. Check the error details and the number of imports.


    (1) Check error details
    You can download the errors and the details in the CSV.
    (2) Number of import data
    The number of data that are or aren't available appears.
  9. Click "OK."
  10. Upload the data in the Campaign Editor to the Campaign Management Tool.
    To complete updating your ads, you must upload ads created in the Campaign Editor to the Campaign Management Tool.
    Learn more about Upload data.

View this page in Japanese