Make something you can explain

From campaign data to a checked executive brief.

Work through a fictional campaign brief in five steps. Practice briefing an assistant, checking its work and finishing an executive summary.

About 30 minutes · Fictional practice data · No account required

Loading your saved exercise… You can open any step.

Guided campaign exercise

Step 1 of 5

Know the job

Give a marketing lead a brief explaining what happened, what the data supports and what to check next.

You leave with

A checked executive brief, review notes and a repeatable way to work. All inputs are fictional teaching data.

Inspect the source before asking for an answer

The source pack contains four export rows for November 2–8, 2026. Two rows belong to the same campaign. All amounts are USD, and a conversion means a recorded purchase.

Read the source rows and definitions
FICTIONAL PRACTICE SOURCES These records were created for this exercise. They are not Joseph Carroll's results, a client's records, or evidence of a real campaign. S1: campaign-performance.csv The CSV header is line 1. Its four data rows are: Line 2: Search brand — spend 120; impressions 4,000; clicks 320; conversions 24; revenue 1,200. Line 3: Search brand — spend 80; impressions 6,000; clicks 180; conversions 16; revenue 800. Line 4: Social prospecting — spend 600; impressions 80,000; clicks 800; conversions 20; revenue 1,000. Line 5: Email event — spend 200; impressions 10,000; clicks 200; conversions 10; revenue 500. S2: source-notes-and-definitions.md Scope: one fictional garden-supply promotion, November 2–8, 2026, inclusive. All spend and revenue use USD. No earlier period, budget target or forecast is supplied. Grain: each row is an export segment for that period. The two Search brand rows are distinct, non-overlapping segments; combine them. They are not duplicate records. Campaign names match exactly. For this exercise, S1 is the complete four-row file. Counting basis: the fictional reporting owner has normalized all campaigns to the same seven-day click attribution rule, with each recorded purchase counted once across this file. These are stated exercise assumptions, not something the CSV parser can verify. Real channel exports often require reconciliation first. Spend: recorded campaign media or distribution cost. It excludes product cost, fulfillment, staff time and overhead. Impressions: recorded ad or message displays, not unique people. Clicks: recorded clicks, not unique visitors. Conversions: recorded purchases, not leads or unique customers. Revenue: purchase revenue attributed under the stated rule; refund, margin and full cost information are absent. Rates: CTR = clicks / impressions; CPC = spend / clicks; click-based CVR = conversions / clicks; CPA = spend / conversions; ROAS = attributed revenue / spend. Recompute every aggregate ratio from summed inputs. Zero denominators mean unavailable, not zero. Limits: attribution does not establish incremental impact. There is no previous period, experiment, capacity estimate, margin or full cost record. A high observed ROAS does not prove that extra budget will perform similarly. Permission: prepare and review a draft only. Do not change budgets, pause campaigns, publish the brief, or access accounts. A human campaign owner decides whether a proposed investigation or later test is appropriate. Reference claims by file and line or by S2 topic, for example [S1 lines 2–5; S2 Rates]. A second person or agent can check the evidence; their agreement is not certification. Using the KPI workbench: Download campaign-performance.csv from this exercise. In the KPI workbench, use “Load a campaign CSV” to select that file. Its default sample is different practice data. Before using any totals, confirm the status says “Uploaded CSV” and names campaign-performance.csv. Download the calculated report before leaving the tool. Reloading returns to the default sample; check the filename again when you return.

Download campaign-performance.csv from this exercise. In the KPI workbench, use “Load a campaign CSV” to select that file. Its default sample is different practice data. Before using any totals, confirm the status says “Uploaded CSV” and names campaign-performance.csv. Download the calculated report before leaving the tool. Reloading returns to the default sample; check the filename again when you return.

A calculator is also fine. Keep the period, currency and conversion definition together; a fluent explanation cannot validate the arithmetic.

Practice files and definitionsDownload the practice pack

No AI account is required: use the supplied draft in step 3. If you use an assistant, choose an approved tool and account. Work stays draft-only throughout this exercise.