Jump to content

No stats and I tried everything..

Recommended Posts

Hello guys,

I'm struggling (to say the least) to get Revive to show stats...

I tried this :


Didn't work.

I'm running manually the maintenance script http://myserverinstall.com/maintenance/maintenance.php

doesn't seem to help much.

I even tried setting the Maintenance Settings / Maintenance Operation Interval (minutes) to 5 minutes...

I checked in the DB and I have my impressions recorded :



My Banner logging settings are the defaults:



My debug log doesn't seem especially buggy to me:




Any tips / ideas maybe ?

Thanks guys,




Link to comment
Share on other sites

@Snoork Hosting The database settings are fine, or the install script wouldn't have worked. Also it seems like data is written in data_bkt_m correctly.

Regarding the maintenance script, if I decypher the log correctly, it seems to work, isn't it ?

Or is there another way to see of the maintenance script is successful or not ?


Link to comment
Share on other sites

OK, so the way the Stats are working are weird / unclear at least.

Somehow I can get the Stats from yesterday to appear but I'll ALWAYS have the Stats of the current day empty and/or with a gigantic delay (despite the cron running like every 10 minutes + me triggering the script manually from the browser)....

Also I don't know how/why but it doesn't really seems like triggering the maintenance script does things instantly, and I can't see any correlation between manual of cron triggering and the Stats getting magically updated "at one point in time"... so basically I'm more or less getting my stats but why and how they are generated is a complete mystery...

e.g. I trigger some pageloads / banners impressions... then I run the maintenance script manually... then god knows what happens but my stats get refreshed "someday" (clearly not in the 5 10 minutes after launching the maintenance script... for just 10 impressions it shouldn't take ages to refresh the stats)

Anyone can help me understand this mystery ??




Link to comment
Share on other sites

Delivery data is logged in so-called 'bkt' (short for bucket) tables during the hour. Logging is by banner by zone. It is about requests (if you've enabled that), impressions, clicks, and conversions.

At the top of the new hour, a maintenance process runs that collects that raw delivery data and summarizes it into another set of tables. We recommend using job to trigger the maintenance process (this is called Scheduled maintenance), but if you can't setup a cron job you can also use the substitute (which is called Automatic maintenance), being triggered by a banner being delivered in the new hour.

Your database user must have "all privileges" on the database in order to be able to create and delete some temporary tables during the maintenance process.

So in short: no, statistics don't appear in real time, but they should update once per hour.

More information about your issue may be here: http://documentation.revive-adserver.com/display/DOCS/No+Statistics

Edited by Erik Geurts
Documentation link added
Link to comment
Share on other sites

OK thanks for the help.

It's working on production, somehow the weird way it was working on a test site made it very confusing... especially since I would have expected that running the CRON at let's say 10:30 would get me updated data at 10:35 but never did... 

No matter if you use CRON or even manually calling the maintenance URL, apparently there is always a delay in stats generation (and I didn't expect this to be the case, especially to compute stats of 20 impressions).

Link to comment
Share on other sites

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...