How do you see, in one place, how every AI-generated headline, image, and video performs across ad platforms and your website? In this module, you will learn to build a working creative performance dashboard in Google Sheets that replaces scattered platform reports with one shared view. By the end, you will build a dashboard tab that combines ad platform and GA4 exports, joins every ad to its creative tags, and lets your team filter results by AI tool, prompt version, creative format, and channel. You will use SUMIFS for headline KPIs, XLOOKUP to join performance data to a creative tag sheet, pivot tables with calculated fields for metrics such as CTR, CPA, and ROAS, and slicers that filter pivot tables and charts with one click. You will also use an AI assistant to draft and debug formulas and verify each one against a hand-checked total. Examples include a library of AI-generated Meta and Google Ads variants, GA4 landing page sessions, and untagged ads that need attention. This module is designed for marketing analysts, marketing operations specialists, and marketing managers who want a self-service view of creative results. You need comfortable spreadsheet skills and a free Google account; no coding or BI tool experience is required, and you do not need any other module first. You will take away a shareable Google Sheets dashboard and a formula library that you can reconnect to your own campaign data.

Why do two people look at the same marketing dashboard and walk away with opposite conclusions about which AI creative is winning? In this module, you will learn to choose and design charts that make creative performance easy to read and hard to misread. By the end, you will redesign a cluttered creative report into a clear dashboard page with a creative leaderboard, a fatigue trend view, and small multiples that compare AI-generated variants fairly. You will use chart selection frameworks, preattentive attributes such as color and position, minimum-volume rules that hide variants with too little data, consistent axes, benchmark lines, and annotation for launches and budget changes. You will also learn to spot misleading patterns such as truncated axes, cumulative totals that hide decline, and leaderboards ranked on tiny samples. Examples include frequency and CTR decay for AI-generated ad images, open-rate trends for AI-written subject lines, and side-by-side views of prompt versions. This module is designed for marketing analysts, marketing managers, creative leads, and anyone who builds or presents performance reports. You need basic familiarity with marketing metrics and charts; no design or coding skills are required, and you do not need any other module first. You will take away a redesigned dashboard page and a visualization style guide that your team can apply to every creative report it publishes.

What happens to your creative decisions when the dashboard silently shows yesterday's numbers, duplicated rows, or a channel that stopped loading? In this module, you will learn to replace manual exports with an automated reporting pipeline that your team can trust every morning. By the end, you will set up a scheduled daily data feed for creative performance and a set of automated quality checks that flag stale, incomplete, or duplicated data before anyone reads the dashboard. You will use marketing data connectors such as Supermetrics or native Google Sheets add-ons, scheduled refreshes, Google BigQuery tables and scheduled queries, freshness, completeness, duplicate, and reconciliation checks, and a pipeline ownership matrix. You will also use an AI assistant to draft SQL and Sheets formulas for the checks and then test them on data with known errors. Examples include daily spend and conversion feeds for AI-generated ads, email platform exports, and GA4 data that arrives late. This module is designed for marketing operations specialists, marketing analysts, and marketing managers who are responsible for keeping reports accurate. You need comfortable spreadsheet skills; SQL templates are provided, no coding experience is required, and you do not need any other module first. You will take away a working automated data feed, a reusable data quality checklist, and a runbook that tells your team who fixes what when a check fails.

How can your team learn that an AI-generated ad has burned out or a campaign has broken within hours, rather than at next week’s review? In this module, you will learn to set alert limits that separate real problems from normal day-to-day noise, so the right person is warned only when something truly needs attention. By the end, you will build an alert rulebook and a working control chart in Google Sheets that flags creative fatigue, sudden CPA spikes and delivery drops for AI-generated campaigns. You will use static thresholds, rolling baselines, statistical process control charts with three-sigma limits, forecast bands and GA4 custom insights. You will also learn to prevent alert fatigue with severity levels, minimum-volume conditions, cooldown periods and clear escalation paths. Examples include CTR decay on AI-generated image ads, a broken landing page after a generated copy update, and overspend on a newly launched AI variant. This module is designed for performance marketers, marketing analysts and marketing operations specialists who manage always-on campaigns. You need basic familiarity with CTR, CPA and spend metrics and comfortable spreadsheet skills; no coding is required, and you do not need any other module first. You will take away a tested control chart template, a CPA spike rule and an alert rulebook that keeps your team informed without flooding its inbox.

How do you make sure that your dashboard actually changes the next round of AI creative instead of becoming another tab nobody opens? In this module, you will learn to run a weekly reporting and creative review routine that turns dashboard data into concrete creative changes. By the end, you will produce an AI-assisted weekly performance summary, a creative brief for the next round of AI-generated variants, and lead a review meeting that ends with agreed owners and deadlines. You will use Claude to draft report narratives, along with a fact-checking routine that verifies every number, the what, so what, now what insight format, a creative brief and prompt update template, and a review meeting agenda. You will also set basic dashboard governance, including access, a change log, and adoption tracking. Examples include weekly reviews for AI-generated paid social ads, email subject line programs, and landing page copy refreshes. This module is designed for marketing managers, creative leads, marketing analysts, and growth marketers who coordinate work between data and creative teams. You need basic familiarity with marketing metrics and a free AI assistant account; no coding is required, and you do not need any other module first. You will take away a reusable weekly report template, a creative brief workflow, and the confidence to lead review meetings that keep AI creative improving.