Overview

The Import Campaigns page in the Campaigns tab allows you to upload a file to create, edit or delete multiple campaigns, ad groups, keywords and ads at once. We also provide you with a downloadable template file in which to insert your selected campaign information. After you complete the template file, you can upload the information into your account.

Benefits

• Save time editing the bids, URLs, ad text, and settings for your campaigns.
• Create entirely new campaigns from a file that you upload.
• Import your campaign information to a spreadsheet for reference and archival purposes.

How It Works

To import your new campaigns, ad groups, ads and keywords:

1. Log into your account.
2. In the Campaigns tab, click on the Import subtab.^*
3. In the Import Campaigns page, click on the CSV link to download a new template file. The template file is a spreadsheet that you use to record your campaigns, ad groups, keywords and ad information. For more information on the spreadsheet, please click here.
4. After you complete the template file, save and optionally compress the file on your computer.
5. In the Import Campaigns page, click the Browse button and select your template file and click Open.
6. Enter the name for your upload in the Import Name field and click Upload. Please note that if there are any errors in your template file, a comment file containing the comments will be available in the Import History tab.

Large Downloads

Excel 2003 limits spreadsheets to 65,536 rows. If you have a large Yahoo! Search Marketing account and are using this version of Excel, your template file may exceed this limit. In order to view your full account download, you will need to distribute the information onto multiple Excel tabs. Instructions for placing an oversized bulksheet file onto multiple Excel 2003 tabs are provided below.

Excel 2007 allows for a larger grid size (up to 1,048,576 Excel rows), so this process may not be required.

Note: You must have Textpad®, a third-party text editor, installed to complete the process below. For more information and to download this program, visit http://www.textpad.com/download/index.html.

To place an oversized download file onto multiple Excel 2003 tabs:

1. Open a blank Excel 2003 Workbook.
2. Download the campaign(s) of your choice by clicking the “Download Campaign” button and saving the file(s) to your desktop.
3. Unzip/extract the saved file(s) to your desktop.
4. Right click the unzipped Excel file and select “Textpad”.
5. Wait for the file to open up in Textpad® completely.
6. Hit Ctrl+Q, L to turn on the line number feature in Textpad®.
7. Starting from the top of the file, scroll all the way down until you reach Row 50,000.
8. Hit Ctrl+Shift+Home to select the first 50,000 rows of the file.
9. Hit Ctrl X to cut the rows, then paste them in the first tab of the blank Excel workbook.
10. Repeat Steps 7 to 9 as needed, pasting no more than 50,000 rows on a new tab each time.
11. Save the file with a new name.

*The Import subtab will only appear if the Import Campaign feature is supported by your account.