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)
- 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.
- 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.
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
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
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
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
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
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
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
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
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
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
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
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
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
Thanks for your consideration, if you would like to discuss the project further do get in touch and I’ll give you a call.
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
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
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