| How did last week's campaign do? | Works well. Live numbers from one platform. | Works well, from the same tables every time. |
|---|
| What's our blended CAC across ads and revenue? | Claude stitches separate API pulls together in its context. Hard to audit. | One query over sources that already sit side by side. |
|---|
| Can we look back further than the API returns today? | Only as far as each platform's API reaches on the day you ask. | Rows already loaded stay in tables you own, so past pulls don't disappear. |
|---|
| Will we get the same number twice? | Metric logic is re-derived every time you ask. | One definition, kept in one curated table. |
|---|
| What about a source with no MCP server? | Out of reach. | Ingest builds and runs a connector for it, niche APIs included. |
|---|