287835 XLS / CSV to MySQL Using APIs

Hi there.

I need a web based application created using PHP and MySQL. It needs to pull stats from two different sources. This is the first part of a much larger application. Should this project go according to plan, there is a much longer term project after this.

Part 1)

*******

I need data pulled from the first source. The data can be pulled easily using this sources API and PHP. The data can be pulled in either xls format or tab deliminated text format/file. I will need this data filtered a little. The data contains analytics statistics for many different "campaigns". I need data from only certain "campaigns" extracted and inserted into our applications MySQL DB. The data should be pulled daily. The API has date selector perameters.

I want the option to be able to add additional campaigns in future. Initially, there will be 35.

I will need a web based UI to view this data.

I will need an option to manually trigger a daily import.

I have attached a sample

Part 2)

*******

I need data pulled from a second source. Google AdWords. I will provide API access and you will need to pull adwords SPEND data for each "campaign". The AdWords campaigns have the same names as the campaigns in part 1. I will want a cell(table) for adwords spend to compare to the numbers for each campaign. This part is relatively easy and uses SOAP.

There will be a final cell which is the total campaign value divided by the adwords spend vale.

Please do not bid if you do not have feedback.

No Pre-Payment, Escrow Only.

MySQL Odd Jobs PHP Rendszergazda XML

Projektazonosító: #2034134

A projektről