SPECIMEN · SYNTHETIC DATA · NOT A CLIENT RESULT
THE $500 SCOPE REVIEW / GA4 · Monthly SEO
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 ↗organic sessions
Handoff status OPEN
A fictional monthly SEO handoff displays 4,400 organic sessions. A retained synthetic transformation log exposes a 400-session Paid Search row in the headline. Review traces the filter, landing-bucket rollups, weighted engagement rate, and unresolved handoff evidence.
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-GA4-SEO-01 · 2026-09-01 inclusive / 2026-10-01 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 fabricated draft log adds GA-P01 to all twelve organic rows. This documented synthetic inclusion reproduces the full 400-session excess.
4,400 vs 4,000 sessions; +10.0% against organic control.
Evidence: GA-D01; GA-P01; GA-M12
Apply the agreed session-channel predicate before rollup; request regenerated report and copy.
The twelve included rows support 2,680 engaged sessions / 4,000 sessions.
67.0% after rounding to one decimal; no paid-row engagement is assumed.
Evidence: GA-C02; GA-C03; GA-C05
Retain numerator, denominator and same-row predicate with the rate definition.
There is no named definitions approver, dated decision, or corrected report/export in this synthetic packet.
A calculation pass cannot close the handoff.
Evidence: GA-C07; GA-C08; acceptance-record.txt
Record the approver/date and compare required outputs before acceptance.
The review includes 14 synthetic source rows and 13 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 |
|---|---|---|---|
| GA-M01 | GA-O01;GA-O02;GA-O03sessions | landing_buckets.Service pages.sessions | SUM(sessions)Organic Search; September only |
| GA-M02 | GA-O01;GA-O02;GA-O03engaged_sessions | landing_buckets.Service pages.engaged_sessions | SUM(engaged_sessions)Organic Search; September only |
| GA-M03 | GA-O04;GA-O05;GA-O06sessions | landing_buckets.Articles.sessions | SUM(sessions)Organic Search; September only |
| GA-M04 | GA-O04;GA-O05;GA-O06engaged_sessions | landing_buckets.Articles.engaged_sessions | SUM(engaged_sessions)Organic Search; September only |
| GA-M05 | GA-O07;GA-O08;GA-O09sessions | landing_buckets.Product pages.sessions | SUM(sessions)Organic Search; September only |
| GA-M06 | GA-O07;GA-O08;GA-O09engaged_sessions | landing_buckets.Product pages.engaged_sessions | SUM(engaged_sessions)Organic Search; September only |
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 GA-O01..GA-O12
Reproduce
Count 12 unique row_id values with INCLUDED_ORGANIC_CONTROL; four buckets x three rows.
Next action
Retain the aggregate grain with the reviewed export.
Evidence
source.csv GA-O01..GA-O12; GA-M01..08
Reproduce
Group sessions/engaged_sessions: Service 1600/1100; Articles 1100/740; Product 800/520; Other 500/320.
Next action
Keep these controls in the corrected output review.
Evidence
GA-M09; GA-M10
Reproduce
Sum only twelve included rows: 4000 sessions, 2680 engaged.
Next action
Compare both values with regenerated outputs.
Evidence
GA-P01 sessions=400; draft-calculation-log.csv GA-D01
Reproduce
Draft SUM(GA-O01..12.sessions,GA-P01.sessions)=4400; difference from organic control=400 (10.0%).
Next action
Recommend filtering Organic Search before aggregation.
Evidence
GA-M11; GA-O01..GA-O12
Reproduce
2680/4000*100=67.0%; do not average segment rates.
Next action
Use same channel and period in both operands.
Evidence
GA-B01; metadata.json
Reproduce
Boundary row starts 2026-10-01; exclude 30 sessions/20 engaged from September and from the draft log.
Next action
Preserve inclusive-start/exclusive-end period metadata.
Evidence
metadata.json definitionsApproval; acceptance-record.txt
Reproduce
No named approver/date supplied; frozen fictional basis alone is not approval.
Next action
Obtain written channel, period and rate-definition approval.
Evidence
acceptance-record.txt
Reproduce
No corrected report or exported copy is supplied; only a recommended patch exists.
Next action
After an authorized correction, compare both outputs to 4000/2680/67.0% and record approval.
Evidence
source.csv GA-P01 engaged_sessions blank
Reproduce
Verify blank is not interpreted as zero or added to the organic rate.
Next action
Leave this field unspecified unless evidence is supplied.
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 →