imaddu Posted September 5, 2014 Report Share Posted September 5, 2014 Hi! We are using version 3.0.4 We are looking to get the number of ad calls made to the Revive ad server. In banner loggin we have checked all the 3 boxes: Log a request every time a banner is requested Log an impression every time a banner is viewed Log a click every time a viewer clicks on a banner We want to know number of requests made and number of ads served. How can we get hands on this data, especially the number of reuqests made. I have checked db tables, but nor sure where the 'number of reuqests made' is stored. Tables checked select count(*) from rv_data_raw_ad_impression , select count(*) from rv_data_raw_ad_request but both these tables have no records. Thanks! Aditya Quote Link to comment Share on other sites More sharing options...
Dave Brain Posted September 11, 2014 Report Share Posted September 11, 2014 Hi, Request log records will store on this table "rv_data_bkt_r". And Impressions on "rv_data_bkt_m" table. andrewatfornax 1 Quote Link to comment Share on other sites More sharing options...
imaddu Posted September 12, 2014 Author Report Share Posted September 12, 2014 Thanks! In some cases we are finding the number of requests to be smaller than number of imprerssions. Wondering how that is possbile? Any thoughts? Aditya Quote Link to comment Share on other sites More sharing options...
imaddu Posted September 12, 2014 Author Report Share Posted September 12, 2014 Useful documentation here..http://documentation.revive-adserver.com/display/DOCS/No+Statistics... but dosen't answer the issue that I'm seeing. Thanks! Aditya andrewatfornax 1 Quote Link to comment Share on other sites More sharing options...
imaddu Posted September 13, 2014 Author Report Share Posted September 13, 2014 Another useful link.. http://www.openxtips.com/2009/05/tip-13-understand-the-difference-between-requests-and-impressions/ Thanks! Aditya Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.