visit count not accruing when using bulk tracking api #4750
Labels
Enhancement
For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone
Hello, I am currently attempting to integrate piwik with our current logging system.
I am using the bulk tracking api, and submitting actions without any of these set (because i don't have them):
_idvc, _viewts, and _idts
It seems to me like piwik should still be smart enough to figure out all of these variables by itself, although i could see performance issues, where if you submit data in the past, it would be necessary to possibly modify all logs in the future. (whether at log accept time, or when running archive.php)
Anyways, the resulting weirdness:
mysql> select count(idvisit), visitor_returning from piwik_log_visit group by visitor_returning;
+----------------+-------------------+
| count(idvisit) | visitor_returning |
+----------------+-------------------+
| 4941056 | 0 |
| 312 | 1 |
+----------------+-------------------+
mysql> select count(temp.c) from (select count(idvisit) as c, hex(idvisitor) as id from piwik_log_visit group by idvisitor) as temp where temp.c>1
-> ;
+---------------+
| count(temp.c) |
+---------------+
| 615365 |
+---------------+
it seems to me like the first statement visitor_returning value should be always greater than or equal to the second statement value.
The text was updated successfully, but these errors were encountered: