Business Reporting System + setup DB

Reporting DB and interface.

1. Imports all the data feed via XML/API (multiple sources)?

5 - 20 inputs. XML / API schema will be provided.

2. Store in DB, then ability to order by, all fields, export to csv,

3. Report will display

Performance Variables: Impressions, Clicks, CTR, CTR%, CV (conversions), CVRate, eCPM, EPC, Spend,

Arranged by: Pub Account, Campaign Name, Campaign ID, Ad ID#, Ad Name, Creative Size.

Order by (Above) / display per account.


- Flags? Performance indicators, which can be set as good or bad (numeric imput), campaign over/under-spending, either actual $ amount or % amount,

- sort by all variables, query the DB, filter report by campaign, lifetime, dates, today/yesterday, custom etc,


Business Reporting System + DB setup


1. Imports all the data feed via XML/API.

5 - 50 inputs. XML / API schema will be provided. Important that you build this system so it can scale.

2. Store all aggregate feeds in mySQL Database. Database preference will be on AWS*

3. Once data is stored in database, then we require reporting software to query the database and display a number of fields.

Report will display

- Performance Variables: Impressions, Clicks, CTR, Spend, etc (additional fields will be provided)

- Arranged by: Account ID, Campaign Name, Campaign ID, etc (additional fields will be provided)

Additional Features:

- Flags: In the form of performance indicators, which can be set as good or bad (numeric input), campaign over/under-spending, either actual $ amount or % amount,

- sort by all and any variables (highest/lowest first), filter report by campaign, lifetime, dates, today/yesterday, custom etc,

- ability to export all reports to excel via csv.

Extra conditions:

- Delivery of software will include installation of software and database on Amazon Web Services. AWS account will be provided.

- All input feeds will be provided.

- An example excel (CVS) file of all the fields in the report will be provided. Reporting software must match this structure.

- Preference is to use PhalconPHP because we will be dealing with a lot of real-time data, and important to maximize number of queries per second both on the data coming into the database and the when querying the database to display the reports. If you want to suggest a different PHP framework, please do.

***API Feed Examples.***

Here is one example of the API and the response [url removed, login to view]

There a number of APIs I am interested in, I would require 5 APIs at the beginning to be integrated, and we can then discuss additional on-going work to integrate new APIs afterwards if you are successful. The first 5 api's are from Admob. Mopub. iAd, Fiksu, and mdotm.

Let me know if you have questions, list them in your bid and we can start private discussion so I can answer them thanks.

PLEASE NOTE: To be successful you will have to submit a technical proposal.

Budget is $10,000 to $20,000 USD. I am happy to negotiate on price.

Any questions please ask.

Compétences : Services Web d'Amazon, MySQL, PHP, Architecture Logicielle

en voir plus : xml aggregate, we require business, system one services, successful cv examples, successful cv example, submit xml feed, submit a feed, lifetime account, i want to start any business, in iad, google system architecture, google cv, good questions to ask google, good proposal example, good it cv examples, good examples of cv, good example of cv, good example cv, good cvs, good cv examples

Concernant l'employeur :
( 0 commentaires ) Australia

Nº du projet : #6116927

40 freelance font une offre moyenne de $15643 pour ce travail


We would love to discuss the project details, before placing a firm bid. We have some initial questions and more will follow as we discuss. This will ensure we have a strong grasp on the project. Looking forward to hea Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 90 jours
(262 Commentaires)

Kindly accept my bid for your Business Reporting System project and be assured of a high quality work with our highly experienced and dedicated developers. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 100 jours
(101 Commentaires)

Kindly ignore the bid amount & time-line, it is just a placeholder to submit the proposal & to start the dialogue, as we still need to receive more detailed requirements from you to finalize it. -------- Dear Sir, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 120 jours
(55 Commentaires)

Hello, We have read the project requirements in complete detail. We have noticed that you are seeking highly skilled and expert professional personnel to develop a business reporting system and database. Features Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 60 jours
(154 Commentaires)

Hello, I have reviewed your project requirement and found it to be one of the challenging project we would like to work on.I would like to connect with you over private message or other medium to discuss about the Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 90 jours
(122 Commentaires)

Hello, sir I'm interested with your project. I have good skill and my place is 8th in freelancer. I'll do it for you. I can do it well more than you could guess. :) If you give me t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 40 jours
(180 Commentaires)

Hi We would like to come up with DETAIL PROJECT PLAN & COMMENTS so let me know your if you are interested in our proposal. :-) ## Latest Projects : [login to view URL] This Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(509 Commentaires)

Hi there, Awesome, Simple Awesome. It is very rare when you find such a detailed description and a client having in-depth knowledge and research about what he wants. Advantage of this is: It make communication very Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(20 Commentaires)

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 45 jours
(88 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(352 Commentaires)

Thank you for looking at our bid. May be DFP API is the one we should be using (targeting ad newtworks Admob, Mopub, iAd, Fiksu, and mdotm). Also all the report data can be fetched using DFP API. Could you kindly Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 100 jours
(74 Commentaires)

Hi, The basic requirements are understood. Please let us know the data structure of all the APIs will be similar or different? I am assuming that you have a more detailed specification that you are willing to share wit Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 60 jours
(109 Commentaires)

Hi Wish a good day for you! We have gone through your specification entirely so,We can integrate how many api's would like to integrate on your site ,if want we can make a script for api or xml feeds in codings to Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(57 Commentaires)

Hi Ollieportman, I went through your technical details carefully and want to properly discuss with you. There is a problem with this message system. It shows all text "mixed" so I cannot write a proper formatted easy t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 90 jours
(450 Commentaires)

Hi, Hope you are doing well. We have read your requirements but would like to discuss things further. We have PHP experts in our company and have strong hands in PHP and completed over 80 medium sized projects in P Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 90 jours
(22 Commentaires)

Hello Sri Technocrat will provide fully interactive website for your project. As per the detail, Sri Technocrat will provide three template functional schemes and sample pages to make your choice for layout. It will Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(55 Commentaires)

Thanks for your consideration, if you would like to discuss the project further do get in touch and I’ll give you a call.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 95 jours
(14 Commentaires)

Hello, I have read through the job specification carefully and I am absolutely sure that we can deliver top quality and complete your project on time and within your budget. However, in order to estimate timeframe a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 90 jours
(19 Commentaires)

Hello, I want to suggest you 2 of the best open source softwares that is an awesome solution for your task: Saiku and Pentaho. Saiku Demo: [login to view URL] Pentaho Website: [login to view URL] I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 60 jours
(61 Commentaires)

Hello, as per my UNDERSTANDING::--- [login to view URL] want us to develop a buisness reporting system and as database setup for it. ---- [login to view URL] want several API\XML feeds to be built to extract data. --- [login to view URL] that data get stored Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 50 jours
(15 Commentaires)