Cancelado

Google Adwords API and few other web-services based connectors

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, '[url removed, login to view]', '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, '[url removed, login to view]', '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, '[url removed, login to view]', '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, '[url removed, login to view]', '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, '[url removed, login to view]', '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.

Habilidades: PHP

Ver mais: php google adwords api connector, speed google adwords api php, web services development company, web services development, web services company, web services application development, web development using html 5, web development technology, web development job requirements, web development contact number, web development company description, web development based project, web database development tools, web application development cost, web application development comments, web advertising services, tools needed for web development, sql server open source, sql company london, speed date script, reporting services sql, put in production, production tool, production marketing company, process x

Acerca do Empregador:
( 2 comentários ) Warsaw, Poland

ID do Projeto: #160588