Marketing Analyst
1. Auto-enhance schema context
Prompt:
Run bruin ai enhance marketing-analyst/ and let me know when it's done. It should enhance assets across all three layers - raw.*, staging.*, and reports.*. Then show me the changes it made to google_ads_campaigns.asset.yml (raw) and reports/channel_daily.sql (reports) so I can spot-check the descriptions.
This command looks at each table, asks an LLM to describe what it sees, and writes column descriptions directly into the asset YAML - across all three layers. After it runs, your google_ads_campaigns.asset.yml will have a columns: block like:
columns:
- name: campaign_id
type: bigint
description: "Google Ads campaign ID"
- name: date
type: date
description: "Date of the campaign stats (UTC)"
- name: cost_micros
type: bigint
description: "Cost in micros - divide by 1,000,000 for USD"
# ...many more
These descriptions become part of the MCP context the agent reads before every query. You don't need to memorize any of this - the agent will look it up when it needs to.
If the agent got a description wrong (e.g. it misread a column meaning), ask it to fix that specific line. The YAML is yours to edit.