My Favorite File Renaming Tool

If you have ever worked with images, especially in bulk as is often needed for SEO, you know that cameras name images with meaningless hashes.

Granted they are generally sequential, so that makes sense within the context of the camera but file names like IMG_63826151.JPEG are meaningless to anyone else in any other context.

I mean, imagine your parents are standing next to you as you search for a certain photograph that you know is on your computer. That’s no time to discover that meaningless hashes force you to review the file to gauge its contents.

No Siree, I’d rather have that photo named naughty-picture-of-my-girlfriend.jpg then I can be sure not to preview that one when Mom’s in the room.

Options of the Name Changer App by MRR Software

Photo Naming Conventions

I like image file names to be all lower case, with words separated by dashes, descriptively named and with a 3 letter extension (i.e. .jpg not .JPEG).

The Name Changer App by MRR Software makes changes like that easy and quick across any number of files.

Need your photos appended with a number?

No problem, it handles RegEx and more with ease and yet still has a pleasant intuitive GUI.

I suppose there might be better utilities for this out there but this one is good enough that I quit looking when I found it.

Plus it’s free (one of these days I’ll donate).

Common Sense PPC Targeting

I’ve been managing a lot of PPC advertising lately, mostly AdWords but also Bing and Yahoo through Bing Ads. I’m good at it and I enjoy it (even though my interests are more holistic).

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.