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.

Regular Expressions to automate metrics is an investment everyone should do!

regular expressions to automate metrics

Regular Expressions

Regular Expressions to automate metrics

I’ve written a script that logs into our vendor website and exports the recent email campaigns then breaks them out by region, campaign type, Business Unit, etc. and links them back to our SharePoint site for more information.  The script relies on a regular expression to automate metrics on our long string name and parse-out sections by examining patterns in the Naming convention.

My script first logs into our tool (SilverPop) and performs web scraping to capture the data and dumps it to a local HTML file.  I then use Excel to import the HTML file and start parsing the naming convention with the regular expression.   After all the columns are created I replace some of the short abbreviations with longer, easier to understand, words.   Then I insert functions aggregating the metrics by Type of campaign, Region, Language etc.   After that I break out four regions.  All in all it takes about 10 minutes to run but saves me about 40 hours worth of work.  The below video demonstrates the regular expressions to automate metrics in action

Automating email metrics