Quickly Transferring Ads From AdWords Editor to Bing Ads Editor

tumblr_nqx8chHbKD1tubinno1_1280

When you regularly change out ad tests on a regular basis, you can spend a lot of time pausing, adding, labeling and tweaking ads in Google AdWords Editor. For me, the most unfortunate part of that is I have to turn around and make those same changes over again in Bing Ads Editor.

That’s the reason that I created an Excel Macro to make my ad porting a little easier. I’ll walk you through how to create this Macro so that you can easily port your ads over.

Step 1 – Select Ads in AdWords Editor & Paste Into Excel

Select the ads that need to be transferred. Copy and paste them into Excel. You’ll end up with more columns than you need as well as columns that are mislabeled for Bing. See the picture below to see how it looks when I paste.

Step1

Step 2: Start Recording the Macro

Go the the Developer tab of Excel and click “Record Macro.”

Macro

Step 3: Delete

Next, delete the Labels column as well as all columns after the Final URL in the spreadsheet. Adjust the name of the “Final URL” column to be “Destination URL” and then delete the previous “Destination URL” column. See the photo below to see how my spreadsheet looks after this is complete.

Step3

Step 4: Renaming Columns

There are some differences in what Google calls certain portions of its ads and what Bing calls those same parts. As long as your campaigns and ad groups are named the exact same way in Google as they are in Bing, this will all go smoothly. Take special note of capitalization. If one character is different, even a simple capitalization difference, you’ll end up creating a new campaign or ad group, potentially complicating your account.

Start by renaming the Headline column “Ad Title”. Next we need to turn two lines of ad text into one. Insert a blank column beside the two description lines. Then use the concatenate function in in that new column to combine Description Line 1 and Description Line 2. Here’s how it will look:

 =CONCATENATE(A1,” “B1)

Note, the ” ” is included to add a space between the text in the 2 cells so you get a naturally freeflowing sentence. Name this column “Ad Text”. After this is complete, you can use the hide function to hide these columns but still let them stay in the spreadsheet. See picture below

step4

Step 5: Stop Recording and Save

Now hit the stop button and make sure to save your spreadsheet in the macro-enabled template so you can come back to it later.

MacroEnabled

You can now easily copy and paste this information into Bing Ads Editor. The next time you need to make quick ad changes, all you’ll need to do is open this same spreadsheet, paste your Google data, then navigate to your macros list and hit go on the macro you just recorded and voila! Bing Ads data ready for upload.

Is this macro helpful for you? How do you use macros to make your life easier? Share with us in the comments!