topic Re: Exclude Specific Browsers From Query Results in Real User Monitoring

Exclude Specific Browsers From Query Results

cwinkler109 — Thu, 01 May 2025 19:54:18 GMT

We use the following query in Data Explorer to monitor LCP:

builtin:apps.web.action.largestContentfulPaint.load.userType.geo:filter(and(or(in("dt.entity.application_method",entitySelector("type(application_method),entityName.equals(~"loading of pdp~")"))))):splitBy("dt.entity.application_method"):percentile(95.0):sort(value(percentile(95.0),descending)):limit(20)

Is it possible to modify that query to exclude LCP data from the "FacebookBot" browser?

Re: Exclude Specific Browsers From Query Results

AntonPineiro — Fri, 02 May 2025 06:53:51 GMT

Hi,

I would say no, as you can see, browser is not a metric dimension:

Best regards

Re: Exclude Specific Browsers From Query Results

cwinkler109 — Fri, 02 May 2025 16:46:29 GMT

Yes, for me Browsers is a dimension:

Re: Exclude Specific Browsers From Query Results

AntonPineiro — Mon, 05 May 2025 09:13:58 GMT

Hi,

Yes, I was checking another metric. Which options appears to you in filter field?

Is not there?

Best regards

Re: Exclude Specific Browsers From Query Results

cwinkler109 — Mon, 05 May 2025 12:58:40 GMT

Yes, I can filter by browser. Many different types of browsers are available for me to filter the results by.

My question is how can I exclude one of those browsers from the results. For example, how would I write my query to retieve and trend LCP metrics for everything EXCEPT the "facebookbot" browser.

Re: Exclude Specific Browsers From Query Results

mark_bley — Mon, 05 May 2025 13:16:45 GMT

You will need to adapt the query and negate the browsers you are not interested in, here an example:

builtin:apps.web.action.largestContentfulPaint.load.browser :filter( and(not(in("dt.entity.browser",entitySelector("type(browser),entityName.in(~"Chrome 100~",~"Chrome 101~",~"Chrome~")"))) ) ) :splitBy("dt.entity.browser"):sort(value(auto,descending)):limit(20)

Re: Exclude Specific Browsers From Query Results

AntonPineiro — Mon, 05 May 2025 14:42:06 GMT

Hi,

I see your point. @mark_bley has already pointing you in the right direction. You need to use "not" to exclude it.

Best regards

Re: Exclude Specific Browsers From Query Results

cwinkler109 — Mon, 05 May 2025 15:50:33 GMT

Perfect. Thank you!