Question
There are duplicate records which show the same values in each column.
Environment
Connector: Google Ads
Answer
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 theid
andAdGroupId
columns
Cause
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.
Comments
0 comments
Please sign in to leave a comment.