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.
Step 2: Start Recording the Macro
Go the the Developer tab of Excel and click “Record 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.
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
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.
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!