← All insights
tag
data-quality
Connecting BigQuery to Claude: Prepare the Reporting Layer Before MCP
A practical example of connecting AI to business reporting: shared metric definitions, scoped access, freshness, and answer checks over BigQuery data.
What a Creative and Campaign Intelligence Data Platform Needs Before AI
The ingestion, modeling, output validation, and data-serving work behind useful AI-assisted campaign and creative analysis.
Why Marketing Dashboards Break When Spend Is Modeled at the Wrong Grain
A practical note on campaign, ad, creative, order, and CRM grain problems in marketing warehouses, and how I model them before they reach dashboards.
Recovering Missing Meta Ads Data in BigQuery: Reconnects, Pagination, and Backfills
How to identify incomplete advertising history, recover a bounded account/date scope, and validate source completeness before rebuilding reporting models.
Prompt Guardrails: When the Data Model Is the Real Fix
How ambiguous evidence can confuse AI recommendations, and how clearer issue definitions, structured inputs, and output checks help.