PlugsightDocs

Build a monthly client marketing report

Pull last month against the month before across Google Ads, GA4 and Search Console, check the numbers, then draft the email to your client.

This guide builds a monthly marketing report for one client in your AI chat: headline numbers, what changed, why, and what to do next. You finish with a draft email in your mailbox, ready to check and send.

It takes about 20 minutes the first time and less once you reuse your questions.

What you need

  • A Pro or Agency plan (marketing connectors aren't on Free).
  • The client's marketing accounts connected and in an MCP server: see Set up Plugsight for a new client.
  • Optional: an email account connected, if you want your AI to save the report as a draft.

Step 1: open a chat with the right server

  1. Start a new chat in your AI app.
  2. Switch on the client's MCP server (in Claude: + → Connectors; in ChatGPT: + next to the message box).
  3. Ask "List my marketing accounts" and check the client's accounts are there.

If you use one server for several clients, name the client's accounts in every question below, for example "for Acme's Google Ads account".

Step 2: get the headline numbers

Ask for last month as a whole calendar month:

  • "Give me an account overview for last month compared with the month before, for every platform."

This runs the account overview deep dive: spend, conversions, CPA, ROAS, organic clicks, sessions and revenue, for this period and the previous one.

"Last month" means the 1st to the last day of the previous calendar month, worked out in UTC. Run the report after the month has ended, and, for Search Console, a few days later: its data becomes final 2–3 days after each date. See Get accurate numbers from marketing data.

Step 3: find out what changed

Ask for a period comparison on the platforms that matter to this client:

  • "Compare cost, conversions and CPA by campaign in Google Ads, last month against the month before. Show the biggest gains and drops."
  • "Compare sessions, key events and revenue by channel in GA4, last month against the month before."
  • "Compare organic clicks and impressions by page in Search Console, last month against the month before. Which pages lost the most clicks?"

For a year-on-year view, ask for "the same month last year" instead of "the month before".

Step 4: add the why

Pick the questions that explain the changes:

  • "Which search terms cost money last month without converting?" (the wasted spend deep dive)
  • "Which campaigns lost impression share to budget last month?"
  • "Which queries are close to page one in Search Console?" (the SEO opportunities deep dive)

Step 5: check the numbers

Before anything goes to a client:

  1. Ask "Were any data notes returned for these reports?" Plugsight adds notes when Google holds data back (hidden low-volume search terms, GA4 thresholds or sampling, Search Console data that isn't final yet).
  2. If the client has ad accounts in more than one currency, ask for results "split by account" so money isn't added across currencies.
  3. Spot-check one or two totals against the Google Ads or GA4 interface for the same dates.

Step 6: turn it into a report

Ask your AI to write it up:

  • "Write this as a client report with these sections: headline numbers (a table, last month vs the month before, with % change), what went well, what didn't, and three recommendations for this month. Keep it under 400 words."

Ask for changes until you're happy with it.

Step 7: save it as a draft email

If an email account is in the same MCP server:

  • "Save this report as a draft email to jane@acme.com from my work inbox, subject 'Acme marketing report: October'."

Your AI saves it in the account's Drafts folder. Nothing is sent. Drafts work on every plan, even when the account's switch is off or the server is read-only.

Open the draft in your mail app, check it and send it yourself. Or, if your plan includes changes and the account's switch is on Can send, ask your AI to send it: it shows you the final email and waits for your yes. See Approvals in the chat.

Make it faster next month

  • Keep your questions from this month in a note and paste them in next month.
  • Ask the same questions in the same order, so reports stay comparable.
  • Use exact dates if you need a period that isn't a calendar month, for example "from 2026-10-01 to 2026-10-31".