Openx is an ad sever platform who provide you ad serving solution to power all of your digital advertising. I am working with mobile advertising platform application and i have used Openx-2.8 for ad delivery. Now my client needs some customization for tracking requests/ log requests by country, region and city. Openx is tracking requests in ‘data_bkt_r’ table and transfer it to another table ‘data_summary_ad_hourly’ after every one hour. This are the total requests for particular campaign or zone.