How do I regenerate statistics in Openx?

Posted by Martin Bauer on Stack Overflow See other posts from Stack Overflow or by Martin Bauer
Published on 2010-05-10T02:34:33Z Indexed on 2010/05/10 2:38 UTC
Read the original article Hit count: 404

Filed under:

openx

ue to faulty hardware, statistics generated over a 2 week period were significantly higher than normal (10000 times higher than normal).

After moving the application to a new server, the problem rectified itself. The issue I have is that there are 2 weeks of stats that are clearly wrong.

I have checked the raw impressions table for the affected fortnight and it seems to be correct (ie. stats per banner per day match the average for the previous month). Looking at the intermediate & summary impressions tables, the values are inflated.

I understand from the openx forum (http://forum.openx.org/index.php?s=7796fd9dae40e020a010773746f3ada9&showtopic=503424297) it's possible to regenerate stats from the raw data but it will only regenerate stats per hour, meaning regenerating stats for 2 weeks would be very time consuming.

Is there another, more efficient way to regenerate the stats from the raw data for the affected fortnight?

Related posts about openx

certain Smarty tags don't work in OpenX templates

as seen on Stack Overflow - Search for 'Stack Overflow'
I am on a team that is developing an OpenX plugin, and I am responsible for the UI. I noticed that if I use certain Smarty tags in my template, the app doesn't work and I see an error message, similar to this: Plugin by name 'Html_select_date' was not found in the registry; used paths: default_views_helpers_:… >>> More
OpenX : mySql VS PostgreSQL

as seen on Super User - Search for 'Super User'
I have been using OpenX's AdServer with mySql as a backend, and since OpenX allows one to choose between mysql and postgres, I was wondering if anyone ever used Postgres and wished to talk about their experience with it here. Also, is there anyone who maybe tried using OpenX with both and can offer… >>> More
Include OpenX ad in a jquery-ui dialog?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm loading some content into a jquery-ui dialog via .ajax. That's all working fine but now I've been given an OpenX ad to embed into the dialog & can't figure out how to do it. I know all the script is stripped when coming in via ajax, & I know how to use $.getScript to load .js files for… >>> More
How do I regenerate statistics in Openx?

as seen on Stack Overflow - Search for 'Stack Overflow'
ue to faulty hardware, statistics generated over a 2 week period were significantly higher than normal (10000 times higher than normal). After moving the application to a new server, the problem rectified itself. The issue I have is that there are 2 weeks of stats that are clearly wrong. I have… >>> More
openx banner delivery

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I display a single banner on a page by using its ID with OpenX? I cannot get banners to display without using zones. >>> More

Developer IT