Home Data Quality Audit - Noble House

Data Quality Audit - Noble House

Data Quality Audit

Internal use — Crecera only.

This dashboard runs 11 automated checks (QA-00 through QA-10) against the Funnel → BigQuery pipeline on every build (daily at 06:00 UTC). Use it to track data quality over time and catch connector or backfill issues before they affect the marketing dashboards.

Status meanings:

  • PASS — Working as expected, no action needed
  • INFO — Informational only, no action needed
  • WARNING — Needs attention but not blocking the dashboard
  • ACTION REQUIRED — External action needed (backfill request, Funnel config fix)

Showing audit from: 2026-04-09 . Latest data in pipeline: 2026-04-08 . Days of history: 60 / 730 target.

Current priority: QA-01, QA-05, and QA-10 ACTION REQUIRED counts are dominated by the 2-year backfill — all hotels currently have only 60 days of data. These will all flip to PASS once the Funnel backfill is complete. The missing connector table below is the actionable item right now.

Status Summary

Action Required

52

Warnings

25

Passing

140

Info

27

Issues Requiring Attention

The table below shows all WARNING and ACTION REQUIRED rows for the latest audit.

Known issue groups:

  • QA-01 / QA-05 / QA-10 (backfill) — All hotels have fewer than 730 days. Resolves when Funnel completes the 2-year backfill. No dashboard fix needed.
  • QA-00 / QA-02 / QA-03 (blank location rows) — Brand-level GA4 sessions (noblehousehotels.com) have no hotel location. Expected. Already excluded from hotel queries via WHERE location IS NOT NULL.
  • QA-04 / QA-09 (missing connectors) — Hotels with gaps in the table below. These require a Funnel connector fix.
  • QA-07 (daily partitioning) — A WARNING on the most recent date is expected (Funnel push still in progress when the build runs). Self-corrects the next day.
  • QA-08 (brand rows) — Noble House brand-level rows across GA4, GBP, GSC. Expected and handled.

Missing connectors:
No Results
No Results

Full QA Results

Check Name What it verifies Resolves when
QA-00 Location Values Every unique location value and its row count Ongoing monitoring
QA-01 Date Range & Volume Total rows, earliest/latest date, days of history Backfill complete (~730 days)
QA-02 Blank Location Rows Count of NULL location rows overall Funnel config fixes applied
QA-03 Blank Location by Source Which connectors produce blank-location rows Funnel config fixes applied
QA-04 Source Coverage Per Hotel Each hotel has GA4, Google Ads, GSC, GBP data Missing connectors added in Funnel
QA-05 Date Range Per Hotel Each hotel has 2+ years of history Backfill complete per hotel
QA-06 Metric Population Key metrics are populated at expected rates Always PASS — monitoring only
QA-07 Daily Partitioning Each day has a normal row count (15K–50K) Auto-resolves next day if Funnel push completes
QA-08 Brand-Level Rows Identifies rows tagged "Noble House Hotels & Resorts" Decision: include or exclude from portfolio
QA-09 ROAS Per Hotel Google Ads ROAS is within a plausible range (0–100x) Missing connectors fixed; ROAS data present
QA-10 Hotel Master List All 25 hotels present with sufficient history Backfill complete (~730 days per hotel)
No Results