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.

Standardized naming convention via SharePoint

Standardized naming conventionsStandardized naming conventions are a must for consistent email metrics.

In this post I demonstrated how I used a regular expression to automate email metrics.  I thought I’d create a short video demonstrating how we were able to use SharePoint to automate the creation of our campaign names.  Pre-SharePoint our clients would create and enter names manually.  This was a nightmare!

Standardized naming conventions

This video demonstrates how we managed to get SharePoint to ease the creation of our naming conventions.

Standardization of email naming convention