For full-service agency account directors

Prepare quarterly business reviews for every client with your AI agent

Twenty retainers means twenty quarterly reviews, each needing one honest story across SEO, paid and the website. Prep them with your agent, and spot which clients have been slipping for three months before the review.

Continue with Google

Free for 2 sites · No credit card

Or have your agent set it up

Set up DuckDive for my website. Follow https://analytics.duckdive.ai/agents.md

Updated 18 min read

The short answer

Start three weeks before each review. With DuckDive connected, ask your agent to compare the last 90 days against the 90 before across GA4, Search Console and Google Ads, then shape the result into three talking points: what moved, why, and what happens next. Separately, screen the whole roster for clients whose conversions fell three months in a row.

  • Pull numbers a few days after the quarter closes. All three Google tools keep filling in late data for a while.
  • One weak month proves little. A decline that repeats three times deserves a call before the review.
  • DuckDive builds no slides. Your agent's tables and talking points go into your own deck.

Three weeks before the review: the prep calendar

A good QBR is mostly decided before anyone opens the slide template. This calendar counts back from the meeting and assumes each retainer's Google data is linked in DuckDive and your team asks questions through an AI agent such as Claude connected to GA4, Search Console and Ads.

What DuckDive adds to the prep: when you link a client, it imports that client's GA4, Search Console, Google Ads and Local Services Ads history and keeps it, with Yext and Local Falcon for the clients that use them. Your agent reads the stored copy through DuckDive's MCP server, one client site per tool call. Nobody on the account team exports a CSV or waits for a report to render.

Why the first pull waits until day three

Pull on the first morning and you would be presenting numbers Google has not finished counting. The Analytics Help article on data freshness tells you to allow up to two days of processing on a GA4 property and warns that figures shift while it runs. The Ads team writes the same two-day caveat into its conversion tracking guide and asks advertisers to wait it out before comparing final results. Search Console's Performance report help flags its most recent days as preliminary. Three products, one rule for the account team: nothing from the quarter's closing week counts as final until the third morning after it ends.

Google Ads has a second quirk: its main conversion columns credit the click date, not the day the lead arrived. A prospect who clicked on the quarter's last day and called a week later lands in the old quarter, so a finished quarter's count keeps rising for days. Re-run the headline numbers just before the meeting.

Who does what in each week of QBR prep
WhenYour agent pullsTeam decides
Quarter end, plus 3 daysImport status for every retainer due a reviewWhich clients review this cycle, and in what order
21 days outThe renewal-risk screen and each client's quarter comparisonWhich reviews are routine and which become save meetings
14 days outThe why: landing pages, channels, search pagesSEO, paid and web leads each own one next step
7 days outTables and talking points, each figure labelledThe deck, built in your template, one figure checked by hand
2 days outThe headline numbers again, for late conversionsThe one ask you will make in the room

Building the quarter's story from six sources

A full-service retainer throws off a pile of numbers from different teams. Clients want what moved, why, and what you will do about it. Each of DuckDive's six sources answers a different part.

Which source answers which part of a client's quarter
SourceWhat movedWhy it moved
Google Analytics 4Sessions, key events, conversion rateWhich channels and landing pages changed
Search ConsoleOrganic clicks and impressionsPages gaining or losing clicks, average position
Google AdsSpend and cost per conversionAccount level only, no campaign split
Local Services AdsLeads and charged leadsSpend against leads for service clients
YextListing searches, views, actionsReview counts and average rating by publisher
Local FalconAverage map rank per keywordTop-3 share across the scan grid

For most retainers the first three rows carry the review; add the local rows for clients with a storefront or service area. DuckDive reads the Ads account summary, so "which campaign" stays a question for your paid specialist. The Google Ads integration page lists exactly what comes through.

How a quarter is compared when the tools take fixed ranges

DuckDive's data tools only accept preset windows (a week, two weeks, 30 days, 90 days, half a year or a full year), and none of them is called "Q3". For GA4 and Search Console the agent asks for the last 6 months, which come back day by day, and splits them into the latest 90 days and the 90 before. For Google Ads it asks for the last 90 days and the last 6 months, then subtracts one from the other.

Six months runs a few days longer than two 90-day blocks, so a subtracted block is slightly long. Ratios like cost per conversion barely notice; raw totals do. Because GA4 returns daily rows, the agent can also cut an exact calendar quarter when a client thinks in quarters.

Key event
The label GA4 now gives to the events a property owner marks as business-critical, such as a quote request; Google's help page explains how they replaced conversions. DuckDive's tools still say conversions.
Cost per conversion
Google Ads' "Cost / conv.": total cost divided by the Conversions column, which Google says counts primary conversion actions, credited to the click date.
Clicks and average position
In Search Console's definition, a click is each time someone clicked through to the site from Google Search results, which is not the same as a GA4 session. Average position is the average rank of the site's topmost result, so lower is better.
Three straight declines
This page's renewal screen: each of the last three complete months had fewer GA4 conversions than the month before it.

Two counts, not one

GA4 key events and Google Ads conversions are different counts with different rules. Ads credits the click date and, per Google's conversion tracking guide, can include modeled conversions. Never add them together on a slide, and never present the gap between them as lost leads.

Worked example: Thornbury Kitchens' quarter in three talking points

A kitchen remodeler on a full retainer: SEO, paid search and the website. The account director wants a first draft before the channel leads weigh in.

Ask your agent
Compare the last 90 days with the 90 days before for Thornbury Kitchens across GA4 sessions and conversions, Search Console clicks and Google Ads cost per conversion, then give me three talking points for the client.

Tools it calls list_websites get_ga4_overview get_search_console_summary get_google_ads_summary get_search_console_pages get_ga4_landing_pages

EXAMPLE DATAFictional business: Thornbury Kitchens

Last 90 days against the 90 before for Thornbury Kitchens: GA4 sessions and conversions, search clicks, Ads cost per conversion, and three talking points.

  1. list_websitesfinds the Thornbury Kitchens site under its client
  2. get_ga4_overview6 months of daily sessions and conversions, split into two 90-day blocks
  3. get_search_console_summary6 months of clicks, split the same way
  4. get_google_ads_summarylast 90 days and last 6 months, the earlier block worked out by subtraction
  5. get_search_console_pagestop 100 pages over 90 days and over 6 months; for pages on both lists, the earlier block is the 6-month clicks minus the 90-day clicks, compared per day
  6. get_ga4_landing_pageslanding pages for the same two ranges, worked out the same way, to see which pages the extra sessions entered on

Traffic grew faster than enquiries this quarter, and paid search got more expensive per lead.

MetricPrior 90 daysLast 90 daysChange
GA4 sessions18,26521,190+16%
GA4 conversions307334+9%
Search clicks9,61511,890+24%
Ads cost per conversion$86.40$97.10+12%

1. Organic search carried the quarter. Search clicks rose 24%. Among pages on both top-100 lists, two took most of the gain: the cabinet refacing guide and the island ideas gallery.

2. More visitors, slightly fewer converting. Conversion rate slipped from 1.68% to 1.58%. GA4's landing page list shows most of the extra sessions starting on those two inspiration pages, which convert far less than the service pages. Next quarter: add a quote prompt to both gallery pages.

3. Each paid lead cost more. Cost per conversion rose from $86.40 to $97.10. The Ads summary can't say which campaign drove it, so your paid lead should check the campaigns before the meeting.

Note: every block worked out by subtraction runs two or three days longer than 90. That leaves a per-conversion cost untouched, and the page-level changes above are compared per day for the same reason.

GA4 Search Console Google Ads

Read it as a draft. Talking point two is the agent joining dots; your web lead may know the quote form broke in August, which is why the 14-day step exists. If a figure looks off, the guide on checking your AI agent's marketing numbers shows how to confirm it against the source.

Ask your agent
For Thornbury Kitchens, split GA4 conversions by channel for the last 90 days and the 90 before. Which channel added the most, which lost the most, and does that match the search click change?

Tools it calls get_ga4_channels get_search_console_summary

Draft next quarter's talking points from your own retainers

Link one client free and ask for its 90-day comparison across Analytics, Search Console and Ads before your next review.

Continue with Google

Free for 2 sites · No credit card

Screening the roster for renewal risk

Clients rarely leave over one bad month. They leave after a drift nobody named. The screen below looks for that stretch: GA4 conversions lower than the month before, three months running.

Why three, and not "any month down 20%"? A single month swings on holidays, weather, a sales event or a tracking hiccup. Persistence filters most of that out. Still, it is a filter, not a verdict. If each month were a coin toss, three drops in a row would come up one time in eight, so on a 24-client roster about three clients could land on the list by chance alone. Treat the list as "talk to the account team", not "call the client".

Ask your agent
Across all clients, which ones had fewer GA4 conversions in each of the last three months than in the month before?

Tools it calls list_websites get_ga4_overview

The agent lists every client site, reads 6 months of daily GA4 data for each, and groups the days into calendar months. Give it three rules up front:

  • Complete months only. Mid-November, the current month is half empty and always looks like a drop.
  • Per day when months differ in length. February against March is 28 days against 31.
  • A floor on size. A client sliding from 9 conversions to 8 to 7 to 6 is noise at that volume. Skip clients under a level you set.

One thing the screen cannot do: check whether the same months dipped last year. The agent's longest window is 12 months, and the same months a year earlier sit just outside it. Ask the account lead, who usually knows a client's seasons by heart.

Before a flagged client becomes a save meeting

  • Key events unchanged? Ask whoever manages the GA4 property whether a key event was added, removed or edited during the period.
  • Site unchanged? A redesign or new form tool can break tracking while enquiries carry on.
  • Imports current? A source that stopped importing looks like a collapse. Check sync status first.
  • Quality, not just count? Fewer but better leads is a different conversation. Ask the client's sales contact.
  • Channel located? Split conversions by channel so the save plan names the team that owns the fix.
  • Season checked with the account lead? Some clients dip every autumn or every summer, and the agent cannot see the same months a year ago.

Worked example: three clients whose conversions fell three months running

A 22-retainer agency runs the screen in mid-November, three weeks before its December reviews. The last three complete months are August, September and October, each compared with the month before.

EXAMPLE DATAFictional businesses: Cotterell Solar, Kilnworth Ceramics Studio, Pellingham Physio

Which clients had fewer GA4 conversions in each of the last three months than in the month before? Complete months only.

  1. list_websitesfinds all 22 client sites
  2. get_ga4_overview6 months of daily conversions for each site, 22 calls, grouped into July to October
  3. get_ga4_channelschannel split for the last 90 days and the last 6 months for the 3 flagged sites, the earlier block by subtraction, so the change by channel shows

3 of your 22 clients had three straight monthly declines. Two more fell in two of the three months and are not on this list. Three flags on 22 clients is about what chance alone would produce, so treat these as questions for the account leads, not a trend.

ClientConversions, Jul to OctChange
Cotterell Solar64, 57, 49, 41-36%
Kilnworth Ceramics Studio38, 35, 31, 27-29%
Pellingham Physio112, 108, 103, 97-13%

Cotterell Solar has the steepest slide, and comparing its last 90 days with the block before puts almost all of the loss in paid search. Check with the account lead whether it softens like this every autumn; I can't reach last year's August to October.

Kilnworth Ceramics Studio lost organic conversions while paid held steady. Its volume is small, so confirm nothing changed on the booking form before treating this as a trend.

Pellingham Physio is the quietest decline but the most consistent. October is still lower per day than September, so the extra day in October does not explain it.

GA4

Pellingham Physio is the easiest to miss: no single month looks bad on its own. So the account director asks which pages carry its conversions, and whether search still feeds them:

Ask your agent
List the five landing pages that drove the most conversions for Pellingham Physio in the last 90 days and say whether each one's search clicks grew.

Tools it calls get_ga4_landing_pages get_search_console_pages

EXAMPLE DATAPellingham Physio: top converting landing pages over the last 90 days. The click change compares each page's last 90 days of search clicks, per day, with the earlier block (6 months minus 90 days), for pages on both top-100 lists
Landing pageConversionsSearch clicks, change
/book-online128+4%
/sports-injury-clinic61-18%
/back-pain-treatment44-27%
/physio-for-runners29+11%
/prices22-3%

Now the worry has an owner. The booking page kept its search traffic, so the website is not the first suspect; two treatment pages lost a fifth or more of their clicks, so the SEO lead takes the "what next" slide. The agent matched pages across the two tools by URL path; confirm the match in Search Console before the slide goes out. To see whether Pellingham's rate is low against the rest of your book, benchmark conversion rates across your clients.

Where the slides still get made

DuckDive does not produce slides, PDFs or white-label reports. It gives your agent the numbers; the agent gives you text and tables; your team puts them into the agency's own deck, in the agency's own design. For most full-service shops that's the right split. The deck is where your brand and your judgment live.

To make the hand-off quick, ask for output that drops straight onto a slide:

Ask your agent
Rewrite the Thornbury Kitchens comparison as one slide: a four-row table, three talking points under 20 words each, and a footnote naming the date window and Google source for every figure.

Tools it calls get_ga4_overview get_search_console_summary get_google_ads_summary

The footnote earns its place when the client's marketing manager opens GA4 and sees a different number: it shows which window and which tool you used.

QBR formats DuckDive will not carry for you

  • You send branded reports on a schedule. DuckDive's scheduled emails go only to your own address. A white-label tool fits better; see the AgencyAnalytics comparison for a fair look.
  • Social or CRM numbers lead your QBRs. DuckDive holds six Google and local sources, nothing else.
  • Your paid story lives at campaign level. That detail still comes from Google Ads itself.
  • You need year-on-year by quarter. The agent reads up to 12 months back, so "this Q4 against last Q4" is out of reach today.

Which DuckDive role each person on the account team needs

An agency account in DuckDive holds clients, and each client holds its website or websites. Three roles exist: Agency Admin, Client Admin, and team members who can read but not change anything. Setup actions such as adding a site or linking a source need an admin, on an agent connection that was allowed to take actions.

A starting point for giving each person the least access they need
PersonDuckDive roleUsed for
Account directorAgency AdminRuns the roster screen, adds new retainers
Operations or onboarding leadAgency AdminLinks sources when a client signs
SEO leadTeam member, read onlySearch pages and clicks for the why
Paid specialistTeam member, read onlyCost per conversion before the campaign deep dive
Web developerTeam member, read onlyLanding page conversion rates after site changes
Client's marketing leadClient Admin, to confirmDepends on what a client user can see

Ask DuckDive what a client login shows before you promise anyone a view. Whatever the role, the assistant sees only the websites that person's account can see.

Linking every retainer before the quarter closes

Do this in a quiet week before quarter end, so imports finish well ahead of the first pull.

  1. Start from the inbox clients already granted access to

    Select Continue with Google using the account that already has access to your clients' GA4, Search Console and Ads. If a property is missing, the client adds that login as a user in Google first.

  2. Add each client, then its website

    Websites sit under clients. Every retainer's site gets one GA4 property and one Search Console site, and the Ads and Local Services Ads accounts too when that client buys them. History begins importing the moment a source is linked; a few minutes is typical, and years of data take a while longer. Listings (Yext) and map-grid rankings (Local Falcon) are separate subscriptions, so skip them for any retainer whose contract never included that work.

  3. Or hand the adding to your agent

    As an admin, paste the setup prompt, keep "Also allow actions" ticked when you approve the connection, and click Continue with Google once. The agent adds the site and links the sources it can match, and asks before moving a source that already belongs to another website.

    Give your agent this prompt
    Set up DuckDive for my website. Follow https://analytics.duckdive.ai/agents.md
  4. Connect the assistant your team already uses

    Each person on the account team adds https://api.duckdive.ai/mcp to their own assistant and signs in to DuckDive with Google, so no shared key gets passed around the agency or rotated when someone leaves. Audit the seats before rollout day. A strategist on a Claude subscription is covered at whatever tier they pay for. A planner using a personal ChatGPT Plus account is not, because DuckDive's AI connector guide names ChatGPT Business or Enterprise as the minimum, so move that person into the agency's workspace first. Each app tucks the option into its settings under a label like connectors or custom MCP servers, and those labels get renamed. Step-by-step: Claude, ChatGPT.

  5. Check the reviewing clients are ready

    Before the 21-day pull, confirm every source for the clients you review this cycle shows ready. If one looks stale, an admin can ask DuckDive to pull up to 30 recent days again; a given site accepts that request once per quarter hour.

    Ask your agent
    I review these eight clients in December: [paste names]. Check each one's GA4, Search Console and Google Ads imports and tell me which aren't ready or look out of date.

    Tools it calls search get_sync_status

Is a Google update your bigger worry than the quarterly cycle? See core update triage for SEO agencies. The agencies overview covers paid and local clients more broadly.

Questions account directors raise

Can my agent compare this quarter with the same quarter last year?

Not yet, so build the deck without that slide or source it elsewhere. Every agent question stops at a 12-month window, which means the nearest thing to a seasonal read is this quarter set against the one just before it (last 90 days against the prior 90). Older months are not thrown away: when you link a client, DuckDive keeps up to two years of what it imports. No agent tool reads that far back today, though, so open the client's GA4 property and set last year's quarter in its date picker by hand.

Does DuckDive make the QBR deck or a branded PDF?

No. There is no slide, PDF or white-label export. Your agent returns tables and talking points in the chat, and your team pastes them into the agency's own template. If clients expect a branded report on a schedule, a reporting tool built for that is the better fit.

Why flag three straight monthly declines instead of one big drop?

A single month moves for many harmless reasons: holidays, weather, a promotion ending, a short month. A decline that repeats three times is less likely to be one of those. It still is not proof, so check tracking, season and lead quality before you treat a client as at risk.

Why doesn't the conversion count match the client's Google Ads account?

They measure different things. GA4 counts key events on the day they happen. Google Ads counts conversions from its own conversion actions and credits them to the date of the ad click. Report each in its own row, and footnote which tool every figure came from.

Should Local Services Ads leads sit on the same slide as GA4 conversions?

Beside them, never summed with them. DuckDive reads leads, charged leads and spend from the client's Local Services Ads account, and Google counts those leads on its own platform, not in the client's GA4 property. The two tallies can overlap or miss each other, so give LSA its own row with spend per charged lead and let the client read both.

How do I present a quarter where the client cut its ad budget?

Lead with rates, not totals. Fewer paid clicks and conversions are the expected result of a smaller budget, so put cost per conversion next to the GA4 conversions from channels other than paid search. Ask the agent for the channel split in both 90-day blocks. If organic and direct held while paid shrank in line with the cut, the slide says the budget changed, not the quality of the work.

Sources

  1. Data freshness, Analytics Help, Google, checked November 16, 2026.
  2. Understand your conversion tracking data, Google Ads Help, Google, checked November 16, 2026.
  3. Performance report (Search results): Overview and basic setup, Google Search Console Help, checked November 16, 2026.
  4. Conversions vs. key events in Google Analytics, Analytics Help, Google, checked November 16, 2026.

Last reviewed . Numbers in EXAMPLE DATA blocks are fictional.

Walk into every QBR with the story ready

Link your retainers once, and next quarter's comparison and renewal screen are a question away.

Free for 2 sites · No credit card · Working in an agent? Let it set DuckDive up