A Report Generating System

The client was working with very large excel datasets and Google AdWords Editor to run his SEM campaigns. However, this was becoming too cumbersome and time consuming, as they have over 1 million ads in 10 different accounts.

Basically their accounts were more or less duplicates (of different languages), thus we wanted to develop a tool that allows them to make changes across accounts (say if we want to add or change a negative or new keyword to a campaign in all 10 accounts, they do not need to add it 10 times). The goal of this project is to link  cost data with sale data, and to make as accurate as possible cost/revenue analysis reports based on these data. 

The system except communication between excel (input) and Google AdWords API and is also able to import and link with their sales data (also excel). The tool that we have developed is able to store cost data and sale data different files like (XLS, CSV and TXT) and we have parsed these files and stored in the database and created different reports as per client request with graph facility.