I’ve been trying to run the “Average visit duration” query from the basic recipes but the data seemed to be quite off… We also had certain days that the average was double or 3 times what it is normally (e.g. whole week we have an avg of ~250 seconds and one day this shoots to ~450 for no reason). When I did some investigation I saw that the collector_tstamp isn’t always correct. See below.
This doesn’t happen very often on a day but often enough to skew the data. I tried to use the dvce_timestamp but that can have totally inaccurate times (and it does). We do have page_pings active on our website.
My question: whats the best way of filtering out this problem and getting the most accurate “avg time”?