Love Me Tender: Uploading Negatives Into Bing
February 7, 2012
Welcome to the second installment of our PPC Love Series this month. Even though today is my birthday, which is a very happy day, I am prepared to tell you about my heartache and strife with the adCenter editor and it’s sometime unwillingness to be a good PPC partner. So what do you do? Keep it around or break up with it? Many times I have wanted to end the relationship, but I stuck it out. And you will too after reading this amazing editor tip on how to upload your negatives in bulk. Really. You will love this more than Elvis loved grilled peanut butter and banana sandwiches.
In the past 6 months, my relationship status with adCenter and the desktop editor has changed from “It’s Complicated” to “Engaged.” I have become proficient with these PPC tools and if I don’t know where something is, I poke around until I find it. But this stumped me for sure: How in the world can I save time and upload a bulk list of negatives? I don’t have to insert each keyword into their ad groups individually, do I? If that is the case, this relationship is over. Don’t get me wrong, I am all for working on solving a problem, but I would never get to anything else in my accounts! So, I asked for help. Yup, the adCenter editor and I went to counseling and here is what I learned.
Step One: Gathering Your Information
In order to create a negatives keyword list, you need to perform a Search Query Performance report. If you have not pulled this report in a while, I suggest taking a 3-month snapshot. This will be a lot of data to sort through, but it’s all valuable information! Sort your excel spreadsheet in ascending order by the search term and start scrolling. The first move is to find search inquiries that are completely bizarre and have nothing to do with your account and mark those as negatives. It could be a word, a phrase, or you may want to eliminate the entire search as an exact match. Next, sort by conversions. This is a great way to actually expand your account by adding in these higher converting words or phrases. On the flip side, you can exclude things that have not converted or have a very low click-through rate. Once your exclusions are made, create your new upload sheet.
Step Two: Prepping Your Information
Creating your bulk upload sheet is simple. Create your columns and fill in your information. The following columns are required for upload:
- The column will be filled with either “Campaign Negative Keyword” or “Ad Group Negative Keyword.” This will depend on where you want your negative to be placed.
- Will it be on the Campaign or Ad Group level? Remember, Ad Group level negatives will trump Campaign level negatives.
- The column will be filled with the different Campaign names and is needed for Campaign AND Ad Group level negatives.
- Ad Group:
- This column will only be needed if “Ad Group Negative Keyword” is the Type.
- This column should say “Active.”
- This column will be filled with the negative keyword you want to upload.
- Remember that adCenter will not recognize a match type column for negative keywords. So where you would actually delete out the match type signifier out of your Google keyword column, for adCenter, you will need to add them in!
- Phrase Negatives should be signified with “quotes”
- Exact Negatives should be signified with [brackets].
- Broad Negatives – tricked you! There is no such thing in adCenter… don’t forget that!
Step Three: Uploading Your Information
In the editor, you can upload in a couple different ways. You can choose to cut and paste your information and hope that you have all of your columns set up correctly, or you can import from an Excel spreadsheet. We are going to go with the latter because it puts up less of a fight!
Log into your account, synch the account to make sure the editor and the User Interface are on the same page and click the “Import” icon in the Home Tab in the Data box.
One thing to note when using this function, is that you must uploaded your data from a single tab excel workbook and save it to the desktop. If you have multiple tabs in your document, the editor will become confused and not know what information to pick… (Ladies, does this sound like any ex-boyfriends you know!? Just playing guys!) So, keep it simple – one tab!
The editor will ask for a file name and then it will actually give you the option to view your import (al la Google!). This is the best feature of the Import Wizard, which is why I prefer using it instead of the cut and paste method.
Once you hit “Next”, you are on your way to upload! The rest of the process is the same as uploading your keywords or your bid changes. Don’t forget to synch your account back up with the User Interface when you are done with all of your edits!
This uploading technique is quick and simple and should save you a whole heck of a lot of heartache with adCenter. See, you don’t have to break up and throw all of your campaigns out on the street after all. Just by giving your account tools a little love, you too can have a strong, healthy relationship with adCenter.
Please let us know what tools make your life as a PPC Manager a little bit easier! Be sure to check out Sarah’s post tomorrow about the love between AdWords and Analytics reporting. Thanks, as always, for reading PPC Hero!
Expanded Text Ads And Other Bing Ads Editor Updates
Pilot access for Expanded Text Ads is now available to Bing Ads users. Get access to the link and learn about other new features in the latest Bing Ads Editor update.
Keynotes from Bing & Google + the Hero Conf Advanced Track
Where do you go to get the most relevant information in PPC, plus the opportunity to network with the best and brightest the industry has to offer? Why Hero Conf, of course.
3 Questions You Need To Answer Before Beginning Paid Advertising
So you’ve you decided you want to start PPC advertising, but now you are asking, “Where do I start?” We've listed and answered 3 questions you should be asking.
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
Road Trip - 5 Tips For Creating International Campaigns
International markets can add complexity to any account, but here are a few settings and opportunities to make your global ad strategy stand out in non-US markets.
Discover 3 Levels Of Geo Targeting For Beginners, Intermediates, & Experts
Setting geographic targets is day one. Whether it’s to exclude places you cannot sell or serve or to specifically target your primary customer base, the implementation of geo-targets is on the must-do list.
[New Webinar!] What You Need To Know About New AdWords Features
In this new live webinar, Hanapin Associate Director of Services Jeff Baum and Optmyzr’s CEO Frederick Vallaeys will walk you through the new AdWords tools and show how you can use them to optimize your accounts.
The Social Strategies You Need To Know For App Promotion
Create social strategies to promote app awareness and leverage geographic and demographic data reported by these platforms to refine audiences.
Guide the Industry and Take the 2016 State of PPC Survey!
Each year, Hanapin Marketing manages extensive research into the State of PPC Report, which provides a statistical breakdown of the digital ad industry and guides expectations.
What's In A Name? Building Powerful Product Titles For Ecommerce
Over the years, we've tested a variety of different product title alterations in hopes of finding the perfect title. Did we? Yes, and no. The fact of the matter is, it depends.
What Upgraded Bing URLs Mean For You
Bing is continuing its effort to catch up with Adwords. Upgraded URLs, which isolate tracking parameters from final URLs, are now available to Bing advertisers.
Where Does Your Hero Conf Dollar (or Pound) Go?
5 Common Excel Issues And How To Fix
Excel, while a fabulous tool for PPC, is not without its occasional hang-ups. In this post, we’ll go through some common problems, and how to fix them.
[New Whitepaper!] Guide to Google AdWords: Advanced Edition
In this whitepaper, you will gain a greater understanding of the distinction between e-commerce and lead generation PPC strategies, learn the effective use of Remarketing, how to utilize advanced segmentation for improved targeting, cross-device attribution, and how to use automated rules in your accounts.