There are duplicate records that show the same values in each column.
Connector: Google Ads
The _fivetran_id column identifies unique records.
To see Google values that differ for the same rows:
- Create a new report
- Configure the report to include <report_type>.resource_name columns.
Example: for the campaign report, configure the
The cause of the perceived duplicate is due to an Google Ads feature - Implicit Segmentation. This may produce report rows with same set of attributes/segments and different (or even the same) metrics.
Based on the fields you have configured, the records appear to be duplicates.