Still need to add MS App Insights, most (all?) Catchpoint RUM scripts are self-hosted so this may under detect them
One thing to remember is although there may be the data collection script on the page, there are multiple versions of these products e.g. there’s a free (lite) and paid for version of mPulse, similar thing applies for New Relic – many sites have the script but the data collection is so low that the product isn’t very useful
SELECT
sites,
ROUND(sites / (SELECT COUNT(DISTINCT page) FROM `httparchive.requests.2020_06_01_desktop`) * 100 , 2) AS pct_sites,
vendor
FROM (
SELECT
COUNT(DISTINCT page) as sites,
CASE
WHEN REGEXP_CONTAINS(url, r"http[s]*://[www.|ssl.]*google-analytics.com/ga.js") THEN "Google Analytics"
WHEN REGEXP_CONTAINS(url, r"http[s]*://[www.|ssl.]*google-analytics.com/analytics.js") THEN "Google Analytics"
WHEN REGEXP_CONTAINS(url, r"http[s]*://[www.|ssl.]*googletagmanager.com/gtag/js") THEN "Google Analytics"
WHEN REGEXP_CONTAINS(url, r"http[s]*://rum-static.pingdom.net/prum") THEN "Pingdom"
WHEN REGEXP_CONTAINS(url, r"insight.torbit.com/.*.js") THEN "Torbit"
WHEN url LIKE "%aksb.min.js%" THEN "Akamai (Legacy RUM)"
WHEN url LIKE "%go-mpulse.net/boomerang/%"
OR url LIKE "%lognormal.net/boomerang/%" THEN "Akamai mPulse"
WHEN url LIKE "%/gomez%"
AND url LIKE "%rum%"
AND url LIKE "%.js%" THEN "Gomez"
WHEN REGEXP_CONTAINS(url, r".*boomerang[\d\-\w\.]*(\.js)?$") THEN "boomerang.js"
WHEN url LIKE "%js-agent.newrelic.com%" THEN "New Relic"
WHEN url LIKE "%spdcrv%" OR url LIKE '%speedcurve.com/js/lux.js%'THEN "SpeedCurve"
WHEN url LIKE "%nccrum.core.js%"
OR url LIKE "%://data.rci.eggplant.cloud/rci.core.js%" THEN "Eggplant"
WHEN url LIKE "%cdn.appdynamics.com%" THEN "AppDynamics"
WHEN url LIKE "%static.cloudflareinsights.com/beacon.min.js%" THEN "CloudFlare"
WHEN url LIKE "%ruxitagent%.js%" THEN "Dynatrace"
WHEN url LIKE "%rum.monitis.com%.js%" THEN "Monitis"
WHEN url LIKE "%site24x7rum-min.js%" THEN "Site24x7"
WHEN url like "%uptrends.com%rum.%.js%" THEN "Uptrends"
WHEN url like "%cdn.raygun.io/raygun4js/raygun.%.js%" THEN "RayGun"
WHEN url like "%atatus.js%" THEN "Atatus"
WHEN url LIKE "%://eum.instana.io/eum.min.js%" THEN "Instana"
WHEN url LIKE "%://cdn.sematext.com/rum.js%" THEN "Sematext"
WHEN url LIKE "%btttag.com/btt.js%" THEN "Blue Triangle"
WHEN url LIKE "%://stckjs.azureedge.net/stckjs.js%" THEN "Stackify"
WHEN url LIKE "%://www.datadoghq-browser-agent.com/datadog-rum%" THEN "Datadog"
WHEN REGEXP_CONTAINS(url, r"/catchpoint[0-9\-]*.js") THEN "Catchpoint"
WHEN url LIKE "%://cdn.webtuna.com/webtuna.js%" THEN "WebTuna"
WHEN url LIKE "%://browser.plumbr.io/pa.js" THEN "Plumbr"
WHEN url LIKE "%://cdn-assets.rapidspike.com/static/js/timingpcg.min.js" THEN "RapidSpike"
WHEN url LIKE "%/clobs.min.js%" THEN "ip-label"
WHEN url LIKE "%://appstatic.quanta.io/quanta-rum%" THEN "Quanta"
WHEN url LIKE "%://cdn.quantummetric.com/qscripts/quantum-%.js%" THEN "Quantum Metric"
END as vendor
FROM `httparchive.requests.2020_06_01_desktop`
GROUP BY vendor
)
WHERE vendor IS NOT NULL
GROUP BY vendor, sites
ORDER BY sites DESC
sites | pct_sites | vendor |
---|---|---|
3393853 | 68.03 | Google Analytics |
147983 | 2.97 | New Relic |
127671 | 2.56 | boomerang.js |
15396 | 0.31 | Akamai mPulse |
7773 | 0.16 | CloudFlare |
5667 | 0.11 | Dynatrace |
5018 | 0.1 | Pingdom |
2949 | 0.06 | AppDynamics |
2514 | 0.05 | Akamai (Legacy RUM) |
1313 | 0.03 | Instana |
1150 | 0.02 | SpeedCurve |
963 | 0.02 | RayGun |
886 | 0.02 | Site24x7 |
652 | 0.01 | Quantum Metric |
558 | 0.01 | Datadog |
177 | 0.0 | Blue Triangle |
166 | 0.0 | Monitis |
68 | 0.0 | Plumbr |
66 | 0.0 | Catchpoint |
54 | 0.0 | Atatus |
47 | 0.0 | Eggplant |
13 | 0.0 | Sematext |
10 | 0.0 | Quanta |
10 | 0.0 | ip-label |
9 | 0.0 | RapidSpike |
2 | 0.0 | WebTuna |
1 | 0.0 | Uptrends |
1 | 0.0 | Stackify |