SUSE Data Warehouse

Appearance

SUSE Data WarehousePaid Advertising Analytics V2

Cross-platform ad performance data from 6 platforms, unified in BigQuery

Browse Datasets
Data Dictionary
Workflows
📊

6 Ad Platforms

Google, Microsoft, LinkedIn, Reddit, 6sense, and StackAdapt data flowing through standardized pipelines.

🎨

Creative Tracking

Ad creative metadata with image URLs, ad copy, and performance joins for fatigue analysis.

âš¡

UDF-Powered Metadata

10 SQL functions parse campaign naming conventions at query time for dynamic reporting.

🔄

Daily Automation

Scheduled refresh scripts run daily with delete-by-ID integrity and comprehensive logging. 6sense and StackAdapt are manually updated via Google Sheets.

Project Overview ​

MetricValue
Projectpaidteam-data-warehouse
Datasetcustomer_ads_suse
Regioneurope-west2
Tables36 (24 V2 active, 12 V1 legacy)
Views9
UDFs10
Total Data~830 MB, 2.15M rows
Last Audit2026-02-09

Architecture ​

Dataslayer / Google Sheets (daily ingestion)
        │
        â–¼
  staging_v2 tables ─── rolling window, fully replaced
        │
        â–¼
  Scheduled Refresh Scripts (08:00 UTC)
  ├── Adlevel: DELETE-by-ID + INSERT
  └── Creative: MERGE (update/insert/preserve)
        │
        â–¼
  final_v2 tables ─── partitioned by Date, historical
        │
        â–¼
  Performance Views ─── JOIN creative + adlevel + UDFs
        │
        â–¼
  Looker Studio Dashboards

SUSE Paid Advertising Data Warehouse V2

Internal Documentation