Client-owned Ads Warehouse

Scheduled source data becomes joined business evidence, alerts and a human decision

Client-owned Ads Warehouse Scheduled source data becomes joined business evidence, alerts and a human decision Client-owned Google Cloud project Google Ads · campaign + conversion data · Architecture component · source Google Ads campaign + conversion data source GA4 · consented web events · Architecture component · source GA4 consented web events source CRM · lead stage + value · Architecture component · source CRM lead stage + value source Microsoft Ads · campaign + conversion data · Architecture component · source Microsoft Ads campaign + conversion data source Scheduled loads · connectors + n8n · Client-owned Google Cloud project · monitored Scheduled loads connectors + n8n monitored Raw datasets · source-shaped history · Client-owned Google Cloud project · retained Raw datasets source-shaped history retained Curated model · joined facts + definitions · Client-owned Google Cloud project · documented Curated model joined facts + definitions documented Dashboard · business outcomes · Architecture component · read-only Dashboard business outcomes read-only Variance checks · weekly comparisons · Client-owned Google Cloud project · rules Variance checks weekly comparisons rules Alert digest · movement + evidence · Architecture component · Monday Alert digest movement + evidence Monday Human review · diagnose + decide · Architecture component · accountable Human review diagnose + decide accountable scheduled extract events export outcomes scheduled extract append / replace by contract transform + test defined metrics weekly facts exceptions + context inspect trend investigate exception Legend Frontend Backend Database Message bus External

Owned and portable

  • • The warehouse sits in the client's cloud project
  • • Retention, access, query controls and connector fees are documented
  • • Raw history survives a change of agency

Joined business evidence

  • • Ads and analytics are joined to CRM stages and value
  • • Metric definitions live beside the curated model
  • • A dashboard is a consumer, not the source of truth

Machine check, human decision

  • • Weekly rules flag unusual movement with its comparison window
  • • A person diagnoses the likely constraint before changing the account
  • • Joined attribution improves hygiene; it does not prove causation