SYNTHETIC REPORTING EXAMPLE · USD
Synthetic CSV reporting example
All data is fictional and uses invented formats. This is an engineering example, not a customer result, live integration, or evidence of business improvement.
Campaigns: DEMO-ONLY
- Previous: 2026-10-05 to 2026-10-11 inclusive; 7 joined rows.
- Current: 2026-10-12 to 2026-10-18 inclusive; 7 joined rows.
Six illustrative metrics
| Metric / total | Previous | Current | Relative change (%) |
|---|---|---|---|
| Total spend (USD) | 280.00 | 315.00 | 12.50 |
| Impressions | 3500 | 4200 | 20.00 |
| Clicks | 140 | 210 | 50.00 |
| Source-reported leads | 14 | 21 | 50.00 |
| Click-through rate (%) | 4.00 | 5.00 | 25.00 |
| Cost per reported lead (USD) | 20.00 | 15.00 | -25.00 |
Relative change = (current − previous) / previous × 100. N/A means a zero baseline or undefined ratio. Rate changes are relative percentages, not percentage-point differences.
Definitions and formulas
- Total spend (USD):
sum(spend) - Impressions:
sum(impressions) - Clicks:
sum(clicks) - Source-reported leads:
sum(source-reported leads) - Click-through rate (%):
clicks / impressions * 100 - Cost per reported lead (USD):
spend / reported leads
Leads are additive source-reported counts, not unique customers or cross-platform attribution. No inferred or missing values are filled. Ratios and changes are rounded to two decimal places using half-up rounding; JSON preserves exact spend totals as decimal strings.
Sources and validation
Validation passed. Both files have unique, identical date/campaign keys. Every campaign includes every day in both periods.
- performance: performance.csv; 14 data rows. SHA-256:
6a9c76b5738b0d8c7ede67c7e1112f058418b821f4591942fa42df9919f82f25 - leads: leads.csv; 14 data rows. SHA-256:
7db741f9e902411fefe2ec6d15fbcf0c90ab408344fa5ef30b01216c2ac477d4
Limits: UTF-8 CSV; exact headers and cell counts; at most 2 MiB and 10,000 data rows per file; nonnegative integer counts; nonnegative USD amounts with at most two decimal places; valid nonoverlapping inclusive periods. No network calls or external assets.
This validates the file contract, not the truth, attribution, or accounting accuracy of source data. Open this file locally. Use your browser’s Print / Save as PDF for a printable copy; no separate PDF generator is included. Inspect the calculation receipt and source hashes.
Inspect this synthetic example
Use the fictional inputs and calculation receipt to check the report, or follow the Python instructions to reproduce it locally. This published example does not accept uploads.