We use crontab to hourly import and process visits from Apache based logs.
We have created 3 segments to filter visits as NoBOT, External Visitors IPs and Internal Visitors IPs.
We noted in some days reports filtered with ‘External Visitors’ have 0 visits, unique visitors, actions per visit and so on, but same reports have not 0 for stats like pageviews, unique pageviews, downloads, unique downloads.
Same reports of same days filtered with NoBOT or no filtered (All Visits) have all stats OK.
In addition, the report ‘Visits per server time’ filtered with ‘External Visitors’ is OK, and each of 24 hours has all the filtered visits (i.e., 3033 vs 2052).
This behavior was repeated randomly without an apparent reason on different days, some days on December, some days on January (i.e. 8th and 12th).
We have tried to reprocess these days invalidating data and reprocessing reports, with no success.
We have also tried to purge db log tables, reimport visits logs, invalidate and archive them, with no success.
We did not find any error message during import or archive stage.
In attach 3 pics, allvisits.png (no filters), ‘external visits segment’ (8th and 12th january with 0 visits), and ‘nobot segment’.
Any idea ???
Thanks in advance