Upload Your Google AdWords Campaigns into Yahoo and MSN adCenter in a Flash!

By ,

3 SHARES
ppcsavetime3

Since this week’s topics are all about saving PPC advertisers time when managing their accounts, this one is a must-know-and-use strategy that will surely help save you time creating new PPC campaigns, ad groups or accounts as a whole.

If you’re like most people, you start out with a Google AdWords account. Either you can build it from scratch in Adwords or you can use Adwords Editor, which is a free desktop software program that allows you to make bulk edits to your account. If you don’t know this already, you can take what you have in Google, and easily and quickly upload those changes into Yahoo! and MSN.

Upload into Yahoo!

Step 1: To upload your Google AdWords accounts into Yahoo, simply download your account, campaign or ad group from Google into a .csv file.

Step 2: Once you have this csv file, you’ll want to delete any negative keywords from the file since yahoo doesn’t convert negative keywords. You’ll also want to change the start date if there is one listed. Save that file, and log into your Yahoo account.

Step 3: Once you’re into your Yahoo account, click on the campaigns tab, then the “Import” link, then the ‘Convert third party campaigns’ tab.third-party-converter

Step 4: To convert your Google file into the Yahoo! format, simply upload your Google .csv file, give it a name, and hit the convert button on this page. This will literally take your Google .csv file and format it automatically for you so that you’ll have a completely editable file for Yahoo.

Step 5: Once your converted file is complete, you can download it in the ‘converted campaign file’ column. Download your new file and save it to your desktop. Then,

Step 6: Back in yahoo, click on the ‘import campaigns’ tab near the convert third party campaigns tab. Here, you again simply upload your new file, name it, and hit upload.

This will literally upload everything you had in Google directly into Yahoo with zero manual editing!

Uploading into MSN adCenter

Step 1: Once you are logged into your account, click on the campaigns tab. There is an option located above your list of campaigns to ‘Import campaigns…’, click it! You can then select either an excel or CSV template to choose from when adding in your new campaigns. MSN has a slightly different format than Yahoo, it won’t directly ‘convert’ the Google file for you, you have to format it manually, but it’s not hard. The key thing to remember is that you can only upload up to 500 lines into MSN at one time.

msn-import

Step 2: Format your file. The MSN formatting of the excel or CSV file is as follows:

Campaign > Ad Group > Keyword > Keyword Matching > Current Maximum CPC > Keyword Destination URL > Headline > Description line 1 > Description Line 2 > Display URL > Destination URL.

If you follow this order in your MSN template, you should be able to upload your new campaigns into MSN without stress!

Step 3: Now, once you have your new file formatted according to MSN’s specs, you can literally go to the same page under the campaigns tab in your MSN account, and import your file normally. I rarely have problems importing my Google or Yahoo campaigns into MSN. The only thing that will hold me up is the 500 line limit, so be watchful of that!

The truth is that Yahoo and MSN knows if they are compatible with Google they’re going to benefit. These two major search engines may be the next two down from Google, but they also know everyone usually starts out in Google. By making it easy to upload your Google AdWords campaigns, Yahoo and MSN are getting more money too. This is a great way to quickly transfer or move your accounts over with minimal effort on your end.

ACO_endad_Secrets

Twitter Facebook LinkedIn Google+ Email Print More
  • http://www.guiltybyaffiliation.com Justin M.

    Thanks, this is what I really needed. My Yahoo account doesn’t give me an option to import. I heard that this is a function that is added manually by Yahoo once your account reaches a certain threshold. I can’t wait until I am able to import my large google adwords campaigns into Yahoo.

  • http://www.rockyfu.com/blog/ Rocky Fu

    When you upload adwords file to Yahoo, need to be careful about currency issue. As for yahoo, some markets use local currencies like Taiwan, Hong Kong, etc. So, you may want to update the currency related values before uploading like max CPC, daily budget.

  • http://www.leapfrogg.co.uk Amelia

    The only thing that really annoys when you do a “bulk upload” to MSN with the template, is that you then have to go and approve all ad group settings/stages to take it out of draft status. Surely that is a step that could be removed!??

  • http://www.performicsinternational.com eloi

    Awesome post Amber. There always is a thread, somewhere on the net, asking “how do i import a campaign into yahoo” etc… If using the best practice you described very well, there should be nooo problem :)

  • Matt

    Hi Guys,
    I’ve tried this several times before, and although it sounds ideal in practice it still is quite cumbersome. Certain features of the Google account won’t transfer over and it causes an error (onto Yahoo anyway) and stops it uploading. You then need to go through and fix the problem before attempting again. Once account got up to 15 attempts before we gave up and got Yahoo staff to upload.

    It might just be us being useless but haven’t found this uploading system very easy. If only there was a rival to adwords editor!

  • http://searchbeest.com Jonathan Beeston

    You should really follow up on this post with an explanation of why it’s a bad idea to load your Google account into Yahoo and Microsoft. Just because the functionality is there, it doesn’t mean you should use it.

  • http://blog.ppcproz.com Dan PPCPROZ

    excellent post, thanks so much Amber

  • http://searchcorner.blogspot.com/ krishna

    I agree these are some nice points made here. But, how come this be beneficial as we are trying to work on same keywords in all the accounts. Can we achieve good results trying out the same campaigns/keywords in different networks. I was thinking of something different here. Try different keywords in different networks for better results..what say?

  • http://hirendesai.com hiren

    I do not think this is an ideal thing to do. As correctly mentioned in above comments, i agree that we always try different keywords in different search engines… what works in google might not work on yahoo or msn. Though this is a good feature to save time but not recommended.

  • http://www.ppchero.com Amber

    Some people have pointed out that this method of uploading Google into Yahoo and MSN shouldn’t be done, even though the functionality is there. In reality, all three search engines perform differently, and shouldn’t have all the same bids, settings, etc. But doing this is a good start – and that’s the basis of the post. To get started quickly! Once you have uploaded all of your keywords into Yahoo and MSN, you’ll want to check on your stats and still see where your bids need to be adjusted on certain keywords and so on. Essentially, you do want the same keywords in all three accounts, just a different bids more than likely.

    Also, yes there are some things you will need to change in your Google file before uploading into yahoo like negative keywords and start date as an example. If you are continually having problems uploading, just contact a yahoo or MSN rep and they can help you format your file to upload into their system. Trust me, they want your business so they’re more than willing to help!

    @Justin, just call your Yahoo rep or email Yahoo and ask them to add the import feature to your account. You no longer have to meet a threshold to get this feature!

    @Amelia – I agree, that part of uploading into MSN is a real pain. Just email or call MSN and they will more than likely do this step for you!

  • http://www.searchlaboratory.com Ryan

    Hi Amber,

    Microsoft adCenter Desktop makes importing campaigns from Adwords way easier than it used to be. You can upload an export of an Adwords campaign (in csv format) straight into adCenter Desktop without having to modify the structure at all. And the 500 line limit you mentioned doesn’t apply either. It is so much easier!

  • http://ppchero amber speer

    @Ryan, yes you’re right. Using adCenter desktop is great. I only wish yahoo could get something like it!

  • adamp

    How do you handle subsequent changes to a campaign?

    For example, say after importing my adwords capmpaigns into yahoo, i make subsequent changes in google.

    How do i reflect those changes in yahoo / msft?

    If I redo the import process as you outlined, does that overwrite what i previously imported? will it duplicate a lot of stuff?

    i guess the point is, do you have techniques to only apply ‘deltas’?

    thanks in advance and great info FYI.

  • http://www.ppchero.com Amber

    @Adamp, it will not overwrite what is already in yahoo and msn. It will recognize campaigns that already exist and make changes according to the campaign. I do this several times throughout the month. Note that if you are adding anything, you must copy and paste the same campaign, ad group, or ad id number in that row in order for yahoo or msn to recognize it.

  • adamp

    Thanks Amber, however when I create an export file from the Google Editor, there is no ad ID column in the .csv file. Am I missing something?

  • http://twitter.com/eagle8 Keith Horwood

    This is going to become very important, what with the Search alliance. Never has a time come when people are more in need of a PPC Hero! It’s a good time to become familiar with the adcenter desktop tool for importing google campaigns or yahoo campaigns. Can take some time but the results I had at Christmas made the it well worth it.

  • Nick A.dams

    Great post!
    Now  that MSN AdCenter and Yahoo have merged – it’s even easier to do this using their import feature. I use ppc keyword toolz to export all my adgroups and ads and keywords and then quickly import into MSN – it takes me less than 3 minutes.  

  • Pingback: yamaha yzf r6