Jun 11 2007
Adwords to Adcenter - Transferring Your Adverts & Adgroups
It not exactly the easiest process in the world but here is how I have been moving some paid search campaigns from Google Adwords to Microsoft Adcenter. Don’t expect everything to transfer exactly and also keep in mind that your Google ads are probably shown over two lines while your MSN Adcenter ads can be shown over one line and the link break is ignored.
Step 1 - Export Your Ads from Google
Log into adwords and choose Reports > Create Report
1. Report Type
ad Performance
2. Settings
Tick Text Ad
Date Range - This Month
Campaigns and Ad Groups - check “Manually select from a list”
then click Add in the left hand side to move the selected adgroups over to the right column.
3. Add or Remove Columns
Tick
Campaign
Ad Group
Site/Keyword
Ad Id (not required for adcenter but Google insist)
Match Type
Headline
Description Line 1
Description Line 2
Display URL
Current Mximum CPC
Keyword Destination URL
Destination URL
Impressions (again only required by Google)
4. Name the report and save the report template
Click Create Report
It may take some time to go away and have your lunch
when it’s finished download the file as csv (for excel)
Now you need to do some editing to the file
Delete columns I and M which should be adgroup ID and Impressions
Remove the first 6 rows of headings and labels etc
Remove the last row which is the totals
Sort by column C so that you can remove all rows that are about content targetting
Now you need to make sure your columns are in the following order
Campaign
Ad Group
Keyword
Keyword Matching
Max CPC
Keyword URL
Headline
Description 1
Description 2
Display URL
Destination URL
Then save as an excel file
Another problem here is that MSN doesn’t like ad titles which are of the form
{Keyword:Buy Stuff Here}
So you are going to need to do a find and replace on
{Keyword:
and
}
to get rid of them
Importing
Log in to Adcenter
Campaigns > Import
Make sure you select UK or whatever is relevant
Click import - point it at the excel file
cross your fingers, hold your breath and hope that it’s your lucky day
You’ll probably get some errors which have to be downloaded as a CSV file to review.
Some of these errors are purely created by Microsoft to help you grow in patience
However in the end it’s better than nothing - just!
You now need to go into your campaign in adcenter and go through and review every order as they are only imported in draft format. Nice touch eh?
If you give this a try then do leave me a comment and let me know if I have made any errors.



Trackbacks & Pingbacks
Trackback Address
16 comments | Leave your comment | Feed for this Entry
Jun 13th, 2007 at 2:10 am | #
Will we ever see a real alternative to Google Adsense and Adwords. I think that there is a market for someone willing to put the big bucks in and take on Google - but who would be brave enough?
Jun 13th, 2007 at 3:58 am | #
Thankyou, thankyou, thankyou!!! You just save me A LOT of time.
Jun 13th, 2007 at 9:13 am | #
I hope it does help Jamdo - let me know if I’ve missed any steps when you get a chance to follow it through.
Mark - I’m not convinced that there is much room for anyone else in the market to compete on an equal footing. I suppose I might have thought the same before google came along but they just seem to have both sides (audience & ads) totally cornered.
Jun 13th, 2007 at 9:26 pm | #
I agree, there is no one near big enough to battle Google advertising.
Jun 14th, 2007 at 11:00 am | #
Nice tips thanks. However, those implementing it should keep in mind that the market share of MSN is much smaller than that of Google - so don’t freak if you see few less hits and conversions. However, MSN users are known to convert better, at least in some markets, so who knows…
Jul 3rd, 2007 at 12:27 pm | #
So far the best way (that I’ve found) is to create campaigns in excel and upload to Google via the adwords editor. Then simply modify the excel sheet slightly to also do the upload to MSN. (via their import feature). I havent tried to export from Adwords first, then go to MSN.
Aug 8th, 2007 at 3:44 pm | #
Thanks a ton! I was putting off figuring this out, but its very easy actually. I’ll reprint your tutorial with a link back to you.
Thanks again!
Aug 9th, 2007 at 9:38 am | #
Rian - glad you’ve found this useful. It was a task I put off for ages too but it’s not that bad in the end.
I’d be delighted if you do link to the article and use a short excerpt but please don’t reprint it in full, thanks!
Sep 19th, 2007 at 4:01 pm | #
if you are going to keep dynamic keyword insertion in for the ad description/destination URL ensure you change {KeyWord:Default Text} to {keyword} and note its case sensitive.
also I found I had to put in the adcenter column headers (from the template) otherwise it wouldn’t accept the file
anyone found a bulk way to submit the newly imported from “draft” to “active”?
Oct 18th, 2007 at 12:08 pm | #
Interesting Information should give it a try
Dec 26th, 2007 at 8:17 pm | #
Thank you for saving me time!
Sep 8th, 2008 at 11:16 am | #
This will help you turn draft campaigns active without visiting each individually.
http://forums.microsoft.com/AdCenter/ShowPost.aspx?PostID=2342623&SiteID=44
Hope it helps. Ian http://www.iplanware.com
Sep 8th, 2008 at 1:22 pm | #
That’s handy Ian - thanks
Sep 9th, 2008 at 3:20 pm | #
The destination url doesn’t import. Anyone notice this?
Sep 22nd, 2008 at 1:41 pm | #
nice, I should start doing that
Dec 4th, 2008 at 9:40 pm | #
It’s far easier than that! Just use Google AdWords editor - File - Export whole account in csv format and then import it to adCenter using the desktop tool. If there are errors they will clearly be shown and usually they are simple things like reducing ad text.
Comment Guidelines:
You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Off-topic or inappropriate comments will be edited or deleted.
Email addresses will never be published.