Love Me Tender: Uploading Negatives Into Bing
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!
Get Your Brand in Front of Dedicated PPC Pros!
We're headed to London to join nearly 300 of our best PPC friends. And we still have a limited number of opportunities for your brand to join us!
The Top Ten Tips For Effective Dayparting
Determining your need for hour of day modifiers can provide extremely competitive returns based on time invested in implementing.
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
Should You Be Creating Device Specific Campaigns?
Creating new device specific campaigns is a lot of work and can potentially overcrowd your account. You need to determine if this tactic is right for you.
9 Hero Conf London Advanced Sessions You Can't Miss
If you'd like some more details (and we've got plenty of details), how about a rundown of the deepest, most actionable sessions you'll see. These 9 sessions are designed for the expert-level PPC professional.
Why Your PPC Account Isn’t Living Up To Its Potential
I will review common themes that I see in either prospective clients, new clients, or accounts that are red that aren't living up to their potential.
[New Webinar!] 6 Steps To An Advanced Competitor Analysis For Digital Marke...
In this new live webinar, Hanapin’s Jacob Fairclough and SEMrush’s Paul Klebanov will direct you through the process of analyzing your own account, comparing it to your competition, and taking the steps to put your brand above the rest.
5 Psychological Principles You Should Be Using In Your Marketing
I propose that knowing what your audience is thinking or even the steps in their thought process is even more beneficial than simply knowing who they are.
Add It To The List - Structured Snippets Now Available In Bing
Another item for the list of new features in Bing - Structured Snippets are now available to all U.S. advertisers, with international support already being rolled out.
Do You Want A Free PPC Hero T-Shirt?
We're conducting a brief 2-minute survey to get your thoughts and opinions. By taking the survey, you'll get entered to win a certified PPC Hero shirt! Fill out the survey by Friday, September 23rd.
4 Tips To Survive An Account Manager Change
Have you ever received a call or email from your agency that you will be getting a new account manager? The thought could be frightening, especially if you LOVE your current AM. After you take a deep breath and realize life will go on, keep...
Build Your PPC Network, One Pro at a Time!
Do you ever feel that the people who understand your role best live mostly on Twitter? Is it sometimes difficult to find those few individuals you know you can count on for the best PPC advice? We’ve got the solution for your paid search woes.
Balancing Volume, Competition, And Intent To Find The Right Keyword
Although it isn’t going to bring results as quickly as a PPC campaign (and you can even use these methods for PPC), you can’t go wrong with a good old organic traffic campaign running alongside your ads.