 |
Tips on Uploading Google Campaigns into YahooPosted by Amber on July 29, 2008 in Yahoo! Search Marketing |
A while back I wrote on how to take an export of your Google Adwords campaigns and use the Yahoo Third Party Converter Tool to bulk upload into Yahoo. While the process itself is fairly simple, a lot of people are still running into problems. In order to be successful at bulk uploading your Google Adwords campaigns into Yahoo, first you must have the import feature in Yahoo before you can use the Convert third party campaigns tool. In order to get the import feature simply call your Yahoo rep and ask for it. Below I have described some tips along with common errors I have run into in the past and how I got around them:
1. Delete negative keywords
a. Because you can add negative keywords within Google in the keywords tab of your ad group, you can’t do this in yahoo. Therefore you must remove all negative keywords from your spreadsheet before uploading them into Yahoo.
2. You cannot edit actual keywords in bulk form then upload into yahoo
a. Yahoo only allows you to delete and add keywords in your spreadsheet. You cannot modify an existing keyword then upload the file.
3. Fill in columns if adding ad text or additional keywords
a. Before submitting your spreadsheet, be sure to copy down all campaign and ad group id columns so Yahoo knows which ad or keyword should be under which campaign and ad group.
4. Be sure start date is listed
a. If you are uploading a brand new spreadsheet into a new yahoo account, be sure to fill in the yahoo start date column before uploading your spreadsheet.
Types of Errors and how to fix them:
If you get this error:
Error: “Can’t determine parent ad group or parent campaign.”
Fix: This means you haven’t copied all column data with your new additions. (See #3 from above)
Error: “Cannot add keyword because it already exists within the campaign.”
Fix: While Google allows you to add singular and plural versions of your keywords separately, Yahoo takes both plural and singular as one. It’s okay, you don’t have to do anything at this point. Yahoo will kick out the duplicate keywords for you.
If there are any other errors you are running into while bulk uploading your Google campaigns into Yahoo, please feel free to let me know and I will research how to get around it!
- Our Greatest Hits for January!
- 5 Tips That Will Make Bulk Uploading into MSN AdCenter Headache Free
- Upload Google Campaigns in Yahoo! in Three Easy Steps
- PPC News Roundup for July 3, 2008
- MSN adCenter Desktop Is Now Ready For Public Testing
July 29th, 2008 at 4:10 pm
[...] Tips on Uploading Google Campaigns into Yahoo, PPC Hero [...]
July 30th, 2008 at 4:23 am
Hi,
When I try to uplaod my csv file into Yahoo, I get an error message saying “The upload file you selected does not contain a valid header”.
I would appreciate any help from you on why this is happening and how to fix this. I tried removing the negative keywords but it still does not help.
Thanks!
July 30th, 2008 at 5:28 am
[...] by bidding directly through the Yahoo system. Amber over at PPC Hero offers up some tips on exporting your Google AdWords info and then uploading it into the Yahoo system to make campaign expansion [...]
July 30th, 2008 at 6:21 am
[...] Tips on Uploading Google Campaigns into Yahoo, PPC Hero [...]
July 30th, 2008 at 11:38 am
Hi, if you’re getting an error message saying the upload file you selected does not contain a valid header, more than likely that means that the file didn’t download correctly from the third party converter tool. I would suggest trying to convert your original file in yahoo again and see if that helps. Be sure you’re not taking the converted file from the converted campaign file column and not the comments column. The comments column will give you the exact same file you downloaded from Google but with comments/recommendations of things you need to change in order to get a successful spreadsheet ready for Yahoo.
August 3rd, 2008 at 7:07 am
[...] original here: Tips on Uploading Google Campaigns into Yahoo [...]
August 6th, 2008 at 1:20 am
[...] Tips on Uploading Google Campaigns into Yahoo, PPC Hero [...]