airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
15.41k stars 3.98k forks source link

[source-google-ads] Missing Records in `ad_group` vs. `ad_group_criterion` #38092

Open karolur opened 4 months ago

karolur commented 4 months ago

Connector Name

google ads

Connector Version

3.4.1

What step the error happened?

Other

Relevant information

I'm experiencing an issue with the Google Ads source connector where there appears to be a discrepancy in the number of records between the ad_group and ad_group_criterion streams.

Here's a breakdown of the problem:

Stream: ad_group Expected Behavior: All ad groups from the Google Ads source should be included in this stream. Actual Behavior: The number of unique ad_group_id values in the ad_group stream is approximately 70% less than the number of unique ad_group_id values in the ad_group_criterion stream.

This suggests that a significant portion of ad groups are missing from the ad_group stream.

Relevant log output

No response

Contribute

marcosmarxm commented 4 months ago

Thank you for reporting the issue, @karolur. I've added it to the connector team's backlog for discussion in the next sprint.