Count of Unique Visitors and Visits is sometimes different when between Matomo UI and SQL query results

This issue is resolved. The reason for the differences is that Matomo aggregates the unique visits of each day to make up a week. I believe this is done for performance reasons but people should know that unique visits can be counted multiple times for an individual over the span of a week/month/year leading to an inaccurate total of “unique” visits.

More explanation here: Unique visitor per week/month

1 Like