Amazon Business Report Automation

Description During my internship at Vimbly Group in the summer of 2022, I undertook a pivotal role in automating reports for the Cresimo business unit, streamlining the extraction and analysis of data from Amazon Ads and Amazon Business. Recognizing the inefficiencies in Amazon's existing report formats, the managers sought a more user-friendly solution. To achieve this, each of the four interns, including myself, was assigned to automate a specific report. My Work I focused on automating the Pay Per Click (PPC) report. Leveraging the Amazon Ads and Amazon Business APIs, I implemented a systematic data-fetching process. This involved batching and processing the data to ensure its compatibility with the desired format, ultimately populating it into .xlsx files. The automation process culminated in the generation of comprehensive PPC reports, offering a clear and digestible overview of key metrics. To further enhance data management and future analytical capabilities, my team and I decided to store the retrieved data in a SQL database hosted on EC2 instances. This strategic decision not only facilitated efficient data storage but also laid the groundwork for future developments. Recognizing the value of historical product data, we envisioned a graphical user interface that would empower managers to generate diverse reports with varying formats and data parameters. Final Product and Impact Upon project completion, the automated PPC reports significantly optimized operational efficiency, saving the company four hours of employee time per week. The streamlined process not only alleviated the burden of manual report generation but also provided managers with timely and actionable insights. This project showcased my proficiency in API integration, data processing, and strategic database management, demonstrating a tangible impact on operational efficiency and setting the stage for future data-driven endeavors within the organization.