Daily run · nothing fails silently
Every RFQ → Quote → Order conversion from the CRM, matched to its ad click and pushed to Google Ads + GA4 — with a live count of what uploaded, what didn't, and why.
Converted (90d)
8,146
6,981 quotes · 1,165 orders
Uploadable to Google Ads
3,145
gclid 1,642 + ECL 1,503
Match rate (of website)
66%
↑ from 34% (gclid only)
Did not import
87
every one traceable, with reason
Conversions uploaded · last 30 days
PHASE 1QuotesOrdersIllustrative daily volume · real aggregates above
Last run
StartedToday 06:00 EST
Pulled since cursor312
Matched198
Uploaded196
Failed2
Next runTomorrow 06:00
validateOnly passed
Why 87 rows didn't import
the answer the spreadsheet never gaveDefinition of done: Google Ads and GA4 counts reconcile, and any record that doesn't make it is visible — traceable to its RFI/order ID, with the reason.
By date · by ID · with reason
The per-record feed that replaces the export-and-diff. Every RFI/order ID, its upload status, the match key, value, and — when it fails — exactly why.
| RFI / Order ID | Date | Stage | Status | Match key | Value | Detail |
|---|---|---|---|---|---|---|
| RFI-10486 | Jun 22 | Order | Uploaded | gclid | $18,400 | matched · deterministic |
| RFI-10485 | Jun 22 | Quote | Uploaded | ECL | $4,250 | hashed email · probabilistic |
| RFI-10484 | Jun 22 | Quote | Failed | none | $2,100 | no gclid — missing UTM on landing page |
| RFI-10481 | Jun 21 | Order | Failed | gclid | $9,800 | EXPIRED_EVENT — click older than the action window |
| RFI-10479 | Jun 21 | Quote | Uploaded | gclid | $3,600 | matched · deterministic |
| RFI-10477 | Jun 21 | Quote | Bing | msclkid | $1,150 | routed to Microsoft leg · Phase 2 |
| RFI-10472 | Jun 20 | Order | Uploaded | ECL | $22,750 | hashed phone · probabilistic |
| RFI-10468 | Jun 20 | Quote | Uploaded | gclid | $5,900 | matched · deterministic |
Showing 8 of 3,145 uploadable records · 2 failed of the last batch — every record traceable back to where tracking broke. Rows are illustrative; aggregate counts are live.
Attribution · deterministic + probabilistic
How many converted website RFQs we can actually tie back to an ad click. gclid is exact (~100%); Enhanced Conversions for Leads adds hashed email/phone — submittable, matched probabilistically (~30–70%).
Quotes · last 90 days
2,724 uploadable · 63% of web · +85% vs gclid-only
Orders · last 90 days
421 uploadable · 89% of web · +152% vs gclid-only
gclid — deterministic (~100% match)ECL — hashed email/phone (probabilistic)unreachable (non-web / out-of-window)
Website vs total RFQs
always compare platforms to website, never totalWhy it matters: GA4 and the ad platforms only ever see website activity. Comparing them to total RFQs invents a gap that isn't real.
Objective 2 · reconcile across platforms
Counts will never match exactly — ad platforms are modeled and click-dated, GA4 is observed and event-dated. The job is to explain the divergence, not treat it as a bug.
Google Ads ↔ GA4 · website RFQs
PHASE 1| Date | CRM (website) | Google Ads | GA4 | Δ Ads | Status |
|---|---|---|---|---|---|
| Jun 18 | 214 | 208 | 211 | −6 | reconciled |
| Jun 19 | 198 | 191 | 196 | −7 | reconciled |
| Jun 20 | 231 | 205 | 224 | −26 | investigate |
| Jun 21 | — | 177 | — | — | unsettled |
| Jun 22 | — | 96 | — | — | unsettled |
Last two days greyed — unsettled. GA4 takes a day or two to attribute; ad platforms revise modeled counts. Reporting on them invents gaps that vanish later.
CRM ↔ GA4 ↔ Google Ads ↔ Microsoft
PHASE 2CRM website RFQs
6,618
Google Ads
6,210
GA4
6,489
Microsoft Ads
412
Pipeline operations
Every scheduled run, idempotent and cursor-based — safely re-runnable. Pick a run to see each stage and its per-stage counts.
| Run | Pulled | Uploaded | Failed | Status |
|---|---|---|---|---|
| Jun 22 · 06:00 | 312 | 196 | 2 | complete |
| Jun 21 · 06:00 | 288 | 181 | 4 | complete |
| Jun 20 · 06:00 | 341 | 214 | 0 | complete |
| Jun 19 · 06:00 | 276 | 172 | 1 | complete |
Run · Jun 22 06:00
completePoll Supabase since cursor
deals advanced to quote/order
312
Resolve match key
gclid → ECL fallback, in-window
198
validateOnly dry-run
structure + auth + destination
198
Ingest · Data Manager API
Quotes + Orders actions · GA4 events
196
Write import log + advance cursor
status / reason / run_id → Supabase
2 failed
Phase 2 · autonomous agent
The pipeline becomes an agent that runs itself, that you can ask for status in plain language, and that escalates to a human gate when a decision is above its pay grade. You supervise by exception instead of watching dashboards.
Ask the agent
runningWhat's the status of today's run?
Today's 06:00 run is complete. I pulled 312 changed deals, matched 198 (162 gclid, 36 ECL), and uploaded 196 to Google Ads + GA4. 2 failed — both Orders, clicks past the 90-day window. The import log has both, by ID. Next run: tomorrow 06:00.
Why did the match rate dip on Jun 20?
Jun 20's Ads count ran 26 under CRM — above the usual −7 drift. Cause: a batch of website quotes came in with no gclid and no usable PII (a landing page dropped its UTM). It's not an upload failure — those records have no ad click to attribute. I flagged it as a human gate below, and opened a note to fix capture upstream.
Agent status
StateIdle · healthy
CadenceDaily · 06:00 EST
Last run2h ago · ok
Open gates1 awaiting you
7-day match rate64%
AutonomySupervised
Human gates · awaiting decision
the agent stops where it shouldn't decide aloneMatch-rate anomaly · Jun 20 quotes
26 website quotes arrived with no gclid and no usable PII (UTM dropped on /part_search/straightrfq.asp). Outside normal drift. Recommended: log as unattributable + open a capture fix. Approve to proceed, or hold for review.
Config change · enable Orders value-based bidding
The agent proposes sending order_total as the conversion value on the Orders action, so bidding optimizes on revenue. This changes how Google spends — gated to you.
Configure · your tool
The knobs your team owns — conversion mapping, match windows, the unsettled-day cutoff, value handling, and who gets alerted.
Conversion mapping
Quote stage → actionQuotes · 7208316397
Order stage → actionOrders · 7208513754
RFQ (web tag)RFQs · 1072234740
Operating account201-830-1930
Matching & cadence
gclid window90 days
ECL (hashed PII) window63 days
GA4 freshness72 hours
Exclude unsettled2 days
Run cadenceDaily · 06:00 EST
Value per stage
Order valueorder_total
Quote valueto confirm
CurrencyUSD
Dedupe keytransactionId = rfq_id
Alerts
Daily failure digeston
Match-rate drop alerton
Recipientsmezar@4star… +1
ChannelEmail · Slack