Freelancer

Description

1. Project general description - We are Internet Marketing Company. We are building/implementing a new reporting system solution to speed up and automate as much as possible processes for daily reporting production in our company. Daily we receive reports from Google Adwords which we put into Excel and we build a report based on this data. Our idea is to store all data from Google Adwords in a MySQL database and use the Business Intelligence Tool (Eclipse Business Intelligence and Reporting Tools) to produce reports based on the sql database. We need the Google Adwords API connector to collect all necessary data from Google Adwords and insert it into our MySQL database. We need a one way connector only. We will collect data but we will manage campaigns in the same way as we currently do. The next step will be to build other connectors for MSN Advertising, Yahoo Sponsored and 3rd party web-statistics vendors like Hitbox and Coremetrics - based on web services technology too.

2. Environment
- server - Linux with Apache, PHP 4.x and Mysql 4.x and upper
- application - Google Adwords

3. Task description - Google Adwords and MySQL connector/script based on PHP and Google Adwords API to grab all necessary data. One way connection (from Google Adwords into MySQL) using Google Adwords API. PHP Script will be run with a cron job daily after midnight and should collect all our data from the previous day and insert the data into the MySQL database table.

MySQL database table with Google Adwords data:
CREATE TABLE `data_google_adwords` (
`Date` date NOT NULL,
`Account` text NOT NULL,
`Customer_Id` int(11) NOT NULL,
`Time_Zone` text NOT NULL,
`Campaign` text NOT NULL,
`Ad_Group` text NOT NULL,
`Keyword` text NOT NULL,
`Keyword_Matching` date NOT NULL,
`Keyword_Status` text NOT NULL,
`Keyword_Min_CPC` decimal(6,2) NOT NULL,
`Current_Maximum_CPC` decimal(6,2) NOT NULL,
`Current_Maximum_CPM` decimal(6,2) NOT NULL,
`Keyword_Destination_URL` text NOT NULL,
`Campaign_Status` text NOT NULL,
`Impressions` smallint(6) NOT NULL,
`Clicks` smallint(6) NOT NULL,
`CTR` decimal(5,2) NOT NULL,
`Avg_CPC` decimal(6,2) NOT NULL,
`Avg_CPM` decimal(6,2) NOT NULL,
`Cost` decimal(6,2) NOT NULL,
`Avg_Position` decimal(6,1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

Data example:

INSERT INTO `data_google_adwords` VALUES ('2007-06-01', 'CC', 1600000000, '(GMT+00:00) London', 'CC', 'Generic', 'good morning', '0000-00-00', 'Active', 0.05, 0.50, 0.00, 'good_morning.html', 'Paused', 20, 1, 5.00, 0.10, 5.00, 0.10, 1.1);
INSERT INTO `data_google_adwords` VALUES ('2007-06-01', 'CC', 1600000000, '(GMT+00:00) London', 'CC', 'Generic', 'good afternoon', '0000-00-00', 'Active', 0.05, 0.50, 0.00, 'good_afternoon.html', 'Paused', 90, 2, 2.22, 0.05, 1.11, 0.10, 1.0);
INSERT INTO `data_google_adwords` VALUES ('2007-06-01', 'CC', 1600000000, '(GMT+00:00) London', 'CC', 'Generic', 'good evening', '0000-00-00', 'Active', 0.02, 0.50, 0.00, 'good_evening.html', 'Paused', 93, 1, 1.08, 0.02, 0.22, 0.02, 1.0);
INSERT INTO `data_google_adwords` VALUES ('2007-06-01', 'CC', 1600000000, '(GMT+00:00) London', 'CC', 'Generic', 'hello world', '0000-00-00', 'Active', 0.02, 0.15, 0.00, 'hello_world.html', 'Paused', 5, 0, 0.00, 0.00, 0.00, 0.00, 1.0);
INSERT INTO `data_google_adwords` VALUES ('2007-06-01', 'CC', 1600000000, '(GMT+00:00) London', 'CC', 'Generic', 'hi', '0000-00-00', 'Active', 0.05, 0.08, 0.00, 'hi.html', 'Paused', 78, 1, 1.28, 0.05, 0.64, 0.05, 1.4);

4. Delivery requirements:
- open source, uncoded PHP script with code documented inside containing comments about functions and variables in English language.
- readme file with short description on how to install script and clear documentation on which part of code should be changed if it is necessary to alter the number of columns containing information from Google Adwords in the future
- copyrights messages which allow us to change the code in the future

5. Additional information.
Please include in bids: cost and number of days for all our needed connectors including Google Adwords, MSN Advertising, Yahoo Sponsored and 3rd party web-statistics vendors like Hitbox and Coremetrics. Please include in details cost and time for Google Adwords API connector only and provide us with information which tools are you going to use for development process. This information is important for us to integrate your development tools with our environment.

If you have any questions or something is not clear enough then don't hesitate to contact me.