Developing Realtime Analytics/Reporting system on mongoDB - oDesk

I'm looking for somebody who designs a high performance database model in mongoDB which allows deep analytics (AdServing System).



I need the "insert statistics" and "receive statistics" including drilldown possibilities code for php as well.



This is just one module. If i'm satisfied with your work, i would hire you for more modules within the AdServing System as well.





Requirements:



The keys are "date", "site_id" and "creative_id". The database has to log the "impressions","clicks" and "leads" done by certain users, it has to have the possibility to drill down per hour. We also have a key field called "CPM_CPC" - which is in fact the price the advertiser pays per impression/click. As this value of the advertiser bid might change anytime, it also has to take effect within the database model immediately. (If the bid is changed during an hour it still has to show accurate stats for that hour!)



The stats should have the possibility to be drilled down by day/hour or for custom period.

The "leads" field has to contain informations which "site_id" & "creative_id" triggered the conversion with the value X$ at what time (exact time).



We're talking about 5000 different "site_id" values, and 1000 different "creative_id" values. I want to avoid (minimum) 5M (*24 if we log hourly!) entries per day, so i need a storing solution that:



- stores the information with the key "creative_id" OR "site_id" and "date" (YYYYMMDD). This would minimize the entries per day to 1000 / 5000 instead of minimum 5M.

BUT: The object still has to contain the information which site_id (or creative_id) had how much clicks / impressions at which CPM on which "site_id" or with which "creative_id". It also has to be possible, to get reportings for a specific creative_id / site_id easily (with all the information, average CPM/CPC (appended to clicks/impressions stats, hourly - CPM/CPC changes could happen during any hour, keep that in mind!) , impressions (hourly & total), clicks (hourly & total)

- is scalable (should also run smooth with 10000 different "site_id" values or 5000 different "creative_id" values

- is fast for reporting and inserting/updating (maybe more than 1k stats updating request per minute)

- has to be as accurate as possible



Starting On: May 1, 2012

Ending On:

Posted On: April 25, 2012 05:38 UTC

ID: 201106396

Category: Web Development > Web Programming

Skills: mongodb,php,reporting,statistics

Country: Germany

Hours Billed: 0.00



click to apply



via All Web Development jobs | oDesk.com https://www.odesk.com/jobs/Developing-Realtime-Analytics-Reporting-system-mongoDB_%7E%7Ef54e0992e4ac1d28?source=rss