hmmm...
the IPs should be separated by commas only, NOT line breaks too..
can you try that?

BTW, in any case, you should not let the DB grow that much. Eventually you will have problems if the DB keeps growing. We always recommend to purge old data (data that probably is not that useful anymore) and don't let the DB table grow more than, say... 1million records.

Hi Germi,

That did the trick
All i'm interested in are 3 types of data: artist views / album views and song views.
If possible i'd like to keep an ongoing record for this.

I cleaned my db from all others types (my other thread ) and i only have type 1 2 and 3 now.

The database is still over 3 million though, a lot of bot records which i'm cleaning up by ip numbers.

Leaves 2 questions in this case:

1. You say purge old data, can you share some sql commands for this? It would help me a lot as it's not really my area of expertise...

and 2, i noticed that the ip block option does NOT work for the cud_muscol_statistics table?? I still have the bots issue here, its growing fast and i doubt that is a good thing

1. I thought you were using Content Statistics (which has a built in option to purge old data).
you will need to "DELETE" records where the "date_event" field is "<=" than the date you want...

2. the IP block is for CS only. I'm confused here. are you using MC or CS for statistics?
you only have a subscription for MC with us... right?

yes, only mc