Earlier this week I was trying to import a Google campaign into Yahoo!. Yahoo! has this tool that is supposed to convert a spreadsheet with Google campaign data into the correct format to work with Yahoo!. Well, that thing seems to be a piece of crap. We ended up having to manually move lots of columns around, change column names, and add lots of data that Yahoo! needed. It was a pain in the butt. And then it still didn’t work…at first. If you are trying to do this same thing, here is what we had to do to make it work.
1. We had to first create a campaign in Yahoo! to hold the new campaign data. Unless I’m wrong, you can’t actually create a new campaign by importing the data – you can only add data to an existing campaign.
2. We had to specify our newly created campaign ID in the import spreadsheet.
We had also originally specified IDs for our new ad groups (which we made up), but Yahoo! did not like this. So…you DO specify a campaign ID in the import file, but you DO NOT specify ad group IDs.
There was a lot of work that had to be done on the import file (which was created by doing an export from Google AdWords Editor, which we have blogged extensively about), but the frustrating thing was when we got to the point of importing the file and it still didn’t work. That is until we took the above steps.
If you need help managing your Google or Yahoo! campaigns (or any other search engine), feel free to contact Work Media at 888-299-4837 or email Info@WorkMedia.net.