Data missing in Google Ads latest vrsion for `ad_group_ad_report`

[marcosmarxm]

Environment

• Airbyte version: 0.35.61-alpha
• OS Version / Instance: GCP
• Deployment: Docker
• Source Connector and version: Google Ads 0.1.37
• Destination Connector and version: Snowflake 0.4.24
• Step where error happened: Deploy / Sync job / Setup new connection / Update connector / Upgrade Airbyte

Current Behavior

Latest version of Google Ads is not bringing all campaigns for ad_group_ad_report
This is what Google return from querying directly the data:

• Responsive search ad
• Non-skipable in-stream ad
• Discovery ad

But ad_group_ad_report only brings campaign of type

• Reponsive search ad

There isn't any info in docs or Google changelog saying something about filtering data from reports.
Using Version with Google v8 brings all records and campaigns.

Expected Behavior

Tell us what should happen.

Logs

Steps to Reproduce

Are you willing to submit a PR?

Remove this with your answer.

[marcosmarxm]

One comparative is: ad_group_ad_report and ad_group_ads have the same table reference but they bring different campaigns.

[tinomerl]

@marcosmarxm we also encountered this behaviour. i replicated the raw http calls and found out that data goes "missing" when the field segments.keyword.ad_group_criterion added in #9310 is in the call. Data is then missing on the campaign level. The missing campaigns seem to be retargeting campaigns.

downgrading the google ads connector to 0.1.34 fixes it for now.

[davydov-d]

Hi @marcosmarxm have you tried reproducing the issue with version 0.1.39? I tried to reproduce it on versions 0.1.23 (api v8), 0.1.34 and 0.1.39 and the data was not missing. The one thing worth mentioning is that we do not have ads of types Non-skipable in-stream and Discovery in our test account as they are quite expensive. Instead, we have "Responsive search" ad and "Responsive display ad". I'd be grateful if you provide me with more details on how I can reproduce the issue or give me the access to the account where it persists. Another option is to gain approval for running ad types from report

[tinomerl]

Hey @davydov-d,

i'm sadly not marcosmarxm but i tried replicating the issue with 0.1.39. and it persisted. see the attached screenshots.

i dug a bit more in this ad account. the missing campaigns have the campaign type display network. and the ads are responsive display ads. Hope that helps.

[davydov-d]

@ycherniaiev could you please support me and fill in our test account with the data provided by @tinomerl ? that would give me another try to reproduce the issue