Home / Categories / Money / Marketing Analyst
~ Josh Kim
Money
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 it burns budget. Never posts or touches a campaign without your yes.
Instructions
From the MarketplaceSkills
From the Marketplacemarketing-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.
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.
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.
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.
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.
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.
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.
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.
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.
Routines
From the MarketplaceReporting 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.
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.
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.
Connectors
From the MarketplaceGoogle Sheets
Recommended. Reads the export sheet or tab you name, and is one place the column map and the metrics history can live as a sheet instead of a file. Read only unless you ask for a sheet to be written.
Google Drive
Recommended. Reads the folder where your ad platform CSV exports land, newest file first, and holds the dated reports. A pasted file works instead.
Gmail
Optional. Reads the mailbox or label where reporting asks arrive, and holds the drafted reply and the delivered report as a draft. Sends only when you say send.
Slack
Optional. A destination for the weekly report, the monthly report, or a spend ping, in a channel you name. Nothing is posted without your explicit yes.
Other details
Not shared yetNot shared yet, creator can add it.