DataBull Search
dating_platform/traffic_overview.dashboard.lookml 12 tiles7 filters 3 warnings Repo files

LookML dashboard · dating-platform

Traffic pulse dashboard: twelve session tiles and seven fully wired filters

At a glance

Does
Twelve tiles on the sessions explore: new vs returning split, sessions by referer medium, country and landing page, daily trends, engagement for top landing pages and referer hosts, session index and event tiers, and a weekly cohort table.Trust: Source-defined
Why
A daily acquisition and engagement check for the dating app: where traffic comes from, whether it bounces, and whether visitors come back.Trust: Inferred
Breaks
3 warnings. Top: The cohort table is cut by the session date filter
Grain
Every tile counts sessions from sessions, except the cohort table, which counts visitors through the joined visitors view.Trust: Source-defined
Source
dating_platform/traffic_overview.dashboard.lookml 364 lines
Source: traffic_overview.dashboard.lookml L1-10
dating_platform/traffic_overview.dashboard.lookmlL1-10
- dashboard: traffic_pulse  title: Traffic pulse  layout: tile  tile_size: 120  filters:  - name: app_id    title: Application    type: select_filter    explore: sessions    dimension: sessions.app_id    default_value: dating  - name: date    title: Date

dating-platform, traffic_overview.dashboard.lookml, lines 1-10

Tile map: Traffic pulse 12

Trust: Source-defined

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

T1

New vs returning sessions count

looker_pie explore sessions

Dimensions
sessions.new_vs_returning_visitor
Measures
sessions.count
Sort
count desc, limit 500
Listens to
date, referer_medium, new_vs_returning, country, landing_page, referer_host, app_id

new_vs_returning_visitors L42-64

T2

Sessions count by referer medium

looker_pie explore sessions

Dimensions
sessions.referer_medium
Measures
sessions.count
Sort
count desc, limit 500
Listens to
date, referer_medium, new_vs_returning, country, landing_page, referer_host, app_id

sessions_by_referer_medium L65-87

T3

Sessions count by country

looker_pie explore sessions

Dimensions
sessions.geography_country
Measures
sessions.count
Sort
count desc, limit 500
Listens to
date, referer_medium, new_vs_returning, country, landing_page, referer_host, app_id

sessions_by_country L88-109

T4

Sessions count by landing page

looker_pie explore sessions

Dimensions
sessions.landing_page_path
Measures
sessions.count
Sort
count desc, limit 500
Listens to
date, referer_medium, new_vs_returning, country, landing_page, referer_host, app_id

sessions_by_landing_page L110-131

T7

Sessions by day by referer medium

looker_area explore sessions

Dimensions
sessions.start_date
Measures
sessions.count
Pivots
sessions.referer_medium
Sort
start_date desc, limit 500
Listens to
date, referer_medium, new_vs_returning, country, landing_page, referer_host, app_id

sessions_by_day_by_refr_medium L191-227

T11

Split in number of sessions by number of previous visits

looker_pie explore sessions

Dimensions
sessions.session_index_tier
Measures
sessions.count
Sort
session_index_tier, limit 500
Listens to
date, referer_medium, new_vs_returning, country, landing_page, referer_host, app_id

session_count_by_session_index L319-341

T12

Split in number of sessions by number of events per session

looker_pie explore sessions

Dimensions
sessions.events_during_session_tiered
Measures
sessions.count
Sort
events_during_session_tiered, limit 500
Listens to
date, referer_medium, new_vs_returning, country, landing_page, referer_host, app_id

session_count_by_engagement_level L342-364

Filter wiring: Traffic pulse

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
app_idApplicationdatingsessions.app_id12 of 12: T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12 none
dateDatelast 30 daysdate_filter12 of 12: T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12 none
new_vs_returningNew vs returning visitorsnonesessions.new_vs_returning_visitor12 of 12: T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12 none
referer_mediumReferer mediumnonesessions.referer_medium12 of 12: T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12 none
referer_hostReferer URL hostnonesessions.referer_url_host12 of 12: T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12 none
countryCountrynonesessions.geography_country12 of 12: T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12 none
landing_pageLanding page pathnonesessions.landing_page_path12 of 12: T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12 none

Filters and exclusions that change meaning

The app filter defaults to dating

Trust: Source-defined

app_id defaults to dating and every tile listens to it. Sessions from other apps on the same tracker are excluded unless the reader clears it.

Source: traffic_overview.dashboard.lookml L6-11
dating_platform/traffic_overview.dashboard.lookmlL6-11
  layout: tile  tile_size: 120  filters:  - name: app_id    title: Application    type: select_filter    explore: sessions    dimension: sessions.app_id    default_value: dating  - name: date    title: Date    type: date_filter

dating-platform, traffic_overview.dashboard.lookml, lines 6-11

Date applies to session start

Trust: Source-defined

date defaults to last 30 days and maps to sessions.start_date on every tile, including the cohort table.

Source: traffic_overview.dashboard.lookml L12-15
dating_platform/traffic_overview.dashboard.lookmlL12-15
    explore: sessions    dimension: sessions.app_id    default_value: dating  - name: date    title: Date    type: date_filter    default_value: last 30 days  - name: new_vs_returning    title: New vs returning visitors    type: select_filter

dating-platform, traffic_overview.dashboard.lookml, lines 12-15

Worth noticing

Every tile listens to all seven filters

Trust: Source-defined

Each tile repeats the same seven listen bindings. The filter wiring table below shows no tile skipping a filter, unlike the advertising dashboard.

Source: traffic_overview.dashboard.lookml L42-64
dating_platform/traffic_overview.dashboard.lookmlL42-64
    explore: sessions    dimension: sessions.landing_page_path  elements:  - name: new_vs_returning_visitors    title: New vs returning sessions count    type: looker_pie    explore: sessions    dimensions:    - sessions.new_vs_returning_visitor    measures:    - sessions.count    filters: null    listen:      date: sessions.start_date      referer_medium: sessions.referer_medium      new_vs_returning: sessions.new_vs_returning_visitor      country: sessions.geography_country      landing_page: sessions.landing_page_path      referer_host: sessions.referer_url_host      app_id: sessions.app_id    sorts:    - sessions.count desc    limit: 500    width: 3    height: 2    legend_align: null  - name: sessions_by_referer_medium    title: Sessions count by referer medium    type: looker_pie

dating-platform, traffic_overview.dashboard.lookml, lines 42-64

Previous visits are shown as session index tiers

Trust: Source-defined

"Split in number of sessions by number of previous visits" groups by session_index_tier. Tier 1 is first sessions, so it repeats the new vs returning split in more detail.

Source: traffic_overview.dashboard.lookml L319-341
dating_platform/traffic_overview.dashboard.lookmlL319-341
    y_axis_labels: null    y_axis_min: null    y_axis_max: null  - name: session_count_by_session_index    title: Split in number of sessions by number of previous visits    type: looker_pie    explore: sessions    dimensions:    - sessions.session_index_tier    measures:    - sessions.count    listen:      date: sessions.start_date      referer_medium: sessions.referer_medium      new_vs_returning: sessions.new_vs_returning_visitor      country: sessions.geography_country      landing_page: sessions.landing_page_path      referer_host: sessions.referer_url_host      app_id: sessions.app_id    sorts:    - sessions.session_index_tier    inner_radius: 75%    limit: 500    width: null    height: null    legend_align: null  - name: session_count_by_engagement_level    title: Split in number of sessions by number of events per session    type: looker_pie

dating-platform, traffic_overview.dashboard.lookml, lines 319-341

What can change the answer 3

Caution: The cohort table is cut by the session date filter

Trust: Inferred

cohort_analysis pivots sessions.start_week against visitors.first_touch_week and counts visitors.count, but the date filter limits sessions to the last 30 days.

What goes wrong: Older cohorts show only visitors who came back recently, so retention for early weeks looks lower than it was.

Read the guide: Filters that change metric meaning

Source: traffic_overview.dashboard.lookml L263-283
dating_platform/traffic_overview.dashboard.lookmlL263-283
    y_axis_labels: null    y_axis_min: null    y_axis_max: null  - name: cohort_analysis    title: Cohort analysis    type: table    explore: sessions    dimensions:    - visitors.first_touch_week    pivots:    - sessions.start_week    measures:    - visitors.count    listen:      date: sessions.start_date      referer_medium: sessions.referer_medium      new_vs_returning: sessions.new_vs_returning_visitor      country: sessions.geography_country      landing_page: sessions.landing_page_path      referer_host: sessions.referer_url_host      app_id: sessions.app_id    limit: 500    width: null    height: null  - name: session_count_and_engagement_level_by_referer_host    title: Session count and events per sesion for top 10 referer hosts    type: looker_column

dating-platform, traffic_overview.dashboard.lookml, lines 263-283

Caution: Bounce rate on top pages inherits session gaps

Trust: Missing

The landing page and referer host tiles show sessions.bounce_rate for the top 10 by session count. Bounce depends on number_of_events from sessions_basic, which is not in the repo.

What goes wrong: A change in how events are counted upstream moves bounce rate without any change in this repo.

Read the guide: Missing tables and stale references

Source: traffic_overview.dashboard.lookml L228-249
dating_platform/traffic_overview.dashboard.lookmlL228-249
    y_axis_min: null    y_axis_max: null    hide_points: true  - name: sessions_and_engagement_levels_for_most_popular_landing_pages    title: Sessions count and events per session for top 10 landing pages    type: looker_column    explore: sessions    dimensions:    - sessions.landing_page_path    measures:    - sessions.count    - sessions.bounce_rate    - sessions.events_per_session    listen:      date: sessions.start_date      referer_medium: sessions.referer_medium      new_vs_returning: sessions.new_vs_returning_visitor      country: sessions.geography_country      landing_page: sessions.landing_page_path      referer_host: sessions.referer_url_host      app_id: sessions.app_id    sorts:    - sessions.count desc    limit: 10    width: 6    height: 4    legend_align: null    hide_legend: null

dating-platform, traffic_overview.dashboard.lookml, lines 228-249

Note: New vs returning is cookie based

Trust: Source-defined

Three tiles split on sessions.new_vs_returning_visitor, which uses the cookie session index. Cleared cookies and new devices count as new visitors.

Source: traffic_overview.dashboard.lookml L42-64
dating_platform/traffic_overview.dashboard.lookmlL42-64
    explore: sessions    dimension: sessions.landing_page_path  elements:  - name: new_vs_returning_visitors    title: New vs returning sessions count    type: looker_pie    explore: sessions    dimensions:    - sessions.new_vs_returning_visitor    measures:    - sessions.count    filters: null    listen:      date: sessions.start_date      referer_medium: sessions.referer_medium      new_vs_returning: sessions.new_vs_returning_visitor      country: sessions.geography_country      landing_page: sessions.landing_page_path      referer_host: sessions.referer_url_host      app_id: sessions.app_id    sorts:    - sessions.count desc    limit: 500    width: 3    height: 2    legend_align: null  - name: sessions_by_referer_medium    title: Sessions count by referer medium    type: looker_pie

dating-platform, traffic_overview.dashboard.lookml, lines 42-64

Related

Guides built on this file

Guide How this LookML project separates new and returning visitors Are visitors coming back? How a real product splits new and returning visitors, why its visitor share counts sessions, and what cookies hide. RetentionAcquisition Guide How this LookML project measures acquisition quality Which channels bring visitors who engage? How a real product compares bounce rate and events per session by channel and landing page, with the SQL. Acquisition 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 Guide Catching missing tables and stale references before a dashboard breaks Models can name tables, fields and explores that do not exist, and nothing fails until a chart runs. Real examples, and how to check yours before release. Best practices

Related source files

Source file sessions One derived table that stitches session basics, geo, landing page, exit page, source and technology into a ... 2 views4 warnings Source file visitors One row per cookie visitor with first and last touch, lifetime events, pages and sessions, plus the landing... view4 warnings Source file business dashboards Business overview (7 tiles), Conversion Rates (3 tiles) and Maps (3 tiles). They chart revenue, transaction... 3 dashboards4 warnings

Source model

Source model Inside a dating platform LookML project: sessions, revenue, subscriptions and messaging Product, revenue and customer analytics 17 views20 joins