~/talk

Using Google Data (now Looker) Studio for Dashboard Analytics Reporting

Talkat DrupalCamp NJ 2023 · 2023-03-16..03-18· [data-visualization]
links:none on file
slides:none on file

Uses Looker Studio (formerly Google Data Studio) to turn GA4 event data into interactive dashboards that stakeholders can use instead of raw Analytics access. Connects GA4, Google Sheets, BigQuery and third‑party sources (21 built‑in connectors, 730 third‑party connectors available). Implements custom GA4 dimensions for email link clicks and file downloads, surfaces results with scorecards, time series, tables and conditional formatting, and uses report-level controls and filters to compare date ranges. Solves missing metrics by creating custom definitions, filters out referral spam, and reports worked consistently across Drupal, WordPress and static sites.

AI-written summary · about

  1. 0:00Introduction to dashboards
  2. 3:14What is a data dashboard
  3. 4:17Google Looker Studio overview
  4. 7:30Key report components
  5. 13:13Report level controls
  6. 16:00Sharing and embedding reports
  7. 16:21GA4 transition challenges
  8. 19:13Live demo setup
  9. 24:40Interactive dashboard features
  10. 36:08Q&A and closing
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.