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.
Feature:
- 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
Steps:
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 [login to view URL]
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.