DataBull Search
advertising_marketing_small/default.dashboard.lookml 8 tiles1 filter 3 warnings Repo files

LookML dashboard · advertising-marketing-small

Unusual UAs dashboard: how eight tiles slice one impressions explore

At a glance

Does
Eight tiles over the other_browser_os_impressions explore: browser and OS mix, rare user agents, top PIDs and referrers by volume and bid sum, top IPs and top countries.Trust: Source-defined
Why
A traffic-quality review screen for unusual user agents. It helps spot publishers and IPs that send odd traffic and shows whether that traffic still earns bids.Trust: Inferred
Breaks
3 warnings. Top: The country filter is not wired to any tile
Grain
Every tile counts impression rows from one view. Tile-level filters change which rows count, tile by tile.Trust: Source-defined
Source
advertising_marketing_small/default.dashboard.lookml 145 lines
Source: default.dashboard.lookml L1-10
advertising_marketing_small/default.dashboard.lookmlL1-10
- dashboard: default  title: Unusual UAs, Examined Impressions Over 27 Days  layout: tile  tile_size: 100  filters:  - name: country    type: suggest_filter    explore: other_browser_os_impressions    dimension: other_browser_os_impressions.country    default_value: US  elements:  - name: browser_os_breakdown    title: Browser-OS Breakdown

advertising-marketing-small, default.dashboard.lookml, lines 1-10

Tile map: Unusual UAs, Examined Impressions Over 27 Days 8

Trust: Source-defined

Every tile in file order, with the fields it reads. Field links go to their definitions.

Filter wiring: Unusual UAs, Examined Impressions Over 27 Days

Trust: Source-defined

Dashboard filters only reach tiles that declare a listen binding. Tiles in the Skips column ignore the filter even when it is set.

FilterDefaultFieldDrivesSkips
countryUSother_browser_os_impressions.country0 of 8T1 T2 T3 T4 T5 T6 T7 T8

Filters and exclusions that change meaning

Unusual means not starting with Mozilla/5.0

Trust: Inferred

The Unusual UAs table keeps only UAs that do not begin with Mozilla/5.0. Almost every modern browser sends that prefix, so this keeps bots, SDKs and old clients. It sorts ascending, so the rarest UAs come first.

Source: default.dashboard.lookml L35-47
advertising_marketing_small/default.dashboard.lookmlL35-47
    width: 10    y_axis_labels:    - Count of Impressions  - name: unusual_uas_table    title: Unusual UAs    type: table    explore: other_browser_os_impressions    dimensions:    - other_browser_os_impressions.ua    measures:    - other_browser_os_impressions.count    sorts:    - other_browser_os_impressions.count    filters:      other_browser_os_impressions.ua: -Mozilla/5.0%    limit: 50  - name: revenue_and_impressions_top_10_pids    title: Revenue and Impressions for Top 10 PIDs    type: looker_column

advertising-marketing-small, default.dashboard.lookml, lines 35-47

Only three tiles drop empty domains

Trust: Source-defined

The two revenue tiles and the top countries tile filter domain: -EMPTY. The volume tiles do not, so impression totals differ between tiles that look comparable.

Source: default.dashboard.lookml L48-61
advertising_marketing_small/default.dashboard.lookmlL48-61
    filters:      other_browser_os_impressions.ua: -Mozilla/5.0%    limit: 50  - name: revenue_and_impressions_top_10_pids    title: Revenue and Impressions for Top 10 PIDs    type: looker_column    explore: other_browser_os_impressions    dimensions:    - other_browser_os_impressions.pid    measures:    - other_browser_os_impressions.count    - other_browser_os_impressions.sum_of_bids    filters:      other_browser_os_impressions.domain: -EMPTY    sorts:    - other_browser_os_impressions.sum_of_bids desc    limit: 25    show_null_labels: false    column_group_spacing_ratio: 0.25    stacking: ''

advertising-marketing-small, default.dashboard.lookml, lines 48-61

Worth noticing

Tile names and titles disagree

Trust: Source-defined

top_10_pids_by_requests_with_unusual_uas is titled "Top 10 PIDs by Impression Volume" and applies no UA filter. "Revenue and Impressions for Top 10 PIDs" returns up to 25 rows.

Source: default.dashboard.lookml L100-110
advertising_marketing_small/default.dashboard.lookmlL100-110
    stacking: ''    y_axis_labels:    - Sum of Bids ($)  - name: top_10_pids_by_requests_with_unusual_uas    title: Top 10 PIDs by Impression Volume    type: looker_pie    explore: other_browser_os_impressions    dimensions:    - other_browser_os_impressions.pid    measures:    - other_browser_os_impressions.count    sorts:    - other_browser_os_impressions.count desc    limit: 10    show_null_labels: false    inner_radius: 50    width: 5

advertising-marketing-small, default.dashboard.lookml, lines 100-110

Revenue is ranked by bid sum

Trust: Inferred

Both revenue tiles sort by sum_of_bids desc. "Most profitable" here means highest summed bid amount, not margin or cleared spend.

Source: default.dashboard.lookml L83-95
advertising_marketing_small/default.dashboard.lookmlL83-95
    sorts:    - other_browser_os_impressions.count desc    limit: 25  - name: most_profitable_uas    title: Top 10 Most Profitable UAs    type: looker_column    explore: other_browser_os_impressions    dimensions:    - other_browser_os_impressions.ua    measures:    - other_browser_os_impressions.sum_of_bids    filters:      other_browser_os_impressions.domain: -EMPTY    sorts:    - other_browser_os_impressions.sum_of_bids desc    limit: 10    show_null_labels: false    stacking: ''    y_axis_labels:

advertising-marketing-small, default.dashboard.lookml, lines 83-95

What can change the answer 3

Caution: The country filter is not wired to any tile

Trust: Source-defined

The dashboard filter country defaults to US. No tile declares listen, so changing it changes nothing.

What goes wrong: Readers believe they are looking at US traffic while every tile counts all countries.

Read the guide: Filters that change metric meaning

Source: default.dashboard.lookml L6-10
advertising_marketing_small/default.dashboard.lookmlL6-10
  layout: tile  tile_size: 100  filters:  - name: country    type: suggest_filter    explore: other_browser_os_impressions    dimension: other_browser_os_impressions.country    default_value: US  elements:  - name: browser_os_breakdown    title: Browser-OS Breakdown

advertising-marketing-small, default.dashboard.lookml, lines 6-10

Caution: "Top IPs That Send Unusual UAs" ranks all traffic

Trust: Source-defined

The tile filters only ip: -EMPTY. There is no UA filter, so it lists the highest-volume IPs overall.

What goes wrong: IPs flagged from this tile are often large NATs, proxies or data centres with normal browsers, not unusual clients.

Read the guide: Filters that change metric meaning

Source: default.dashboard.lookml L69-82
advertising_marketing_small/default.dashboard.lookmlL69-82
    y_axis_labels:    - ImpressionCount    - Bid Sum ($)  - name: unusual_requests_by_ip    title: Top IPs That Send Unusual UAs    type: table    filters:      other_browser_os_impressions.ip: -EMPTY    explore: other_browser_os_impressions    dimensions:    - other_browser_os_impressions.ip    - other_browser_os_impressions.country    measures:    - other_browser_os_impressions.count    sorts:    - other_browser_os_impressions.count desc    limit: 25  - name: most_profitable_uas    title: Top 10 Most Profitable UAs    type: looker_column

advertising-marketing-small, default.dashboard.lookml, lines 69-82

Note: "27 days" exists only in the title

Trust: Source-defined

No tile or dashboard filter restricts time, and the view has no time dimension group. The window is whatever the underlying table holds.

Source: default.dashboard.lookml L1-5
advertising_marketing_small/default.dashboard.lookmlL1-5
- dashboard: default  title: Unusual UAs, Examined Impressions Over 27 Days  layout: tile  tile_size: 100  filters:  - name: country    type: suggest_filter    explore: other_browser_os_impressions

advertising-marketing-small, default.dashboard.lookml, lines 1-5

Parser checks 1

Trust: Source-defined

Mechanical findings from parsing the LookML. They are facts about the files. The cards above explain which ones matter.

Show all 1 check
  • filter-unwired 1
    • default.dashboard.lookml:6 Dashboard filter "country" is not wired to any tile through listen.

Related

Guides built on this file

Guide Using user agents to flag non-browser ad impressions How a real ad-tech model flags impressions from clients that are not ordinary browsers, which publishers send them, and where its user-agent rule misleads. Acquisition Guide Checking whether a few publishers earn most of the revenue How a real ad-tech model ranks publishers by bid revenue, why a ranking is not a concentration measure, and what its parsed publisher id hides. Revenue Guide Filters that quietly change what a metric means Why two reports disagree on one metric: hidden default filters, tile filters and unwired dashboard filters, with a checklist and real examples. Best practicesAcquisitionRetention

Related source files

Source file other_browser_os_impressions Exposes raw ad impression rows with browser, OS, user agent, IP, geography, subid, campaign, creative and b... view4 warnings

Source model

Source model Inside an AdTech LookML project: traffic quality, publisher revenue and IP clustering AdTech traffic quality 9 views0 joins