Automating email metrics w/AutoHotKey, Excel, & RegEx on the naming convention

Automating email metrics

Automating email metrics

I’ve written an AutoHotKey script that logs into our vendor website and uses web scraping 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.

 

What’s really cool is that I’m putting in formulas (not the static number) thus if some of the items that ¬†are not classified (someone incorrectly used our mailing name so the RegEx¬†broke) they can go back and update the code and all the numbers will adjust!

Automating email metrics

Automating email metrics

Leave a Reply