SPECIMEN · SYNTHETIC DATA · NOT A CLIENT RESULT
THE $500 SCOPE REVIEW / Meta Ads · Weekly performance
A complete written report: what we found, why it matters, what to change and what still needs approval. Read it all in one PDF.
Read the full PDF report ↗cost per purchase
Handoff status OPEN
A fictional weekly summary labels purchases as 7-day click but selects the 1-day-click denominator for its cost line. The review uses a deliberately recorded calculation log to distinguish a reporting formula error from an unsupported claim about platform attribution.
The PDF explains what is wrong, the figures that support that conclusion, and the actions needed before the report can be accepted. It includes the completed check results and recommendations in one document; the supporting files are optional.
Read the full PDF report ↗REVIEW DISPOSITION / OPEN
6 checks pass · 1 fails · 2 remain open.
The corrected report and dated definitions approval are missing. This specimen does not claim an implemented fix or a signed-off client outcome.
RP-META-WEEK-01 · 2026-10-12 inclusive / 2026-10-19 exclusiveA $500 assessment of one workflow, one primary schema and one representative client, with up to three agreed export formats. Implementation is separately scoped.
The synthetic log names purchases_1day_click as the denominator under a 7-day-click heading.
$40.00 draft vs $30.00 control; $10.00 difference for this label.
Evidence: ME-D02; ME-M22; ME-C03
Recommend using the 7-day-click column consistently with the 60-purchase headline.
Nine disjoint synthetic ad-set rows preserve the original three campaign totals, including both separate purchase views.
The additive totals pass; the documented issue is in the labeled calculation.
Evidence: ME-C01; ME-C02
Retain field-level mappings and show a separate labeled 1-day comparison only if required.
No authorized decision or corrected output has been provided; window values do not establish causal lift.
Acceptance remains unresolved.
Evidence: ME-C07; ME-C08
Obtain the definitions decision and final-output sign-off without changing attribution settings.
The review includes 9 synthetic source rows and 22 explicit source-to-output mappings. Download the CSVs to inspect every row and transformation.
Freeze the fictional period, channel/action/component basis, currency when applicable, and cutoff.
Inspect individually identified synthetic aggregate rows; no personal records.
Trace exact source row IDs and fields through grouped and headline output calculations.
Reproduce the deliberately incorrect draft calculation; this log is invented fixture evidence, not a live diagnosis.
Separate arithmetic passes, reproduced draft failures, and unresolved approval/evidence items.
Review recommendations and leave handoff acceptance unresolved until an authorized approver and corrected outputs exist.
| ID | Source rows / field | Output | Rule / basis |
|---|---|---|---|
| ME-M01 | ME-A01;ME-A02;ME-A03spend_usd | campaigns.Prospecting A.spend_usd | SUM(spend_usd)Same period, USD where applicable; separate window columns |
| ME-M02 | ME-A01;ME-A02;ME-A03impressions | campaigns.Prospecting A.impressions | SUM(impressions)Same period, USD where applicable; separate window columns |
| ME-M03 | ME-A01;ME-A02;ME-A03link_clicks | campaigns.Prospecting A.link_clicks | SUM(link_clicks)Same period, USD where applicable; separate window columns |
| ME-M04 | ME-A01;ME-A02;ME-A03purchases_7day_click | campaigns.Prospecting A.purchases_7day_click | SUM(purchases_7day_click)Same period, USD where applicable; separate window columns |
| ME-M05 | ME-A01;ME-A02;ME-A03purchases_1day_click | campaigns.Prospecting A.purchases_1day_click | SUM(purchases_1day_click)Same period, USD where applicable; separate window columns |
| ME-M06 | ME-A04;ME-A05;ME-A06spend_usd | campaigns.Prospecting B.spend_usd | SUM(spend_usd)Same period, USD where applicable; separate window columns |
Each check retains an evidence reference, a way to reproduce it and the next action. A calculation pass does not close an approval gap.
Evidence
source.csv ME-A01..ME-A09; ME-M01..15
Reproduce
Sum three ad sets each: A 900/45000/900/36/28; B 600/30000/450/18/14; C 300/15000/150/6/3 (spend/impressions/clicks/7d/1d).
Next action
Retain unique ad-set grain and campaign mapping.
Evidence
ME-M16..20
Reproduce
Sum all nine rows: $1800 spend, 90000 impressions, 1500 link clicks, 60 7-day-click purchases, 45 1-day-click purchases.
Next action
Compare each required output to these controls.
Evidence
ME-D02; ME-M22
Reproduce
The 7-day heading selects purchases_1day_click=45; 1800/45=$40.00.
Next action
Recommend selecting purchases_7day_click for this labeled output.
Evidence
ME-M21
Reproduce
1800/60=$30.00; arithmetic difference to draft=$10.00.
Next action
Retain the exact purchase-action and window labels beside the cost.
Evidence
source.csv window columns; ME-D01
Reproduce
Read 60 and 45 as alternative views; no output mapping sums them as 105.
Next action
Label any 1-day comparison explicitly; do not present combined results.
Evidence
metadata.json; source.csv reporting_clock
Reproduce
All rows specify impression_time; period/account time zone and fixed cutoff recorded.
Next action
Carry the same clock and cutoff into final definitions.
Evidence
metadata.json; acceptance-record.txt
Reproduce
Named approver/date absent for fixture_purchase, 7-day click, clock and cutoff.
Next action
Obtain written definitions approval; do not assume account defaults.
Evidence
acceptance-record.txt
Reproduce
No regenerated report or export supplied.
Next action
Owner to supply both, verify $1800/60/$30 and retain dated approval.
Evidence
draft-calculation-log.csv ME-D02
Reproduce
Denominator field selection is explicitly recorded; no account, tracking or attribution-setting fault is inferred.
Next action
Keep the proposed correction at the report formula layer.
Delivery for an agreed $500 review is three business days after written scope, payment and complete agreed inputs. It is an assessment, not an implementation or a guarantee of report accuracy.
The findings, supporting figures, check results, recommendations and acceptance decision are explained together in one PDF. You do not need to open a spreadsheet or recreate a calculation.
Read the full report · PDF ↗All report data and draft logs are synthetic, not a client result.
These files preserve the detailed evidence trail. Everything needed to understand the review is already in the PDF.
FROM A QUESTIONABLE NUMBER TO A REPRODUCIBLE DECISION.
Get a written fit answer for the $500 review. Implementation is agreed separately; this review is included once in a $2,500 sprint when both scopes fit.
Ask about your report ↗Browse all case files →