DataStudios Private & confidential
4 Star Electronics × DataStudios

Offline Conversion Tracking — Findings & Recommendation

What you import today, the quality and compliance of what's sent, the reachable uplift from Enhanced Conversions, and the recommended path forward. Read-only analysis on live data — no production writes.
As-of 2026-06-23· Client-approved definition: 60-day window · status 5/11/12 · internal & test excluded
Executive summary

You asked for two things — here's where each stands

Ask 1 · Offline conversions ✓ Built & validated

Get your offline Quote & Order conversions into Google Ads (+ GA4) via the Data Manager API, in n8n — with per-row “which rows did not import” accountability.
  • Clean send built & validated — ~3,500 conversions staged, validateOnly HTTP 200, zero writes.
  • Enhanced Conversions ~doubles reach over gclid alone — quotes +110%, orders +161% (already enabled on your account).
  • Every excluded row is reason-coded — your did-not-import requirement, met per row.
  • Awaiting your go-live approval (Jun 26) to switch from validate to write.

Ask 2 · Reconciliation ✓ Done & explained

Reconcile the website-RFQ numbers across CRM, Google Ads and GA4 — explain why they never match, on a defensible basis.
2,411
CRM website RFQs (30d) — source of truth
2,005
GA4 — ≈ CRM ✓ validates the signal
1,610
Google Ads — −33%, by design
  • The Ads gap is attribution method — modeled & click-dated — not lost conversions.
Reachable ≠ realized. ECL realizes an aggregate ~30–70% of the reachable set, measured at go-live. Everything as-of 2026-06-23 on your approved definition (60-day · status 5/11/12 · internal & test excluded) — read-only, no production writes.
DataStudiosExecutive summary · the two asks · as-of 2026-06-23 · private
1
Section 1 · Research & analysis

The detail behind each ask

How we reached the executive summary — the offline-conversion analysis (what you import today, the quality & compliance of the send, the reach Enhanced Conversions adds, and per-row accountability), the cross-platform reconciliation, and the recommended path forward.
Offline conversionsReconciliationRecommendation & roadmap
Recommendation

Replace the Sheet with the Google Data Manager API

Today · Google Sheet

Lossy intermediary · no per-row outcome · no consent gate · manual-shaped

→
Data Manager API

Same clean data, sent direct — programmatic, auditable, idempotent

AccountabilityPer-row did-not-import log — every excluded conversion carries a reason.
IdempotencyStable transaction id → safe re-runs, never double-counts.
Consent filteringAutomatically removes the 170 non-consented-PII events — closes the compliance gap.
Validated & stagedvalidateOnly confirms Google accepts each payload before any write.
DataStudiosRecommendation · private
Roadmap

Phase 1 now; Phase 2 builds on it

Phase 1 · cutover

Sheet → Data Manager API

  • Clean, consent-filtered uploads (drops the 170 risk)
  • Per-row did-not-import accountability
  • Idempotent, validated, staged before any write
Go-live gate: accept Google's customer-data terms on the Quotes/Orders actions; align the idempotency key. No production writes until approved.
Phase 2 · build on it

Reconciliation + operational view

  • Cross-platform reconciliation (CRM / GA4 / Ads), settled cadence
  • Operational drill-down dashboard — funnel → channels → did-not-import
  • Decompose the recoverable share of the Ads gap
→ site/dashboard.html (Phase 2 mockup, data-driven)
DataStudiosRoadmap · private
2
Section 2 · Appendix

How every number was derived

Acceptance criteria, open questions, and a per-claim reproduction for each figure in this deck — the exact query or command, the raw→headline derivation, and a claim↔run check. As-of 2026-06-23 · aligned 60-day definition · read-only, no production writes.
Acceptance criteria & open questionsPer-claim reproductions
Appendix

Acceptance criteria & open questions

How to read these numbers

Every figure is aligned to your approved query (60-day window · status 5/11/12 · internal & test excluded), as-of 2026-06-23. Query-derived figures (live Supabase / GA4 / Ads) reproduce within minor drift on re-run; pipeline-derived figures are exact against the frozen capture artifacts. Nothing in this analysis was written to Ads or GA4.
  • Reachable ≠ realized — uplift is a candidate ceiling; realized ECL match is measured at go-live.
  • attributed ≠ uploaded — Ads attribution is not a count of rows sent.
Open questionStatus
Google customer-data terms + Enhanced Conversions for Leads — verified enabled on the account (no action needed).verified ✓
The ~138 thank-you-page tagging gap — web conversions with no gclid and no PII. Audit GTM/gclid capture?confirm
Idempotency key — your workflow uses history_id; ours uses rfq_id. Reconcile so re-runs dedupe cleanly.align at go-live
DataStudiosAppendix · as-of 2026-06-23 · private