Google Adwords API connector software development

Google Adwords API connector software development is project number 160578 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Cancelled by Service Buyer)
Selected Providers:	-
Budget:	$300-1500
Created:	07/19/2007 at 11:48 EDT
Bidding Ends:	07/29/2007 at 11:48 EDT
Project Creator:	mkierdelewicz   Buyer Rating: (2 reviews)
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 BusinessIntelligence 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 Google Adwords API connector. In details please include cost and number of days for all our connectors (including MSN Advertising, Yahoo Sponsored and 3rd party web-statistics vendors like Hitbox and Coremetrics) and provide us with information which tools are you going to use for this development. 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 us.
Job Type:	PHP
Database:	MySQL
Operating system:	Linux
Bid count:	0
Average bid:	-