There are duplicate records which 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 *Id columns.
Example: for the keyword_performance_report, configure the
The cause of the perceived duplicate is due to an Adwords 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.