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
Cross websites reporting: Let me see the number of users who browsed two websites (new plugin) #6082
Comments
This plugin would be nice for users with many Sites, we have dozens. |
+1 It would be very great! |
That's a good idea. |
For the SQL query to detect unique users across websites, maybe this is a good and fast option? Example to get number of cross users across website 1 and 2:
|
Maybe a newbie question, but is it different from this: SELECT COUNT(DISTINCT log_visit_t1.config_id) AS config_ids FROM piwik_log_visit as log_visit_t1 INNER JOIN piwik_log_visit as log_visit_t2 WHERE log_visit_t1.config_id = log_visit_t2.config_id AND log_visit_t1.idsite = 1 AND log_visit_t2.idsite = 2 ? |
I've ran both against my test db and tooks abt 297ms in the first case and abt 234ms in second case. Result was 749 |
@kylekatarnls good point we don't need the outer query, yours works better 👍 |
Plugin is here: https://github.com/PiwikPRO/plugin-InterSites Closing ticket. @tassoman I put your suggestion here: https://github.com/PiwikPRO/plugin-InterSites/issues/1 |
InterSites not compatible with Piwik 3, re-opening |
We've released a new premium plugin which aggregates data from multiple websites, mobile apps and shops into a Roll-Up site to gain new insights and save time. Also gives you a view of visitors across several websites/apps. Get it here: https://plugins.piwik.org/RollUpReporting |
The goal of this ticket is to create a new plugin published on the Marketplace that will let a user pick two websites from the list of tracked websites in Piwik, and will then output the number of unique users that visited both websites in the selected time period.
Proposal
10% of users who browsed SiteA also viewed SiteB. That represents 560 users.
Total visitors: $visitors
config_id
Tasks
Note: for more advanced cross websites reporting, check out the RollUp Reporting plugin. see also #6079
The text was updated successfully, but these errors were encountered: