Project: Campaign Insight Tool for PaperG
While I was working with data gathered by our software’s automated website scrapers, I realized the standard process of querying the data (directly writing queries to the database) was inefficient. Developers like myself were repeatedly writing the same queries, and our customer service personnel had to rely on developers to stop and help troubleshoot customer’s issues.
I recognized these inefficiency, and solved them by independently designing a simple PHP page which granted insight into a specific advertising campaign (hence, Campaign Insight Tool) by running a set of commonly used queries and formatting the results to be easy to view and to be further examined on secondary pages. After spending some time personally using and refining the tool, I shared it with other developers, who were able to immediately benefit from having faster access to data.
Additionally, when I demonstrated the ability to rapidly provide answers to customer requests, they were excited to use the tool themselves. Feedback from the team was incorporated into the tool, which resulted in a tool that reduced the need to bring in a developer to solve problems, as well as allowing customer support to develop better bug reports. As a result, the tool freed up developer time, as well as providing a better customer experience by improving response time by the customer service team.