# AI marketing reporting assignment

Synthetic training exercise from LearnCowork. These invented campaign records
are not client data, measured customer outcomes, or evidence of time saved.

## Approved input

Use only synthetic-campaigns.csv. All four rows cover October 1 through 7, 2026.
The currency is USD. A lead is a counted inquiry for this exercise, not a sale.
Do not invent revenue, conversion quality, attribution settings or a comparison
period. Ask for missing inputs instead of silently filling gaps.

## Assignment to give your AI tool

Read the attached CSV and make a one-page internal campaign review. First
confirm the reporting period, currency and four unique campaign rows.
Calculate total impressions, clicks, spend and leads. Calculate CTR as
clicks / impressions * 100, CPC as spend / clicks and CPL as spend / leads.
Use total denominators for combined rates, not averages of campaign rates.
Keep full precision in calculations and round only display values.

Produce a campaign table, the combined totals, three evidence-based
observations, questions for the campaign owner and a limitations section.
Separate observations from hypotheses. Do not claim that the lowest CPL
produced the best customers or recommend moving budget without quality data.
Show the formulas, period and source file beside the output.

## Acceptance and review

- Reconcile all four source rows. Check for duplication and missing values.
- Confirm 68,000 impressions, 1,640 clicks, $2,110 spend and 85 leads.
- Recalculate total CTR 2.41%, CPC $1.29 and CPL $24.82.
- Open the actual exported document and inspect its tables and links.
- Test a copied dataset with zero leads. CPL should be unavailable, not zero.
- Do not combine a seven-day report with a ten-day report as equal periods.
- Record the reviewer, corrected values, uncertainties and approved audience.
- Keep this exercise internal until an authorized owner approves sharing.

## Handoff record

Input filename/version:
Period and currency confirmed:
Calculation checks performed:
Corrections:
Missing information:
Reviewer and date:
Approved next action:

Comparison output: marketing-reporting-checked-output.csv.
Live teaching and scope: https://learncowork.net/corporate-ai-training/