# S2: Source notes 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.
