Use the Import Campaigns page to download a bulk CSV or XML template file to create, edit, or delete multiple campaigns, ad groups, keywords and ads at once. You can then upload the completed file into your account.

If you have third party campaigns, you can also convert them into the Yahoo! format.

Note: Import will not appear if the Import Campaign feature is not supported by your account. If you do not have ability to import campaigns, you can still use bulk function to download your campaigns, ad groups, or keywords.

• Creating and Importing a New Bulksheet

• Editing Existing Campaigns, Ad Groups, Ads, and Keywords

• Deleting Existing Campaigns, Ad Groups, Ads, and Keywords

• Viewing the Import History for Your Account

• Converting Third-Party Campaigns

• Understanding the Bulk Template File

Creating and Importing a New Bulksheet

The bulk template file is a spreadsheet that you can download and fill out with campaign, ad group, keyword, and ad information.

Downloading the Bulk Template

To download the bulk template:

1. Click Campaigns tab > Import, located under the Campaigns tab. The Import Campaigns page opens.
2. Select either the XML link or the CSV link to download a new bulk template file to your computer. This bulk template file is a spreadsheet you can use to record your campaign, ad group, keyword, and ad information. Both the XML and the CSV bulk template contain the same columns; however the XML version is better structured to help you enter your data.
3. Read the Understanding the Bulk Template File section to become familiar with the bulk template.
4. Continue on to the procedures below to create a new bulk template. Repeat the steps as needed in under to add more campaigns, ad groups, ads, and keywords to your bulk template.

Creating a New Bulksheet from the Template

Step One – Adding Campaign Information

In the first blank row of the spreadsheet, enter your new campaign information. This row should contain only campaign specific information.

1. In the Campaign Name column, enter a campaign name. This column must be filled out for every row in the spreadsheet.
2. In the Component Type column, enter Campaign.

3. In the Component Status column, enter On or Off. This will create your campaign with campaign status of On or Off.

   Note: If you set the component status to On and enter a campaign start date in the future, your campaign status will appear as Scheduled when you log in to your account.

4. In the Sponsored Search Status and Content Match Status columns, enter On or Off to select the distribution tactics to use in this campaign.
5. In the Match Type column, enter Standard or Advanced to specify which match type to use for this campaign.
6. In the Watch List column, enter On or Off. This specifies whether or not to add your campaign to your campaign watch list.
7. In the Campaign ID column, leave the Campaign ID column blank. A unique Campaign ID will be created when your campaign is imported into your account.
8. In the Campaign Description column, enter a description.

9. In the Campaign Start and Campaign End Date columns, enter the campaign start date and campaign end date in the form mm/dd/yyyy to define the campaign schedule. For instance, a Campaign Start Date of 01/31/2003 would have started the campaign on January 31, 2003.

   Note: If you leave the Campaign Start Date field empty, the campaign will default to begin the same day of the import. If you leave the Campaign End Date field empty, the campaign will run continuously.

Step Two – Adding Ad Group Information

In the next blank row of the spreadsheet, enter your new ad group information. This row should contain only ad group-specific information.

1. In the Campaign Name column, enter the campaign name for the ad group. This column must be filled out for every row in the spreadsheet.
2. In the Ad Group Name column, enter an ad group name to identify your ad group. This column must be filled out for every row in the spreadsheet, except for the Campaign rows.
3. In the Component Type column, enter Ad Group.
4. In the Component Status column, enter On or Off. This will create your ad group with ad group status of On or Off.
5. If applicable, enter your bid. Bids are required if you have enabled the corresponding tactic. For instance, if you have enabled Sponsored Search, you must enter a Sponsored Search Bid.
   • You may enter a Sponsored Search ad group bid in the Sponsored Search Bid column.
   • You may enter a Content Match ad group bid in the Content Match Bid column.
   • Campaign optimization is not managed via the import campaigns process, so bid limits should never be set when creating new campaigns.
6. In the Match Type column, enter Standard or Advanced to specify which match type to use for this ad group.
7. In the Watch List column, enter On or Off. This specifies whether or not to add your ad group to your ad group watch list.
8. In the Campaign ID column, leave the Campaign ID column blank when you are creating a new campaign. A unique Campaign ID will be created when your campaign is imported into your account. Enter the Campaign ID of a pre-existing campaign if you would like to create this ad group in a campaign that already exists in your account.
9. In the Ad Group: Optimize Ad Display column, enter On or Off. This specifies whether or not to optimize ad display based on click-through rate.
10. In the Ad Group ID column, leave the Ad Group ID column blank when you are creating a new ad group. A unique Ad Group ID will be created when your campaign is imported into your account.

Step Three – Adding Keyword Information

In the following blank row of the spreadsheet, enter your keyword information.

Note: Each row should contain only 1 keyword. If you have multiple keywords to enter for the associated campaign, please enter one per row.

1. In the Campaign Name column, enter the campaign name for the ad group. This column must be filled out for every row in the spreadsheet.
2. In the Ad Group Name column, enter an ad group name to identify your ad group. This column must be filled out for every row in the spreadsheet, except for the Campaign rows.
3. In the Component Type column, enter Keyword.
4. In the Component Status column, enter On or Off. This will create your keyword with keyword status of On or Off.In the Keyword column, enter the keyword.
5. Optionally, enter any keyword alternate text in the Keyword Alt Text column.
6. Optionally, enter a keyword custom URL in the Keyword Custom URL column.
7. If applicable, enter your bid. Bids are required if you have enabled the corresponding tactic. For instance, if you have enabled Sponsored Search, you must enter a Sponsored Search Bid.
   • You may enter a Sponsored Search keyword bid in the Sponsored Search Bid column. This bid would override any ad group bid that you may have entered.
   • You cannot enter a Content Match Bid for a keyword. Please leave this column blank for each of your keywords.
   • Campaign optimization is not managed via the import campaigns process, so bid limits should never be set when creating new campaigns.
8. In the Campaign ID column, leave the Campaign ID column blank when you are creating a new campaign. A unique Campaign ID will be created when your campaign is imported into your account. Enter the Campaign ID of a pre-existing campaign if you would like to create this keyword in a campaign that already exists in your account.
9. In the Ad Group ID column, leave the Ad Group ID column blank when you are creating a new ad group. A unique Ad Group ID will be created when your campaign is imported into your account. Enter the Ad Group ID of a pre-existing ad group if you would like to create this keyword in an ad group that already exists in your account.
10. In the Keyword ID column, leave the Keyword ID column blank when you are creating a new keyword. A unique Keyword ID will be created when your campaign is imported into your account.

Step Four – Adding Ad Information

In the fourth blank row of the spreadsheet, enter your ad information.

Note: Each row should contain only one ad. If you have multiple ads to enter for the campaign, please enter one per row.

1. In the Campaign Name column, enter the campaign name for the ad group. This column must be filled out for every row in the spreadsheet.
2. In the Ad Group Name column, enter an ad group name to identify your ad group. This column must be filled out for every row in the spreadsheet, except for the Campaign rows.
3. In the Component Type column, enter Ad.
4. In the Component Status column, enter On or Off. This will create your ad with ad status of On or Off.
5. In the Ad Name column, enter the Ad Name to uniquely identify your ad.
6. In the Ad Title column, enter the Ad Title that should appear in your ad.
7. Enter either an Ad Short Description, Ad Long Description, or both.
8. Enter the Display URL and the Destination URL of your ad. If they are the same URL, enter the same URL in each column.
9. In the Campaign ID column, leave the Campaign ID column blank when you are creating a new campaign. A unique Campaign ID will be created when your campaign is imported into your account. Enter the Campaign ID of a pre-existing campaign if you would like to create this ad in a campaign that already exists in your account.
10. In the Ad Group ID column, leave the Ad Group ID column blank when you are creating a new ad group. A unique Ad Group ID will be created when your ad group is imported into your account. Enter the Ad Group ID of a pre-existing ad group if you would like to create this ad in an ad group that already exists in your account.
11. In the Keyword ID column, leave the Keyword ID column blank when you are creating a new keyword. A unique Keyword ID will be created when your keyword is imported into your account. Enter the Keyword ID of a pre-existing keyword if you would like to create this ad with a keyword that already exists in your account.

Step Five – Adding Additional Information

The fifth and final rows of the spreadsheet are used for optional and/or additional information.

1. In the fifth blank row of the spreadsheet,, you may optionally add excluded words to your ad group.
2. Please do not enter values in the Checksum or Error Message columns. Those will be populated with system information after your import.
3. You may create additional campaigns, ad groups, ads and keywords in the bulk template file, each by following steps.
4. When you have finished creating your campaign in your bulk template file, save the file on your computer. Note that you may want to compress the file size of your bulk template file by zipping it prior to import.

Final Step

After you have completed steps 1-5 as needed and saved (compressed) your completed spreadsheet into a bulksheet, you can complete the import process.

Importing the Bulksheet

To complete the import process:

1. In the Import Campaigns page, click the Browse button to locate the bulksheet on your computer. The Choose File dialog box opens.
2. Select your completed bulksheet and click Open.
3. Enter a name for your upload in the Import Name field and click Upload. The campaign information in your bulksheet will be imported into your account. If there are any errors in your bulksheet, a comment file will be created in the Import History table.

Editing Existing Campaigns, Ad Groups, Ads, and Keywords

To edit existing campaigns, ad groups, ads, and keywords:

1. Click the Campaigns tab. The Campaigns page opens.

2. Identify the campaign that you would like to edit and click the campaign name link. The Campaign Details page opens.

3. In the Campaign Details page, click the Download Campaign link in the upper right corner of the page and save the campaign file to your computer.

4. Open the campaign file using a spreadsheet program such as Microsoft Excel. The campaign file contains one row for the campaign, each ad group, each ad, and each keyword.

5. Identify which part of the campaign you would like to edit and find its corresponding row in the spreadsheet.

6. Please do not modify the values in the Checksum, Error Message, or ID columns.

7. When you have finished editing the appropriate rows in the campaign file, save the file on your computer. Note that to improve the performance of your import, you may want to compress the file size of your bulksheet by zipping it prior to import. You can also improve performance by deleting any rows from the spreadsheet prior to import.

8. In the Import Campaigns page, click the Browse button to locate the campaign file on your computer. The Choose File dialog box opens.

9. Select your completed campaign file and click Open.

10. Enter a name for your upload in the Import Name field and click Upload. Any edited rows of information in your campaign file will be imported into your account. If there are any errors in your bulksheet, a comment file will be created in the Import History table.

Deleting Existing Campaigns, Ad Groups, Ads, and Keywords

To delete existing campaigns, ad groups, ads, and keywords:

1. Click the Campaigns tab. The Campaigns page opens.

2. Identify the campaign that you would like to edit and click the campaign name link. The Campaign Details page opens.

3. In the Campaign Details page, click the Download Campaign link in the upper right corner of the page and save the campaign file to your computer.

4. Open the campaign file using a spreadsheet program such as Microsoft Excel. The campaign file contains one row for the campaign, each ad group, each ad, and each keyword.

5. Identify which part of the campaign you would like to delete and find its corresponding row in the spreadsheet.

6. In the Component Status column of each row you would like to delete, enter deleted.

7. Please do not modify the values in the Checksum, Error Message, or ID columns.

8. When you have finished editing the appropriate rows in the campaign file, save the file on your computer. Note that to improve the performance of your import, you may want to compress the file size of your bulksheet by zipping it prior to import. You can also improve performance by deleting any rows from the spreadsheet prior to import.

9. In the Import Campaigns page, click the Browse button to locate the campaign file on your computer. The Choose File dialog box opens.

10. Select your completed campaign file and click Open.

11. Enter a name for your upload in the Import Name field and click Upload. Any rows of information in your campaign file in which you changed the status to "deleted" will be deleted. If there are any errors in your bulksheet, a comment file will be created in the Import History table.

Viewing the Import History for Your Account

To view past import information:

1. Click Campaigns tab > Import, located under the Campaigns tab. The Import Campaigns page opens.

2. In the Import History section, view the imports that have been submitted for your account. If there are any errors in your bulksheet, a comment file will be created. Select the comment file link in the Comments column to view detailed information about the errors.

Converting Third-Party Campaigns

To convert your third-party campaign data to Yahoo! Search Marketing format:

1. Export your data from your third party account (such as Google AdWords). You can either export your data to a .csv file from the Google AdWords Editor or download a Google Bulkpost file from your Google AdWords account. Do not edit the file prior to conversion. After the file is converted, you can edit the information.

2. Convert the file and import it into Yahoo! Search Marketing. The instructions are listed below.

To convert and import your data from a third-party campaign into Yahoo! Search Marketing format:

1. Log in to your Yahoo! Search Marketing account.

2. Click Campaigns tab > Import, located under the Campaigns tab. The Import Campaigns page opens.

3. In the Import Campaigns page, click the Convert Third Party Campaigns tab.

4. Click the Browse button. The Choose File dialog box opens.

5. Select the file you downloaded that contains your third party campaigns.

6. In the Name field, enter a name for the Conversion.

7. Click the Convert button.

8. In the Converted Campaigns History table, you can track the progress of your converted spreadsheet.

9. When the upload is completed, check the Comments column in the Converted Campaigns History table.

   1. If the uploaded file contained an error, click the link in the Comments column to open the file and check the error listed in the Suggested Changes column. If necessary, update the file and repeat steps 4-7 above.

   2. If the Comments column is blank, the file was uploaded without error, and the Converted Campaign File column contains a link to the converted file.

10. When the converted campaign file is available, download and review the file. Note that once you download your converted campaign file, you may need to change the destination URL of your ads to ensure that they are passing the correct click source information. The source of the click is passed in your URLs for reporting and analytics purposes.

11. In the Import Campaigns page, click the Import Campaigns tab.

12. Click the Browse button to locate the converted campaign file on your computer. The Choose File dialog box opens.

13. Select your converted campaign file and click Open.

14. Enter a name for your upload in the Import Name field and click Upload. The campaign information in your converted campaign file will be imported into your account. If there are any errors in your bulksheet, a comment file will be created in the Import History table.

Note: Currently, only data in Google AdWords format can be converted to Yahoo! Search Marketing format.

Understanding the Bulk Template File

The bulk template file is a spreadsheet that you can download and fill out with campaign, ad group, keyword, and ad information. You can download the spreadsheet bulk template as either an XML or a CSV file type. Both file types contain the same columns; however the XML version is better structured to help you enter your data. The columns that appear in the bulk template file are listed below:

Table 1.

To learn more about campaigns and downloading data, see:

• Downloading Component Data

• Campaign General Information

• Campaign Settings

• Campaigns