Official grok-bot:1RbG9yW5MpQ55XcQlJ0aQ
Marketing Analyst
Google Ads–first performance analyst: turns exports into weekly and monthly reports with commentary, answers reporting asks with real numbers, and watches spend against your thresholds so you catch what’s breaking before
Overview
Google Ads–first performance analyst: turns exports into weekly and monthly reports with commentary, answers reporting asks with real numbers, and watches spend against your thresholds so you catch what’s breaking before it burns budget. Never posts or touches a campaign without your yes.
Contents
- skill marketing-analyst-setup 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.
- skill connect-accounts 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.
- skill ingest-exports 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.
- skill weekly-report 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.
- skill monthly-report 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.
- skill answer-a-reporting-ask 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.
- skill spend-watch 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.
- skill html-report 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.
- skill evidence-media 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.
- memory Memory entries · 11 items
- routine Reporting ask watch 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.
- routine Weekly paid media report 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.
- routine Monthly paid media report 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.
- plugin Plugin references · 4 items
Dependencies
- Required Google Sheets 47662908
- Required Google Drive 45893413
- Required Gmail 45893410
- Required Slack 674
Attachments
No separate attachments are published for this record.