PluginProbe ʕ •ᴥ•ʔ
Independent Analytics – WordPress Analytics Plugin / 1.18
Independent Analytics – WordPress Analytics Plugin v1.18
2.15.3 2.15.2 2.15.1 2.15.0 2.14.10 trunk 1.1 1.10 1.10.1 1.11 1.12 1.13 1.14 1.15 1.16 1.17 1.17.1 1.17.2 1.17.3 1.17.4 1.18 1.18.1 1.19.0 1.19.1 1.2 1.20.0 1.21.0 1.22.0 1.22.1 1.23.0 1.23.1 1.24.0 1.24.1 1.25.0 1.25.1 1.26.0 1.27.0 1.28.0 1.28.1 1.28.2 1.28.3 1.29.0 1.3 1.30.0 1.30.1 1.4 1.5 1.6 1.7 1.8 1.9 2.0.0 2.0.1 2.1.4 2.1.5 2.1.6 2.10.0 2.10.1 2.10.2 2.10.3 2.10.4 2.11.0 2.11.1 2.11.10 2.11.2 2.11.3 2.11.4 2.11.5 2.11.6 2.11.7 2.11.8 2.11.9 2.12.0 2.12.1 2.12.2 2.13.1 2.13.2 2.13.5 2.13.6 2.14.0 2.14.1 2.14.2 2.14.4 2.14.6 2.14.7 2.14.8 2.14.9 2.2.0 2.2.1 2.3.1 2.3.2 2.4.2 2.4.3 2.5.0 2.5.1 2.6.0 2.6.1 2.6.2 2.6.3 2.6.4 2.7.0 2.7.1 2.7.2 2.7.3 2.8.2 2.8.3 2.8.4 2.8.5 2.8.6 2.8.7 2.8.8 2.8.9 2.9.2 2.9.3 2.9.4 2.9.5 2.9.6 2.9.7
independent-analytics / IAWP / sql / get_referrers.txt
independent-analytics / IAWP / sql Last commit date
city_statistics.txt 3 years ago city_statistics_with_woocommerce.txt 3 years ago country_statistics.txt 3 years ago create_referrer.txt 3 years ago create_resource.txt 3 years ago create_session.txt 3 years ago create_view.txt 3 years ago create_visitor.txt 3 years ago get_campaign.txt 3 years ago get_campaigns.txt 3 years ago get_campaigns_with_woocommerce.txt 3 years ago get_current_session.txt 3 years ago get_current_traffic.txt 3 years ago get_geos.txt 3 years ago get_geos_with_woocommerce.txt 3 years ago get_referrer.txt 3 years ago get_referrers.txt 3 years ago get_referrers_with_woocommerce.txt 3 years ago get_resource.txt 3 years ago get_resources.txt 3 years ago get_visitors_by_minute_interval.txt 3 years ago get_visitors_by_ten_second_interval.txt 3 years ago
get_referrers.txt
30 lines
1 SELECT *
2 FROM (SELECT GROUP_CONCAT(DISTINCT sessions.referrer_id) as referrer_ids,
3 IFNULL(referrer_groups.name, referrers.domain) as group_name,
4 GROUP_CONCAT(DISTINCT IFNULL(referrer_groups.domain, referrers.domain)) as domain,
5 GROUP_CONCAT(DISTINCT referrer_groups.type) as type,
6 COUNT(CASE WHEN views.viewed_at BETWEEN :start AND :end THEN 1 END) AS views,
7 COUNT(DISTINCT (CASE
8 WHEN views.viewed_at BETWEEN :start AND :end
9 THEN sessions.visitor_id END)) AS visitors,
10 COUNT(CASE
11 WHEN views.viewed_at BETWEEN :prev_start AND :prev_end
12 THEN 1 END) AS prev_period_views,
13 COUNT(DISTINCT (CASE
14 WHEN views.viewed_at BETWEEN :prev_start AND :prev_end
15 THEN sessions.visitor_id END)) AS prev_period_visitors,
16 0 AS wc_orders,
17 0 AS wc_gross_sales,
18 0 AS wc_refunds,
19 0 AS wc_refunded_amount
20 FROM wp_independent_analytics_views AS views
21 LEFT JOIN wp_independent_analytics_sessions AS sessions
22 ON views.session_id = sessions.session_id
23 LEFT JOIN wp_independent_analytics_referrers AS referrers
24 ON sessions.referrer_id = referrers.id
25 LEFT JOIN wp_independent_analytics_referrer_groups AS referrer_groups
26 ON referrers.domain = referrer_groups.domain_to_match
27 WHERE views.viewed_at BETWEEN :prev_start AND :end
28 GROUP BY group_name
29 ORDER BY visitors DESC, views DESC) subquery
30 WHERE views > 0