Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

visit count not accruing when using bulk tracking api #4750

Open
anonymous-matomo-user opened this issue Feb 24, 2014 · 2 comments
Open

visit count not accruing when using bulk tracking api #4750

anonymous-matomo-user opened this issue Feb 24, 2014 · 2 comments
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.

Comments

@anonymous-matomo-user
Copy link

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.

@mattab
Copy link
Member

mattab commented Feb 27, 2014

I believe you can make things a bit better, by increasing this setting: http://piwik.org/faq/how-to/faq_190/

You make very good points about _idvc, _viewts, and _idts, we may be able to seed these values to much better defaults!

@anonymous-matomo-user
Copy link
Author

i have already made a workaround with a custom script for correcting the data in the mysql tables.

i am assuming that in order for the suggested setting to work, i would still have to insert all of my actions sorted by date, correct?

not sure if that suggested setting will be a perfect match for me but i will investigate.

what does the visitor_days_since_order field represent in piwik_log_visit?

thanks for all the hard work guys!

@anonymous-matomo-user anonymous-matomo-user added this to the 2.x - The Great Piwik 2.x Backlog milestone Jul 8, 2014
@mattab mattab modified the milestones: Long term, Mid term Oct 11, 2014
@mattab mattab modified the milestones: Long term, Mid term Dec 23, 2015
@mattab mattab modified the milestones: Long term, Mid term Dec 5, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Development

No branches or pull requests

2 participants