[source-bingads] Issue with fields not being marked as primary key in keyword_performance_report

[DorConnecteam]

Connector Name

source-bing-ads

Connector Version

2.6.0

What step the error happened?

During the sync

Relevant information

We set up a connection from bing-ads to bigquery, we have the steams as "Incremental | append + deduped".
Since 2.6.0 new fields have been added to keyword_performance_report,
but after upgrading we see some of the data doesnt add up (we summed columns like spend or clicks and compare it to bing-ads UI, and got a much lower number in the data) but there was no error in the logs.
After playing around with the reports in the UI, the sync settings (sync mode) and the API, I think the problem is that one of the new fields (a field called Goal ) should be marked as part of the primary key,
When goal is part of the requested fields in Bing Ads API, the data is split between the goals (you can set multiple goals in bing, and the same ad + keyword can result in different numbers for each goal)
This means that when goal is not part of the primary key, and the sync-mode is "Incremental | append + deduped" some of the rows (that contains relevant data) are deduped when they shouldnt.

Relevant log output

No response

Contribute

• Yes, I want to contribute