Using a strong Naming Convention & RegEx are keys to automating metrics!

naming conventions

Naming Convention and Regular Expression (RegEx)

Having a strong naming convention can make reporting on your metrics a breeze when you use a regular expression to break out-decrypt the naming scheme. This video shows how easy it is for us to extract: Region, Language, Campaign Type, etc. from our campaign names by using a regular expression. It also points out that there is no need to be stuck with poor acronyms for your reporting.

Naming Convention and Regular Expression

In my above example I use AutoHotKey with Excel. ┬áIf you add the function, Excel can do RegEx itself however (for some crazy reason) it isn’t built into it.

Leave a Reply