VBA Final Project: Automated Web Stats Collection for Adobe Industry Strategy Group
The Industry Strategy Group within the Omnture Business Unit at Adobe consults with the management teams of strategic clients to help them know how to make the most of their digital business. These engagements are referred to as Strategic Value Assessments and include a competitive analysis of the client’s top competitors which involves gathering publicly available data about website traffic/conversion metrics to identify sub-category trends and benchmarks. The purpose of this tool is to automate process of gathering and analyzing those data. When I began doing this work this summer it normally took about two days to gather data and perform a complete analysis. By the end of the summer I could complete the task in two hours. This tool is able to do most of the work in two minutes.
No comments:
Post a Comment