It’s vibrancy surprised me when I first attended, there were at least a 150 people, likely closer to 200.The vibrancy has spilled over into a website for Columbus web analytics jobs. You can post a job, post a resumé and just get to know us a bit. If you’re interested, check it out!
Negative keywords often save a lot of money in PPC.
Local businesses generally don’t want traffic for queries containing other states.
I live in Columbus, Ohio and run a couple dozen AdWords campaigns for local businesses.
Negative Keywords: States With Cities Named Columbus
Most often I would see
Columbus GA or
Columbus Georgia in AdWords queries; initially, I would exclude them when I came across them.
- Columbus, Georgia
- Columbus, Indiana
- Columbus, Mississippi
- Columbus, Nebraska
- Columbus, Texas
- Columbus, Wisconsin
- Columbus, Montana
It took me a while to figure out that I should just add all those states as negative keywords.
The 49 Other States To Use As Negative Keywords for PPC
Once I started thinking about that, I realized I could add every state other than Ohio to the negative keyword list.
Here’s the list (remove your state from the list before adding it to your ‘Shared Library’ as a negative keyword list):
- “New Hampshire”
- “New Jersey”
- “New Mexico”
- “New York”
- “North Carolina”
- “North Dakota”
- “Rhode Island”
- “South Carolina”
- “South Dakota”
- “West Virginia”
State abbreviations as Negative Keywords
I learned this the hard way: The 2 letter state abbreviations match a whole lot of stuff you probably don’t want to prevent your ads from showing on.
The best example of this (which is obvious when pointed out specifically) is the abbreviation for Indiana which is
IN added to your negative keywords list prevents ads from showing on searches like
my service IN my city.
There are several other state abbreviations that can trip you up as well like Lousianna which is abbreviated
LA and Montana which is abbreviated
MT. Having those will prevent your ads from showing on queries containing
hotels near la guardia airport) or
restaurants in mt vernon ohio).
I’m sure there’s other states with abbreviations that could cause problems, so I recommend avoiding adding them wholesale.
That said, here’s the list of US state abbreviations:
Let me say again: Don’t use the abbreviations without careful review.
Additionally, it’s wise to keep in mind that ‘Washington D.C.’ and therefore ‘DC’ is an additional municipality that should be account for.
By making smart—even better—proactive negative keyword lists and adding them to your shared library you save yourself a lot of wasted clicks and needless expense.
Not to toot my own horn but part of what makes me good at it is common sense; common sense seems to be lacking in Internet marketing.
Common Sense PPC Targeting Exclusions
Over and over I have noticed this but it is hard to quantify…until now:
My employer asked me to improve the CPA on our nationwide ‘E-Commerce’ AdWords campaign. I thought about places that were less likely to convert (a common subject to ponder in paid search marketing).
Recollecting my time in a town on the Mexican border, I thought about how hand-to-mouth life there was and how people obtained things through asking family and friends, not by searching the web (which was exasperating for me). I waxed philosophic on how no one there was concerned with online sales (“webpage design” was searched much more often than “website design” if that tells you anything).
Anyway, it occurred to me that exceptionally poor communities have a below average statistical interest in expensive websites, and therefore e-commerce websites.
I then went to Wikipedia and looked up the poorest counties in the U.S. both by household income and per capita income.
What follows is a combined list of the: a.) per capita; and b.) household income; poorest counties in the U.S. (as per Wikipedia, which is good enough for me). I added all of these counties as ‘locations’ to exclude from Google AdWords.
- Adair County, Oklahoma
- Allendale County, South Carolina
- Apache County, Arizona
- Bee County, Texas
- Bell County, Kentucky
- Bennett County, South Dakota
- Benson County, North Dakota
- Big Horn County, Montana
- Breathitt County, Kentucky
- Brooks County, Texas
- Brooks County, Texas
- Buchanan County, Virginia
- Buffalo County, South Dakota
- Bullock County, Alabama
- Calhoun County, Georgia
- Calhoun County, West Virginia
- Cameron County, Texas
- Casey County, Kentucky
- Catahoula Parish, Louisiana
- Charles Mix County, South Dakota
- Chicot County, Arkansas
- Cibola County, New Mexico
- Claiborne County, Mississippi
- Clark County, Idaho
- Clay County, Georgia
- Clay County, Kentucky
- Clay County, West Virginia
- Clinton County, Kentucky
- Coahoma County, Mississippi
- Concordia Parish, Louisiana
- Conecuh County, Alabama
- Corson County, South Dakota
- Costilla County, Colorado
- Culberson County, Texas
- Cumberland County, Kentucky
- Dewey County, South Dakota
- Dimmit County, Texas
- Duval County, Texas
- East Carroll Parish, Louisiana
- Elliott County, Kentucky
- Evangeline Parish, Louisiana
- Floyd County, Kentucky
- Glacier County, Montana
- Greene County, Alabama
- Greene County, Mississippi
- Guadalupe County, New Mexico
- Hamilton County, Florida
- Hancock County, Georgia
- Hancock County, Tennessee
- Harlan County, Kentucky
- Harmon County, Oklahoma
- Hidalgo County, Texas
- Holmes County, Mississippi
- Hudspeth County, Texas
- Hughes County, Oklahoma
- Humphreys County, Mississippi
- Issaquena County, Mississippi
- Jackson County, Kentucky
- Jackson County, South Dakota
- Jefferson County, Mississippi
- Jefferson Davis County, Mississippi
- Kalawao County, Hawai’i
- Kemper County, Mississippi
- Keya Paha County, Nebraska
- Knott County, Kentucky
- Knox County, Kentucky
- La Salle County, Texas
- Lake County, Tennessee
- Lawrence County, Kentucky
- Lee County, Arkansas
- Lee County, Kentucky
- Leflore County, Mississippi
- Leslie County, Kentucky
- Letcher County, Kentucky
- Lewis County, Kentucky
- Luna County, New Mexico
- Macon County, Alabama
- Macon County, Georgia
- Madison County, Idaho
- Madison Parish, Louisiana
- Magoffin County, Kentucky
- Martin County, Kentucky
- Maverick County, Texas
- McCreary County, Kentucky
- McDowell County, West Virginia
- McKinley County, New Mexico
- McPherson County, South Dakota
- Mellette County, South Dakota
- Menifee County, Kentucky
- Menominee County, Wisconsin
- Mingo County, West Virginia
- Monroe County, Arkansas
- Morgan County, Kentucky
- Navajo County, Arizona
- Noxubee County, Mississippi
- Oregon County, Missouri
- Owsley County, Kentucky
- Pemiscot County, Missouri
- Perry County, Alabama
- Perry County, Kentucky
- Phillips County, Arkansas
- Presidio County, Texas
- Pushmataha County, Oklahoma
- Quitman County, Mississippi
- Randolph County, Georgia
- Reeves County, Texas
- Rolette County, North Dakota
- Roosevelt County, Montana
- Russell County, Kentucky
- San Juan County, Utah
- Searcy County, Arkansas
- Shannon County, Missouri
- Shannon County, South Dakota
- Sharkey County, Mississippi
- Sioux County, North Dakota
- Starr County, Texas
- Stone County, Arkansas
- Summers County, West Virginia
- Sumter County, Alabama
- Sunflower County, Mississippi
- Tallahatchie County, Mississippi
- Tensas Parish, Louisiana
- Thurston County, Nebraska
- Todd County, South Dakota
- Tunica County, Mississippi
- Wade Hampton, Alaska
- Wayne County, Kentucky
- Webb County, Texas
- Webster County, West Virginia
- Wheatland County, Montana
- Whitley County, Kentucky
- Wilcox County, Alabama
- Wilkinson County, Mississippi
- Willacy County, Texas
- Winn Parish, Louisiana
- Wolfe County, Kentucky
- Woodruff County, Arkansas
- Zapata County, Texas
- Zavala County, Texas
- Ziebach County, South Dakota
So, if you have a product or service which appeals to people of higher socio-economic status, consider using this to exclude PPC advertising in that area.
Conversely, if you have a product or service that appeals to the less affluent, consider using this list as a starting point for targeting…that is, if you trust Wikipedia.
After you update your OS, the surest way to know that everything will work right is to make sure you have all the software that is likely to be used installed.
This is a long list, and most of it is command-line software but you’ll like it because it’s mostly “package management,” “task automation,” and “version control,” and “virtualization” software.
Package/Dependency Management: Installs stuff for you (like homebrew)
Task/Automation: Builds and tests stuff for you
Version Control: Let’s you change/update/revert software easily
Virtualization: Let’s you install software on a “virtual machine” so you can run Windows/Linux software on your Mac (also lets you install software on a ‘virtual’ computer which greatly reduces the risk of any software/malware/problems hurting your computer.
Install (or Update)
- Install ‘Git’
- Install ‘Homebrew‘
- Install ‘RVM‘
- Install ‘XCode’
- Install ‘XCode Command Line Tools’
- Install ‘XQuartz‘
Additionally Install (in this order):
- Install ‘Node.js‘ (includes NPM)
- Install ‘Yeoman‘(includes yo, bower, grunt)
- Install ‘Compass‘ (includes Sass)
- Install ‘Virtual Box‘
- Install ‘Vagrant‘
Recommended (all available from Get Mac Apps) :
- Install ‘Sublime Text 3‘
- Install ‘Gimp‘ (open-source bitmap graphics editor, a PhotoShop alternative)
- Install ‘Inkscape‘ (open-source vector graphics editor, an Illustrator alternative)
- Install ‘The Unarchiver‘ (make and open archive files easily)
- Install ‘Alfred‘ (fantastic productivity shortcut application)
Last time I updated my OS, it ‘broke’ everything so don’t rely on anything you already installed to work after you update.
Almost all of those have clear, simple directions (either a copy and paste command line prompt for Terminal or a ‘click here to download’ button).
If you have any problems feel free to send me questions.
Follow all the directions and you should be fine.
I pity the fool at Google who picked David Hasselhoff over Mr. T.
I’m a big fan of Google, they usually put a lot of work and thought into everything they do. Their Betas are better than most company’s finished products.
But given enough time, any company makes a mistake.
Today, I’m sad to report an egregious—and potentially fatal—error in judgement by the people in charge of Google+, and more specifically the Google+ Auto-Awesome Photo Tools. You can preview the post announcing this foolishness on the Official Google blog.
I Pity The Fool
Who in their right mind thought that David Hasselhoff would be better as the first celebrity for honorary photobomb status than Mr. T?
If you ask me this is an unforgivable oversight.
This is a travesty!
It’s the beginning of the end; it’s all downhill from here.
Google Even Featured #Hoffsome on Their Homepage
Even a company as mighty as Google, that should have quality control practices in place, still chose to feature “Auto-Awesome Photobombing” by David Hasselhoff on its homepage. No mention of Mr. T at all.
How does such a mistake happen?
The Beginning of the End
Surely a gaffe this significant is fatal even to a company as mighty as the big G…as it should be, if you as me. Such a lapse of judgement is a #Hoffsome mistake. I don’t know about you, but I’d much prefer to have my pics photobombed by the greatness of Mr. T.
Sign the Petition
If you agree, sign the petition below (AKA comment) to voice your support for Mr. T.