Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi everyone, I was playing around with Airbyte and the Google Ads connector and until recently using only the *ad_group_ad_report* stream I was able to get all the costs/metrics associated with a google ad account. However from my latest tests with this stream I observed that it is missing a lot of clicks and costs (as far as I was able to check Smart Campaign clicks, DSA's  are not included anymore). I am not sure if this is an airbyte sync issue or something else, hope somebody can shed some light on it. Thanks!

Did you upgrade recently <@U0382UNF3RS> ? Do you have the previous version?

Hi Marcos, yes, I am using latest for connectors (destination and source) and Airbyte version 0.38.4-alpha
The issue was present before making these updates.

( also we checked, running with a GAQL  custom query on ad_group_ad resource from Google Ads which seems that is mapped to ad_group_ad_report and it gets all the clicks &amp; costs correctly )

Do you mind sharing the query you run in GAQL? Did you try to create a custom report with the custom query?

sure <@U01MMSDJGC9>, this is the query which we used in our Source setup:
```SELECT customer.id,customer.descriptive_name,customer.currency_code,campaign.id,campaign.name,ad_group.id,ad_group.name,ad_group.type,segments.ad_network_type,segments.device,metrics.cost_micros,metrics.impressions,metrics.clicks,metrics.conversions,metrics.video_views,metrics.video_quartile_p25_rate,metrics.video_quartile_p50_rate,metrics.video_quartile_p75_rate,metrics.video_quartile_p100_rate FROM ad_group```
we successfully materialised in BigQuery (as destination) clicks and cost with this custom query, however I would like to use standard Airbyte connector &amp; implementation for this.