Delete statistics

[Patrick]

Hi, is there a way to reset (or delete) old or past statistics from all campaigns, but only the statistics

i use Revive for own campaigns ( have more than 150 campaigns) and wish to start from zero in stats....

[Dave Brain]

Hi, 

Execute these queries into phpMyAdmin tool : 

TRUNCATE TABLE  `rv_data_intermediate_ad`;
TRUNCATE TABLE  `rv_data_intermediate_ad_connection`;
TRUNCATE TABLE  `rv_data_summary_ad_hourly`;

 

These queries will delete all the statistics(Only Statistics) information.

 

Thanks.

[Erik Geurts]

One should never delete statistics this way, since it will restart certain types of campaigns that have ended when they reached their target number of impressions or clicks.

Moreover, the queries above will just kill all statistics, effectively wiping your database.

DO NOT FOLLOW DAVE'S SUGGESTION! 

[jobcrusher]

Erik,

So what can we do?  My rv_data_intermediate_ad is very large and I would love to be able to safely remove old records from this table to keep it slim.

Can you confirm this is possible?

[Erik Geurts]

I would strongly recommend to never manually delete any rows in that table (or any other).

[jOOc]

Hi,

Any new information about this? I have done some testing on my environment and want to clear all my statistics

[MikeMynis]

Erik, you're telling what NOT to do. That is not very helpful.

Please tell WHAT to do to clear stats for campaigns.