Access to stored views and clicks

[servei]

Hello everyone,

I'm newbie with Revive Adserver. I've been looking for if there is a way to access the stored views and clicks of my ads in the database. Is there a way to access all the clicks and views to create our own statistics based on them?

thanks a lot and kind regards.

[checkad]

you can by using phpmyadmin on the database (at your own risks)

views and clicks of banners are stored in the xx_ pub_data_summary_ad_hourly table

banners are stored in the xx_banners table
campaigns are stored in the xx_campaigns table

then, it's a question of join request on these 3 tables

Edited September 26, 2016 by Addev