Use the Import Campaigns page to download a bulk CSV or XML (available only in the US, UK and AU) 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: The Import link 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 Daily Spending Limit, enter an amount. This amount can be set individually for each campaign you create; however, your Account Daily Spending Limit overrides any budget settings at the campaign level.

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.
5. In the Keyword column, enter the keyword (one per line).
6. Optionally, enter any keyword alternate text in the Keyword Alt Text column.
7. Optionally, enter a keyword custom URL in the Keyword Custom URL column.
8. 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.
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 keyword 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 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.
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 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 account or ad group level, To add account level excluded words:
   • In the Component Type column, enter Account Excluded Word.
   • In the Component Status column, enter On.
   • In the Keyword column, enter the keyword (one per line).
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.

You may create additional campaigns, ad groups, ads and keywords in the bulk template file, each by following steps 1-5.

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.

Column Name	Definition
Campaign Name	The unique name that you create to identify a campaign. This column must be filled out for every row in the spreadsheet.
Ad Group Name	The unique name that you create to identify an ad group. This column must be filled out for every row in the spreadsheet, except for the Campaign rows.
Component Type	A component type can be a campaign, ad group, ad, keyword, or ad group excluded word. Complete this column to indicate the component type for a particular row.
Component Status	Indicates the status of the component type entered in a particular row. This column must be filled out with either “On” or “Off” for every row in the spreadsheet to indicate the status you request. Note: When a component status is enclosed in square brackets, one of its parent component types has a deleted status.
Display Status	A brief description that shows whether or not a component (Campaign, Ad Group, Keyword, or Ad) are active, as described in the Statuses topic. If the primary reason that a component is not active is because its "parent" entity is not serving, the parent status appears before the component status, and the parent and component statuses are enclosed by [] and () respectively. For instance, a Keyword may be inactive primarily because its parent Ad Group is inactive. Do not edit this value.
Keyword	The keyword you are creating, editing or deleting. This column must be filled out for each row in the spreadsheet with the component type specified as keyword.
Keyword Alt Text	Alternate text defined for a keyword, which allows you to reword the keyword to better fit within the sentence structure of the title or description when using the Keyword Insertion feature for Sponsored Search and Content Match. This column must be filled out for each row in the spreadsheet with the component type specified as keyword.
Keyword Custom URL	Custom URL specified for a Sponsored Search keyword. This column may be filled out for rows where the component type is specified as keyword.
Sponsored Search Bid (USD)	This column is used when campaign optimization is OFF and will be blank if optimization is ON. The values include Default and {BID VALUE}. Default means that the default bid is in use. {BID VALUE} is the custom bid you specified. Please do not use "$" or "{" in the bulk template file. Example: 1.35 This column may be filled out for rows with the component type specified as either ad group or keyword.
Sponsored Search Bid Limit (USD)	This column is used when campaign optimization is ON and will be blank if optimization is OFF. The values include Default and {BID LIMIT VALUE}. Default means the keyword is using the default bid limit. {BID LIMIT VALUE} is the custom bid limit you specified. Please do not use "$" or "{" in the bulk template file. Example: 1.35 The campaign bid limit will not appear in this column. This column may be filled out for rows with the component type specified as either ad group or keyword.
Sponsored Search Min Bid (USD)	The minimum bid required to keep all of the ads in the Sponsored Search ad group active through the ad group default bid. Please do not edit this value.
Sponsored Search Status	Indicates whether Sponsored Search is on or off. This field may be filled out for rows with the component type specified as either campaign or ad group.
Match Type	Indicates whether the Standard match type or Advanced match type for Sponsored Search is on. Advanced means the Advanced match type is in use. Standard means the Standard match type is in use. This column may be filled out for rows with the component type specified as campaign, ad group, or keyword.
Content Match Bid (USD)	This column is used when campaign optimization is OFF and will be blank if optimization is ON. The values include Default, {BID VALUE}. Default means the default bid is in use. {BID VALUE} is the custom bid you specified. Please do not use "$" or "{" in the bulk template file. Example: 1.35 This column may be filled out for rows with the component type specified as ad group.
Content Match Bid Limit (USD)	This column is used when campaign optimization is ON and will be blank if optimization is OFF. The values include Default and {BID LIMIT VALUE}. Default means the ad group is using the default bid limit. {BID LIMIT VALUE} is the custom bid limit you specified. Please do not use "$" or "{" in the bulk template file. Example: 1.35 The campaign bid limit will not appear in this column. This column may be filled out for rows with the component type specified as ad group.
Content Match Min Bid (USD)	The minimum bid required to keep the Content Match ad group active, if the ad group is enabled for Content Match. Please do not edit this value.
Content Match Status	Indicates whether Content Match is On or Off. This field may be used in rows with the component type specified as either campaign or ad group.
Ad Name	Unique name that identifies an ad, for use in rows with the component type specified as ad.
Ad Title	Title that appears in the ad. Maximum length is 40 characters. This field may be filled out for rows with component type specified as ad.
Ad Short Description	Short description of the ad used in certain ad formats. Maximum length is 70 characters. This field may be used for rows with the component type specified as ad.
Ad Long Description	Long description of the ad used in certain ad formats. Maximum length is 190 characters. This field may be used for rows with the component type specified as ad.
Ad Display URL	The Display URL designated to appear with the ad, instead of the destination URL. Maximum length is 1024 characters. This field may be used for rows with the component type specified as ad.
Ad Destination URL	The Destination URL is the landing page that is accessed when the ad is clicked. Maximum length is 1024 characters. This field may be used for rows with the component type specified as ad.
Watch List	A list of campaigns, ad groups, and keywords that are of particular interest to you. The Watch List can be viewed from the Dashboard page. Values include On and Off.
Campaign ID	A number that uniquely identifies a campaign. Please do not edit this value, as it is used when editing an existing campaign, ad group, ad or keyword.
Campaign Daily Spending Limit	Manages the amount set for each campaign; however, your Account Daily Spending Limit overrides any budget settings at the campaign level.
Campaign Start Date	The first date that a campaign is scheduled to run, formatted depending on your market (e.g. MM/DD/YYYY).
Campaign End Date	The last date that a campaign is scheduled to run, formatted depending on your market (e.g. MM/DD/YYYY).
Ad Group ID	A number that uniquely identifies an ad group, included in rows with the component type specified as ad group and its associated ad and keyword rows. This column must be filled out for every row except those with the component type specified as campaign. Please do not edit this value.
Ad Group: Optimize Ad Display	Indicates whether Optimize Ad Display is On or Off.
Ad ID	A number that uniquely identifies an ad, for use when editing or deleting rows with the component type specified as ad. Please do not edit this value.
Keyword ID	A number that uniquely identifies a keyword, used when editing or deleting rows with the component type specified as keyword. Please do not edit this value.
Checksum	Internal value used to determine whether a row has been updated. Please do not edit this value.
Error Message	This column may contain a system message returned in the Feedback File after an import is processed. Please do not edit this value.

---

To learn more about campaigns and downloading data, see:

• Downloading Component Data

• Campaign General Information

• Campaign Settings

• Campaigns

---