- OpenX Community Forums
![]() ![]() |
Jul 21 2011, 02:22 PM
Post
#1
|
|
|
Beginner ![]() Group: Members Posts: 4 Joined: 2-November 08 Member No.: 23,961 |
Hi all,
Openx uses ox_data_summary_ad_zone_assoc table to store the priority and other values for every OI for zoneid and ad_id combination. Can any someone help me whats the use of required_impressions and requested_impressions fields and on what basis this values are calculated. eg. | ad_id | zone_id | interval_start | priority | required_impressions | requested_impressions | +-------+---------+---------------------+------------------+----------------------+-----------------------+ | 2726 | 613 | 2011-07-20 10:35:00 | 0.30506496950411 | 5752 | 5752 | | 2726 | 613 | 2011-07-20 10:50:00 | 0.26137702109434 | 4882 | 4882 | | 2726 | 613 | 2011-07-20 10:55:00 | 0.25669486502506 | 4764 | 4764 | | 2726 | 613 | 2011-07-20 11:00:00 | 0.26494328673173 | 5022 | 5022 | | ad_id | zone_id | interval_start | priority | required_impressions | requested_impressions | +-------+---------+---------------------+-------------------+----------------------+-----------------------+ | 2551 | 259 | 2011-07-10 00:15:00 | 0.5 | 1 | 1 | | 2551 | 259 | 2011-07-10 00:20:00 | 0.5 | 2 | 2 | | 2551 | 259 | 2011-07-10 00:30:00 | 0.14285714285714 | 1 | 1 | | 2551 | 259 | 2011-07-10 00:35:00 | 0.11111111111111 | 1 | 1 | Thanks in advance |
|
|
|
Jul 26 2011, 01:41 PM
Post
#2
|
|
|
Expert ![]() ![]() ![]() ![]() Group: Members Posts: 239 Joined: 30-June 08 Member No.: 22,010 |
Can any someone help me whats the use of required_impressions and requested_impressions fields Yes. OpenX just calculates the amount of required impressions what would have been needed to fulfill the campaign goal. And the requested impressions are the delivered ones. If those values are equal, everything is perfect. and on what basis this values are calculated. No on this point, haven't looked into the code that much. I guess that "mathematical magic" is somewhere in the code, maybe there are documented parts in the code about that. Must be a mix of the whole campaign goal, the price, limitations and the calculated priority. But you have to look at the OpenX code to find and maybe debug that code to see how all those values are generated. |
|
|
|
Jul 27 2011, 09:46 AM
Post
#3
|
|
|
Beginner ![]() Group: Members Posts: 4 Joined: 2-November 08 Member No.: 23,961 |
Can any someone help me whats the use of required_impressions and requested_impressions fields Yes. OpenX just calculates the amount of required impressions what would have been needed to fulfill the campaign goal. And the requested impressions are the delivered ones. If those values are equal, everything is perfect. and on what basis this values are calculated. No on this point, haven't looked into the code that much. I guess that "mathematical magic" is somewhere in the code, maybe there are documented parts in the code about that. Must be a mix of the whole campaign goal, the price, limitations and the calculated priority. But you have to look at the OpenX code to find and maybe debug that code to see how all those values are generated. herrby, thanks for the reply.... Also request you if you come across any documentation on this please post me also. |
|
|
|
![]() ![]() |