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