Duplicate Conversions: How to Identify and Fix Double-Counting
Duplicate conversions inflate your conversion count, distort CPA and ROAS metrics, and confuse Smart Bidding. Here’s how to identify, fix, and prevent them.
How Duplicates Happen
| Cause | Example |
|---|---|
| Running manual + automated | CSV upload on Monday, TUOCA relay on Tuesday — same data |
| Overlapping date ranges | Relay fetches last 48 hours daily → yesterday’s records appear twice |
| Timestamp variations | Same conversion with 1-second time difference = “new” conversion |
| Multiple data sources | CallRail AND HubSpot both upload the same lead |
| Count set to “Every” | Multiple conversions per GCLID are allowed |
Detecting Duplicates
In Google Ads
- Go to Goals → Conversions → Uploads → your upload → Details
- Look for DUPLICATE_CONVERSION status — this means Google caught and rejected the duplicate
- If you see zero duplicate errors but conversion count seems too high, duplicates may be getting through (different timestamps)
In TUOCA
Check Activity Logs for:
- Same GCLID appearing in multiple upload batches
- Same phone number/email in overlapping batches
Fixing Existing Duplicates
Option 1: Conversion Adjustments (Google Ads)
Upload a conversion adjustment to “retract” the duplicate:
Google Click ID,Conversion Name,Adjustment Time,Adjustment Type
EAIaIQob...,Booked Job,2026-04-15 00:00:00,RETRACTION
Option 2: Recreate the Conversion Action
If duplicates are severe, create a new conversion action and start fresh with clean data.
Prevention
- Always include order_id — Deterministic, consistent, unique per record
- Don’t run both manual and automated — Choose one
- Set Count to “One” — For service businesses (one conversion per GCLID)
- Use TUOCA — Automatic order_id generation and cross-relay deduplication