1. Open the Adwords Editor and download the newest version of your account

2. Export desired campaigns, if not all, to as .csv file

3. Open the exported csv file in Excel

4. Remove all negative keywords(without sorting)(

• Select All(Ctrl + A)
• Turn on the “Filter”

• Filter the “Keyword Type” column to only include negative keywords

• Once only the Negative Keywords are showing select all rows(excluding row 1) and delete.
• Clear the filter

5. Save file as UNICODE TEXT and click YES on the warning screen that pops up after clicking save

6. Close the file in excel and DO NOT save changes

7. Login to your Yahoo Search Account

8. Click the Campaigns Tab

9. Click on the “Import” link

10. Click on “Convert Third Party Campaigns”

11. Hit the browse button

12. Find the unicode txt file you saved and Click once to edit the file name.  Add .cvs to the end(VERY IMPORTANT).

13. Select the file and click “Open” to add the file into the converting box

14.  Once you receive the confirmation screen, click on return to import history

15.  Open the converted file and look at the error columns.  If there are no errors you are done, if you have errors see below.

POSSIBLE ERRORS

Error Message: The Short Description Is Too Long. Please Enter A Valid Short Description. This means that your 70 character ad in Google turned into a 71 character Ad in Yahoo, because Yahoo forces a period at the end of every ad. Play with your ad and get it to fit within the 70 character limit with a period. Yes, exclamation and questions marks are fine too.

Error Message: The Keyword ________ Was Not Added Because It Is Covered By An Existing Keyword In Your Ad Group.

This means that your keywords is already somewhere in the account, and Yahoo won’t allow duplicates. If you really want it in there twice, call your rep and ask to have your account switched to an umbrella account, with a new account opened as a child account (there will probably be small fee involved). Redo the campaign import with the new account instead of the original account. (Remember you’ll need to load conversion tracking for the new account)

Error Message: Cannot Determine Which Campaign/Ad Group Is The Parent

I really hate this one. It means that you probably tried sorting the columns when working on a project and didn’t put it back precisely the way it was. Unless you’re working with only one or two accounts, it’s usually fastest just to start over.

After you correct these errors you need to re-download the Yahoo template and paste ONLY the corrected items. Then…

• In Excel, Click On “Save As” And Save The Template File As A .Csv File With A Different Name Than The Imported Campaign (Even If You Haven’T Saved The Imported Campaign)
• Again, Click Yes On The Warning Window That Says Formatting May Not Be Compatible With Unicode Text
• Close The File Without Saving Changes
• In The Yahoo Interface Click On The Browse Buttons On The Import Campaigns Tab
• Hit The Browse Button And Find The File To Upload
• Click Once And Add .csv To The End Of The File Name
• Give It Any Import Name (Can Be Identical To Your Conversion File Name) And Click Upload
• Once You Receive The Confirmation Screen, Click On Return To Import History
• You Will See The Status Be Labeled As “In Progress” For A While. Refresh Every 10-15 Seconds Until Completed

It’s possible that you get an additional error file, but it should be smaller than the original. Keep repeating the above steps until all errors are gone and you’ll be done! Congratulations!

Keep in mind some important issues:

• Bulk uploads are limited to 10mb/day/account.
• A day is defined by 24 hours, not a business or working day.
• If you are making account updates instead of 3rd party conversions, DO NOT try to upload anything that you don’t intend changing. Attempts can kick back error messages that will make things tedious.

Adwords, convert, Google, upload, Yahoo Search