An executive marketing dashboard puts revenue, leads, paid media, search and AI search visibility on one weekly page for leaders. In November 2026 you can schedule it in Data Studio (the new name for Looker Studio), in GA4, or with a Claude scheduled task, but the numbers only hold up if definitions are agreed, the data has finished processing and a person reviews the page before it sends.

TL;DR

An executive marketing dashboard is one page, read in about two minutes: headline numbers, paid media, search, AI search and three ranked priorities. If a number would not change a decision, it does not go on the page.

In November 2026 there are three ways to send it on a schedule: Data Studio (Looker Studio was renamed on 16 April 2026), GA4 scheduled emails, or a Claude scheduled task that reads your tools and writes the summary.

Time it to the data. GA4 usually has yesterday ready in Reports by about 3:30pm in the property's time zone, and Google warns events can take up to 72 hours. A Monday 9am report should cover the week to Saturday.

Trust comes from agreed definitions, a source and date range under every block, a few weeks of reconciling against the source tools, and a person who reads the page before leadership does.

You open the leadership meeting and three people have three numbers for last week's leads. One took it from GA4, one from the CRM, one from the Google Ads screen. Nobody is wrong, exactly. The data was never the problem. The assembly and the definitions were.

An executive marketing dashboard that builds itself fixes the assembly. It cannot fix the definitions or broken tracking, so this guide covers both. If you would rather have the measurement and the report set up for you, that is what my analytics and tracking service does.

What is an executive marketing dashboard, and what goes on it?

Short answer: It is a one-page weekly view of marketing for people who decide budgets: five blocks covering headline results, paid media, search, AI search visibility and three ranked priorities, each compared with the week before. It is a summary, not a list of every metric.

The request I hear most about reports is some version of "can it show a summary, not a list?" Leaders want the state of the business in two minutes, the change since last week, and a benchmark behind every label so that "good" means something.

BlockWhat goes in itUsual source
1. Headline numbersRevenue, leads, ad spend, cost per lead, week on weekCRM or shop, GA4, ad platforms
2. Paid mediaSpend and cost per lead by platform, waste caughtGoogle Ads, Meta Ads
3. SearchOrganic clicks, pages that moved, fixes shippedSearch Console, GA4
4. AI searchWhere the brand is named in AI answersA fixed weekly prompt check
5. Three prioritiesRanked moves for this week, each with a reasonWritten, then reviewed by a person
Illustrative animation of the five blocks of a one-page executive marketing dashboard
Illustrative. Five blocks, each with its source and date range in small text underneath.

The last block is the one that changes behaviour. Numbers without a recommendation create more meetings. Keep the ad platform detail out of this page: if a leader wants it, link to the full paid media report, such as the one in my guide to a single Google Ads and Meta report.

For block 4, there is no standard metric yet. Run the same set of buyer questions through the main AI assistants each week and record whether you are named. My AI citation audit explains how to set that list up.

What changed in the reporting tools by November 2026?

Short answer: Looker Studio is called Data Studio again (16 April 2026), GA4 added an AI assistant called Ask Advisor plus AI summaries on its homepage, Google Ads added prompt-built dashboards in beta, and Claude scheduled tasks now run in the cloud even when your computer is off.

If your team still searches for "Looker Studio", that is fine: Google says existing reports carried over. The Data Studio release notes put it plainly: "We've rebranded Looker Studio as Data Studio." The paid edition is now Data Studio Pro, and the free edition remains no cost, according to Google's announcement.

Data Studio release notes entry dated 16 April 2026 saying Looker Studio has been rebranded as Data Studio
Data Studio release notes, 16 April 2026. Screenshot of the public page, 17 November 2026.
ToolWhat changedWhen
Data StudioNew name for Looker Studio; Pro edition renamed too16 Apr 2026
Data StudioConversational Analytics generally available30 Jul 2026
Data Studio ProHourly schedules and alerts5 Dec 2025
GA4Ask Advisor (beta, English-language properties)Google Marketing Live 2026
GA4AI summary at the top of the homepage, opt-in email updates10 Aug 2026
Google AdsDashboards from text prompts (beta); GA4 "coming soon"10 Aug 2026
ClaudeCowork scheduled tasks run remotelyHelp page, Nov 2026

Two cautions. The Google Ads dashboards and the GA4 homepage summaries are, in Google's own post, "currently available in beta for English language accounts". And GA4's Ask Advisor help page says answers use only data from that one property, so it cannot see your CRM or your Meta spend. Neither replaces a cross-tool executive page.

Which tool should build and send the report?

Short answer: Use Data Studio when leaders want a live dashboard they can click, GA4 scheduled emails when a single GA4 report is enough, and a Claude scheduled task when the page needs data from several tools plus a written summary and priorities. Many teams end up using two of them.

NeedData StudioGA4 emailClaude task
Live, clickable dashboardYesNoNo
Written summary and prioritiesNot its jobNoYes
Data from many toolsYes, via connectorsGA4 onlyYes, via connectors
Fastest scheduleDaily (hourly on Pro)DailyHourly
Recipients per scheduleUp to 50Up to 50You choose the destination
FormatPDF plus linkPDF or CSVDocument or message

Data Studio's free edition allows one schedule per report, at most once a day, sends a PDF with a link back to the report, and caps recipients. Since March 2025 it also limits how many people you can email per day and per month.

Email quotaPersonal accountWorkspacePro
Per day200500Unlimited
Per month8003,000Unlimited
Data Studio documentation table of scheduled email limits by account type, with notes on quotas
Data Studio documentation, "Schedule automatic report delivery". If you exceed a quota, further emails are not sent and you cannot check progress against it.

GA4 can also email a report. Only administrators can schedule one, each property can have up to 50, and each schedule stays active for 1 to 12 months, as Google's Schedule reports page sets out. That suits a fixed traffic or key event report, not a cross-tool page.

Google Analytics Help page on scheduling reports showing the Schedule Email menu and the field table
Google Analytics Help, "[GA4] Schedule reports". Note the Choose date row: events can take up to 72 hours to process.

The Claude route is a Cowork scheduled task: you describe the job once, choose hourly, daily, weekly or weekdays, and it runs with your connectors, skills and plugins. Developers can do the same with Claude Code cloud scheduled tasks, which are still a research preview. My comparison of Looker Studio alternatives goes deeper on when an AI assistant can replace the dashboard build.

Claude Help Center section on what Cowork scheduled tasks can do, listing weekly reports and explaining they run remotely
Claude Help Center, "Schedule recurring tasks in Claude Cowork". Weekly reports are one of the listed uses.

How does the report assemble itself each week?

Short answer: Five layers, built once: read-only connections to each data source, a written list of definitions, checks that run before any sentence is written, a prompt that drafts the page, and a schedule that delivers a draft for a person to approve before it goes to leadership.

Illustrative animation of the weekly report pipeline from sources to pull, check, draft, review and send
Illustrative. The review step is the one teams try to skip and should not.
  1. Connections. Give the assistant read access only. For GA4, Google publishes an open-source Google Analytics MCP server; its write tools only work if you pass an extra flag. Google's Google Ads MCP server is read and partial write (assets and labels), and can be locked to read-only. Use exports where no connector exists.
  2. Definitions. One file that says what a lead, a conversion and revenue mean, and which tool owns each number.
  3. Checks. Is every day present? Do totals match the source tool? Did leads in GA4 and the CRM drift apart?
  4. Prompt. One prompt per page, fixed format, compared with the previous week. An example is below.
  5. Schedule and delivery. Draft first, approve, then send to the place leaders already read: email, a shared document or a chat channel.

This weekly prompt is a starting point for a Claude scheduled task. Replace the square brackets with your own values.

You are writing the weekly executive marketing report for [company].
Reporting week: Monday to Saturday last week, compared with the same six days the week before.
(Sunday is left out because Google Analytics usually finishes processing a day by mid afternoon the next day.)

Data you can use (read-only): Google Analytics 4, Google Ads, Meta Ads export in reports/meta/, CRM leads export in reports/crm/.
Definitions are in definitions.md. Use them exactly. If a number cannot be matched to a definition, leave it out and say so.

Before writing:
1. Check every source has data for every day in the week. If a day is missing, stop and write "Data incomplete: [source], [day]" at the top.
2. Compare leads in GA4 with leads in the CRM. If they differ by more than [x]%, flag it in one line.

Write one page with five blocks:
1. Headline numbers: revenue, leads, ad spend, cost per lead. This week, last week, change.
2. Paid media: spend and cost per lead by platform, plus anything that spent with no leads.
3. Search: organic clicks and the pages that gained or lost most.
4. AI search: the result of the weekly prompt check in ai-prompts.md.
5. Three priorities for this week, ranked, each with one reason and the number behind it.

Under each block, write the source and date range in small text.
Start with three lines: where we are, what we are doing, what is next.
Do not recommend budget changes. Do not send anything. Save the draft to reports/weekly/[date].md for review.

From the official Google Analytics channel, July 2025. A product demo of asking an assistant questions about GA4 data; it does not sell a paid product.

When is last week's data actually final?

Short answer: Not on Monday morning. For a standard GA4 property, yesterday's daily data is typically ready in Reports by about 3:30pm in the property's time zone, some events arrive up to 7 days late, and attribution can shift for up to 12 days. Report the week to Saturday, or send on Tuesday.

Google's data freshness page says "Data processing can take 24-48 hours. During that time, data in your reports may change." It lists typical times for the previous day, which the chart below draws.

Timeline chart: GA4 daily collection stops at midnight, Explore ready about 11:30am, BigQuery events about noon, Reports about 3:30pm
Typical times from Google Analytics Help, "Data freshness", read 17 November 2026. Google says these are not a guarantee.
LayerTypical delayWhat it means for Monday
GA4 realtimeA few minutesToo thin for a weekly page
GA4 standard intraday2 to 6 hoursChannels may be missing
GA4 dailyAbout 12 hoursUse this; Sunday not ready at 9am
Late eventsUp to 7 daysSmall restatements are normal
Data Studio cacheUp to 12 hoursRefresh before you send
Google Analytics Help table of data freshness intervals for standard and 360 properties
Google Analytics Help, "Data freshness". Standard properties: intraday 2 to 6 hours, daily about 12 hours.

Data Studio adds its own delay. Its Google Analytics data sources refresh every 12 hours by default, and reports on the GA4 connector are subject to Google Analytics Data API quotas: 200,000 core tokens per property per day on a standard property. A report many people open at 9am on Monday can hit them, which is one more reason to send a PDF or a written page rather than ask everyone to open a live dashboard at once.

How do you make the numbers trustworthy?

Short answer: Agree definitions in writing, decide which tool owns each number, print the source and date range under every block, run the automated page beside the manual one for a few weeks, and keep a person reviewing the priorities. Fix tracking first, or the page will tell the wrong story with confidence.

  1. Define every metric in writing. "Lead" must mean the same thing every week, in every block.
  2. Pick one owner per number. Revenue from the CRM or shop, not from an ad platform.
  3. Show the source and date range under each block so anyone can trace a figure.
  4. Run it beside the manual report for three or four weeks and explain every difference.
  5. Keep a human review step, especially for the priorities block.
  6. Fix tracking gaps first. My event map guide is where I start.

Expect tools to disagree even when nothing is broken. GA4 reports in the property's time zone and Google Ads in the account's, and Google says different time zones can cause discrepancies. GA4 also credits paid and organic channels by default, while each ad platform credits its own ads. In my work, reconciling tracked conversions against CRM leads is the check that catches most problems.

NumberOwnerWhy
RevenueShop or CRMIt is what the business banks
LeadsCRMIncludes calls and chats tags miss
Ad spendEach ad platformBilling truth
Sessions, key eventsGA4One model across channels
Organic clicksSearch ConsoleGoogle's own count

Can alerts replace part of the weekly report?

Short answer: They can replace the "did anything break?" part. GA4 custom insights email you when a metric crosses a threshold or behaves abnormally, and Data Studio Pro can alert on a chart. The weekly page still does the judging and ranking that alerts cannot.

GA4 lets you create up to 50 custom insights per property, evaluated hourly, daily, weekly or monthly. Hourly checks work only for web data, and you need the Editor or Administrator role. A useful first alert is "key events fell more than [x]% day on day", because a broken form shows up there before anyone reads a report.

Google Analytics Help steps for creating custom insights, including evaluation frequency, threshold and email notifications
Google Analytics Help, "Analytics Insights". Choose "Has anomaly" and GA4 decides what counts as unusual.

Data Studio alerts are a Pro feature, can only email people inside your organisation, and run against the report's default filters. GA4's new homepage summaries can also be sent by email, per Google's August post, but they cover one property only.

AlertWhereBest for
Custom insightGA4, any editionTraffic or key event drops
Chart alertData Studio ProA threshold on a blended chart
Homepage summaryGA4 (beta)What changed since last login
Daily check taskClaude scheduled taskZero leads, spend with no results

From a UK analytics consultancy channel, November 2024. A short walk through setting custom insights and email alerts in GA4; the agency sells analytics services.

What changes for the team once it runs?

Short answer: Time moves from gathering numbers to deciding what to do about them. The Monday morning that went on exports goes on the three priorities, and the meeting starts from one agreed page instead of three versions of the truth.

Start small. Automate the headline block first and check it for a month, then add paid media, search and AI search one at a time. Resist the urge to add every metric.

Agree who owns the report, who reads it and which decisions it should trigger. A dashboard nobody acts on is decoration. I put a short human note on top of every report I send: where we are, what we are doing, what is next. It takes five minutes and it is the part people read.

Uploaded in April 2026 by one of the Google Data Cloud product leads, on a personal channel. A short tour of the renamed Data Studio home page and Conversational Analytics; no paid product beyond Google's own.

What people say on X and Reddit

Short answer: Practitioners agree on two things: the hard part is agreeing definitions before building anything, and AI summaries are arriving inside the platforms but each one only sees its own data. Google's own posts focus on dashboards built from prompts and an assistant that remembers context across tools.

Post or threadWhere, whenTypePoint
Dashboards in Google Ads and AnalyticsGoogle Ads Liaison account on X, 10 Aug 2026VendorVisual reports from simple prompts
Got access to the AI dashboard betaA PPC practitioner on X, 14 Aug 2026First-handOld dashboard still there; testing it
Ask Advisor shared memory, coming soonGoogle Ads on X, 24 Aug 2026VendorGoals carried across Google tools
GA data to LLMs through the MCP serverGoogle Analytics on X, 8 Jan 2026VendorAsk questions beyond standard reports
What do you define before building?r/LookerStudio, Jul 2026First-handDefinitions and one source of truth
AI insights inside the dashboard?r/LookerStudio, Feb 2026Opinion, some vendorNot native in free edition
Does Data Studio Pro actually exist?r/LookerStudio, Jun 2026First-handPro upgrade runs through Cloud billing
Totalling Meta and Google ad metricsr/LookerStudio, Aug 2026First-handBlends drop days one side lacks

The r/LookerStudio thread on definitions is the most useful: the original poster describes one person counting form fills as conversions while another includes calls and bookings. A reply adds that you should decide which platform owns each metric, not only what it means. Another thread, on first dashboards, argues for one page and four numbers before anything else.

Be careful with replies that recommend a specific connector or reporting tool: several in the AI insights thread come from accounts promoting their own product.

Videos worth watching

Short answer: Start with Google's own Google Analytics MCP videos if you plan an AI-written report, then a Data Studio tutorial for the dashboard itself. The rest cover GA4 alerts and Ask Advisor.

VideoChannelDateWhat it covers
Introducing the Google Analytics MCP ServerGoogle Analytics (official)Jul 2025Chat with GA4 data
Google Analytics MCP Setup TutorialGoogle Analytics (official)Sep 2025Step-by-step setup
Intro to Google Cloud Data Studio, April 2026 demoA Google Data Cloud product leadApr 2026The renamed Data Studio
Looker Studio Tutorial (Now 'Data Studio')An analytics training channelMay 2025Build a report end to end
Custom insights and email alerts in GA4A UK analytics consultancyNov 2024GA4 alerts
Analytics Advisor: Chat With Your Google Analytics DataAn analytics training channelNov 2025The GA4 assistant, early look

Where this advice is weak

Short answer: The timings are Google's typical figures, not guarantees; beta features may change or not reach your account; and nothing here has been tested against your data. Treat the setup as a starting design, then check it against your own tools for a month.

  • GA4 processing times vary for large properties and during slowdowns. Google says so on the same page.
  • Ask Advisor, the GA4 homepage summaries and Google Ads dashboards are betas for English-language accounts. Names and limits may change.
  • Claude Code cloud scheduled tasks are a research preview. Cowork task frequencies and plan availability can change.
  • There is no agreed way to measure AI search visibility. A fixed prompt set is a practical proxy, not a standard.
  • I have not tested every connector mentioned here, and third-party connector quality varies.

Want a dashboard leadership actually reads?

Short answer: If the numbers disagree today, start with tracking and definitions, then automate the page. I set up measurement, reconcile GA4, ad platforms and the CRM, and build the weekly report and its checks.

My analytics and tracking service covers the measurement plan, tag fixes, the data sources and the scheduled report. Rates are on the pricing page. For prompt templates and checklists you can use yourself, see the free guides.

Sources

SourceWhat it supportsDate
Data Studio release notesRename, Conversational Analytics, Pro hourly schedules, quotas16 Apr, 30 Jul 2026
Google Cloud blogData Studio and Data Studio Pro editions11 Apr 2026
Data Studio docs: schedulingLimits, 50 recipients, email quotasRead 17 Nov 2026
Data Studio docs: alertsPro only, internal recipientsRead 17 Nov 2026
Data Studio docs: data freshness12 hour default for Google sourcesRead 17 Nov 2026
Data Studio docs: GA connectorSubject to GA Data API quotasRead 17 Nov 2026
GA Data API quotas200,000 tokens per property per dayRead 17 Nov 2026
GA Help: Schedule reportsAdmins, 50 reports, 72 hours, PDF or CSVRead 17 Nov 2026
GA Help: Data freshnessIntervals, prior day timings, late eventsRead 17 Nov 2026
GA Help: Analytics Insights50 custom insights, email alertsRead 17 Nov 2026
GA Help: Ask AdvisorBeta, single property, EnglishRead 17 Nov 2026
GA Help: Attribution settingsTime zone discrepanciesRead 17 Nov 2026
Google blogHomepage summaries, dashboards, benchmarking10 Aug 2026
Google Analytics MCP serverRead tools, write behind a flagRead 17 Nov 2026
Google Ads MCP server docsRead and partial mutateRead 17 Nov 2026
Claude Help CenterCowork scheduled tasksRead 17 Nov 2026
Claude Code docsCloud scheduled tasks, research previewRead 17 Nov 2026
X and RedditPractitioner and vendor viewsJan to Aug 2026, see table above

This article expands on my post on LinkedIn ↗.

FAQ

What should a weekly executive marketing dashboard include?

Five blocks on one page: headline numbers such as revenue, leads, spend and cost per lead; paid media by platform; search; AI search visibility; and three ranked priorities. Each block shows the change from last week and its source and date range.

Is Looker Studio still available?

Yes, under its old name. Google rebranded Looker Studio as Data Studio on 16 April 2026, and the paid edition is now Data Studio Pro. Existing reports carried over, and the free edition still costs nothing.

How do I schedule a report in Data Studio?

Open the report, choose Share, then Schedule delivery, add recipients, pick pages, a start time and how often it repeats. The free edition allows one schedule per report, at most daily, to up to 50 recipients; Data Studio Pro allows up to 200 schedules and hourly delivery.

Can GA4 email a weekly report automatically?

Yes. An administrator opens a report, clicks Share this report, then Schedule Email, and can send it daily, weekly, monthly or quarterly as a PDF or CSV. A property can have up to 50 scheduled reports, each active for up to 12 months.

Can Claude build the weekly marketing report without manual exports?

Yes, if it can reach your data. A Claude Cowork scheduled task runs on a cadence with your connectors, skills and plugins, and can draft the page from GA4, ad platforms and CRM exports. Keep its access read-only and have a person approve the draft before it goes to leadership.

What time should a Monday executive report send?

After the data is ready. GA4 typically has the previous day in Reports by mid afternoon in the property's time zone, so a 9am Monday report should cover the week to Saturday, or send on Tuesday. Refresh any Data Studio data sources first, because they cache for up to 12 hours.

Why do GA4, Google Ads and the CRM show different lead numbers?

They count different things in different ways. GA4 credits paid and organic channels, each ad platform credits its own ads, time zones can differ, and the CRM includes calls and chats that tags miss. Pick one owner per number and reconcile the others against it.

How do I make sure an automated report is accurate?

Write down every definition, show the source and date range under each block, and run the automated report beside the manual one for three or four weeks, explaining every difference. Fix conversion tracking first and keep a human review step.