Got Ads?
5/09/2007
  How To Convert & Upload Google AdWords Campaign To Yahoo Panama

Suppose you have a big Google AdWords Campaign, and you want to get it into Yahoo Panama. Here's what you need to do to convert an AdWords Campaign into Yahoo:

  1. Be a "Gold Tier" Yahoo Panama customer, so you can qualify for bulk upload. To be Gold Tier, you need to spend at least $500 per month for 3 months. If you've done that, and you don't see a "Import Campaigns" link on your Create a Campaign screen, you need to call Yahoo and get that added.
  2. Install the Google AdWords Editor
  3. Use Google AdWords Editor to Export your AdWords campaign to CSV.
    • Open AdWords Editor, and update your account information
    • Export your campaign as CSV from AdWords Editor. Select the specific campaign, and then choose: File -> Export to CSV -> Export Current Campaign
    • Open the exported campaign in Excel.
    • Change a lot of stuff in the Excel file. You generally don't want to upload the exact Google campaign. Look carefully at your bids. Also look at destination URLs, you may want to change tracking codes or parameters to indicate that the clicks will be coming from Yahoo. Save the changes.
  4. Goto "Import 3rd Party Campaign" tab in Yahoo Panama
  5. Import the campaign. Panama will upload your excel file, then convert it to it's format. When this is done, you download the file it creates, Check it carefully, and re-upload into Panama...
  6. Before loading it, go and make any Yahoo specific changes.
    • Change any tracking codes to indicate Yahoo sourcing.
    • Yahoo idiotically doesn't allow keyword substitution in the destination URL of the ad. However, it does have a field called "Custom URL" for each keyword, and you can set the specific keyword in the URL. That's handy for when your landing page needs to dispatch off the keyword (i.e. it can include the keyword in the generated landing page by pulling it from the URL.)
    • Look carefully at "Advanced Match" vs "Standard Match". Advanced Match is equivalent to "Broad Match" in Google. "Standard Match" is more like "Exact Match" in Google.
  7. Save the modified file. Set the file name to have a ".csv" file extension. BUT - Choose File type to be : "Unicode txt". The resulting filename must end in .csv.
  8. Go to the "Import Campaigns" tab in Panama
  9. Browse for the modified Excel file, give it an "Upload" name, and do "Upload".
  10. Wait a while.
  11. Check the new campaign. Look at any errors that may have happened during upload. Check carefully - seriously, mistakes can be costly!
  12. Go to the Dashboard page, select the new campaign and set a daily spending limit. You probably should turn off content matching as well.

Let it run. Check it tomorrow. Watch your logs in the meantime. See if it gets worse quality traffic due to all the garbage partners that Yahoo lets have Overture feeds (Hint: It will...)

Anyways, that's the easy and safe way. If you don't have access to the "Gold Tier" upload from Yahoo, you can call Yahoo and ask them to do it for you. If you do that, MAKE SURE you pre-edit the CSV file you give them, or else they'll just put in the stuff from Google, and you probably won't like that.

Labels: ,

 


Links to this post:

Create a Link



<< Home

Subscribe to GotAds?



Links



Recent Posts

How To Convert & Upload Google AdWords Campaign To Yahoo Panama


Archives

February 2005 /  March 2005 /  April 2005 /  May 2005 /  June 2005 /  July 2005 /  August 2005 /  September 2005 /  October 2005 /  November 2005 /  December 2005 /  January 2006 /  February 2006 /  March 2006 /  April 2006 /  May 2006 /  June 2006 /  July 2006 /  August 2006 /  September 2006 /  October 2006 /  November 2006 /  December 2006 /  January 2007 /  February 2007 /  March 2007 /  April 2007 /  May 2007 /  June 2007 /  July 2007 /  August 2007 /  September 2007 /  October 2007 /  November 2007 /  December 2007 /  January 2008 /  February 2008 /  March 2008 /  April 2008 /  May 2008 /  June 2008 /  July 2008 /  August 2008 /  September 2008 /  November 2008 /  December 2008 /  January 2009 /  March 2009 /