Why Are There Duplicate Rows in the Google Ads Table?
Question
Why are there duplicate records that show the same value in each field?
Environment
Connector: Google Ads
Answer
Use the _fivetran_id
column to identify unique records.
To view Google values that differ for the same rows:
- Create a new report.
- Configure the report to include
*.id
fields.
Cause
The Implicit Segmentation feature may produce report rows with similar segment and metrics values.
Some field configurations may cause records to appear as duplicates. For example, if you create an ad_group
report with the fields segments.date
and metrics.impressions
, Google Ads implicitly adds the ad_group.resource_name
field to the report. This processing error adds multiple impression values to the same value of the date
dimension. However, the field does not appear in your destination table because the connector is not set up to sync the ad_group.resource_name
field.