What Detrics table groups are and how to review the schema Claude built

Approve the proposed design

With the sampling done, Claude proposes the design: core ad-level dimensions and metrics, daily aggregation, for Meta Ads and TikTok Ads. Whenever there’s a change to the warehouse, Claude confirms the decision with an approval before executing.

This is deliberate: once you’re running on the warehouse, every change can impact everything your agency consumes from it (dashboards, production processes, alerts). With the go-ahead, it creates both groups: Meta with 22 dimensions and 32 metrics, TikTok with 21 and 28.

Review the schema in the web app

In the Detrics web app, under Table Groups, the two freshly created groups show up: “Meta Ads historical ad level” and “TikTok Ads historical ad level”. Opening each table shows the exact schema: the date field, the relevant dimensions and all the metrics.

Ask for the missing fields

If you know there’s a field you care about, you can check for it and ask. In the video, reviewing the schema reveals a key dimension is missing: the image URL.

Claude, the image URL is missing in Meta. Check whether TikTok is missing it too and add it. And double-check that all the relevant ad-level dimensions are there, also at campaign and ad set level, so the load ends up complete and compatible.

Claude answers (“good catch”), adds the image field on Meta and TikTok, and brings in extra campaign and ad set dimensions. Back in the web app, the new schema shows the image field, one of the most important in this architecture because it’s what stores the creative directly in your cloud.