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 clicks/ log clicks by country, region and city. Openx is tracking clicks in ‘data_bkt_c’ table and transfer it to another table ‘data_summary_ad_hourly’ after every one hour. This are the total clicks for particular campaign or zone.