Where Is Impression/click Data Stored Before Going Into Hourly/intermediate Tables?

[goldentuna]

We notice that with the raw_impressions/click tables not being used anymore in Revive - the hourly & intermediate tables get update everytime maintenance is run.

 

Question is .. where/how is the data stored before it gets into those tables?

 

[Riyas]

Hi,

 

Initially the datas are stored in the bucket tables ,

            impression - rv_data_bkt_m  

            Clicks - rv_data_bkt_c

            Conversion - rv_data_bkt_a

[goldentuna]

Thanks .. to bad we can't get the raw data anymore .. not sure how to get the geo info now.

[andrewatfornax]

Unfortunately, core Revive Adserver does not log geo data for impressions any more - it was a tradeoff made in the OpenX days that this was worth it for the performance improvement of using the data_bkt_ tables for logging.