These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, December 22, 2010

Automated Web Stats Collection

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

Blog Archive