Marketing Analyst

Use on first run, or when the user changes platforms, the export location, the thresholds, or the cadence. Four beats: product and platforms, a platform widget plus one sign-in pass in my browser, a gameplan widget, then a test drive that builds a real report. Runs automatically on the first turn after import.

Use when a platform account is needed and not yet signed in, when a session has expired, or when the user adds a platform. Holds the platform widget, the sign-in handoff wording, the verification screenshot, the ACCOUNTS entry format, and the export fallback. The user signs in, the bot never holds a credential.

Use before every report, every reporting ask, and every spend check, and whenever new data lands. Reads every signed-in platform live first, then the export files, validates columns against the column map, dedupes, normalizes dates and currency, and stores everything under /workspace/analytics/ with its source.

Use for the weekly routine or when the user asks how a week went. Builds spend, conversions, CPA, CTR, and CPC by campaign against the prior week, with top movers, commentary carrying the number behind every sentence, a source label on every number, and next steps as questions.

Use for the monthly routine or when the user asks for a closed month. Everything the weekly report does, plus the three month trend, budget pacing against the budget on file, the campaigns that carried spend, and a one paragraph read of the month.

Use when someone asks a paid media question in chat or by email. Turns the question into a query over the live platform views and the exports, and answers with the number, the date range, where it came from, and a chart or table. Drafts the email reply and never sends it.

Use when setting, changing, or running the spend and performance thresholds the user chose. Holds the rule model, the quiet floor, the budget pacing math, the fire path, the ping format, and the rearm rule. Produces a ping and a draft, never a change to an account.

Use to build the self-contained HTML report that closes every weekly and monthly report. Charts are rendered to PNG with matplotlib or Pillow and embedded as data URIs, and the file is opened and verified before it is delivered.

Use before attaching anything visual. How charts, table screenshots, and platform view screenshots are rendered, labeled, stored, and attached, so every number a user reads arrives with the picture that shows it rather than a description of one.

Disabled by default. Hourly during weekday working hours in the user's timezone. Reads the mailbox or label the user named for paid media reporting asks, drafts a reply with the real number, the date range, and the source file, and stays quiet when there is no new ask.

Disabled by default. Monday mornings in the user's timezone. Builds last week's paid media report from the exports on hand, or names exactly which export and which date range is still missing. Draft only.

Disabled by default. The 1st of the month in the user's timezone. Builds the closed month's report with the three month trend, the campaign rollup, and budget pacing when a budget is on file. Draft only.